Rank: Newbie
Groups: Registered, Registered Users
Joined: 2/1/2009(UTC)
Posts: 4
Location: newark, de
|
hi all,
this is not so much a how to question but a capability question. i want to know if metastock's programming syntax allows manipulation of data from two different stocks symbols at once. i have an arbitrage algorithm in a spreadsheet i'd like to try to replicate and automate in metastock. the computation in the spreadsheet compares data from two or more symbols and then graphs the results. any useful insight?
thanks,
mike james
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 5/13/2005(UTC)
Posts: 715
Location: Midwest, USA
Was thanked: 1 time(s) in 1 post(s)
|
Mike -- You probably want the SECURITY() function.
Would have to see your spreadsheet -- or at least some of its equations -- to say more.
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users
Joined: 2/1/2009(UTC)
Posts: 4
Location: newark, de
|
jjstein wrote:Mike -- You probably want the SECURITY() function.
Would have to see your spreadsheet -- or at least some of its equations -- to say more.
hi johnathan, thanks for the reply. my spreadsheet models a quantitative hedge algorithm involving more than one security in the computation. i wanted to be sure i can do such operations in addition to writing formulas for single securities. i'll get more familiar with this function. thanks, mike james
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users
Joined: 2/1/2009(UTC)
Posts: 4
Location: newark, de
|
oh, looking through the metastock formula primer i found that the security function is only available in the professional version. currently i have metastock EOD. if i want to use this function, i have to upgrade. [:(]
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 5/13/2005(UTC)
Posts: 715
Location: Midwest, USA
Was thanked: 1 time(s) in 1 post(s)
|
Uh, I have EOD and it works fine. It looks something like this:
Security("\MetaStock Data\Indices & Indicators\US & Canadian Indices\X.AMEX-A",C);
|
|
|
|
|
|
Rank: Advanced Member
Groups ready for retrieval: Registered, Registered Users, Subscribers
Joined: 4/5/2006(UTC)
Posts: 129
Location: Norgate Data
|
squark62 wrote:oh, looking through the metastock formula primer i found that the security function is only available in the professional version. currently i have metastock EOD. if i want to use this function, i have to upgrade. [:(]
Equis added the SECURITY function in MetaStock Pro v7 but I think they made it available in either MetaStock v8 EOD or MetaStock v9 EOD and above. Try it and see if the SECURITY function works in your version and report back here. |
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users
Joined: 2/1/2009(UTC)
Posts: 4
Location: newark, de
|
thanks guys,
i'll tray an hack something together real quick and will let you know what i got.
cheers,
mike
|
|
|
|
|
|
| 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.
