logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Flexi  
#1 Posted : Monday, February 7, 2011 10:48:32 AM(UTC)
Flexi

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 5/27/2006(UTC)
Posts: 135

what is the correlation use on metastock? spearman or pearson?

why is that the correlation function return a different value compared to the correlation indicator using the same data?

For the 3 bars data below what is your correlation value? Is the value 0.15 using the correlation function with zero shift?

a b
19.01 9.22
19.12 9.54
19.48 9.66
Flexi  
#2 Posted : Monday, February 7, 2011 10:49:06 AM(UTC)
Flexi

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 5/27/2006(UTC)
Posts: 135

or 0.85
wblam  
#3 Posted : Monday, February 7, 2011 1:51:22 PM(UTC)
wblam

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 11/25/2006(UTC)
Posts: 79

Both MetaStock and Microsoft Excel return 0.85011 (correct to 5 d.p.).
It should be Pearson's formula.

Flexi  
#4 Posted : Tuesday, February 8, 2011 11:01:16 AM(UTC)
Flexi

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 5/27/2006(UTC)
Posts: 135

does ms keep the chart intact with two securities on one chart and with an indicator using "P" variable?

close ms and reopen ms but the chart with two securities are intact but the indicator become blank

y this so?
wabbit  
#5 Posted : Wednesday, February 9, 2011 2:02:07 AM(UTC)
wabbit

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)
P is the selected data array. If nothing is selected then P is empty.

Use Security() instead.



wabbit [:D]

Users browsing this topic
Guest (Hidden)
Similar Topics
Is it possible, using the correlation (Formula Assistance)
by mohamedmostfa 5/11/2024 8:07:55 AM(UTC)
Correlation formula (or process) ? (Formula Assistance)
by TomHam 4/15/2024 2:12:07 AM(UTC)
May 2020: Correlation as a Trend Indicator (2020)
by MS Support 6/15/2022 4:21:22 PM(UTC)
Correlation formula (Formula Assistance)
by ohad@altris.co.il 11/27/2016 9:39:04 AM(UTC)
correlation indicator (MetaStock)
by gorachand 1/3/2016 5:10:39 AM(UTC)
How can I calculate the correlation between 2 instrument in Explorer? (Formula Assistance)
Belarus rasj 7/30/2014 2:29:00 PM(UTC)
Scaling 2 Correlations (MetaStock)
by halcour 12/29/2013 4:06:40 AM(UTC)
Beta vs Correlation? which one is better? (Formula Assistance)
by oem7110 10/3/2013 10:36:40 AM(UTC)
Simple correlation (Formula Assistance)
by Precisely 6/24/2013 2:22:11 PM(UTC)
4.SEMWEB-CFYE.Consistently Finding Your Edge Through Price and Time Correlations (Archive)
by KTP2 8/31/2012 4:24:32 PM(UTC)
Correlation Analysis in Exper Advisor (Formula Assistance)
by scocci357 1/20/2012 3:31:29 PM(UTC)
Plot/calculate correlation of n securities (MetaStock)
by Precisely 8/15/2011 11:31:13 PM(UTC)
Spearman Correlation (Formula Assistance)
by Flexi 2/15/2011 4:07:27 AM(UTC)
find out the correlation from each trading days compare with the whole month (Formula Assistance)
by wwlwilliam 12/3/2010 7:39:50 AM(UTC)
find out cofficient correlation (Technical Chat)
by minakshi04 3/31/2010 3:01:49 AM(UTC)
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.