Discussions
»
Product and Service Development
»
MetaStock
»
Plot the Correlation indicator into "system Tester'&qu
Rank: Newbie
Groups: Registered, Registered Users
Joined: 8/22/2005(UTC)
Posts: 7
Location: NO
|
Is it possible use "system tester" to run Correlation of two securities?
I plot the Correlation indicator like Metastock Say:
1. Select the two plots that you want to correlate (i.e., two indicators, a price plot and an indicator, or two price plots). Select the first plot (the independent variable) by simply clicking on it. Select the second plot (the dependent variable) by holding down the SHIFT key and clicking on it. Small square handles will appear on the plots indicating that they are selected.
2. Drag the Correlation indicator from the Indicator QuickList and drop it on the chart.
I use $XOI and XOM (same window)
Now I would like to run this correlation in "System Tester".
I know create "system tester" So I would like to create something like : Buy if "correlation ($XOI and XOM)" > 0.90 ....
Is it possible?
Best Regards
macm
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
Have a look in your MS Users Manual, in the MSFL section for Correlation Analysis.
The Bible wrote:The formula "correl( macd(), CLOSE, 5, 10 )" compares the MACD indicator to the closing price 10-periods[size=18:c08732b371] [color=red:c08732b371]in the future[/color][/size:c08732b371], after statistically averaging each data array over the preceding 5-periods.
In my book this makes correl() untradable, just as LastValue(), Peak(), Trough() and Zig() are untradable.
wabbit :D
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users
Joined: 8/22/2005(UTC)
Posts: 7
Location: NO
|
I understand.
But in your sample it is to the same securitie. I can do this for one share like XOM.
I am asking for TWO SECURITIES like $XOI and XOM.
How can I test both?
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
If I understand your predicament correctly, you can use the Security() function:
x:=Security("D:\\MetaStock Data\\$XOI",C);
y:=Security("D:\\MetaStock Data\\XOM",C);
z:=Correl(x,y,5,10);
z;
wabbit :D
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Discussions
»
Product and Service Development
»
MetaStock
»
Plot the Correlation indicator into "system Tester'&qu
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.
