Forum Discussion
Stock data type and beta calculation
Thanks Joe
I think you are right about Morningstar. When you type a ticker symbol on their website you get some information on the risk tab. The data there is very close to but not exactly the same as what Excel returns. Five years is a pretty long time for a beta calculation and I think in the case of some symbols these measures are flawed and I prefer my own calculation which is also very easily calculated given historical stock data adjusted for dividends and corporate actions (splits, etc...)
Best regards
Steve
sedelstein Re: ``I think you are right about Morningstar. [....] The data there is very close to but not exactly the same as what Excel returns.``
Schwab had told me that "Morningstar" revises its statistics only periodically -- perhaps every quarter(?). I suspect they mean that Schwab pulls the statistics only periodically. The same might be true of Refinitiv. Or it might be that Morningstar had only recently updated its statistics based on Dec'20 data, and Refinitiv has not caught up yet.
In any case, I agree with doing your own calculations based on your own needs. I, too, prefer to have control over the details.
PS.... In other forums, I have seen many complaints about the "Excel" (Refinitiv) stock data. It does not sound very reliable -- at least, according to others. I have no experience with it myself, obviously.