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
| Argument | Required? | What it does |
|---|---|---|
| ProgID | Yes | The registered program ID of the RTD server, in quotes. |
| server | Yes | The machine running the server. Use "" for your own computer. |
| topic1, … | Yes / Optional | Up 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
- For stock data in Microsoft 365, the built-in Stocks data type or STOCKHISTORY may be simpler.
- Related functions: STOCKHISTORY, WEBSERVICE.

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.