RTD Function

Streams real-time data from an add-in or program into a cell.

Category

Lookup & Reference

Available in

Windows desktop, Microsoft 365

Returns

Live data from a server

Overview

RTD (Real-Time Data) connects Excel to a COM automation server — usually a trading platform or data feed add-in — and updates the cell as new data arrives.

You'll only use RTD if a provider gives you a ProgID and topic strings to plug in.

Syntax

=RTD(ProgID, server, topic1, [topic2], …)

Arguments

ArgumentRequired?What it does
ProgIDYesThe registered program ID of the RTD server, in quotes.
serverYesThe machine running the server. Use "" for your own computer.
topic1, …Yes / OptionalUp to 253 strings describing the data you want (e.g. ticker and field).

Examples

Example 1 — A live price from a data add-in

Your provider's documentation will give the ProgID and topics. A typical call looks like:

=RTD("provider.rtd", "", "MSFT", "Last") Explain

Example 2 — Topics from cells

Build a watch-list by pointing topics at cells.

=RTD("provider.rtd", "", A2, "Last") Explain
Adjust update speed under File → Options → Formulas if the feed slows Excel down.

Common mistakes

  • #N/A errors. The RTD server isn't installed or registered on this computer.
  • Mac / web users. RTD relies on Windows COM and isn't available in Excel for Mac or the web.

Notes

Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.