Lookup & Reference
All versions
◉ 23 views
Dynamic Array
=RTD()
Retrieves real-time data from a program that supports COM automation.
Applies To:
Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016
=RTD(ProgID, server, topic1, [topic2], ...)
Hover argument names in the table for details.
Output typeValue
Popularity37 / 100
VolatileNo
Dynamic ArrayYes
Download sample .xlsx ▦ Try in Playground
Dedicated file for this function — safe & lightweight · sample data + live formulas
⬇ Download Sample Workbook
A dedicated .xlsx for =RTD() with Persian sample data & live formulas — open in Excel and practice.
- Sheet “Sample” — data table + formula in place
- Sheet “Guide” — syntax, arguments & tips from this page
- Instant & secure (token + rate limit)
Quiz this function
%d questions — syntax, example & errors — test yourself!
◧ Arguments
| Argument | Type | Required | Description |
|---|---|---|---|
progID |
Text | Required | The name of the ProgID of a registered COM automation add-in that has been installed on the local computer. Enclose the name in quotation marks. |
server |
Text | Required | Name of the server where the add-in should be run. If there is no server, and the program is run locally, leave the argument blank. Otherwise, enter quotation marks ("") around the server name. When using RTD within Visual Basic for Applications (VBA), double quotation marks or the VBA |
nullString |
Text | Required | property are for the server, even if the server is running locally. |
topic1 |
Text | Required | , topic2, ... Topic1 is required, subsequent topics are optional. 1 to 253 parameters that together represent a unique piece of real-time data. |
▣ Examples
Real-time data retrieved from a program that supports COM automation.
=RTD("mycomaddin.progid",,"Server_name","Price")
Result:
#N/A
§ Remarks
- The RTD COM automation add-in must be created and registered on a local computer. If you haven't installed a real-time data server, you will get an error message in a cell when you try to use the RTD function.
- When the server has been programmed to continually update results, unlike other functions, RTD formulas will change when Microsoft Excel is in automatic calculation mode.
✦ Tips
- The RTD COM automation add-in must be created and registered on a local computer. If you haven't installed a real-time data server, you will get an error message in a cell when you try to use the RTD function.
- When the server has been programmed to continually update results, unlike other functions, RTD formulas will change when Microsoft Excel is in automatic calculation mode.
💬 Comments & Q&A 0 approved
🔒 Your comment will be published after review.Share your thoughts — visible after admin approval
No comments yet — be the first!