Practice free

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.

FormulaExcel showsCase
=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 .