RTD

RTD(progID, server, topic1 [,topic2])

Returns the real time data from a program that supports COM.

progID	The name of the registered COM add-in.
server	The name of the server running the add-in.
topic1	The first argument to pass to the server.
topic2	(Optional) The second argument to pass to the server.

REMARKS

* For an illustrated example refer to the [[RTD Server]] page.
* The RTD COM automation add-in must be installed and registered on the computer.
* No RTD servers are shipped with Microsoft Office, so you must manually install a real-time data server if you want to use this function.
* The "progID" must be enclosed in speech marks.
* The "server" can be left blank for testing but if the data is coming from a different machine, this machine name must be provided.
* If the real-time data server is being run locally then leave the "server" argument blank.
* This function will only continuously update when the calculation mode is set to automatic.
* 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.
* You can have a maximum of 28 topics.
* This function was added in Excel 2003.
* For the Microsoft documentation refer to support.microsoft.com

	A
1	=RTD("MyCOMAddin", , "price", "MSFT.O")
2	=RTD("BLOOMBERG.RTD", "", "AAC EQUITY", "SECURITY"_TYP")
3	=RTD("BLOOMBERG.RTD", "", "XS0115748401 COMP", "QUOTE_ASK")
4	=RTD("K4RtdServer", , "plant1", "quote", "bid", "MSFT.O")
5	=RTD("ExcelRTD.RTDFunctions", , "Log", "True", "C:\Temp\TestLog.txt")
6	=RTD("SIXP.RTD", , "/rt/stock/quote?Mkt=""SSE""", "SEE.ERIC-B", "TrVo", "UPDATES=ALL")