I would like to request a quote for an excel worksheet which imports streaming options chain data from ToS in an edited form.
Here are some details of the request:
The Excel Sheet would present option chain quotes for one chosen underlying.
The option chain would only display quotes for Puts
The option data to be retrieved would be Month, Strike, Last, Bid, Ask, and Mid-price
The options chain would only display all the Put ITM strikes which are at most 5 from the ATM
Since the chain only displays all quotes which are at most 5 strikes from the current underlying price, the selection of displayed strikes would also be dynamic as the underlying price moves.
The Excel user could insert rows and columns as needed in excel around these coded quote cells.
The sheet would populate option chains for the next 4 Expiration months from current date.
Weekly option chains would populate if available.
I have attached a screen shot of a sample layout.
Thanks for your assistance.
5 freelancere byder i gennemsnit $158 på dette job
Hi, I can perform the tasks you want to be done on the excel spreadsheet. I will do it with high levels of accuracy and according to your instructions. Contact me for more details