Author:

Andrew Carpenter

Andrew is the Chief Operating Officer (COO) at Intrinio. Get to know him and say hi on LinkedIn!

December 6, 2017
Refreshing Data in Excel for Mac
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.

Read More
November 29, 2017
Corporate Actions API For Developers
Andrew Carpenter

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.

Read More
November 11, 2017
Choosing An Exchange For Stock Prices
Andrew Carpenter

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.

Read More
November 11, 2017
Yahoo Finance API Replacement - Intrinio
Andrew Carpenter

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.

Read More
October 19, 2017
Real Time Stock Prices from Quodd
Andrew Carpenter

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.

Read More
July 5, 2017
What is Intrinio's Data Explorer?
Andrew Carpenter

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.

Read More
June 27, 2017
Why Get Financial Data From Intrinio?
Andrew Carpenter

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.

Read More
May 22, 2017
API Paging Limits: What they are and how to work with them
Andrew Carpenter

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.

Read More
April 25, 2017
Press Release API from NASDAQ
Andrew Carpenter

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.

Read More
March 31, 2017
Options Prices API
Andrew Carpenter

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.

Read More
March 6, 2017
Introducing CSV Downloads for Intrinio Financial Data
Andrew Carpenter

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.

Read More
February 9, 2017
Tracking the Latest SEC Filings
Andrew Carpenter

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.

Read More
February 9, 2017
News API: Get the Latest News on Your Stocks
Andrew Carpenter

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.

Read More
February 7, 2017
Introducing the Intrinio Real-Time Stock Price SDK for NodeJS
Andrew Carpenter

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.

Read More
February 6, 2017
The Intrinio Economic Data API and Excel Add-in
Andrew Carpenter

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.

Read More
February 3, 2017
Quotes API: The Story of Stock Prices from Intrinio
Andrew Carpenter

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.

Read More
January 17, 2017
Financial Modeling with Intrinio Data in Excel and API
Andrew Carpenter

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.

Read More
January 17, 2017
Sector & Industry API - [Instant Access via SIC Code]
Andrew Carpenter

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.

Read More
January 6, 2017
Stock Price API and Excel add-in. Real time and EOD prices
Andrew Carpenter

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.

Read More
January 4, 2017
Stock Screener API From Intrinio
Andrew Carpenter

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.

Read More
January 4, 2017
Standardized XBRL Financial Data - [Why It Matters and How We Fix It]
Andrew Carpenter

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.

Read More
December 27, 2016
Trouble Shooting the Excel Add-In On PC
Andrew Carpenter

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.

Read More
December 27, 2016
Trouble Shooting the Excel Add-In on Mac
Andrew Carpenter

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.

Read More
December 14, 2016
The Importance of Adopting XBRL [4 Reasons To Use XBRL]
Andrew Carpenter

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.

Read More
November 30, 2016
Historical Market Cap and Other Data in Excel
Andrew Carpenter

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.

Read More
November 11, 2016
Stock Prices From Intrinio
Andrew Carpenter

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.

Read More
October 9, 2016
What's an API Call and How Are They Counted?
Andrew Carpenter

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.

Read More
August 17, 2016
Stock API For Fintech Developers: How to Get Started
Andrew Carpenter

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.

Read More
August 17, 2016
How are you calculating that?
Andrew Carpenter

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.

Read More
August 16, 2016
How Can I See a Company's Dividend?
Andrew Carpenter

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.

Read More