StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Updating answer a bit </p> <p><strong>1.</strong> Try <a href="https://www.alphavantage.co/documentation/" rel="noreferrer"><strong>Alpha Vantage API</strong></a></p> <p>For beginners you can try to get a JSON output from query such as </p> <pre><code>https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=MSFT&apikey=demo </code></pre> <p><strong>DONT Try <a href="http://developer.yahoo.com/finance/" rel="noreferrer">Yahoo Finance API</a></strong> (it is DEPRICATED or UNAVAILABLE NOW). </p> <ul> <li>Here is a link to <a href="https://stackoverflow.com/questions/1763310/yahoo-finance-api">previous Yahoo Finance API discussion on StackOverflow</a>.</li> <li>Here's an alternate <a href="http://code.google.com/p/yahoo-finance-managed/" rel="noreferrer">link to Yahoo Finance API</a> posted on Google Code.</li> </ul> <p>For beginners, you can generate a CSV with a simple API call:</p> <pre><code>http://finance.yahoo.com/d/quotes.csv?s=AAPL+GOOG+MSFT&f=sb2b3jk </code></pre> <p>(This will generate and save a CSV for AAPL, GOOG and MSFT)</p> <p>Note that you must append the format to the query string (<code>f=..</code>). For an overview of all of the formats see <a href="http://www.jarloo.com/yahoo_finance/" rel="noreferrer">this page</a>.</p> <p>For more examples, visit <a href="http://developer.yahoo.com/yql/guide/yql-code-examples.html" rel="noreferrer">this page</a>.</p> <p>For <code>XML</code> and <code>JSON</code>-based data, you can do the following:</p> <p>Don't use YQL (Yahoo Query Language)**</p> <p>For example: </p> <pre><code>http://developer.yahoo.com/yql/console/?q=select%20*%20from%20yahoo.finance .quotes%20where%20symbol%20in%20(%22YHOO%22%2C%22AAPL%22%2C%22GOOG%22%2C%22 MSFT%22)%0A%09%09&env=http%3A%2F%2Fdatatables.org%2Falltables.env </code></pre> <p><strong>2. Use the webservice</strong></p> <p>For example, to get all stock quotes in <code>XML</code>:</p> <pre><code>http://finance.yahoo.com/webservice/v1/symbols/allcurrencies/quote </code></pre> <p>To get all stock quotes in <code>JSON</code>, just add <code>format=JSON</code> to the end of the URL:</p> <pre><code>http://finance.yahoo.com/webservice/v1/symbols/allcurrencies/quote?format=json </code></pre> <h2>Alternatives:</h2> <p><strong>1. <a href="http://1forge.com/forex-data-api" rel="noreferrer">1Forge Financial APIs</a></strong></p> <ul> <li>Real-time rates for about 40 currency pairs are available <a href="https://1forge.com/forex-quotes/quotes" rel="noreferrer">here</a>.</li> </ul> <p><strong>2. <a href="http://www.financialcontent.com/support/documentation/json_quote_api.php" rel="noreferrer">Financial Content API</a></strong></p> <ul> <li>The <a href="http://www.interactivebrokers.com/en/software/api/api.htm" rel="noreferrer">documentation</a> for this API is very good.</li> </ul> <p><strong>3. <a href="http://openexchangerates.org/" rel="noreferrer">Open Exchange Rates</a></strong></p> <p><strong>4. <a href="http://oanda.com" rel="noreferrer">Oanda API</a></strong></p> <p><strong>5. <a href="http://xe.com" rel="noreferrer">XE API</a></strong></p> <p><strong>6. <a href="http://www.xignite.com/forex" rel="noreferrer">Xignite API</a></strong></p> <p><strong>7. <a href="https://currencylayer.com" rel="noreferrer">currencylayer API</a></strong></p> <p><strong>8. Other API discussed at <a href="http://www.programmableweb.com/news/25-finance-apis/2008/04/24" rel="noreferrer">programmableWeb</a></strong></p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

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