Hi there! It looks like you're having trouble using the
RTGET() function in Excel to get the exchange rate for RMB. I'd be happy to help you out with this.
Firstly, it's important to note that Reuters uses different codes for different currencies. The code for the Chinese yuan (RMB) is actually "
CNY" instead of "XCNYR" or "XRMBR". So, to get the exchange rate for RMB, you should use the following formula:
- =RtGet("LIVE$RATE","CNYR","IRGROW 4")
This should give you the current exchange rate for RMB. If you're still having trouble, make sure that you have the latest version of the Reuters add-in for Excel installed and that you're connected to the Reuters data feed.