RTD Function Explained
The RTD function in Microsoft Excel is used to retrieve real-time data from a program that supports COM automation. It takes three arguments: ProgID, Server, and Topic1, Topic2, etc. The ProgID argument is the programmatic identifier of the COM server from which the data is retrieved. The Server argument is the name of the computer on which the COM server is running. The Topic1, Topic2, etc. arguments are the topics of the data to be retrieved. The RTD function returns the real-time data from the specified COM server.
RTD Function Syntax
RTD(progID, server, topic1, [topic2], ...)
- progID: The programmatic identifier of the Automation server from which to retrieve real-time data.
- server: The name of the computer running the Automation server.
- topic1: The first topic to be monitored for real-time data.
- topic2: (Optional) Additional topics to be monitored for real-time data.