Andrew Carpenter

Boy, Excel for Mac can be a real pain in the butt sometimes. In particular, refreshing data within a Mac Excel spreadsheet is near impossible. Many of our users face this issue. Thankfully, we’ve got two simple solutions for you, and this blog walks you through each one step by step.

Intrinio provides corporate actions data for companies around the world with the help of our partner, Exchange Data International. This article explains the corporate actions API, including important links to resources, what's included, how much this data feed costs, and how to access it via API.

If you're looking for real time stock prices, it's important to clarify what a stock price even is. This article explains why there can be multiple prices for the same stock at the same time, how those prices converge, and how to decide which stock price is the right price for you.

Last week, thousands of fintech developers scrambled to find a Yahoo Finance API replacement. Individual investors, startups, and even fortune 500 companies had taken advantage of this free service to obtain financial data like stock prices for their websites, intranets, and applications.

Intrinio is pleased to announce the addition of QUODD to the Intrinio Financial Data Marketplace. Intrinio users can now access more than a dozen real-time stock, index, commodities, forex, and options price feeds. This article explains which data feeds are included and how to access them.

Intrinio’s Data Explorer has a webpage for each of the companies, securities, and stocks that Intrinio covers. Each page includes basic information like financials, stock prices, and news. This article explains how to take advantage of the Data Explorer to search Intrinio’s coverage.

Intrinio’s mission is to make financial data affordable and accessible for all types of users. This article explains why we believe affordability and accessibility are critical and the unique features of the Intrinio platform that make it cheap and easy to get the data you need.

If you’re a developer using Intrinio’s API, you will have noticed that for many data types, the results are limited to a specific number per page. What are API paging limits? What are Intrinio’s paging limits? How can you write code to get all of the pages? This article explains.

Intrinio is excited to announce the addition of the NASDAQ Global Press Releases data feed. This data feed will provide Intrinio users with API access to the latest breaking news for companies from around the world. This article explains how to get access and provides sample API calls.

Intrinio is pleased to provide an end-of-day options prices API. Using our intuitive API, look up options contracts for any US security, then see current pricing for those contracts. We also offer historical options pricing via bulk downloads, for a 3 year, 6 year, or 9 year period.

It's now possible to query the Intrinio financial database via API and receive responses in CSV format. In other words, you can download Intrinio data in bulk to CSV and open it in Excel for further analysis. This article explains why you might want this functionality and how you can use it.

Keeping track of the latest SEC filings is an important part of consuming financial data. Intrinio offers several API calls that to help you make sure your financial analysis stays up-to-date. See our sample API calls to get a list of SEC filings ordered by date, company, and more.

When you’re managing a portfolio of stocks, it’s important to stay up to date with company news. Easy access to these updates helps you keep a pulse on the company and its performance. This article explains how to pull the latest news on the stocks you follow via the Intrinio News API.

Intrinio is pleased to announce our official SDK written for NodeJS. The SDK allows you to quickly and easily bring real-time stock quotes into your NodeJS project. The SDK will provide you with real-time stock quotes, including bid/ask/last price, order size, and execution timestamp.

Intrinio provides a real-time macroeconomic data API with Excel access. There are 200,000+ data series available, including non-farm payrolls, interest rates, and exchange rates. This article shows how to access that data, both the most recent data and historically, in Excel and API.

Real-time stock prices are expensive, and downright unaffordable if you need redistribution rights so you can show the data to your own customers. This article explains how real time stock prices are produced, how Intrinio’s stock quotes API works, and why it’s a more affordable solution.

If you think financial modeling requires data entry to constantly update your calculations, you're in for a treat. This article shows how to calculate a discounted cash flow (DCF), weighted average cost of capital, or quantitative model in Excel or API automatically, without data entry.

Accessing Intrinio data for individual US equities is affordable, easy, and extremely valuable when analyzing investments. We developed a Sector & Industry API so investors and developers can instantly access data to generate lucrative insights for different segments of the market.

Users are fed up with data they get from other providers because it is hard to access and expensive. Our stock price API is affordable and easy to access in Excel or API format. This article explains the ins and outs of the stock price API and how to get a custom market data solution.

The stock screener API returns a list of stocks that meet predefined conditions. The ticker and value for each parameter are returned and can be called in almost any language. This article explains what Intrinio’s stock screener API is and how to get access, and provides sample API calls.

If you want to find out what Tesla’s market capitalization was over the past ten years, and you want to access that data in Excel, it seems like it should be cheap and straightforward to do so. Thanks to a technology called XBRL, this has become easier over the past several years.

Intrinio's Excel add-in is a valuable tool that helps analysts quickly pull data and make calculations without the hassle of manual data entry. This article provides a step-by-step process for getting the Intrinio Excel add-in installed if you are experiencing problems on a PC.

Intrinio's Excel add-in is a valuable tool that helps analysts quickly pull data and make calculations without the hassle of manual data entry. This article provides a step-by-step process for getting the Intrinio Excel add-in installed if you are experiencing problems on a Mac.

Intrinio's technology leverages a data standard called XBRL. XBRL, combined with the Intrinio standardization technology, enables us to rapidly and accurately source, standardize, normalize, and distribute financial data directly from regulatory bodies like the SEC and the FDIC.

One way we make financial data easy to access is by providing historical market cap in flexible formats. This blog shows how to get historical market cap data and hundreds of other financial metrics in Excel. You’ll be able to pull in historical time series data for any US security.

There are many kinds of “stock prices” and there are also many ways to access those prices. This article explains the different types of stock price data available through the Intrinio Financial Data Marketplace and the different ways investors or developers can access those prices.

We regularly get questions about our API, and it's easy to see how it could be confusing – no one was selling financial data through APIs five years ago. This blog will tell you what an API and API call are, how API call limits work in Intrinio’s data plans, and how API calls are counted.

Intrinio’s stock API was designed by financial professionals for developers, a rare situation in the world of fintech. Getting started with the API can be challenging, so this article explains a few of the resources Intrinio has made available to help you get started, including sample API calls.

Intrinio likes to give its users the flexibility to calculate their own metrics and ratios – it makes it easier to understand what the data is telling you. We do, however, calculate more than 100 of these data points for you. This post outlines a few data points that users have asked about.

Many investors like to keep an eye on an important metric: the dividend yield of a stock. This diversity of dividend options makes it important to explore the different ways you can access dividends. The following lists show the numerous ways dividends can be pulled from Intrinio data.