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.
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
PIII 900 or better with a minimum of 256 Mb 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
The following is a description of
enter the type of data you want the program to load into excel. In this case
“C” will load just the close data. The data is then always loaded from cell
A21 down. If you had typed DOHLCVT in cell E3 the program would load the Date
values in column A, the Open values in column B, the High values in column C,
the Low values in column D, the Close values in column E, the Volume values in
column F, the Tick Volume in column G and the Open Time of current bar in
column F. The program will load the symbol data in the order of what is typed
in cell E3. For example, if you typed HL in cell E3 the program would load
the Highs in column A and the Lows in column B. LH would cause the program to
load the Lows in column A and the Highs in column B.
enter the number of lines to be plotted for this indicator. You can plot
up to 6 lines. In this case, 2 lines are to be plotted. The formulas you write
for line 1 of your indicator will be entered into the column you select in
cell E5, in this case column L. This example uses contains a formula that will
calculate the average of the last 4 closing prices. The columns containing the
formulas for your indicator must be next to each other. In this case, the
formula for line 2 of the moving average (in this example, the average of the
last 7 closing prices) is entered in column M. If you had a 3rd
line to be plotted the E4 cell would have the value 3 and the formulas for the
lines to be plotted would be in columns L, M and N.
enter the column where line 1 of your indicator is to be plotted. In this
case, column L.
enter the column where you will enter the formula used to initiate and exit
positions (i.e. entry and exit rules). In this case the formula is enter in
column N. If you want entry and exit arrows to show on your chart then write
your formula so that it will generate the values 1 for long, -1 for short and
0 for flat. In this example, we have if column L (the average of the last 4
closes) is greater than column M (the average of the last 7 closes) then the
indicator is long (1) otherwise the indicator is short (-1). If your
indicator can have a flat position fill the cell where the indicator is flat
for trade price, enter the column in which the results from the position
column will be displayed, In this case column O. If the position from column N
changes then the trade price in column O will be updated. In our example as
column N changes position we save the resulting trade price in column O.
enter Y if the plotted lines have the same scale as the main bar chart or N if
the plotted lines have a different scale than the main bar chart. (see E9).
If E8 is set to N then use E9 to enter the correct scale. Your scale options
are: 0 = same as bar chart. 1 = from 0 to 100. 2 = from –100 to 100. 3 =
independent with 2 decimals. 100 = paint bar indicator (if plot value is 1
then paint using color1. If plot value is 2 then paint using color2). 101 =
paint bar indicator (if plot value is 1 then paint using color1. If plot value
is 2 then paint using color2. Iif plot value is 3 then plot half of bar using
color1 and the other half using color2). For Paint Bar 100 and 101 the program
will only use the values for 1 plot line - the one that is under "PLOT LINES
START ON COLUMN”. See the example in file C:\FTGT\EXCEL\PAINTBAR.XLS
To use this example indicator
open the indicators window and scroll down the list until you find the indicator
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.
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.
Copyright © 1996-2001
PAS Astro-Soft, Inc. Last updated:
April 23, 2014. All names mentioned in
this document are trademarks or registered trademarks of their respective