Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Lookup and Reference > RTD
 

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

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

 progIDThe programmatic ID of the registered COM add-in.
 serverThe name of the server running the add-in.
 topic1The first parameter to pass to the add-in.
 topic2The second optional parameter to pass to the add-in.

 REMARKS
 
  		• 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" must be enclosed in speech marks.
     
  		• 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 2002.

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

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top