Using Reuters' RTD quote system in VBA

  • Thread starter Thread starter cluckers
  • Start date Start date
C

cluckers

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.
 
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
 
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?
 
Back
Top