Small project with Interactive Brokers and Excel
Budget: $30 – $250 USD
I trade options with Interactive Brokers on the Canadian stock market, and uses Excel to help myself select the trades.
I need to update the option chain strike price, for my list of stocks, once per day. At this moment, I’m doing this update manually myself.
I think this could be done much more efficiently with Excel VB code, from Interactive Brokers data utilizing RTD.
Here is what I need developed: Outputs all strike prices for one expiry date (for example the 2021-09-17) for a list of stocks, on specified sheet/tab (I think this can be done through reqSecDefOptParams, but I don’t know how to do it).
The deliverable will be the modified version the Excel file with a button to update the strike price.
Thank you,
I need to update the option chain strike price, for my list of stocks, once per day. At this moment, I’m doing this update manually myself.
I think this could be done much more efficiently with Excel VB code, from Interactive Brokers data utilizing RTD.
Here is what I need developed: Outputs all strike prices for one expiry date (for example the 2021-09-17) for a list of stocks, on specified sheet/tab (I think this can be done through reqSecDefOptParams, but I don’t know how to do it).
The deliverable will be the modified version the Excel file with a button to update the strike price.
Thank you,