The RTD function retrieves real-time data from a program that supports COM automation.

Syntax

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

Arguments

Argument Description
ProgID The name of the ProgID, enclosed in quotation marks, of a registered COM automation add-in that has been installed on the local computer
server Name of the server where the add-in should be run

  Enclose server name in quotation marks, e.g. “myServer”
  If there is no server, and the program is run locally, leave the argument blank
  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,
[topic2], …
1 to 253 parameters that together represent a unique piece of real-time data.

  Topic1 is required, subsequent topics are optional

Examples

  A B C
1 Formula Result Notes
2 =RTD(“mycomaddin.progid”,,”Server_name”,”Price”) #NAME? Real-time data retrieved from a program that supports COM automation

Usage note: 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.