TWS and Excel - how fast get list of combo ?

Discussion in 'Automated Trading' started by VladimirN, Sep 30, 2011.

  1. VladimirN



    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

    But this insane-slowly.

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

    please advise.


    P.S. Is there way for fast import symbols from TOS (Think or Swim) to Excel ?
  2. 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.