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
0
votes
0 answers

RTD formula not working after migrating from .NET 4.x to .NET 7

I have an implementation of RTDServer working fine in .NET Framework 4.x and I am trying to upgrade to .NET 7 but still have problems. This is my basic example in .NET 7, Server.cs: using System; using System.Runtime.InteropServices; using…
Giuseppe Corti
  • 76
  • 4
0
votes
0 answers

How do I get the last RTD update time in Excel?

I am using the RTD Excel function to subscribe to topics of a ProgID like this: =RTD("tos.rtd",,"LAST","SPY") If I have a number of cells with different topics from that ProgID, how can I determine the last time each was updated, even if the value…
feetwet
  • 3,248
  • 7
  • 46
  • 84
0
votes
1 answer

Is there a way to freeze, snapshot, and chart streaming RTD data?

I have real-time data streaming from another application into Excel and making =RTD() calls successfully in a complex workbook. Trying to (a) compare historical data as of a moment in time to current/live data, and, (b) run stats on snapshots taken.…
KevinB
  • 1
0
votes
0 answers

Microsoft Excel RTD Server Problems

I created a VBA macro with a RTD (Real time data) connection to capture some data in real time for an excel spreadsheet. It happens that from time to time, when the macro runs, sometimes the code stops and Excel gives the following message: "The…
Marcel
  • 1
  • 3
0
votes
1 answer

In =RTD(ProgID,Server,String1,[String2],...), passing array for String2, String3 and so on

is there any way to pass myStringArray to the RTD function? Data = "A,B,C" Dim myStringArray() As String ` myStringArray = Split(Data, ",")` Application.WorksheetFunction.RTD("rtd.server.1", "", "" + URL+ "", "User", "Query",…
Vimla Sharma
  • 1
0
votes
0 answers

How and with which steps can I install ReadTheDoc on my server and connect it to Gitlab?

By default, our friends use readme.mds in MarkDown format as documents on our Gitlab server. We want ReadThedocs (RTD) to be prepared as ReadThedocs (RTD) with rst extension on Gitlab server and documents can be read in RTD format in a more…
sysoptr
  • 1
  • 2
0
votes
1 answer

Getting UpdateNotify error when implementing a python RTD client

I'm trying to implement an RTD client using this project as an example, but without success. Instance as RTD server the example contained in the win32com package below, and in Excel it works perfectly, but in the RTD client used as a template, it…
Luis Chaves
  • 31
  • 4
0
votes
1 answer

RTD #N/A error in Excel 365 only when RTD COM object is registered at the user level

I am developing a COM object that implements the excel RTD interface using .NET c#. It is a x64 bit project and office is also 64bit. The 64bit RTD COM object works just fine in Office 2016 (also 64bit). I can register the COM object at the CURRENT…
Mike Messina
  • 11
  • 2
0
votes
1 answer

Using blp.live with Pyxll Asyncio RTD in python

I am new to Pyxll and Asyncio and having trouble get the following code going. I kept getting the initial value = 0 on the spreadsheet and it's not refreshing. Could you help and let me know what I did wrong? I followed the example from Pyxll's…
DLW
  • 121
  • 1
  • 2
  • 8
0
votes
1 answer

Excel RTD - stops updating when user is typing into another Worksheet. Is there a workaround?

We have a user using Excel 2019 (64 bit) RTD to stream market data into his Excel worksheet. When he types into a different Worksheet (totally separate Excel Window), the market data stops updating into the other Worksheet until he is done…
Sam Goldberg
  • 6,711
  • 8
  • 52
  • 85
0
votes
0 answers

MAX31865 C++ Class on Raspberry Pi with pigpio SPI functions

I am looking for some guidance on integrating a MAX31865 board into my Raspberry Pi project with a Qt front end. The board contains 4 MAX31865 chips with separate CS pins. I have confirmed the chips / RTDs are working correctly with both Arduino and…
TyrantUT
  • 29
  • 1
  • 5
0
votes
1 answer

Multiple Array Calculations

Script below runs a array difference calculation then processes the data further if other criteria is met. I need to add one additional criteria to filter the data further before it logs the final output to Sheet1. Need to add the "Location" in…
mjac
  • 125
  • 11
0
votes
0 answers

Subtract Updated Array w/ Stored Array Values

Script below currently stores an array and then compares it to an RTD updated array and outputs if there is a change. If there is no change then it will not log the change. Works great, but now I need an output log of the difference if a change…
mjac
  • 125
  • 11
0
votes
0 answers

Recording Values from Workbook_1 onto Workbook_2

Having issues linking the values from Workbook_1 to appear on Workbook_2. I am not seeing the syntax error. Set Capture line is flagged. Any help much appreciated. Sub RecordData() Dim NextTime As Date Dim Interval As Double Dim cel As Range Dim…
mjac
  • 125
  • 11
0
votes
0 answers

Python RTD server won't update

I am running this example of a RTD server. I make the call in excel: =RTD("Python.RTD.TimeServer","","seconds","5") The first call works, but than it doesn't update anymore. There is an error: pywintypes.com_error: (-2147221008, 'CoInitialize has…
Borut Flis
  • 15,715
  • 30
  • 92
  • 119
1 2 3
…
8 9