Custom Beta
How to use the Custom Beta function - 7day , 15day, 6month, 3year , 5year etc.
1
=CustomBetaFiveYears("MSFT","SPY","monthly")
Copied!
Beta is a measure the systematic risk. In most simple terms, the Beta of a stock is the percentage change in the stock’s return, given a 1% change in the market.
Second argument - By default, it takes SPY as the comparison symbol. But, we can select any ticker symbol other than SPY, like a stock- AAPL or any other ETF.
Third argument - By default, it calculates the Beta on a daily basis. But the user can use any time frame - daily, weekly or monthly.
Examples - =CustomBetaFiveYears("MSFT") - Calculates beta against SPY on a daily basis. =CustomBetaFiveYears("MSFT","AAPL") - Calculates beta against AAPL on a daily basis. =CustomBetaFiveYears("MSFT","AAPL", "monthly")- Calculates beta against AAPL on a monthly basis.
Copy link