Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Thanks for all your answers.</p> <p><strong>Free currencyconverterapi:</strong> </p> <ul> <li>Rates updated every 30 min </li> <li>No account required</li> </ul> <p>A sample conversion URL is: <a href="http://free.currencyconverterapi.com/api/v5/convert?q=EUR_USD&amp;compact=y" rel="noreferrer">http://free.currencyconverterapi.com/api/v5/convert?q=EUR_USD&amp;compact=y</a></p> <hr> <p>For posterity here they are along with other possible answers:</p> <ol> <li><h3><del>Yahoo finance API</del> Discontinued 2017-11-06</h3> <p>Discontinued as of 2017-11-06 with message</p> <blockquote> <p>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.</p> </blockquote> <p>Request: <a href="http://finance.yahoo.com/d/quotes.csv?e=.csv&amp;f=sl1d1t1&amp;s=USDINR=X" rel="noreferrer">http://finance.yahoo.com/d/quotes.csv?e=.csv&amp;f=sl1d1t1&amp;s=USDINR=X</a><br> This CSV was being used by a jQuery plugin called <a href="http://curry.netyou.co.il/demo" rel="noreferrer">Curry</a>. 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.</p></li> <li><p>(<a href="https://stackoverflow.com/a/16408368/1269037">thanks to Keyo</a>) <strong>Yahoo Query Language</strong> 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.</p> <p><a href="http://curry.netyou.co.il/demo" rel="noreferrer">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</a></p> <p>Here is the YQL query builder, where you can test a query and copy the url:</p> <p><a href="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" rel="noreferrer">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</a></p></li> <li><h3>Open Source Exchange Rates API</h3> <p><a href="https://openexchangerates.org/signup/free" rel="noreferrer">Free for personal use</a> (1000 hits per month)<br> Changing "base" (from "USD") is not allowed in Free account<br> Requires registration.<br> Request: <a href="http://openexchangerates.org/latest.json" rel="noreferrer">http://openexchangerates.org/latest.json</a><br> Response:</p> <pre class="lang-js prettyprint-override"><code>{ "disclaimer": "This data is collected from various providers ...", "license": "all code open-source under GPL v3 ...", "timestamp": 1323115901, "base": "USD", "rates": { "AED": 3.66999725, "ALL": 102.09382091, "ANG": 1.78992886, // 115 more currency rates here ... } } </code></pre></li> <li><h3>currencylayer API</h3> <p><a href="http://www.currencylayer.com" rel="noreferrer">Free Plan</a> for 1,000 monthly hits<br> Changing "source" (from "USD") is not allowed in Free account<br> Requires registration.<br> Documentation: <a href="http://currencylayer.com/documentation" rel="noreferrer">currencylayer.com/documentation</a><br><br> JSON Response:</p> <pre class="lang-js prettyprint-override"><code>{ [...] "timestamp": 1436284516, "source": "USD", "quotes": { "USDAUD": 1.345352401, "USDCAD": 1.27373397, "USDCHF": 0.947845302, "USDEUR": 0.91313905, "USDGBP": 0.647603397, // 168 world currencies } } </code></pre></li> <li><h3>Fixer.io API (European Central Bank data)</h3> <p>Free Plan for 1,000 monthly hits<br> Changing "source" (from "USD") is not allowed in Free account Requires registration.<br></p> <p>This API endpoint is deprecated and will stop working on June 1st, 2018. For more information please visit: https://github.com/fixerAPI/fixer#readme) </p> <p><br> Website : <a href="http://fixer.io/" rel="noreferrer">http://fixer.io/</a> <br> Example request : <a href="http://api.fixer.io/latest?base=USD" rel="noreferrer">http://api.fixer.io/latest?base=USD</a> <br> Only collects one value per each day</p></li> <li><h3>European Central Bank Feed</h3> <p>Docs: <a href="http://www.ecb.int/stats/exchange/eurofxref/html/index.en.html#dev" rel="noreferrer">http://www.ecb.int/stats/exchange/eurofxref/html/index.en.html#dev</a><br> Request: <a href="http://www.ecb.int/stats/eurofxref/eurofxref-daily.xml" rel="noreferrer">http://www.ecb.int/stats/eurofxref/eurofxref-daily.xml</a><br><br> XML Response: </p> <pre class="lang-xml prettyprint-override"><code>&lt;Cube&gt; &lt;Cube time="2015-07-07"&gt; &lt;Cube currency="USD" rate="1.0931"/&gt; &lt;Cube currency="JPY" rate="133.88"/&gt; &lt;Cube currency="BGN" rate="1.9558"/&gt; &lt;Cube currency="CZK" rate="27.100"/&gt; &lt;/Cube&gt; </code></pre></li> <li><h3><del>Google exchange rate query (parsed)</del> Currently unavailable:</h3> <p>Request: <a href="http://rate-exchange.appspot.com/currency?from=USD&amp;to=EUR" rel="noreferrer">http://rate-exchange.appspot.com/currency?from=USD&amp;to=EUR</a><br> Response: </p> <pre class="lang-js prettyprint-override"><code>{"to": "EUR", "rate": 0.76911244400000001, "from": "USD"} </code></pre> <p><br> Here's another JSON(P) API based on the Google API (source: <a href="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" rel="noreferrer">this comment</a>):<br><a href="http://rate-exchange.appspot.com/currency?from=USD&amp;to=EUR&amp;q=1" rel="noreferrer">http://rate-exchange.appspot.com/currency?from=USD&amp;to=EUR&amp;q=1</a></p> <p>Original <a href="https://stackoverflow.com/a/7165203/414385">answer</a> by <a href="https://stackoverflow.com/users/457478/ryan">Ryan</a>.</p></li> </ol>
    singulars
    1. This table or related slice is empty.
    1. POHow do I get currency exchange rates via an API such as Google Finance?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USWonderLand
    1. USzeFree
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow do I get currency exchange rates via an API such as Google Finance?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COHere is a [link](http://www.codereye.com/2009/03/java-currency-converter-using-yahoo.html) with more useful explanation of the Yahoo finance API.
      singulars
      1. PO
      1. USMiranda
    2. COPlease note the Open Exchange Rates project data has been moved away from GitHub (NO data available there now) and is now being served via http://openexchangerates.org - thanks!
      singulars
      1. PO
      1. USWilliam Joss Crowcroft
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload