Not a techie, but I've watched the IB videos in setting up Excel with TWS and I got through the first couple streps. Now, in video 2, I cant figure out what to put in IBApi::EClientSocket::eConnect in settings under API and Global Configuration. Anyone have time to walk me through it? (My spreadsheet keeps saying connecting in a yellow cell.) Thanks in advance.
Not familiar with the Excel API, but I have found twsgroup.io to be helpful with API specific questions.
Well, the IB online help says it all. You need to provide the host, port and client id. Host: that will be 127.0.0.1 if your TWS is running on the same machine as your Excel. Port: that will be what's configured in TWS (can't remember well cause I'm using IBGw). I think the default is something like 4001. ClientId: It's up to you to decide. Any number if fine. It identifies your client (Excel) app.