View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Using Reuters' RTD quote system in VBA

Refer the below link

http://support.microsoft.com/default.aspx/kb/285339


"cluckers" wrote:

I am trying the following



ActiveCell.Value = WorksheetFunction.RTD("ReutersRTD.HistoricalQuote" ,
"10.27.243.33", E1, "close", "09/02/2009", "")


and it retunrs the error:
runtime error 1004
unable to get the RTD property of the WorksheetFunction class

any ideas?


"Jacob Skaria" wrote:

Worksheetfunction.RTD(arguments..)

The only difference from that of using this in VBA is that the server
argument is required....

If this post helps click Yes
---------------
Jacob Skaria


"cluckers" wrote:

Do you know if it is possible to use Reuters' RTD quote system in a macro.
The normal worksheeet function is

=RTD("ReutersRTD.HistoricalQuote",,"symbol","close ","date","")

Where the variables symbol and date have to be assigned to a value and close
is the closing price on that date.

I am trying to put this in a loop function that will pull the previous days
closing price when applicable.