Custom Beta Five Years
Syntax
=CustomBetaFiveYears(Symbol, [Benchmark], [Period])Examples
=CustomBetaFiveYears("AAPL")When to Use
- Very long-term beta analysis
Excel Templates Using Custom Beta Five Years
These ready-made MarketXLS templates call CustomBetaFiveYears() 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:
- Custom Beta Nine Months
- Custom Beta One Year
- Custom Beta Seven Days
- Custom Beta Six Months
- Custom Beta Thirty Days
- Custom Beta Three Months
- Custom Beta Two Years
- Delta
See CustomBetaFiveYears 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?