[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
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 |
The name of the program from which the data is to be retrieved. | |
rtd-server |
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]