Quandl offers a simple API for stock market data. The API delivers end-of-day prices, harmonized fundamentals, financial ratios, indexes, options and volatility, earnings estimates, analyst ratings, investor sentiment and more. Sign up for a free API key. To find the data you need, use the guide below or use our data browser. Use our quick start guide to learn our API syntax, or go to our documentation portal for a full reference.

If you prefer, you can get data via our libraries for Python, R, Excel, Ruby and other tools, instead of via the raw API. Quandl has a huge amount of stock data.

96 Stocks APIs: Bloomberg, NASDAQ and E*TRADE | ProgrammableWeb

This data is divided into multiple databases, each covering a different subject. Most databases are free to use. Premium databases are of higher quality, better documented, more comprehensive, and updated more regularly than free databases. This list is for US stocks. For other countries, please see our API for global stock data page.

What does stock mean?

Earnings and sales estimates are based on Zacks Investment Research daily surveys of 2, equity analysts from over brokerage firms. For the full syntax, read our API reference.

In the following sections, selected stock price databases are described in greater depth. Note that the definitive documentation for any given database can always be found on its documentation page; what follows is merely a brief overview.

For US stock prices, we recommend the Quotemedia End-of-Day US Stock Prices database, EOD. This is the highest-quality stock price database anywhere on the internet: The database covers over 8, public companies, including every stock listed on NYSE, NASDAQ, AMEX and ARCA.

This database is updated daily at 5pm or earlier. EOD offers the lowest-cost, highest-quality professsional-grade end of day stock price data in the world. Single user, startup, developer and redistributor licenses are available. For free and open stock prices, we recommend database WIKI.

This is an unrestricted and unencumbered collection of historical stock prices on 3 North American exchanges: NYSE, NASDAQ and AMEX.

The data in this database is curated by the Quandl community.

It is usually updated within 6 hours of the close; however, since it is crowd-sourced, the delivery time cannot be guaranteed. In the following sections, individual stock fundamentals databases are described in greater depth. For basic US stock fundamentals, we recommend the SF1 Core Fundamentals database.

gedyfej.web.fc2.com - Commodity, stock and forex quotes, charts, news and analysis for US, Canadian, Australian, and United Kingdom markets

This database offers 90 essential fundamental indicators and financial ratios for 5, US public companies, both point-in-time and revised data, annual and quarterly variants, with 10 years of history. In addition to parsing raw SEC filing documents, the data provider has invested s of hours into harmonizing the reported data across companies and across time; a huge and extremely intricate process.

The database is highly accurate, carefully error-checked and updated every single day. Zacks Investment Research has created two excellent and comprehensive databases for fundamental data and financial ratios: These two databases cover over key statistics for each of 10, stocks, including delisted tickers. The presence of delisted stock fundamentals allows back-testing without survivorship bias. Note that ZFB is a superset of ZFA.

However, this database has one major flaw: This is a limitation of the source data. The Quandl community has built a crowd-sourced harmonized fundamentals database that attempts to mitigate this flaw: Being crowd-sourced, we cannot guarantee update times or accuracy for this database. Aswath Damodaran from NYU used to maintain a superb compendium of harmonized corporate data that he would compute himself. You can view the non-updating database at DMDRN , provided solely for historical purposes.

Fundamentals data from the SEC, and the corresponding harmonized indicators from RAYMOND, have at least three known limitations. First, the data only goes back a few years. The SEC did not mandate electronic filing prior to , and so structured online records are not available prior to that date. Second, the harmonization procedure described above fails when companies change their reporting and accounting treatment from year to year. Third, there are occasional gaps in the quarterly data.

Companies are required to file both quarterly Q and annual K reports with the SEC, and these reports are what the SEC makes available on its website. Hence a typical company listing on the SEC will have 3 quarterly reports and 1 annual report, for every fiscal year. First, the data comes from a variety of different public sources, and is subjected to a variety of calculation and adjustment procedures. Second, the data collection and calculation process is designed and optimized for cross-sectional comparisons of companies, not for time series analysis.

Ratios are meant to be forward-looking point-in-time estimates, not best guesses of past actuals. And the emphasis is on sector averages rather than on individual company data. Here is a list of fundamental indicators available for the SF1 database.

Similar lists for ZFA and ZFB can be found on their respective documentation pages. The Quandl API is free for registered users. You can find our rate limits here. Premium databases are governed by their respective subscription licenses. We strive to offer the most liberal, flexible, transparent and fair data licenses in the world.

Individual, startup , developer and institutional licenses are available. You can preview all premium databases before buying, if you sign up for an API key. Your email address will not be published. Global Data and US Data […]. We have made changes to our API limits as of November 21, at 8AM EST. Users of the Quandl API may be affected by these changes.

New API Limits Registered users are now limited to one API request at a time, with additional requests being throttled until the first request has been returned.

These changes will not impact subscribers of premium databases on Quandl. Open Database Users Premium Database Subscribers Concurrent calls to the API prohibited Concurrent calls to the API permitted unchanged 50, Every single dataset on Quandl is available via our API. The API is simple, consistent and completely free to use. Here's a quick and easy guide to get you started.

This is not meant to be a formal reference for the Quandl API; merely a quick-start guide. To read the complete and definitive documentation, please click here. To start using the Quandl API: Sign up for a free API key Synopsis Here is an API call for FB stock data in CSV format: Quandl now offers API access to stock prices from India, China, Japan and other countries.

Quandl also provides stock fundamentals, sentiment, corporate actions and other extended equity data for global stock markets. Data Trends for Investment Professionals GO TO QUANDL. API for Stock Data. API USAGE GUIDES Oct 17 Example Calls AAPL stock price: Data Organization Quandl has a huge amount of stock data.

List of Databases This list is for US stocks. EOD For US stock prices, we recommend the Quotemedia End-of-Day US Stock Prices database, EOD. WIKI For free and open stock prices, we recommend database WIKI. Stock Fundamentals API Here is an example API call for stock fundamentals: Stock Fundamentals API in Depth In the following sections, individual stock fundamentals databases are described in greater depth.

SF1 For basic US stock fundamentals, we recommend the SF1 Core Fundamentals database. Limitations of Free Fundamentals Data Fundamentals data from the SEC, and the corresponding harmonized indicators from RAYMOND, have at least three known limitations.

Indicators in the DMDRN database suffer from a few known limitations. Third and most obviously, the data is not updated any more, due to a legal injunction. Available Fundamental Indicators Here is a list of fundamental indicators available for the SF1 database.

All open databases on Quandl are free and unencumbered. Additional Resources You might find these pages helpful: Complete API documentation Quandl libraries: Leave a Reply Cancel reply Your email address will not be published. Neural Stock Prediction — Jalark says: October 25, at 9: Using Stock Market Data in Excel - Quandl Resource Hub says: May 11, at API for Global Stock Data - Quandl Resource Hub says: April 4, at 2: API USAGE GUIDES Nov 22 Change to Quandl API Limits We have made changes to our API limits as of November 21, at 8AM EST.

API USAGE GUIDES Sep 03 Getting Started with the Quandl API Every single dataset on Quandl is available via our API. API USAGE GUIDES Aug 10 API for Global Stock Data Quandl now offers API access to stock prices from India, China, Japan and other countries. The Alternative Data Weekly. A Quandl curated weekly newsletter featuring leading thoughts and opinions surveying the alternative data landscape.