Hi Interactive Brokers (IB) API question: Excel's VBA and ActiveX. It is confirmed by IB that there is no (Today's) OPEN available via DDE for Excel. I do not have to express how ridiculous this is, not to have such fundamental trading information available in any API! As it is available via ActiveX, I would like to ask any of my fellow trading colleagues if one of you could explain to me what exactly to do to make ActiveX work in Excel via VBA. At least, how to get the OPEN data automatically into my sheet (as soon as it exists). This would be crucial for my Gap play. I managed to build a Visual Basic mini application (by copying it from a sample video from somebody else), but I cannot take that over 1:1 into Excel's VBA. I donât know how the âPrivate Sub xxx yyy â¦â line has to look like in Excel, and also the commands seem to differ from VB where it is AxTws1.xxx, but not so in Excelâs VBA â at least I think so. I also would like to avoid (another) third party application to make this available, to understand the API and ActiveX (in Excel's VBA) and also to avoid yet another third (or fourth or fifth or â¦) party software. So anyone who could post some needed lines or make a simple sample Excel sheet available would be not only helping me, but many more desperate traders as I run into a lot of postings here and there all suffering from the non-available OPEN via DDE. Thanks a lot!