RTD function
RTD connects a cell to a COM real-time data feed, such as market data from a provider's add-in, and returns the live value. It works on Windows only, needs a registered server, and is rare outside finance.
Example
=RTD("prog.id","","topic")
Expected result: n/a Not yet checked in desktop Excel
Syntax
RTD(prog_id, server, topic1, [topic2], ...)
Arguments in [square brackets] are optional.
-
prog_id(required) - ProgID of a registered real-time data server.
-
server(required) - Server name; leave as "" for a local server.
-
topic1(required) - First topic the server understands.
-
topic2(optional) - More topics.
Returns: A live value streamed from a real-time data server.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=RTD("nonexistent.progid",,"x") | #N/A | No RTD server registered |
Watch out for
- Needs a compatible COM server installed and registered.
- It recalculates on the server's update schedule, not yours.
Where it works
- Excel
- RTD is in every version of Excel from 2007 on. Windows only; requires a registered RTD server.
- Google Sheets
- No direct equivalent. No equivalent; Sheets uses GOOGLEFINANCE or add-ons.
Part of Lookup and reference functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .