IB API in Excel and option chains

Discussion in 'Programming' started by Jgills, Jun 23, 2013.

  1. Jgills


    Has anyone use the IB api in excel to pull all listed options for a given underlyer?

    i've been trying to find an easy way to do this without having to find every strike that is listed and make a seperate pull for each.

    any help is appreciated.

  2. There's no way to find what valid strikes exist through the API, in other words there's not list you can download first from IB.

    I just get the strike list programmatically from a web-based source.
  3. Of course there is. Just call the req reqContractDetailsEx, without specifying strike. You will receive ALL the contract details for all strikes (the entire chain).

    If not specify an expiry date, will also receive all the chains for all expiries.