With the click of a button, you can now integrate a wide range of financial data to help track stock prices, analyze your portfolio, build a personalized dividend tracker, and more. No coding required.
This IEX Cloud add-in makes it easy to import the following data for U.S. equities:
This application can be installed free of charge and is available to anyone with an IEX Cloud account.
Retrieving data from IEX Cloud, including through Excel, uses messages. Be sure to read the “Pricing and Messages” section below before getting started. A paid IEX Cloud subscription is required to access splits, earnings estimates, financial statements, more than five years of historical prices, and dividends prior to the most recent reporting period.
Setup is simple:
Importing data into your spreadsheet:
You can test the application with your sandbox token, which returns unlimited scrambled test data for free. If you’re just getting started, we recommend beginning with testing. To do this, use your sandbox API token from IEX Cloud when first initiating the Add-in. Learn more about sandbox testing here.
Use Custom Functions
We’ve also started building custom functions for Excel. You can use the currently available functions to import certain fields from real-time stock quotes, including latest prices and stock volume. Reference the syntax for those functions and what fields are returned here. The other endpoints are only available via the add-in directly.
Pricing and Messages
The "IEX Cloud Stock Data" Excel add-in is available free of charge and can be used by anyone with an IEX Cloud account, both free and paid. A paid plan is required to access certain data on IEX Cloud, including splits, earning estimates, historical prices from the past five years, financial statements, and dividends prior to the most recent reporting period.
Accessing data from IEX Cloud, including through Excel, uses messages. Messages are the fundamental units used to access data and make API calls on IEX Cloud. Each API endpoint has a “data weight” that indicates how many messages are used every time you make an API call or update data from that endpoint. See each endpoint’s data weight in the IEX Cloud API documentation.
This model helps you customize how you use your IEX Cloud subscription. You can use a higher volume of lower-weighted endpoints, fewer higher-weighted endpoints, or a combination. Free plans on IEX Cloud automatically include 50,000 messages to help you get started. Paid plans provide a larger number of allocated messages, give access to a broader range of datasets, and more. Learn more about pricing here.
About IEX Cloud
IEX Cloud is a financial data delivery platform setting new standards for easy delivery and use of financial data. Launched May 2019, the platform offers a flexible, accessible model for connecting developers with curated financial data, and provides a high-performance API along with custom-built services to help users build, launch, and scale their products or businesses.
*A note on real-time data
Real-time prices can be refreshed as often as every ten seconds. Real-time stock prices provided from the IEX Cloud API are different from real-time stock prices made available from the Investors Exchange via direct connection. Learn more.