data from IB in a spreadsheet

When you have a TOS platform running on your computer
it is very easy to use TOS data in an EXCEL spreadsheet

simply enter in a cell "=TOS|ASK!'.RUT110527C820'
to get the ask price of the RUT 820 may Call or any
other put or call.
You can even get the delta by entering
"=TOS|DELTA!'.RUT110527C820' as the cell value.

I like to have that with Interactive Brokers also because
I trade options on the Amsterdam Index the AEX.
That cannot be done at TOS unfortunately.

Is there a way to get the data from IB ?
The TwsDde.xls spreadsheet from IB is clumsy.
The IB-excel adaptor from company DataOutreach has been
withdrawn (?).

Is there a way to get data from IB in a spreadsheet cell ?

 

I think TWSDDE was an older way.

Have you tried the newer ActiveX support?

 

what do you mean clumsy? imo-it's simple and pretty easy to use.
agree on activex and VBA combo

There is TWSAPI group on yahoo. it's pretty active.you can ask specific questions ovethere,if you run into a problems with either DDE or activex