Hello all!
This one was a lot of fun for me as I've been wanting to work with option prices for a while now. It takes in Bitcoin prices and the risk-free rate (which you can alter yourself just change the column name) and simulates what an at-the-money call option price should be using the Black Scholes model. Some quick rules about option prices:
- The longer the time horizon the higher the option price
- The higher the volatility the higher the option price
- The higher the spread between the strike and stock price the higher the call option price and vice versa for put options
There is some ambiguity over which time horizon and volatility to use but I've chosen to use a 30 day standard deviation (annualized) for the volatility, a 30 day time horizon, and a 12 month risk-free rate but it's really up to your discretion.
Suggestions for improvement always welcomed as well as any questions about the algo in general.
The next step would be to include a put-call ratio in this, but let's see if someone else wants to give that a stab!
-Seong