how to get option greeks in IB excel spreadsheet

Discussion in 'Options' started by adamchubb, Dec 9, 2010.

  1. does anybody know how to get the option greeks in IB excel spreadsheet? Using the standard IB Excel spreadsheet, I can only get the delta and IV. How can I get the real-time link to other greeks????
     
  2. Look at their beta version and you should get all the other greeks. However the days to expiration feature is missing and you will have to enter them manually day by day when using excel.

    Call their API tech support and let us know if they were able to solve your problem.
     
  3. do a web search on option greeks + excel.

    Peter Hoadley's web site offers a loy of online calulators as well as excel add ons.