Custom Beta Three Years
Syntax
=CustomBetaThreeYears(Symbol, [Benchmark], [Period])Parameters
symbolstringRequired
Stock ticker symbol
benchmarkstring
Benchmark symbol (default: SPY)
Returns
number
Beta over 3 years
Examples
=CustomBetaThreeYears("AAPL")When to Use
- Long-term beta analysis
Excel Templates Using Custom Beta Three Years
These ready-made MarketXLS templates call CustomBetaThreeYears() in their worksheet formulas. Open one to see the function working inside a complete model.
Related Formulas
More MarketXLS MarketXLS Analytics formulas you can use in the same worksheet:
- Delta
- Drawdown Between Two Dates
- Drawdown Five Years
- Drawdown Nine Months
- Drawdown One Year
- Drawdown Six Months
- Drawdown Thirty Days
- Drawdown Three Months
See CustomBetaThreeYears used in a complete workbook: Stock Beta in Excel: How to Calculate, Interpret, and Use Beta for Portfolio Risk
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?