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) |
|
|