Reuters RTGET() Functions

  • Thread starter Thread starter Chau.Jacky
  • Start date Start date
C

Chau.Jacky

I am currently have a excel file to get the exchange rate from Reuters
using RTGET() function.

=RtGet("LIVE$RATE","XAUDR","IRGROW 4")

Meanwhile, I would like to get the rate for RMB, but I failed to do so
for using the following functions

=RtGet("LIVE$RATE","XCNYR","IRGROW 4")
=RtGet("LIVE$RATE","XRMBR","IRGROW 4")

Do anyone know how to solve this problem?

Thanks a lot.
 
Make sure you have 'permissions' or rights to see that particular exchange
rate. Contact the market data support line at your employer to see if you
have proper permissions to see it . It seems to me that your connection is
working as you can see some rates. CNY and RMB are emerging market
currencies and not as readily available as AUD, GBP, USD etc. Perhaps they
need to set you up for emerging market currencies.
 
Make sure you have 'permissions' or rights to see that particular exchange
rate. Contact the market data support line at your employer to see if you
have proper permissions to see it . It seems to me that your connection is
working as you can see some rates. CNY and RMB are emerging market
currencies and not as readily available as AUD, GBP, USD etc. Perhaps they
need to set you up for emerging market currencies.
Click to expand...

Joe, Thanks for your help.
But I can query in Routers 3000 Xtra using "CNY=" to show the
currency.
Do I need any setup in 3000 Xtra in order to feed CNY into Excel file?
 
Make sure you have 'permissions' or rights to see that particular exchange
rate. Contact the market data support line at your employer to see if you
have proper permissions to see it . It seems to me that your connection is
working as you can see some rates. CNY and RMB are emerging market
currencies and not as readily available as AUD, GBP, USD etc. Perhaps they
need to set you up for emerging market currencies.
Click to expand...

Joe, Thanks for your help.
But I can query in Reuters 3000 Xtra using the keyword "CNY=" to show
the information.
Do I need any setup in 3000 Xtra in order to feed the information for
CNY into Excel?
 
Make sure you have 'permissions' or rights to see that particular exchange
rate. Contact the market data support line at your employer to see if you
have proper permissions to see it . It seems to me that your connection is
working as you can see some rates. CNY and RMB are emerging market
currencies and not as readily available as AUD, GBP, USD etc. Perhaps
they
need to set you up for emerging market currencies.
Click to expand...

Joe, Thanks for your help.
But I can query in Reuters 3000 Xtra using the keyword "CNY=" to show
the information.
Do I need any setup in 3000 Xtra in order to feed the information for
CNY into Excel?


I don't have a definitive answer. Rebooting may help in reestablishing the
connection, but not always. It's been a while since I worked with Reuters
data in Excel. I always found the documentation to be helpful in
troubleshooting the errors.
 
Joe, Thanks for your help.
But I can query in Reuters 3000 Xtra using the keyword "CNY=" to show
the information.
Do I need any setup in 3000 Xtra in order to feed the information for
CNY into Excel?

I don't have a definitive answer. Rebooting may help in reestablishing the
connection, but not always. It's been a while since I worked with Reuters
data in Excel. I always found the documentation to be helpful in
troubleshooting the errors.
Click to expand...

Thanks your help.
I think this is excel problem that didn't update the cell value
automatically.
It works after press F2 and enter in the cell.
 
Back
Top