TWS API, #N/A error in Excel

[zdave83]

I don't recall ... its been years. However I'm sure I followed the API guide ......

http://interactivebrokers.github.io/tws-api/excel_apis.html

Might try deleting the existing or inactive one, and re-add from scratch.

 

[Svalbards]

Ok thank you I will try that again.

 

[fxnewman2]

Did you ever figure this out? I have the same problem, neither TWS nor Excel support could fix it, and they spent a good amount of time trying.

 

[Svalbards]

I never got any further on this unfortunately. I’ll have a stab at it again soon.

 

[GreatRedOne98]

Hello - I had the same problem with TWS API RTD Server for Excel - solved it by the following:
- with Visual Studio (using 2022) - run VS as Adminstrator
- Load the project(s) in the TWS API directory under - source
- build the C# Projects ( I did them as .NET framework 4.8 and 64xbit architecture)
- since you are running the VS as Admin -
- when the projects build (..\TWS API\source\CSharpClient\TwsRtdServer) - during the build VS will update the registry to point RTD to the .dll you just built.

probably a couple of steps I left out - TWS API for Excel is built using C#. You can always build the Sample C# App to test functionality.

Hope that helps -