Beta-stock vs market

[MrMilesIL]

Here is a beta formula I wrote for those who have been looking for one. It calculates a stocks beta versus a specific index over a specific time period using a the stocks correlation to the market, the stocks daily annualized historical volatility, and the markets daily annualized historical volatility.

It needs an edited version of the Pearson Correlation formula is by Chris D. Kryza (Divergence Software, Inc.) in order to work. I will attach that separately.

It is memory intensive, be forewarned. And if anyone can figure a way to make it less so, please share.

Please post any questions, comments, etc.

Jonathan

[MrMilesIL]

edited Pearson Correlation file

edited Pearson Correlation file.

Both efs must be in the same directory.