On 4月19日, 下午12時50分, "Joe S" wrote:
wrote in message

oups.com...
On 4¤ë19¤é, ¤W¤È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

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

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.