DEV Community

Henry Eleonu
Henry Eleonu

Posted on

Pros and Cons of Stock APIs

Real-time and historic stock or other financial dataset are very essential for developing financial applications. Developers and Data Engineers typically want to extract data from Application Programming Interfaces (API) from within their code. There are many stock APIs out there, therefore could be a bit difficult to decide on which API to use.

We will be looking at some of the popular ones out there and comparing them based on cost, how well-supported the API is, ease of use, limitations on the size of dataset, support for real-time data.

In terms of cost, some are free, others give free days of trial, while some are not free and don’t give free trial.

We can measure how well-supported an API is by their last update, for example in the case of a python library of and API, the last date of update in PyPi. We can also measure this by the frequency of update of their GitHub repository.

Yahoo Finance
Yahoo Finance publishes free stock data from major stock market around the world.
Pros:
· It is free
· We can get huge amount of data from it
· It has two well-supported Python libraries, pandas-datareader library as well as the yfinance library. The libraries simplify the extraction and use of the data by reducing the amount of code. The latest release for yfinance was on Nov 16, 2022
Cons:
· The API is not an official Yahoo Finance API
· Only basic dataset can be retrieved
· Because it is unofficial, the rate of API calls could be limited

Alpha Vantage
Alpha Vantage provides enterprise-grade real-time and historical financial market data through a set of powerful and developer-friendly data APIs and spreadsheets. Delivered through REST stock APIs, Excel, and Google Sheets.
Pros:
· It has a python library, but it is not popular
· It is suitable for commercial applications
· Supports real-time and historical financial market data
Cons:
· It is not free.
· It has an unofficial python library which is not well supported of which the latest release is July 4, 2021

Bloomberg API
Pros:
· it has an official python library
· suitable for commercial applications
· Supports real-time and historical financial market data
Cons:
· Not free. Start as $2000 per month
· Its python library is not well supported. The latest version was released Jan 1, 2019

Stock News
Focused on stock news and summary reports
Pros:
· Good at stock news
Cons:
. No custom python library. You make us of request to get data in json format.
. Gives a 14-days free trial plan starting with $19.99 per month.
Requires details like card number and name on the card to make payment.

IEX Cloud
Pros:
· Has free trial
· Supports real-time and historical financial market data
Cons:
. No custom python library. You make us of request to get data in json format.
. Not free. Starting at $49

Morning star
Pros:
· Has a python library
Cons:
. Not free.
. Python library is not well supported. The latest released was Jun 16, 2020

Top comments (0)