How do I get currency exchange rates via an API such as Google Finance

Question

Now  I did find the Google Finance API and started looking through that but I found a lot of info about portfolios  transactions  positions  amp  other stuff I know nothing about    Am I looking at the wrong docs  What do I need to do to get a feed of exchange rates from GF  Is this even possible   EDIT  To make things a little clearer  I m not interested in technical stuff nor do I want any code

User · Accepted Answer

Thanks for all your answers  Free currencyconverterapi   Rates updated every 30 min API key is now required for the free server   A sample conversion URL is  http   free currencyconverterapi com api v5 convert q EUR USD amp compact y  For posterity here they are along with other possible answers   Yahoo finance API Discontinued 2017-11-06      Discontinued as of 2017-11-06 with message  It has come to our attention that this service is being used in violation of the Yahoo Terms of Service  As such  the service is being discontinued  For all future markets and equities data research  please refer to finance yahoo com   Request  http   finance yahoo com d quotes csv e  csv amp f sl1d1t1 amp s USDINR X This CSV was being used by a jQuery plugin called Curry  Curry has since  2017-08-29  moved to use fixer io instead due to stability issues  Might be useful if you need more than just a CSV    thanks to Keyo  Yahoo Query Language lets you get a whole bunch of currencies at once in XML or JSON  The data updates by the second  whereas the European Central Bank has day old data   and stops in the weekend  Doesn t require any kind of sign up   http   query yahooapis com v1 public yql q select   from yahoo finance xchange where pair in   quot USDEUR quot    quot USDJPY quot    quot USDBGN quot    quot USDCZK quot    quot USDDKK quot    quot USDGBP quot    quot USDHUF quot    quot USDLTL quot    quot USDLVL quot    quot USDPLN quot    quot USDRON quot    quot USDSEK quot    quot USDCHF quot    quot USDNOK quot    quot USDHRK quot    quot USDRUB quot    quot USDTRY quot    quot USDAUD quot    quot USDBRL quot    quot USDCAD quot    quot USDCNY quot    quot USDHKD quot    quot USDIDR quot    quot USDILS quot    quot USDINR quot    quot USDKRW quot    quot USDMXN quot    quot USDMYR quot    quot USDNZD quot    quot USDPHP quot    quot USDSGD quot    quot USDTHB quot    quot USDZAR quot    quot USDISK quot   amp env store   datatables org alltableswithkeys Here is the YQL query builder  where you can test a query and copy the url   NO LONGER AVAILABLE  http   developer yahoo com yql console  q show 20tables amp env store   datatables org alltableswithkeys h select 20  20from 20yahoo finance xchange 20where 20pair 20in 20 28 22USDMXN 22 2C 20 22USDCHF 22 29   Open Source Exchange Rates API   Free for personal use  1000 hits per month  Changing  quot base quot   from  quot USD quot   is not allowed in Free account Requires registration  Request  http   openexchangerates org latest json Response      lt  -- language  lang-js -- gt                quot disclaimer quot    quot This data is collected from various providers     quot          quot license quot    quot all code open-source under GPL v3     quot          quot timestamp quot   1323115901         quot base quot    quot USD quot          quot rates quot                quot AED quot   3 66999725             quot ALL quot   102 09382091             quot ANG quot   1 78992886               115 more currency rates here                     currencylayer API   Free Plan for 250 monthly hits Changing  quot source quot   from  quot USD quot   is not allowed in Free account Requires registration  Documentation  currencylayer com documentation JSON Response      lt  -- language  lang-js -- gt                            quot timestamp quot   1436284516         quot source quot    quot USD quot          quot quotes quot                quot USDAUD quot   1 345352401             quot USDCAD quot   1 27373397             quot USDCHF quot   0 947845302             quot USDEUR quot   0 91313905             quot USDGBP quot   0 647603397               168 world currencies                       CurrencyFreaks API   Free Plan  1000 hits per month  Changing  Base   From  USD   is not allowed in free account Requires registration Data updated every 60 sec  179 currencies worldwide including currencies  metals  and cryptocurrencies Support  Even on the free plan  Shell Node js  Java  Python  PHP  Ruby  JS  C   C  Go  Swift  Documentation  https   currencyfreaks com documentation html Endpoint    curl  https   api currencyfreaks com latest apikey YOUR APIKEY   JSON Response         quot date quot    quot 2020-10-08 12 29 00 00 quot        quot base quot    quot USD quot        quot rates quot              quot FJD quot    quot 2 139 quot            quot MXN quot    quot 21 36942 quot            quot STD quot    quot 21031 906016 quot            quot LVL quot    quot 0 656261 quot            quot SCR quot    quot 18 106031 quot            quot CDF quot    quot 1962 53482 quot            quot BBD quot    quot 2 0 quot            quot GTQ quot    quot 7 783265 quot            quot CLP quot    quot 793 0 quot            quot HNL quot    quot 24 625383 quot            quot UGX quot    quot 3704 50271 quot            quot ZAR quot    quot 16 577611 quot            quot TND quot    quot 2 762 quot            quot CUC quot    quot 1 000396 quot            quot BSD quot    quot 1 0 quot            quot SLL quot    quot 9809 999914 quot            quot SDG quot   55 325           quot IQD quot    quot 1194 293591 quot                                            179 currencies            Fixer io API  European Central Bank data    Free Plan for 1 000 monthly hits Changing  quot source quot   from  quot USD quot   is not allowed in Free account Requires registration   This API endpoint is deprecated and will stop working on June 1st  2018  For more information please visit  https   github com fixerAPI fixer readme     Website   http   fixer io    Example request      http   api fixer io latest base USD  7    Only collects one value per each day  European Central Bank Feed   Docs  http   www ecb int stats exchange eurofxref html index en html dev Request  http   www ecb int stats eurofxref eurofxref-daily xml XML Response      lt  -- language  lang-xml -- gt        lt Cube gt         lt Cube time  quot 2015-07-07 quot  gt         lt Cube currency  quot USD quot  rate  quot 1 0931 quot   gt         lt Cube currency  quot JPY quot  rate  quot 133 88 quot   gt         lt Cube currency  quot BGN quot  rate  quot 1 9558 quot   gt         lt Cube currency  quot CZK quot  rate  quot 27 100 quot   gt       lt  Cube gt    exchangeratesapi io   According to the website  Exchange rates API is a free service for current and historical foreign exchange rates published by the European Central Bank This service is compatible with fixer io and is really easy to use  no API key needed  For example  this uses CURL  but you can use your favourite requesting tool        gt  curl https   api exchangeratesapi io latest base GBP amp symbols USD       quot base quot   quot GBP quot   quot rates quot    quot USD quot  1 264494191   quot date quot   quot 2019-05-29 quot     CurrencyApi net   Free Plan for 1250 monthly hits 150 Crypto and physical currencies - live updates Base currency is set as USD on free account Requires registration  Documentation  currencyapi net documentation JSON Response               quot valid quot   true         quot updated quot   1567957373         quot base quot    quot USD quot          quot rates quot                    quot AED quot   3 673042                 quot AFN quot   77 529504                 quot ALL quot   109 410403                   165 currencies   some cryptos                       Currency from LabStack   Website  https   labstack com currency Documentation  https   labstack com docs api currency convert Pricing  https   labstack com pricing Request  https   currency labstack com api v1 convert 1 USD INR Response     js        quot time quot    quot 2019-10-09T21 15 00Z quot       quot amount quot   71 1488          1  http   query yahooapis com v1 public yql q select   from yahoo finance xchange where pair in   quot USDEUR quot    quot USDJPY quot    quot USDBGN quot    quot USDCZK quot    quot USDDKK quot    quot USDGBP quot    quot USDHUF quot    quot USDLTL quot    quot USDLVL quot    quot USDPLN quot    quot USDRON quot    quot USDSEK quot    quot USDCHF quot    quot USDNOK quot    quot USDHRK quot    quot USDRUB quot    quot USDTRY quot    quot USDAUD quot    quot USDBRL quot    quot USDCAD quot    quot USDCNY quot    quot USDHKD quot    quot USDIDR quot    quot USDILS quot    quot USDINR quot    quot USDKRW quot    quot USDMXN quot    quot USDMYR quot    quot USDNZD quot    quot USDPHP quot    quot USDSGD quot    quot USDTHB quot    quot USDZAR quot    quot USDISK quot   amp env store   datatables org alltableswithkeys

User · Answer

Here is one simple PHP Script which gets exchange rate between GBP and USD   lt  php  amount   urlencode  1     from GBP0   urlencode  GBP     to usd  urlencode  USD     Dallor    hl en amp q  amount from GBP0 3D 3F to usd    US Rate   file get contents  http   google com ig calculator    Dallor    US data   explode       US Rate    US data   explode       US data  3      var USD    US data  0    echo  to usd  echo  var USD  echo   lt br  gt       gt    Google currency rates are not accurate google itself says     Google cannot guarantee the accuracy of the exchange rates used by the calculator  You should confirm current rates before making any transactions that could be affected by changes in the exchange rates  Foreign currency rates provided by Citibank N A  are displayed under licence  Rates are for information purposes only and are subject to change without notice  Rates for actual transactions may vary and Citibank is not offering to enter into any transaction at any rate displayed

User · Answer

Here are some exchange APIs with PHP example     Open Exchange Rates API    Provides 1 000 requests per month free  You must register and grab the App ID  The base currency USD for free account  Check the supported currencies and documentation      open exchange URL    valid app id   REQUIRED    exchange url    https   openexchangerates org api latest json    params   array       app id    gt   YOUR APP ID         make cURL request    parse JSON  curl   curl init    curl setopt array  curl  array      CURLOPT URL   gt   exchange url         http build query  params       CURLOPT RETURNTRANSFER   gt  true      response   json decode curl exec  curl    curl close  curl    if   empty  response- gt rates            convert 150 USD to JPY   Japanese Yen       echo  response- gt rates- gt JPY   150         150 USD   18039 09015 JPY     Currency Layer API    Provides 1 000 requests per month free  You must register and grab the Access KEY  Custom base currency is not supported in free account  Check the documentation    exchange url    http   apilayer net api live    params   array       access key    gt   YOUR ACCESS KEY        source    gt   USD        currencies    gt   JPY        format    gt  1    1   JSON        make cURL request    parse JSON  curl   curl init    curl setopt array  curl  array      CURLOPT URL   gt   exchange url         http build query  params       CURLOPT RETURNTRANSFER   gt  true      response   json decode curl exec  curl    curl close  curl    if   empty  response- gt quotes            convert 150 USD to JPY   Japanese Yen       echo  150 USD        response- gt quotes- gt USDJPY   150     JPY          150 USD   18036 75045 JPY

User · Answer

I got this content from  http   www scriptarticle com 2012 05 03 get-live-currency-rates-and-currency-conversion-using-php-and-apis    lt  php  function get currency  from Currency   to Currency   amount         amount   urlencode  amount        from Currency   urlencode  from Currency        to Currency   urlencode  to Currency         url    http   www google com finance converter a  amount amp from  from Currency amp to  to Currency         ch   curl init         timeout   0      curl setopt   ch  CURLOPT URL   url       curl setopt   ch  CURLOPT RETURNTRANSFER  1        curl setopt   ch  CURLOPT USERAGENT                    Mozilla 4 0  compatible  MSIE 8 0  Windows NT 6 1         curl setopt   ch  CURLOPT CONNECTTIMEOUT   timeout        rawdata   curl exec  ch       curl close  ch        data   explode  bld gt     rawdata        data   explode  to Currency   data 1         return round  data 0   2         Call the function to get the currency converted echo get currency  USD    INR   1      gt

User · Answer

The European Central Bank  ECB  also has the most reliable free feed that I know of  It contains approx 28 currencies and is updated at least daily   http   www ecb int stats eurofxref eurofxref-daily xml  For more formats and tools see the ECB reference page  http   www ecb int stats exchange eurofxref html index en html

User · Answer

For all newbie guys searching for some hint about currency conversion  take a look at this link  Datavoila  It helped med a lot regarding my own project in C   Just in case the site disappears  I ll add the code below  Just add the below steps to your own project  Sorry about the formatting   const string fromCurrency    USD   const string toCurrency    EUR   const double amount   49 95     For other currency symbols see http   finance yahoo com currency-converter     Clear the output editor   optional use  AFAIK Output Clear        Construct URL to query the Yahoo  Finance API const string urlPattern    http   finance yahoo com d quotes csv s  0  1  X amp f l1   string url   String Format urlPattern  fromCurrency  toCurrency       Get response as string string response   new WebClient   DownloadString url       Convert string to number double exchangeRate       double Parse response  System Globalization CultureInfo InvariantCulture       Output the result Output Text   String Format   0   1     2   3                                amount  fromCurrency                              amount   exchangeRate  toCurrency

User · Answer

Yahoo has a YQL feature to get a whole bunch of currencies at once in XML or JSON  I ve noticed the data is up to date by the minute where the ECB has day old data  and stops in the weekend   http   query yahooapis com v1 public yql q select   from yahoo finance xchange where pair in   USDEUR    USDJPY    USDBGN    USDCZK    USDDKK    USDGBP    USDHUF    USDLTL    USDLVL    USDPLN    USDRON    USDSEK    USDCHF    USDNOK    USDHRK    USDRUB    USDTRY    USDAUD    USDBRL    USDCAD    USDCNY    USDHKD    USDIDR    USDILS    USDINR    USDKRW    USDMXN    USDMYR    USDNZD    USDPHP    USDSGD    USDTHB    USDZAR    USDISK   amp env store   datatables org alltableswithkeys  Here is their query builder  where you can test a query and copy the url   http   developer yahoo com yql console  q show 20tables amp env store   datatables org alltableswithkeys h select 20  20from 20yahoo finance xchange 20where 20pair 20in 20 28 22USDMXN 22 2C 20 22USDCHF 22 29

User · Answer

You can try geoplugin  Beside the geolocation done by IP  but the IP is the provider IP  so not so accurate   they return currencies also and have a currency converter  see examples   They have 111 currencies updated

User · Answer

If you re looking for a ruby based solution for this problem  I recommend using the Google Calculator method a solution similar to the following  http   j mp QIC564  require  faraday  require  faraday middleware  require  json     Debug     require  pry    country code src    USD  country code dst    INR  connection   Faraday get  http   www google com ig calculator hl en amp q 1  country code src     country code dst     currency comparison hash   eval connection body  Google s output is not JSON  it s a hash  dst currency value   dst currency text    currency comparison hash  rhs  split      dst currency value   dst currency value to f dst currency text   dst currency text join       puts    country code dst  - gt    dst currency value     dst currency text  to 1   country code src

User · Answer

If you need a free and simple API for converting one currency to another  try free currencyconverterapi com    Disclaimer  I m the author of the website and I use it for one of my other websites   The service is free to use even for commercial applications but offers no warranty  For performance reasons  the values are only updated every hour   A sample conversion URL is  http   free currencyconverterapi com api v6 convert q EUR PHP amp compact ultra amp apiKey sample-api-key which will return a json-formatted value  e g    EUR PHP  60 849184

[api] How do I get currency exchange rates via an API such as Google Finance?

Yahoo finance API Discontinued 2017-11-06###

Open Source Exchange Rates API

currencylayer API

CurrencyFreaks API

Fixer.io API (European Central Bank data)

European Central Bank Feed

exchangeratesapi.io

CurrencyApi.net

Currency from LabStack

Examples related to api

Examples related to google-finance-api