View Single Post
  #2   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

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.