We are looking for programming help IB-Excel.

We have a number of projects like download historical ATM prices and implied Vol, dividend related option data etc.

Is there anyone out there who can help?

Kind regards

There are a few options to do what you want to do :

1. create an excel plug-in, this means you create functionality that would be available
to any workbook that you open
https://msdn.microsoft.com/en-us/library/cc668205.aspx

2. create VB script that calls the data, that code is then specifically part of you current
workbook, it is a macro that you activate and that goes and gets the data

3. You can use DDE (dynamic data exchange to talk to IB TWS)
https://www.interactivebrokers.com/en/?f=%2Fen%2Fgeneral%2Feducation%2Fpdfnotes%2FPDF-TwsExcelAPI.php

Each of the solutions have their pro's and con's

Good luck

I think you should explore this link.

https://www.interactivebrokers.com/en/?f=%2Fen%2Fgeneral%2Feducation%2Fpdfnotes%2FPDF-TwsExcelAPI.php

They have a spreadsheet built to communicate via DDE with TWS.

It explains how to download and setup. See if this starts to meet your needs or if you need advanced programming.