TWS and Excel - how fast get list of combo ?

V

VladimirN

Hi,

I am an option-trader and each day buy-selling 50 or 250 spreads, each day different, via IB TWS.

I need automated my trades, and I try do it via Excel-2007.

Tell me pls, what is easy way to get 100 different option-spreads
(COMBO-symbols, in TWS terms), from TWS to Excel?

I can manually entering each spread via Combo-button, like this described in manual

http://institutions.interactivebrokers.com/php/apiguide/interoperability/dde_excel/dde_combo.htm

But this insane-slowly.

Is there way for fast import symbols from TWS to Excel ?

please advise.

Thanks.

P.S. Is there way for fast import symbols from TOS (Think or Swim) to Excel ?
 
I think you meant to say "insanely slow".

Anyway, there definitely is a way to do this.
It'll take a little work, but I believe you can transfer the symbols for the options over to the Excel workbook pretty easily.
 
You must log in or register to reply here.
Back
Top