Real-Time Data (RTD) Function

The Real-Time Data (RTD) function retrieves data in real time from programs that support COM automation. For details on how to create a COM Automation server for use with the RTD function, refer to this article: How to create a RealTimeData server for Excel.

View Example: Use the RTD Function in the Spreadsheet Control

The following properties allow you to control real-time data updates:

Syntax

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

The following table describes the function’s arguments:

Argument Description
ProgID The data server’s programmatic ID.
server The name of the machine on which the real-time data server is running. If the RTD server is running locally, the server name is an empty string or can be omitted.
topic1, topic2, … Specifies the data to retrieve from the real-time data server. At least one topic is required.