Rank: Member
Groups: Registered, Registered Users, Subscribers
Joined: 1/27/2009(UTC)
Posts: 11
|
I wanted to write an Explorer formula that would recommend a buy or a sell based on directional movement of another security or an index. For instance, if I have observed that Google stock rises for three days in a row, Yahoo and MSFT would follow and vice a versa.
How do I go around doing this? Any help is appreciated.
Thank you.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Unverified Users
Joined: 9/13/2004(UTC)
Posts: 673
Location: Salt Lake City, UT
|
There's a couple ways to do this. You could use the "P" variable which would require you to have a chart of the stock/index in question open with the price plot selected.
Alternately, you could use the Security Data function to call the price data into the Explorer. An example is listed below:
{Buy}
Sum(ROC(Security("C:\MetaStock Data\My Data\GOOG",C),1,$) > 0,3)=3
|
|
|
|
|
|
Rank: Member
Groups: Registered, Registered Users, Subscribers
Joined: 1/27/2009(UTC)
Posts: 11
|
Thank you very much Justin.
|
|
|
|
|
|
| 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.
