Custom Beta

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.

Dividends

Next - Options Pricing

Options Pricing

Last modified 7mo ago

Copy link