Data Trends for Investment Professionals

GO TO QUANDL.COM ⟶

API for Currency Data

Tags:

Using the Quandl API for Currency Data

This document is a comprehensive guide to using the Quandl API to access our free currency and exchange rate data. If you haven’t already done so, we recommend reading Quandl’s general API documentation; the functionality will be a lot clearer if you do so.

To start using the Quandl API:

  1. Sign up for a free API key
  2. Find the data you need: use the list below or use our search page.
  3. Start making calls: use our API reference page to learn the syntax.

Free Unlimited API for Exchange Rates

Quandl offers spot exchange rates from the Bank of England (BOE) for over 40 currencies into USD, GBP and EUR. We also offer rates from the European Central Bank (ECB) for 30+ currencies into EUR and from the Federal Reserve Bank of St. Louis (FRED) for 20+ currencies into USD. Quandl’s API gives easy access to daily foreign exchange rates and exchange rate history. With numerous software packages, including Python and R, Quandl is the easiest way to find and download historical currency rate.

This page is a tutorial on usage of the API to access Bank of England and European Central Bank spot exchange rates data. Accessing futures data via the API is no different than the mechanism for all data on Quandl. The purpose of this help page is simply to explain the specific nomenclature we’re using for currency data. For general help, see API. For package specific help, start on the tools page.

Basic Exchange Rate API Usage

Code Formats

Bank of England (Source: BOE), European Central Bank (Source: ECB) and Federal Reserve Economic Data (FRED) codes have the following format

{SOURCE}/{CODE}

Basic Example

Japanese Yen to Pound Sterling rates from the Bank of England.

http://www.quandl.com/api/v3/datasets/BOE/XUDLJYS

Daily Exchange Rates (BOE)

Currency

To USD

To GBP

To EUR

Australian Dollar (AUD)

XUDLADD

XUDLADS

Canadian Dollar (CAD)

XUDLCDD

XUDLCDS

Chinese Yuan (CNY)

XUDLBK73

XUDLBK89

Czech Koruna (CZK)

XUDLBK27

XUDLBK25

XUDLBK26

Danish Krone (DKK)

XUDLDKD

XUDLDKS

XUDLBK76

Hong Kong Dollar (HKD)

XUDLHDD

XUDLHDS

Hungarian Forint (HUF)

XUDLBK35

XUDLBK33

XUDLBK34

Indian Rupee (INR)

XUDLBK64

XUDLBK97

Israeli Shekel (NIS)

XUDLBK65

XUDLBK78

Japanese Yen (JPY)

XUDLJYD

XUDLJYS

XUDLBK63

Lithuanian Litas (LTL)

XUDLBK38

XUDLBK36

XUDLBK37

Malaysian Ringgit (MYR)

XUDLBK66

XUDLBK83

New Zealand Dollar (NZD)

XUDLNDD

XUDLNDS

Norwegian Krone (NOK)

XUDLNKD

XUDLNKS

Polish Zloty (PLN)

XUDLBK49

XUDLBK47

XUDLBK48

Pound Sterling (GBP)

XUDLGBD

XUDLGBG

XUDLSER

Russian Ruble (RUB)

XUDLBK69

XUDLBK85

Saudi Riyal (SAR)

XUDLSRD

XUDLSRS

Singapore Dollar (SGD)

XUDLSGD

XUDLSGS

South African Rand (ZAR)

XUDLZRD

XUDLZRS

South Korean Won (KRW)

XUDLBK74

XUDLBK93

Swedish Krona (SEK)

XUDLSKD

XUDLSKS

Swiss Franc (CHF)

XUDLSFD

XUDLSFS

XUDLBK68

New Taiwan Dollar (TWD)

XUDLTWD

XUDLTWS

Thai Baht (THB)

XUDLBK72

XUDLBK87

Turkish Lira (TRY)

XUDLBK75

XUDLBK95

Historical Exchange Rates (pre Euro) (BOE)

Currency

To USD

To GBP

To EUR

Austrian Schilling (ATS)

XUDLASD

XUDLASS

Belgian Franc (BEF)

XUDLBFD

XUDLBFS

Cyprus Pound (CYP)

XUDLBK24

XUDLBK22

XUDLBK23

Deutschemark (DEM)

XUDLDMD

XUDLDMS

Estonian Kroon (EEK)

XUDLBK32

XUDLBK28

XUDLBK29

French Franc (FRF)

XUDLFFD

XUDLFFS

Greek Drachma (GRD)

XUDLGDD

XUDLGDS

Irish Pound (IEP)

XUDLIPD

XUDLIPS

Italian Lire (ITL)

XUDLILD

XUDLILS

Finnish Markka (FIM)

XUDLFMD

XUDLFMS

Maltese Lira (MTL)

XUDLBK46

XUDLBK44

XUDLBK45

Netherlands Guilder (NLG)

XUDLNGD

XUDLNGS

Portuguese Escudo (PTE)

XUDLPED

XUDLPES

Slovak Koruna (SKK)

XUDLBK57

XUDLBK55

XUDLBK56

Slovenian Tolar (SIT)

XUDLBK54

XUDLBK52

XUDLBK53

Spanish Peseta (ESP)

XUDLSPD

XUDLSPS

USD Exchange Rates (FRED)

Currency

Code

Australian Dollar (AUD)

DEXUSAL

Brazilian Real (BRL)

DEXBZUS

British Pound (GBP)

DEXUSUK

Canadaian Dollar (CAD)

DEXCAUS

Chinese Yuan (CNY))

DEXCHUS

Denish Krone (DKK)

DEXDNUS

Euro (EUR)

DEXUSEU

Hong Kong Dollar (HKD)

DEXHKUS

Indian Rupee (INR)

DEXINUS

Japanese Yen (JPY)

DEXJPUS

Malaysian Ringgit (MYR)

DEXMAUS

Mexican Peso (MXN)

DEXMXUS

New Taiwan Dollar (TWD)

DEXTAUS

New Zealand Dollar (NZD)

DEXUSNZ

Norwegian Krone(NOK)

DEXNOUS

Singapore Dollar (SGD)

DEXSIUS

South African Rand(ZAR)

DEXSFUS

South Korean Won (KRW)

DEXKOUS

Sri Lankan Rupee(LKR)

DEXSLUS

Swedish Krona (SEK)

DEXSDUS

Swiss Franc (CHF)

DEXSZUS

Thai Baht (THB)

DEXTHUS

Venezuelan Bolivar (VEF)

DEXVZUS

Euro Exchange Rates (ECB)

Currency

Code

Australian Dollar (AUD)

EURAUD

Bulgarian Lev (BGN)

EURBGN

Brazilian Real (BRL)

EURBRL

Canadian Dollar (CAD)

EURCAD

Swiss Franc (CHF)

EURCHF

Chinese Yuan (CNY)

EURCNY

Czech Koruna (CZK)

EURCZK

Danish Krone (DKK)

EURDKK

British Pound (GBP)

EURGBP

Hong Kong Dollar (HKD)

EURHKD

Croatian Kuna (HRK)

EURHRK

Hungarian Forint (HUF)

EURHUF

Indonesian Rupiah (IDR)

EURIDR

New Israeli Shekel (ILS)

EURILS

Indian Rupee (INR)

EURINR

Icelandic Krona (ISK)

EURISK

Japanese Yen (JPY)

EURJPY

Korean Won (KRW)

EURKRW

Lithuanian Lita (LTL)

EURLTL

Mexican Peso (MXN)

EURMXN

Malaysian Ringgit (MYR)

EURMYR

Norwegian Krone (NOK)

EURNOK

New Zealand Dollar (NZD)

EURNZD

Philippine Peso (PHP)

EURPHP

Polish Zloty (PLN)

EURPLN

Romanian Leu (RON)

EURRON

Russian Rubble (RUB)

EURRUB

Swedish Krona (SEK)

EURSEK

Singapore Dollar (SGD)

EURSGD

Thai Baht (THB)

EURTHB

Turkish Lira (TRY)

EURTRY

US Dollar (USD)

EURUSD

South African Rand (ZAR)

EURZAR

Currency Exchange Rate Examples

South African Rand (ZAR) to Euro (EUR) rates from the ECB:

http://www.quandl.com/api/v3/datasets/ECB/EURZAR

Turkish Lira (TRY) to Pound Stirling (GBP) rates from the BOE:

http://www.quandl.com/api/v3/datasets/BOE/XUDLBK95

Historical Exchange rates for the Lithuanian Lita (LTL) to US Dollars (USD) from the BOE:

http://www.quandl.com/api/v3/datasets/BOE/XUDLBK38

Additional Resources

  • Additional information is available on our API reference page.
  • All of Quandl’s datasets are also available through a number of tools

 

Get Started Now!

To use Quandl’s API, please sign up for a free API key:
Get Your Free API Key Now
 

VIEW COMMENTS

Leave a Reply

Your email address will not be published. Required fields are marked *


4 Comments
Fix This
Created with Sketch.