[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

RTD

Syntax:

RTD ( progID , [ rtd-server ] , argument-list )

Description: Retrieves data from a program in real-time. Periodically, this function returns new values and causes recalculation of the expression containing the call to it.

Arguments:

Name

Type

Description

progID

text

The name of the program from which the data is to be retrieved.

rtd-server

text

An optional string that is specific to the program with which RTD is communicating.

argument list

any

The presence and meaning of each argument in argument-list is specific to the program with which RTD is communicating.

 

Return Type and Value: array – The set of values returned by the program with which RTD is communicating.

[Example: Consider a stockprice program that is called as follows:

RTD("stockprice.rtd","NASD","MSFT")

The result it returns—the price of the stock MSFT according to NASD—changes over time, often every few seconds.

The rtd-server program could also be written to accept multiple arguments, allowing calls like the following::

RTD("stockprice.rtd","NASD","MSFT","GOOG","AMZN")

where three stock values are requested.

end example]