Exporting option chain data to Excel

Discussion in 'Options' started by Corto, Jan 28, 2019.

  1. Corto

    Corto

    Will try that as well, but a while ago I entered a chat session and the customer service guy said you can only export the portfolio or watch lists.
     
    #11     Jan 28, 2019
  2. Corto

    Corto

    I guess I don't know what a QuoteMonitor page is.
    This is what I see on the option chain: Option chain.jpg
     
    #12     Jan 29, 2019
  3. tommcginnis

    tommcginnis

    Go to TWS, not TWS_Mosaic, and you'll have more choices.
     
    #13     Jan 29, 2019
  4. Corto

    Corto

    Sorry, Sir, if you want to help you'll need to guide me please. What should I open in classic TWS view? Option chain? I tried and doesn't allow me to export it.
     
    #14     Jan 29, 2019
  5. ZBZB

    ZBZB

    In classic tws with the icons at the top of the page.

    Type in rut, select options from the pop up menu,
    Another pop up gives you a box with the option strikes.
    Add as many calls and puts as you want, windows shift multi select does not work.
    Then right click and select import/export/export page in legacy excel format or export page content. Both choices save the option prices to csv file.

    Do file save so the page is there tomorrow.

    You can right click on the column headers and select customise layout and add the option greeks or anything else you are interested in to the page.
     
    Last edited: Jan 29, 2019
    #15     Jan 29, 2019
  6. ZBZB

    ZBZB

    When the second pop up with the option prices comes up it is set to eight strikes if you want more click on the 8 strikes tab and change to all then click on add all on the top right of the box to get a lot of strikes into tws quickly. You can also select rutw, whatever that is, maybe it is weeklies. If you want multiple expiries click on tabbed view and choose lit view.

    When the strikes are in tws right click and select import export to get into a csv file.
     
    #16     Jan 29, 2019
  7. ZBZB

    ZBZB

    In IB mosaic.
    Click new window then watchlist
    enter Rut then select options in popup
    Choose strikes and expiry then click on add all on the top line of the second popup.
    Then right click in the watchlist and select import/export, any one of the menu choices will let you save the option prices to a csv.

    You are trying from an options chain window that does not let you export to a csv.
     
    Last edited: Jan 29, 2019
    #17     Jan 29, 2019
  8. Corto

    Corto

    ZBZB, thank you for your effort, but I guess I'm too old for this. I set the option chain as I want it and after I click on Add All, it becomes like this:

    Screen shot 1.JPG
     
    #18     Jan 30, 2019
  9. Corto

    Corto

    And then after exporting, when I open the file it's like this:

    Screen shot 2.JPG
     
    #19     Jan 30, 2019
  10. ZBZB

    ZBZB

    [​IMG][​IMG] Worked for me. I used the export page content option and I got bid/ask/last for rut options. See attached file.

    Where are you hosting your images?
     
    Last edited: Jan 30, 2019
    #20     Jan 30, 2019