Using Reuters' RTD quote system in VBA

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.
 
J

Jacob Skaria

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
 
C

cluckers

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run time 1004 5
How to use RTD + Bloomberg/Reuters 0
Hiding RTD calls 1
.NET RTD on Excel 2007 & Vista 0
Excel 2007 SP1 - How to do F9 in VBA code? 3
"Unable to get the RTD property of the worksheet function class" 2
Using VBA to parse RTD objectdata 3
Excel User Defined function calling RTD 0

Top