Rank: Newbie
Groups: Registered, Registered Users, Subscribers Joined: 9/21/2005(UTC) Posts: 2
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users Joined: 3/19/2005(UTC) Posts: 2,995
Was thanked: 14 time(s) in 10 post(s)
|
Hey hycm-
Welcom to the forum!
Couple of things... you'll get a better chance of having your chart reviewed by posting it as a picture. The .xls extension is a bit scary for some people and others can't get it past a firewall. Especially those with external links like yours. :wink:
Here is hycm's original chart:
After seeing your work, the first thing I notice is that you aren't plotting prices- your visible y axis scale ranges from 0.89 to 1.11. That's not going to give you what you're looking for. Also, you're not going to get the correct values unless you drop your indicator onto the right price series. So, set up your graph using different scales and make sure that you are applying the indicator to the correct price series.
We recently discussed this here.
Here is a graph using the indicator as posted with the securities that you mentioned.
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users, Subscribers Joined: 9/21/2005(UTC) Posts: 2
|
Thanks for help. I tried your first way to change scale, but it didn't work out, and I also tried your anothe way to change code, but get error message :"This function is available only in MetaStock Professional." the MetaStock I use is Version 7.01 and is end of day program, that might be the problem. I did what instruction said :
1 Open a chart of the desired security(MSFT)
2 Open a chart of the desired index(SP500)
3.Drag the price plot of the index your are comparing, into the chart of the security
4.Drag this custom indicator from the QuickList and drop it onto the price plot of the index.
but get nothing, the value of the beta was 1
According to the formula, the beta needs calculate INDICATOR. But MSFT and SP500 were not INDICATOR, they were price plot. I may misunderstand the formula.
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users Joined: 3/19/2005(UTC) Posts: 2,995
Was thanked: 14 time(s) in 10 post(s)
|
It sounds like you know the correct procedure, but maybe it's tricking you. Are you sure that you are dropping the Beta indicator onto the index and not the security price plot? Try to drop it onto the other plot and see what happens, just so you can prove to yourself that there is no difference. Whenever I tried to use the Beta indicator on my security it was flat like yours is now.
Make sure you are using the correct formula, i.e., there are no transcription mistakes. Should look like this:
[code:1:b301da8b09]( ( 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:b301da8b09]
Make sure you are plotting the Beta indicator using its own scale. You can set it to the left side for example.
Make sure you are plotting the closing values of the index and security. I still don't understand why your y-axis scale range is set 0.89-1.11.
There was a recent discussion of similar problems here: http://forum.equis.com/viewtopic.php?t=1985
|
|
|
|
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.