RTD function
Retrieves real-time data from a program that supports COM automation
Syntax
RTD(progId, server, topic1, [topic2])Square brackets indicate optional arguments.
Arguments
| Argument | Required | Meaning |
|---|---|---|
| progId | Yes | 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."mycomaddin.progid" |
| server | Yes | 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 property are required for the server, even if the server is running locally."" |
| topic1 | Yes | Topic1 is required, subsequent topics are optional. 1 to 253 parameters that together represent a unique piece of real-time data."Topic" |
| topic2 | No · repeats | Topic1 is required, subsequent topics are optional. 1 to 253 parameters that together represent a unique piece of real-time data."Item" |
Try RTD
Use the editable table to build your own formula.
Inspect the current formula
Read its written arguments or observe actual operation values in a separate local calculation. This action neither applies a draft nor grades an answer.
Calculate observations to inspect arithmetic, comparison, concatenation and reference operators. No operation values have been recorded yet.
Follow the cells behind a result
Read explicit local references and helper formulas using a separate calculation. Your draft stays in this field; the worksheet and practice checks do not change.
The worksheet runs locally. Published checks apply to the supplied example only. Native Excel and Google Sheets compatibility remain unverified.
Reference and compatibility
Univer 1.0.4 / Apache-2.0. Calculation checks cover the supplied examples only. The browser worksheet does not implement every Excel feature, external service or connected data type.