IB ActiveX-Excel

Discussion in 'Options' started by just21, Apr 1, 2002.

  1. just21

    just21

    I have a list of april options updating in excel but have put a MAy option at the end of the list but it won't update. Can any body get this to update
    ENZN OPT 180205 50 C BEST
    I have used 180205 as the day after expiry just as april is 200204. I am getting the error message
    Security definition request returned 0 items.
    thanks for any help
     
  2. just21

    just21

    Using expiry of 200204 results in data, what should i use for may expiry? According to my calender 17 th of may is expiry so i add one day to follow the april example and get 180205 but that does not seem to work.

    any help from ib excel users appreciated.
     
  3. just21

    just21

    Problem solved, ignore the expiry calendar and just use 200205!