← Back to Templates


Beta Calculation
Description
Reports beta over eight lookback windows at once, from seven days out to two years, using a separate custom beta formula for each period. Seeing them side by side is the point: a stock whose short window beta has climbed well above its two year figure is behaving differently now than its long run reputation suggests, and one number cannot show that. Paste a list of symbols down the first column and every window fills across. Values refresh from MarketXLS with the add-in installed, so the table can be re-run as conditions change.
Template Screenshots
Market data in your Excel sheets
1 billion usable data points on stocks, options, ETFs, and fundamentals, with simple Excel formulas.
See plans
▶
How does MarketXLS work? Watch Demo
Similar Templates
No similar templates found