USING EXCEL TO CREATE YOUR OWN INDICATORS
version 4.00 or later
The program will send data to an Excel workbook and then receive information to be plotted.
If you are going to create indicators for Real Time calculation then this is an Important considerations – This is a slower process than a direct DLL creation (see how to create your own DLL indicators), A P4 3GHz or better with a minimum of 1 GB of memory is strongly recommended with WIN2000 or later. The program sends the number of bars in memory, to the Excel sheet. Keep this number as low as possible.
Lets look first at the example file that comes with the program. This file is located at C:\FTGT\EXCEL\EXAMPLE.XLS. There is another example file named C:\FTGT\EXCEL\PAINTBAR.XLS as well.
Use Excel to open C:\FTGT\EXCEL\EXAMPLE.XLS.
In this case we are creating and indicator that has 2 moving averages, when the lines cross we have a trade.
The cell E3 to E18 are reserved for you to pass some needed information from excel to the Fibonacci Trader program.
The following is a description of each cell.
To use this example indicator open the indicators window and scroll down the list until you find the indicator called EXCEL
Highlight “EXCEL” and click ADD (or just simply double left click on the excel indicator). The default is set to the EXAMPLE indicator. When you create your own excel indicators click on edit and change the Excel file name box to the name you gave your excel indicator.
If your Excel indicator is designed to initiate trading positions you can see the generated signals on the chart by clicking on the Alarm/Result tab and check “Show trades on chart”. All Excel Indicator files must be saved in the following folder: C:\FTGT\EXCEL.
The next picture shows a chart using the Excel “Example” indicator.