View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
[email protected] Chau.Jacky@gmail.com is offline
external usenet poster
 
Posts: 3
Default Reuters RTGET() Functions

On 4月19日, 上午10時03分, "Joe S" wrote:
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.

wrote in message

ups.com...

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.


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?