Posted to microsoft.public.excel.misc
|
|
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.
|