Currency Data: Key /ky currency

Currency data items include information about a country’s currency as well as a history of daily and monthly exchange rates. An entire group can be printed by specifying its print option, and individual group items can be printed with the “/ml” option.

There is no wildcard used with the currency data. The key for these groups and all of their items is each country’s currency code, for example, “USD”, “CAD”, “GBP”, “JPY” etc. A full list of available country currency codes is in Appendix A.

Note on Exchange Rate Data:

Exchange rates are listed “from” a common currency, “to” the currency in question. Currently, “GBP” (Pounds Sterling) is used as the common “from” currency.

a. Currency Data - /cu
ITM_NAME Description
ISOCURCD ISO Currency Code
ISOCURBD Currency Birth Date
ISOCURDD Currency Death Date
ISOCURLNK Currency Link Code
ISOCURTR Currency Tier Number
ISOCURNM Currency Name

To return currency information for the Euro, from Appendix A, using the input “eur.”

Enter identifier or new option beginning with a slash.
Type ? for help.
/ky currency
Date range: 20080215 - 20090215
 
Enter identifier or new option beginning with a slash.
Type ? for help.
/cu
Keep previous data options? (y/n)
n
Date range: 20080215 - 20090215
options have been reset.
 
Enter identifier or new option beginning with a slash.
Type ? for help.
eur
 
CURRENCY = EUR
 
Currency

--------

ISOCURCD ISOCURBD ISOCURDD ISOCURLNK ISOCURTR
EUR 19990101 0 189 1
 

ISOCURNM

 
EURO
b. Daily Exchange Rate - /xd
ITM_NAME Description
EXRATD Daily Exchange Rate

To extract daily exchange rate data for the Euro for a specified date range:

Enter identifier or new option beginning with a slash.
Type ? for help.
/xd /dt20090101-20090201
Keep previous data options? (y/n)
n
Daily data range: 20090102 - 20090130
options have been reset.
 
Enter identifier or new option beginning with a slash.
Type ? for help.
eur
 
CURRENCY = EUR
 
Exch Rate - Daily
-----------------
DATADATE EXRATD
20090102 1.04100000
20090105 1.06800000
20090106 1.09760000
20090107 1.11030000
20090108 1.10760000
20090109 1.12670000
20090112 1.11240000
20090113 1.10440000
20090114 1.10660000
20090115 1.11410000
20090116 1.11980000
20090120 1.08120000
20090121 1.06670000
20090122 1.06090000
20090123 1.06790000
20090126 1.06100000
20090127 1.07570000
20090128 1.08070000
20090129 1.09440000
20090130 1.11640000
c. Monthly Exchange Rate - /xm
ITM_NAME Description
EXRATM Monthly Exchange Rate

To extract monthly exchange rate data for the Euro for a specified date range:

Enter identifier or new option beginning with a slash.
Type ? for help.
/xm /dt20080101-20090101
Keep previous data options? (y/n)
n
Monthly data range: 200801 - 200812
options have been reset.
 
Enter identifier or new option beginning with a slash.
Type ? for help.
eur
 
CURRENCY = EUR
 
Exch Rate - Mthly
-----------------
DATADATE EXRATM
20080131 1.34110000
20080229 1.31030001
20080331 1.25470000
20080430 1.27210000
20080530 1.27160000
20080630 1.26340000
20080731 1.26960001
20080829 1.23940000
20080930 1.26920000
20081031 1.27350001
20081128 1.20990000
20081231 1.03320000
d. Monthly Exchange Rate Averages - /xv
ITM_NAME Description
EXRAT1M Monthly Exchange Rate, 1 Month Average
EXRAT2M Monthly Exchange Rate, 2 Month Average
EXRAT3M Monthly Exchange Rate, 3 Month Average
EXRAT4M Monthly Exchange Rate, 4 Month Average
EXRAT5M Monthly Exchange Rate, 5 Month Average
EXRAT6M Monthly Exchange Rate, 6 Month Average
EXRAT7M Monthly Exchange Rate, 7 Month Average
EXRAT8M Monthly Exchange Rate, 8 Month Average
EXRAT9M Monthly Exchange Rate, 9 Month Average
EXRAT10M Monthly Exchange Rate, 10 Month Average
EXRAT11M Monthly Exchange Rate, 11 Month Average
EXRAT12M Monthly Exchange Rate, 12 Month Average
EXRAT13M Monthly Exchange Rate, 13 Month Average
EXRAT14M Monthly Exchange Rate, 14 Month Average
EXRAT15M Monthly Exchange Rate, 15 Month Average
EXRAT16M Monthly Exchange Rate, 16 Month Average
EXRAT17M Monthly Exchange Rate, 17 Month Average
EXRAT18M Monthly Exchange Rate, 18 Month Average

To extract monthly exchange rate averages for the Euro for a specified date range:

Enter identifier or new option beginning with a slash.
Type ? for help.
/xv
Keep previous data options? (y/n)
n
Monthly data range: 200801 - 200812
options have been reset.
 
Enter identifier or new option beginning with a slash.
Type ? for help.
eur
 
CURRENCY = EUR
 
Exch Rate - Mthly Avg
---------------------
DATADATE EXRAT1M EXRAT2M EXRAT3M EXRAT4M
20080131 1.33817727 1.36106879 1.37714769 1.39164047
20080229 1.33169524 1.33492838 1.35113468 1.36549616
20080331 1.28944286 1.31022850 1.31941413 1.33516484
20080430 1.25797273 1.27351340 1.29233412 1.30349790
20080530 1.26338182 1.26067147 1.27011821 1.28497235
20080630 1.26355715 1.26346947 1.26163190 1.26847156
20080731 1.26150870 1.26253208 1.26281521 1.26160110
20080829 1.26112381 1.26131623 1.26206232 1.26239194
20080930 1.25271818 1.25690694 1.25843713 1.25971324
20081031 1.27216522 1.26236681 1.26195220 1.26184129
20081128 1.20405501 1.23717340 1.24231195 1.24696210
20081231 1.09927826 1.14928353 1.18751869 1.20317392
 
 
 
DATADATE EXRAT17M EXRAT18M    
20080131 1.45829039 1.45941346    
20080229 1.44886882 1.45062920    
20080331 1.43626781 1.43898464    
20080430 1.42175244 1.42504700    
20080530 1.40775311 1.41191963    
20080630 1.39295809 1.39888427    
20080731 1.37887251 1.38494081    
20080829 1.36636898 1.37175705    
20080930 1.35348188 1.35951677    
20081031 1.34227849 1.34869253    
20081128 1.32603862 1.33377211    
20081231 1.30216518 1.31101431