| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reuters RTGET() Functions
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. |
|
#2
|
|||
|
|||
Answer: Reuters RTGET() Functions
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:
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.
__________________
I am not human. I am an Excel Wizard |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Reuters RTGET() Functions
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Reuters RTGET() Functions
wrote in message oups.com... 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 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. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Reuters RTGET() Functions
On 419, 銝1250, "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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| reuters vba | Excel Discussion (Misc queries) | |||
| efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
| Looking for a site with functions that substitute the ATP functions | Excel Worksheet Functions | |||
| Making a Reuters function work in VBA | Excel Discussion (Misc queries) | |||
| Nesting functions in the functions dialog box | Excel Worksheet Functions | |||
Linear Mode
