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

Notification

Icon
Error

Options
Go to last post Go to first unread
hycm  
#1 Posted : Wednesday, September 21, 2005 10:48:52 PM(UTC)
hycm

Rank: Newbie

Groups: Registered, Registered Users, Subscribers
Joined: 9/21/2005(UTC)
Posts: 2

See: http://forum.equis.com/viewtopic.php?t=1552Beta formula doesn't work. It always retune value 1. Look at the chart Microsoft and SP500.
StorkBite  
#2 Posted : Wednesday, September 21, 2005 11:32:50 PM(UTC)
StorkBite

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: UserPostedImage 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. UserPostedImage
hycm  
#3 Posted : Thursday, September 22, 2005 6:12:38 PM(UTC)
hycm

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.
StorkBite  
#4 Posted : Thursday, September 22, 2005 8:34:03 PM(UTC)
StorkBite

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.