Questions tagged [rtd]

RTD (Real Time Data) is a feature introduced with Excel 2002 to display data provided by an RTD server. For questions regarding real-time data outside Excel choose the tag 'real-time-data'.

RTD (Real Time Data) is a feature that has been introduced with Excel 2002. It provides the ability to display data in real time within the sheet. The data is provided by a so-called RTD server (not to be confused with a hardware server), which is an external program that binds through an IRTD interface that's based on COM interaction.

124 questions
-1
votes
2 answers

RTD in Excel VBA ( need to call data from rtd )

I was looking for the same answer where I need to call data from a RTD server Sub Test() Range("d1") = RTD("tickerplantrtdserver", , 4#2#1#6768#FUTSTK#N1#0#XX#Bid) End Sub When I extract data from Excel RTD("tickerplantrtdserver", ,…
-1
votes
2 answers

Pause RTD server in Excel and save worksheet

I have worksheet which gets data from RTD server through the following formula: =RTD("tos.rtd", , "ASK", ".SPX150220C750") I would like to save the worksheet with above formula every 1 minute or so. The challenge is to pause VBA code and also make…
user1700890
  • 7,144
  • 18
  • 87
  • 183
-1
votes
4 answers

RTD server in C# - where to start

I have RTD server in Excel, which pull data from thinkorswim application. I would like to pull data into C# instead. I have limited programming experience and therefore read multiple tutorials on RTD server implementation in C#, but most of the them…
user1700890
  • 7,144
  • 18
  • 87
  • 183
-1
votes
1 answer

How do I autoformat excel cells that contains both strings and numbers?

I have written an RTD server that I wrap in a UDF - both in C# which looks like this: public object MyUDF(string ItemID, string TopicName) { return _xlApp.WorksheetFunction.RTD("my_rtdserver", null, TopicID, TopicName); } The UDF delivers…
Pat Mustard
  • 1,852
  • 9
  • 31
  • 58
1 2 3
8
9