Stack Overflow
Stack Overflow

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
26
votes
3 answers

How do I create a real-time Excel automation add-in in C# using RtdServer?

I was tasked with writing a real-time Excel automation add-in in C# using RtdServer for work. I relied heavily on the knowledge that I came across in Stack Overflow. I have decide to express my thanks by writing up a how to document that ties…
Frank
  • 3,029
  • 5
  • 34
  • 43
8
votes
5 answers

Excel RTD server in Python not updating data

I've got the excelRTDserver.py up and running in Excel 2010 (32bit) by changing the EXCEL_TLB_MINOR value to 7. I can see the server in the add-ins list and if I enter =RTD("Python.RTD.TimeServer","","seconds","5") into a cell, I get the current…
MatlabSorter
  • 1,290
  • 1
  • 11
  • 19
7
votes
2 answers

How to read temperature using arduino uno board with PT100 RTD sensor?

I am new to arduino programming. And almost inexperienced. I am looking to program my arduino Uno board to read 2/3/4 wire configuration of PT100 RTD sensor (in accuracy levels of atleast 0.5°C). The temperature range is 0 to 400°C and -50 to…
Mayur Agarwal
  • 71
  • 1
  • 1
  • 4
5
votes
1 answer

Excel RTD Server Development in C++

I want to write an excel RTD server in C++ but have not yet had any luck finding and complete tutorials on how to do so aside from this http://weblogs.asp.net/kennykerr/archive/2008/12/02/Rtd5.aspx. However, as I am new to this stuff, I think I…
Pat Mustard
  • 1,852
  • 9
  • 31
  • 58
5
votes
3 answers

Excel RTD (Real Time Data) client other than Excel?

I have been looking all over, and couldn't find any example for an RTD CLIENT (many RTD server samples, though). My goal is to 'pull' data from an RTD server into my application for algo-trading purposes. If possible, without using C# / .Net, as I…
Gil
  • 51
  • 1
  • 3
5
votes
2 answers

C# Excel RTD Server Multiple Instances disconnect all formulas on one sheet stops formulas on the other

I have created an RTD server for Excel in C# that constantly updates cells with data and needs to work with multiple instances of Excel. The issue is if I have the same RTD formula in more than one instance of Excel and I delete the formula in one…
Megaman82
  • 53
  • 4
4
votes
1 answer

How do I enable an Excel Automation Add-in through the registry?

I have an Excel Automation Add-in that is registered with COM by my installer. By registering with COM, my add-in appears in the (for Excel 2007) Excel Options > Add-Ins > Manage Excel Add-Ins Go... > Automation list. The users must still navigate…
Frank
  • 3,029
  • 5
  • 34
  • 43
4
votes
1 answer

How to serve static non-image asset from a readthedocs site?

I have an assets folder in my docs folder that contains image and sample input files associated with my project documentation. The images embed correctly in my documentation, but any links to sample input files (static files that are inputs to my…
Alex Reynolds
  • 95,983
  • 54
  • 240
  • 345
3
votes
1 answer

Excel RTD: running multiple instances, how to include formulas from the other workbook instance

We have a user who is running 2 separate workbooks which need to share data: Pricing workbook which has RTD to receive updated market data Order Placement workbook which uses RTD to place orders and receive status updates Because of limitations in…
Sam Goldberg
  • 6,711
  • 8
  • 52
  • 85
3
votes
0 answers

VBA Copy real time data value to another cell, same worksheet

I have a formula in cell "D1" for receiving RTD, which works and get continuously updated data. Now, I need a copy of this cell (only VALUE) in another cell "B2", same worksheet. When i try the code I have found so far, the "B2" cell stays…
Fabian S.
  • 31
  • 3
3
votes
0 answers

Displaying error messages to the Excel user from an RTD Server

Is there a way to display details of an error to the user other than putting #ERROR# in the cell? I would like to validate the topic arguments and somehow prompt the user with the correct format if they are incorrect. If this isn't possible, is…
Franchesca
  • 1,453
  • 17
  • 32
3
votes
1 answer

Excel calls IRTD.ServerTerminate while there are still active RTD formulas in a sheet

I have a C# RtdServer that receives data updates from a TCPListener. It's runs as expected except for that at certain points when it still has active RTD()s in the sheet ServerTerminate() is called and I can't seem to figure out why. I was of the…
Pat Mustard
  • 1,852
  • 9
  • 31
  • 58
2
votes
1 answer

IronPython Excel RTDServer

How do you build a Excel RTDServer in Python/IronPython. (IE I want to implement the IRTDServer interface in Python/IronPython. So I can push data into Excel in real time from Python/IronPython) I have looked all over the place but the only…
Josh
  • 784
  • 6
  • 13
2
votes
1 answer

RTD client in Python

my goal is to get the updates of an rtd server in python I've following call in excel which is working: =RTD("xrtd.xrtd";;"EUCA") For python I've found following client library: https://github.com/brotchie/pyrtd/blob/master/rtd/client.py I tried to…
Hunk
  • 479
  • 11
  • 33
2
votes
2 answers

RTD - making the sample COM DLL into a COM exe

I'm planning on making my existing application into an RTD server. The application is currently written in C++ and while I will eventually port it to C#/Mono I want to be able to add the RTD functionality with C++. I have found a few sample…
Tim
  • 20,184
  • 24
  • 117
  • 214
1
2 3
…
8 9