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.