Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 5/6/2005(UTC)
Posts: 52
Location: England
|
Hi, could you advise me, when creating an expert advisor, how I reference an indicator Ive imported from excel. Im using an inner window with 2 indicators from excel and want to tell when ones over a certain value. I can can do it with the underlying security but not the indicator.
Regards Robert
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Unverified Users
Joined: 9/13/2004(UTC)
Posts: 673
Location: Salt Lake City, UT
|
If the indicator resides within the Indicator Builder, you can use the FML function to call upon this data.
SYNTAX fml("FORMULA_NAME" )
FUNCTION Calculates the value of another formula. The formula can be referenced using the FORMULA_NAME in quotes.
Notes:
When referencing a formula's name, the name must be contained in quotation marks (e.g., fml( "Secret A")).
If you change a formula's name, you must also change any fml() calls that reference that formula.
EXAMPLE The formula "fml("Secret A") * fml("MyMACD")" calculates the value of the formula named "Secret A" multiplied by "MyMACD."
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 7/25/2005(UTC)
Posts: 1,042
Was thanked: 57 time(s) in 54 post(s)
|
Rob
If you're trying to use an Excel data file as an indicator for testing purposes you could try creating a security from the data you have. Someone sent me an Excel file the other day, and to use it and its hundreds of data points I duplicated the data column to create OHLC columns, added a zero column for volume, added a periodicity and ticker (ticker is not necessary as Downloader asks for a ticker when there isn't one), and Bob's your uncle.
I now have the indicator stored as a security and I can use the Security function to call it an any time.
Roy
MetaStock Tips & Tools
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
