|
Foreign Exchange ... Yahoo download and the magic symbols
|
motivated by e-mail from George F
Once upon a time I was told of some neat tags one could use to download stock data from Yahoo ... and I even wrote a tutorial.
>So?
I didn't know you could also download foreign exchange rates ... if you know the symbols for the country currency.
The format goes like this:
http://quote.yahoo.com/d/quotes.csv?s=AB=X+CD=X&f=tags
where A, C etc. are the "from" symbols and
B, D etc. are the "to" symbols and
tags are a collection of yahoo tags.
>Huh?
- Start with: http://quote.yahoo.com/d/quotes.csv?s=
- Add a sequence of: fromto=X (separated by +)
- End with: &f=tags
For example, try this:
http://quote.yahoo.com/d/quotes.csv?s=USDCAD=X+JPYUSD=X+GBPUSD=X+USDJPY=X+EURUSD=X&f=nl1d1t1
Note the tags I've used:
n is a name for the conversion (like: USD to CAD) and
l1 is the conversion (like: 1.234) and
d1 is the Date (like: 3/27/2004) and
t1 is the Time (like: 3:41am).
>Yeah, but what Yahoo tags give something useful?
I have no idea. Just try all the tags in this tutorial and see which ones work.
For a spreadsheet which assists in this "try-the-Yahoo-codes", click here.
I doubt whether Market Cap tag is meaningful
>And do you know the country currency symbols?
Here's a few ...
| Afganistan Afghani (AFA) |
| Albanian Lek (ALL) |
| Algerian Dinar (DZD) |
| Argentinian Peso (ARS) |
| Aruban Florin (AWG) |
| Australian Dollar (AUD) |
| Austrian Schilling (ATS) |
| Bahraini Dinar (BHD) |
| Bangladesh Taka (BDT) |
| Barbados Dollar (BBD) |
| Belgian Franc (BEF) |
| Belize Dollar (BZD) |
| Bermuda Dollar (BMD) |
| Bhutan Ngultrum (BTN) |
| Bolivian Boliviano (BOB) |
| Botswana Pula (BWP) |
| Brazilian Real (BRL) |
| British Pound (GBP) |
| Brunei Dollar (BND) |
| Bulgarian Lev (BGN) |
| Cambodian Riel (KHR) |
| Canadian Dollar (CAD) |
| Cape Verde Escudo (CVE) |
| Cayman Islands Dollar (KYD) |
| CFA Franc (BCEAO) (XOF) |
| CFA Franc (BEAC) (XAF) |
| CFP Franc (XPF) |
| Chilean Peso (CLP) |
|
| Colombian Peso (COP) |
| Comoros Franc (KMF) |
| Costa Rican Colon (CRC) |
| Croatian Kuna (HRK) |
| Cuban Peso (CUP) |
| Cypriot Pound (CYP) |
| Czech Koruna (CZK) |
| Danish Krone (DKK) |
| Djibouti Franc (DJF) |
| Dominican Peso (DOP) |
| Dutch Guilder (NLG) |
| East Caribbean Dollar (XCD) |
| Egyptian Pound (EGP) |
| El Salvador Colon (SVC) |
| Estonian Kroon (EEK) |
| Ethiopian Birr (ETB) |
| Euro (EUR) |
| Fiji Dollar (FJD) |
| Finnish Markka (FIM) |
| French Franc (FRF) |
| Gambia Dalasi (GMD) |
| German Mark (DEM) |
| Ghanaian Cedi (GHC) |
| Gibraltar Pound (GIP) |
| Greek Drachma (GRD) |
| Guatemala Quetzal (GTQ) |
| Guinea Franc (GNF) |
| Guyana Dollar (GYD) |
|
| Haitian Gourde (HTG) |
| Honduras Lempira (HNL) |
| Hong Kong Dollar (HKD) |
| Hungarian Forint (HUF) |
| Iceland Krona (ISK) |
| Indian Rupee (INR) |
| Indonesian Rupiah (IDR) |
| Irish Punt (IEP) |
| Israeli Shekel (ILS) |
| Italian Lira (ITL) |
| Jamaican Dollar (JMD) |
| Japanese Yen (JPY) |
| Jordanian Dinar (JOD) |
| Kenyan Shilling (KES) |
| Kuwaiti Dinar (KWD) |
| Laos Kip (LAK) |
| Latvian Lats (LVL) |
| Lebanese Pound (LBP) |
| Lesotho Loti (LSL) |
| Lithuanian Litas (LTL) |
| Malagasy Franc (MGF) |
| Malawi Kwacha (MWK) |
| Malaysian Ringgit (MYR) |
| Maldives Rufiyan (MVR) |
| Maltese Pound (MTL) |
| Mauritania Ouguiya (MRO) |
| Mauritius Rupee (MUR) |
| Mexican Peso (MXN) |
|
| Mongolian Tugrik (MNT) |
| Moroccan Dirham (MAD) |
| Mozambique Metical (MZM) |
| Myanmar Kyat (MMK) |
| Namibian Dollar (NAD) |
| Nepal Rupee (NPR) |
| Netherlands Antilles Guilder (ANG) |
| New Zealand Dollar (NZD) |
| Nicaraguan Cordoba (NIO) |
| Nigerian Naira (NGN) |
| Norwegian Krone (NOK) |
| Oman Rial (OMR) |
| Pakistani Rupee (PKR) |
| Papua New Guinea Kina (PGK) |
| Peruvian Sol (PEN) |
| Philippines Peso (PHP) |
| Polish Zloty (PLN) |
| Portuguese Escudo (PTE) |
| Qatari Rial (QAR) |
| Renmimbi Yuan (CNY) |
| Romanian Leu (ROL) |
| Russian Ruble (RUB) |
| Salomon Islands Dollar (SBD) |
| Sao Tome & Principe Dobra (STD) |
| Saudi Arabian Riyal (SAR) |
| Seychelles Rupee (SCR) |
| Sierra Leone Leone (SLL) |
| Singapore Dollar (SGD) |
|
| Slovak Koruna (SKK) |
| Slovenian Tolar (SIT) |
| South African Rand (ZAR) |
| South Korean Won (KRW) |
| Spanish Peseta (ESP) |
| Sri Lanka Rupee (LKR) |
| St. Helena Pound (SHP) |
| Sudanese Dinar (SDD) |
| Surinam Guilder (SRG) |
| Swaziland Lilangeni (SZL) |
| Swedish Krona (SEK) |
| Swiss Franc (CHF) |
| Syria Pound (SYP) |
| Taiwan New Dollar (TWD) |
| Tanzanian Shilling (TZS) |
| Thai Baht (THB)< |
| Tonga Isl Pa'anga (TOP) |
| Trinidad Dollar (TTD) |
| Tunisian Dinar (TND)< |
| Turkish Lira (TRL) |
| Ugandan Shilling (UGX) |
| Ukraine Hryvnia (UAH) |
| United Arab Emirates Dirham (AED) |
| US Dollar (USD) |
| Vanuatu Vatu (VUV) |
| Venezuelan Bolivar (VEB) |
| Vietnam Dong (VND) |
| Western Samoa Tala (WST) |
| Zambia Kwacha (ZMK) |
| Zimbabwean Dollar (ZWD) |
|
|