excel expert for stock option modelling
Budget: $250 – $750 CAD
Need an excel based program that will:
1) download broker data for equity options prices (either scraped or from Interactive Brokers)
2) Create a volatility smile with option prices at each strike for an option chain from the provided data
3) Create a second option chain with theoretical option prices using the ATM IV for all strikes
4) Calculate the difference at each strike between #2 and #3
5) Display this difference graphically
1) download broker data for equity options prices (either scraped or from Interactive Brokers)
2) Create a volatility smile with option prices at each strike for an option chain from the provided data
3) Create a second option chain with theoretical option prices using the ATM IV for all strikes
4) Calculate the difference at each strike between #2 and #3
5) Display this difference graphically