RTD
Retrieves real-time data from a program that supports COM automation.
Lookup & ReferenceLookup & Matching Essentials
What it does
Fetches real-time data from a COM server (e.g. stock quotes).
Syntax
RTD(progID, server, topic1, [topic2], ...)
Arguments
progID(text) — Program ID.server(text) — Server name (usually null).
Examples
Real Time Data
Get data (Conceptual).
FORMULA
=RTD("prog",, "topic")RESULT
(Live Data)
SAMPLE DATA
| A | |
|---|---|
| 1 | Result |
| 2 | (Value) |