View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cluckers cluckers is offline
external usenet poster
 
Posts: 31
Default Using Reuters' RTD quote system in VBA

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.