Rank: Member
Groups: Registered, Registered Users, Subscribers
Joined: 12/8/2005(UTC)
Posts: 14
Location: Edmonton, Alberta
|
Can anyone please tell me if they had any luck getting MetaStock to calculate stocks beta values. If so, can you please tell me the formula you used.
Thanks, Steven
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 9/8/2004(UTC)
Posts: 2,266
Was thanked: 1 time(s) in 1 post(s)
|
|
|
|
|
|
|
Rank: Member
Groups: Registered, Registered Users, Subscribers
Joined: 12/8/2005(UTC)
Posts: 14
Location: Edmonton, Alberta
|
Thanks for the reply, but I was looking for something that could be written as a formula. I want to use it as a formulated value in one of the columns in an explorations. Is it possible someone here has done this before.
Thanks, Steven
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 9/8/2004(UTC)
Posts: 2,266
Was thanked: 1 time(s) in 1 post(s)
|
Well the formula is right here:
[code:1:717f6178d7]( ( 21 * Sum( ROC( CLOSE ,1 ,% ) * ROC( INDICATOR ,1 ,% ) ,21 ) ) - ( Sum( ROC( CLOSE ,1 ,% ) ,21) * Sum( ROC( INDICATOR ,1 ,% ) ,21 ) ) ) / ( (21 * Sum( Pwr( ROC( INDICATOR ,1 ,% ) ,2 ) ,21 )) - Pwr( Sum( ROC( INDICATOR ,1 ,% ) ,21 ) ,2 )) [/code:1:717f6178d7]
Now you have two options:
1) If you have the security function use it to replace the INDICATOR and call whatever index you want for the calculation
2) If you Don't then open a chart of the index you want to use and left click on the price plot then run the exploration with the formula above in one of your columns
Patrick :mrgreen:
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 11/7/2005(UTC)
Posts: 602
|
Seems like instead of "INDICATOR" you could use the "SECURITY" function.
I would think in this way I could create a indicator that I can sort using the explorer
instead of a chart.
I have started to play around with it using your formula but haven't come up with
something I like yet.
|
|
|
|
|
|
Rank: Member
Groups: Registered, Registered Users, Subscribers
Joined: 12/8/2005(UTC)
Posts: 14
Location: Edmonton, Alberta
|
Thank you both Patrick and John. I will try both of your suggestions.
Thanks, Steven
|
|
|
|
|
|
| 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.
