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
2
votes
1 answer

How do I create an Excel automation add-in in C# that wraps an RTD function?

I have a working RtdServer-based automation add-in: How do I create a real-time Excel automation add-in in C# using RtdServer?. Creating a VBA wrapper is trivial: Function RtdWrapper(start) RtdWrapper =…
Frank
  • 3,029
  • 5
  • 34
  • 43
2
votes
1 answer

Dynamic RTD Data Recording to Another Sheet

This code works fine when the data is presented from a range of C4:C7 column however my worksheet is setup with data in a row from C4:K4. I can't get a row instead of a column to work out. Any help? Thanks . Sub RecordData() Dim Interval As…
mjac
  • 125
  • 11
2
votes
0 answers

Excel RTD and Server in python

I'm looking to implement an Excel RTD Server that sends a request to a server and retrieves the information. As an example, the idea is the following: The user would type something like =GetDuration("US912828D804"), where the parameter is the ISIN…
Jose Pedro Melo
  • 21
  • 5
2
votes
1 answer

Excel RTD COM server - Cannot cast UpdateEvent (class) to IRTDUpdateEvent (interface)

This issue is related to a blog post by Kenny Kerr on "Excel RTD Servers: C# Interfaces", which can be found here, that should allow you to build an Excel RTD server without including a reference to any specific Excel type library; having to include…
Shep
  • 539
  • 3
  • 8
2
votes
0 answers

Communicating to a RTD Server in Java instead of Excel

I have a RTD plugin that provides an Excel sheet with Real Time Data of prices. However, I want to avoid the Excel link and I would like to directly communicate to the RTD server with a Java program such that I can retrieve data and send it to a…
Robert
  • 37
  • 8
2
votes
2 answers

How to work around `pywintypes.com_error` using pyrtd/pythoncom?

I am trying to use the pyrtd module for Python to get the information which can be got in Excel through RTD. However, when I try to run the sample python script, I get the following error: pywintypes.com_error:( -2147221164, 'Class not registered',…
Eric Wang
  • 1,009
  • 1
  • 9
  • 16
2
votes
1 answer

Out of process RTD server

I'm trying to embed an RTD server into a preexisting C# application. The Microsoft docs state that the "RTD server can exist as an ActiveX DLL or as an .exe that runs on the same local computer or on a remote server. " so I do believe this is…
MarkNS
  • 3,811
  • 2
  • 43
  • 60
2
votes
0 answers

similar function like RTD() of ms-excel to insert into database

I am currently fetching real time data which i get in my excel sheet using =rtd(some parameters) the way RTD function evaluates those parameters and gives some value, is there a similar function in php/some other that can do the same, passing the…
dhpratik
  • 1,100
  • 4
  • 19
  • 43
2
votes
1 answer

Excel RTD multiple cells

I did a single cell subscription, so when I put the formula into the cell, it updates it correctly. Now, I'm returning an object with multiple values and I want to display all of them in Excel cells. Is it possibly to only put a formula in 1A,…
Alexey
  • 3,607
  • 8
  • 34
  • 54
2
votes
1 answer

ZeroMQ -> Excel RTD server .. Is it that difficult?

I am just starting with zeromq. I've got various platforms / languages all talking to each other nicely now and I must admit - it does a really good job. The last piece of the jigsaw I'd like to do is (as title). Pretty simple, create a cell in…
Richard Green
  • 2,037
  • 2
  • 20
  • 38
2
votes
1 answer

Accessing Microsoft Excel RTD Server from javascript?

Are there any javascript libraries for accessing MS Excel RTD server? I would like to retrieve realtime data from a RTD server from javascript and display it in browser. I don't want to do it on the server side because it can become a scalability…
Heramb Deware
  • 21
  • 3
1
vote
2 answers

Excel Add-in not show up in 64 bit Excel (Add-In Express)

I have an Excel add-in (COM AddIn, XLL, RTD) , created with C#, VS2010, Add-In Express 2010, I install it on a PC with win 64 bit + Excel 2010 64 bit without error, but it does not show up at all. (no toolbar, no ribbon, not in inactive addin…
toosensitive
  • 2,335
  • 7
  • 46
  • 88
1
vote
2 answers

alternative spreadsheet for real time data

I am looking for an alternative spreadsheet to Excel, preferably but not necessarily open source, that allows a programmer to create a plugin that can update cells in the sheet from an external data source in real time. The spreadsheet would then…
freddy smith
  • 3,347
  • 5
  • 24
  • 28
1
vote
2 answers

.NET/COM Exception with IRTDUpdateEvent

We built an RTD Server assembly which has been in wide use for several years. (It was built with VS 2008, .NET 3.5 Target Runtime.) Today a user reported getting the following Exception: System.InvalidCastException: Unable to cast COM object of…
Sam Goldberg
  • 6,711
  • 8
  • 52
  • 85
1
vote
1 answer

How to debug a RTD Server C# Implementation

I'm trying do learn how to implement a RTD Server for Excel. I found this project https://www.codeproject.com/Articles/5343545/Create-Csharp-DCOM-Simple-Server-to-Use-Excel-RTD that I could build and use it in the excel with success. But to…
Kleyson Rios
  • 2,597
  • 5
  • 40
  • 65
1
2
3
…
8 9