Friday, May 2, 2008 - New servers are in! Click-in for more info!
VoyForums

[ VoyUser Login optional ] [ Contact Forum Admin ] [ Main index ] [ Post a new message ] [ Search | Check update time ]

[ Next Thread | Previous Thread | Next Message | Previous Message ]

Date Posted: 20:44:29 04/24/02 Wed
Author: jimmahar
Subject: help with betas






a student (who will remain anonymous) emalied me the following and since I have had several students ask me the same, I htought I would share the response with the class:

> hi (again) dr. mahar...
> i am having a little trouble with my betas. I did
> the regressions and then
> went to finance.yahoo.com to check their (SIC) accuracy.
> and they are way off.
> Also, all my stocks except microsoft (who i did get
> to work out to about 1.8
> like it is) are negative and decimals....any
> thoughts?


I really do not know what would cause that but at least two others have had a similar problem...I'd have a few quesses...

One possible cause is that the returns are messed up...remember it is (this month's close - last month's close)/last month's close...

since the dates go backwards in Yahoo, some are messing up this way.

The other problem seems to be an Excel problem, but I am not sure...

It SEEMS to be if you run the regression on formulas...that is if your return column is made of formulas...the way to fix this is to copy the column and paste it as values (paste special-values) and then run the regression on the value column...I am not sure why or even if this is casuing the problem but for the student that came in today with the exact problem, this method worked.

hope this helps.

jim

[ Next Thread | Previous Thread | Next Message | Previous Message ]
[ VoyUser Login ] Not required to post.
Post a public reply to this message | Go post a new public message
 * Notice: Posting problems? [ Click here ]
 * HTML allowed in marked fields.
Message subject (required):

Name (required):

  Expression (Optional mood/title along with your name) Examples: (happy, sad, The Joyful, etc.) help)

  E-mail address (optional):

* Type your message here:


Notice: Copies of your message may remain on this and other systems on internet. Please be respectful.

[ Contact Forum Admin ]

Forum timezone: GMT-5
VF Version: 2.94, ConfDB:
Before posting please read our privacy policy.
VoyForums(tm) is a Free Service from Voyager Info-Systems.
Copyright © 1998-2008 Voyager Info-Systems. All Rights Reserved.