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

Worksheet.Calculate_Cell Change Copy Adjacent Cell Text

The Apple & Orange Volume are constantly changing values and I need to copy the adjacent Buy/Sell cells once the volume changes. I know I need a Worksheet_Calculate script to do this can you help me start it out? So if a volume of an Apple went…
mjac
  • 125
  • 11
0
votes
1 answer

RTD Client in C#

I'm trying to write a simple RTD client to start with something, but I seem not able to make the initial connection. I have found some examples on the web, and best seemed to be this RTD client in C# gist. Having this on MS-Excel:…
Avenger
  • 177
  • 1
  • 8
0
votes
1 answer

How to make multiple socket DDE & RTD requests faster

So, basically I have a python program and I need to intercept 137 DDE & RTD signals that are feeding excel files. I'm doing this by using a socket with the following code: import socket import win32api s = socket.socket(socket.AF_INET,…
Enzo Dtz
  • 361
  • 1
  • 16
0
votes
0 answers

Does Apache POI implement RTD from Excel?

I'm using Apache POI to read and write MS Excel files that contain Excel's RTD (real time data) formula in some of the sheet's cells. When evaluating a cell, I call: cell.setCellFormula( (String) field); Field is the RTD formula that I'm calling.…
nick
  • 18
  • 4
0
votes
1 answer

Where is OMSDataSet.xml (used by EZoms and EZomsRTD)?

Some times the user needs to wipe the cache of stored orders. This could be done by deleting OMSDataSet.xml file. Where is it located?
Sam Goldberg
  • 6,711
  • 8
  • 52
  • 85
0
votes
1 answer

RTD Excel function return "#N/A". How to run Lightstreamer Excel (RTD) Client?

I have problem with Lightstreamer-Basic Stock-List Demo - Excel(RTD)Client (https://github.com/Lightstreamer/Lightstreamer-example-StockList-client-rtd). I have installed Lightstreamer Server locally which work perfectly(http://localhost:8080). I…
Rafał Bąk
  • 1
0
votes
1 answer

How to sum a single cell that is dynamic?

Input is a Real time data (RTD) function. So it constantly changes. Additionally, at times the value remains same meaning it should NOT be included in the sum. RTD inputs in a SINGLE Cell (A1) as time progresses: 100, 30, 40, 40, 40, 30,30,190…
Nick Chan
  • 1
0
votes
0 answers

How do I create multiple instances of an out of process RTD server?

I have an RTD server that I created, and I want a different instance for each workbook as each workbook will use a different API key to access some data. In other words, if I open Workbook1, and it uses Key#1, when I open Workbook2, I don't want it…
Brett
  • 1
0
votes
0 answers

How to set overrflow-x; visbile and overflow-y: scroll on the same div

I have a sidebar, that has some predefined classes, that I have to use. I cannot make other divs. I have to use those ones. The problem is I have a search input and a table of contents. EXPECTED RESULT: The table of contents should be…
user10104341
0
votes
0 answers

Is it possible to have a different Application.RTD.ThrottleInterval for different Workbooks?

I have two workbooks that have RTD links (Real Time Data). On most of my workbooks, i dont need the data to update faster than once every 4-5 seconds, however - I would need only 1 of my workbooks to update as fast as possible…
novawaly
  • 1,051
  • 3
  • 12
  • 27
0
votes
1 answer

OnTime TimeStamp Value Doubling Up

When you launch RecordData() sub (from OpenMe() sub) just once it works perfectly. Each time stamp log is consecutive with no doubles. Its when the workbook, re-opens again (due to OpenMe()/Close() subs) is when it creates a duplicate time stamp…
mjac
  • 125
  • 11
0
votes
0 answers

RaycastHit.triangleIndex alternatives

I am working on a Real-time destruction plugin for unity but I have run into some problems as far as mesh manipulation is concerned. what I am trying to do: cut a hole out of a mesh by removing the front and back sides of the 3d mesh. Example…
ari b
  • 1
  • 1
0
votes
1 answer

auto save excel workbook on every auto update change

I have an excel workbook which pulls stock data from from another source (open, close, net position etc.) The point is, I would like to save a CSV file with every data change, for example, I have entered a position with 100 stocks, the excel has…
Mr.Riply
  • 825
  • 1
  • 12
  • 34
0
votes
0 answers

How to stream FIX Market Data to Excel using RTD

Currently, I'm running a C# Win Form application to get market data stream via FIX (Financial Information Exchange), And also, I already build an RTD Server to update value to Excel spreadsheet. Currently, it's just a simple one, generate a random…
Frank
  • 51
  • 8
0
votes
1 answer

Trying to build Excel RTD server in Delphi

I'm trying to build an RTD server for Excel in Delphi and I cannot get this part of the code to work: function TRtdServer.RefreshData(var TopicCount: Integer): PSafeArray; //Called when Excel is requesting a refresh on topics. RefreshData will be…
Bigman74066
  • 408
  • 4
  • 12
1 2 3
…
8 9