I'm no technology expert so would appreciate any help.
I've downloaded the latest version of TWS API and ticked the "Enable ActiveX and Sockets Clients" box under API Settings in TWS.
However, when attempting to run the sample Excel sheet TwsRtdServer sheet or building simple RTD functions to bring in stock prices I get #N/A error codes.
Any idea what might be the reason for error?
I've tried to repair Excel but the problem still remains.
After looking through Microsoft help pages I read: "RTD servers should be digitally signed. If an RTD server is not digitally signed, the server may not load, and a #N/A will be displayed in the cell(s) referencing the RTD server."
Does anyone know how to confirm that the RTD server is digitally signed?
Also, are there any specific excel COM Add-ins that have to be running for TWS RTD to work?
I¡¯m running Excel on Microsoft 365.
Svalbard