Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Reuters' RTD quote system in VBA
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. |
#4
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reuters RTGET() Functions | Excel Discussion (Misc queries) | |||
How do I open an Excel file on XP system, saved on a Vista system | Excel Discussion (Misc queries) | |||
reuters vba | Excel Discussion (Misc queries) | |||
Making a Reuters function work in VBA | Excel Discussion (Misc queries) | |||
excel causing system to be in low system resource | Excel Discussion (Misc queries) |