NAV

Overview

The Intrinio Excel Add-in extends the functionality of Microsoft Excel by enabling you to access the Intrinio API without any programming experience. This Excel Add-in works on both Mac OS X and Microsoft Windows versions of Excel.

With the Intrinio Excel Add-in, you can access your Intrinio Data Feeds through the various Excel custom functions.

Download Intrinio Excel Add-in

Below are the links for the latest versions of the Intrinio Excel Add-in. Select the appropriate version (Windows or Mac) to download. Please see the install instructions below to begin using the Intrinio Excel add-in

Intrinio App Marketplace

Intrinio Excel Add-in

Windows

For all versions of Windows running Excel 2010 or newer. Download Intrinio_Excel_Addin.exe

Mac OS X (64-bit)

For users running OS X and the latest version of 64-bit Excel 2016 Download Intrinio_Excel_Addin.zip

Mac OS X (32-bit)

For users running OS X and older versions of 32-bit Excel 2016 and Excel 2011 Download Intrinio_Excel_Addin.zip

Github

intrinio-excel

GitHub

The Intrinio Microsoft Excel add-in is released open source on github. If you have any questions, find bugs, or wish to improve the functionality, please feel free to contribute in the intrinio-excel repository.

System Requirements

Supported Operating Systems

The Intrinio Excel Add-in for Microsoft Excel is supported on both Windows and Mac, including the following operating systems:

Microsoft Windows

Mac OS X

Additional Software Requirements

One of the following versions of Microsoft Office is required:

Microsoft Windows

Mac OS X

The Intrinio Excel Add-in has functionality built in it for both the 32-bit and 64-bit versions of Excel. The Add-in is not currently supported on Microsoft Office web applications.

Install Instructions

Getting your Access Key

During the installation process, you will be prompted for your Access Key username and password. You can obtain those by following these steps. If you already have an Intrinio account, skip to step 5:

  1. Visit intrinio.com
  2. Click sign up and enter your email
  3. You will receive a verification email with a link to follow
  4. Click the link in the email and complete your account details
  5. In your Account Page (intrinio.com/account), scroll down and note your Access Key username and password

Windows

  1. Download the latest version of the Intrinio Excel add-in by clicking on the appropriate link above.
  2. The Intrinio Excel add-in will be saved as an Application in your Downloads folder. Find it there, and double click on it.
  3. You’ll see a pop-up titled “Intrinio Excel Add-in”. Check the box to agree to the terms and conditions, then click “Install”.
  4. After a few moments the add-in will be installed, and you can click “Finish”.
  5. Open Microsoft Excel and go to the Intrinio tab on the top ribbon. Select API Keys and a prompt will pop up asking for your API Username and API Password.
  6. Copy your Access Key username and paste it into the User API Username field in Excel.
  7. Copy your Access Key password and paste it into the API Password field in Excel.
  8. Click the “Start” button to begin using the Intrinio API via the Intrinio Excel Add-in!
  9. You can begin by building your own spreadsheet or by opening a template.

Mac OS

  1. Download the latest version of the Intrinio Excel add-in by clicking on the appropriate link above.
  2. Extract the Intrinio Excel add-in zip file to a folder on your hard drive. (On Mac OS X it may automatically extract it for you.)
  3. NOTE: If you’ve already done this once OR if you are updating the add-in, be sure to overwrite the old file.
  4. DO NOT click on Intrinio_Excel_Addin.xlam - you’ll select this later.
  5. Open a BLANK Microsoft Excel worksheet on a Windows or Mac computer.
  6. Open the Intrinio Excel Add-in through the Excel Add-in manager. Click on the “Tools” top menu, Add-Ins >> Select, and navigate to the folder where you extracted the Intrinio Excel Add-In and select it.
  7. Close out the blank Excel spreadsheet
  8. In the next step: if an alert pops up asking you about macros, be sure to click “Enable Macros” (macros are required for the add-in to work - on Windows you can permanently enable them - check our Youtube for instructions).
  9. In the next step: if an alert pops up asking you about links, be sure to click “Ignore Links” or “Do Not Update Links” (this only pops up in the template).
  10. Navigate to your Intrinio_Excel_Addin folder. Open the “Templates” folder, then the “Industrials” folder. Open: IntrinioFinancialData-Industrials.xlsm (YOU MUST OPEN THIS FILE FIRST).
  11. Copy your Access Key username and paste it into the User API Username field in Excel.
  12. Copy your Access Key password and paste it into the API Password field in Excel.
  13. Click the “Start” button to begin using the Intrinio API via the Intrinio Excel Add-in! In this template you can enter a ticker to get started.
  14. You can use any of the templates provided in the Intrinio Excel Add-In folder that you downloaded, or you can build your own models in Excel.

A whole data buffet is being pulled into Excel. It may take longer than you expect to populate. On Windows computers you will see text at the very bottom of Excel that says “Calculating”. This means the data is still downloading. On Mac computers you will see text at the very bottom that says “Ready” when the data has finished downloading. If you click on anything while the data is downloading it will delay the process, so please be patient.

Note: The template is just an illustration of the breadth of data we provide. Click in any cell to see the formula being used to pull that data in. Feel free to use the template if it is helpful to you, but there are no limits to the spreadsheets and models you can create on your own. Once you’ve installed the add-in, these formulas will work in any workbook in Excel. You can create, save, re-open and edit - and the data will be updated continuously.

Intrinio Excel Functions

Below are all of the Excel custom functions for accessing the Intrinio API through the Excel add-in.

IntrinioDataPoint

=IntrinioDataPoint(identifier, item)
Returns that most recent data point for a selected identifier (ticker symbol, CIK ID, Federal Reserve Economic Data Series ID, etc.) for a selected tag. The complete list of tags available through this function are available here. Income statement, cash flow statement, and ratios are returned as trailing twelve months values. All other data points are returned as their most recent value, either as of the last release financial statement or the most recent reported value.

Parameters

=IntrinioDataPoint("`AAPL","name")

Apple Inc.

=IntrinioDataPoint("0000320193","ticker")

AAPL

`=IntrinioDataPoint("AAPL","pricetoearnings")

17.8763

`=IntrinioDataPoint("AAPL","totalrevenue")

199800000000.0

=IntrinioDataPoint("FRED.GDP","value")

18,034.8

=IntrinioDataPoint("DMD.ERP","ttm_erp")

0.0612

IntrinioHistoricalData

=IntrinioHistoricalData(ticker, item, sequence, start_date, end_date, frequency, data_type)
Returns that historical data for for a selected identifier (ticker symbol or index symbol) for a selected tag. The complete list of tags available through this function are available here. Income statement, cash flow statement, and ratios are returned as trailing twelve months values by default, but can be changed with the type parametrer. All other historical data points are returned as their value on a certain day based on filings reported as of that date.

Parameters

=IntrinioHistoricalData("AAPL","open_price",0)

121.85

=IntrinioHistoricalData("AAPL","adj_close_price",0,"2012-01-01","2012-12-31")

71.43

=IntrinioHistoricalData("AAPL","close_price",0,,,"yearly")

110.38

IntrinioHistoricalPrices

=IntrinioHistoricalPrices(ticker, item, sequence, start_date, end_date, frequency)
Returns professional-grade historical stock prices for a company. New EOD prices are available at 5p.m. EST and intraday IEX real-time prices are updated every minute during the trading day. Historical prices are available back to 1996 or the IPO data in most cases, with some companies with data back to the 1970s. Data from Quandl and QuoteMedia.

Parameters

=IntrinioHistoricalPrices("AAPL","open",0)

121.85

=IntrinioHistoricalPrices("AAPL","date",0,"2012-01-01","2012-12-31")

2012-12-31

=IntrinioHistoricalPrices("AAPL","adj_close",0,"2012-01-01","2012-12-31")

71.43

=IntrinioHistoricalPrices("AAPL","date",0,,,"yearly")

2014-12-31

=IntrinioHistoricalPrices("AAPL","close",0,,,"yearly")

110.38

IntrinioFundamentals

=IntrinioFundamentals(ticker, statement, type, sequence, item)
Returns a list of available standardized fundamentals (fiscal year and fiscal period) for a given ticker and statement. Also, you may add a date and type parameter to specify the fundamentals you wish to be returned in the response.

Parameters

=IntrinioFundamentals("AAPL","income_statement","FY",0,"end_date")

2014-09-27

=IntrinioFundamentals("AAPL","balance_sheet","QTR",0,"fiscal_period")

Q3

=IntrinioFundamentals("AAPL","balance_sheet","QTR",0,"fiscal_year")

2015

IntrinioTags

=IntrinioTags(ticker, statement, sequence, item)
Returns the As Reported XBRL tags and labels for a given ticker, statement, and date or fiscal year/fiscal quarter.

A basic list of all industrial standardized tags can be found here. A basic list of all financial standardized tags can be found here.

Parameters

=IntrinioTags("AAPL","income_statement",0,"tag")

operatingrevenue

=IntrinioTags("AAPL","balance_sheet",3,"name")

Short-Term Investments

IntrinioFinancials

=IntrinioFinancials(ticker, statement, fiscal_year/sequence, fiscal_period/type, tag, rounding)
Returns professional-grade historical financial data. This data is standardized, cleansed and verified to ensure the highest quality data sourced directly from the XBRL financial statements. The primary purpose of standardized financials are to facilitate comparability across a single company’s fundamentals and across all companies fundamentals.

For example, it is possible to compare total revenues between two companies as of a certain point in time, or within a single company across multiple time periods. This is not possible using the as reported financial statements because of the inherent complexity of reporting standards.

Parameters

=IntrinioFinancials("AAPL","income_statement",2014,"FY","operatingrevenue","A")

182,795,000,000

=IntrinioFinancials("AAPL","balance_sheet",2,"QTR","totalequity","B")

123.328

=IntrinioFinancials("AAPL","income_statement",7,"TTM","netincometocommon","M")

37,037

IntrinioReportedFundamentals

=IntrinioReportedFundamentals(ticker, statement, type, sequence, item)
Returns an as reported fundamental (fiscal year, fiscal period, start date, and end date) for a given ticker and statement. Also, you may add a period type parameter to specify the fundamentals you wish to be returned in the response.

Parameters

=IntrinioReportedFundamentals("AAPL","income_statement","FY",0,"fiscal_year")

2014

=IntrinioReportedFundamentals("AAPL","income_statement","QTR",2,"fiscal_period")

Q1

=IntrinioReportedFundamentals("AAPL","balance_sheet","QTR",5,"end_date")

2013-12-28

IntrinioReportedTags

=IntrinioReportedTags(ticker,statement,fiscal_year,fiscal_period,sequence,item)
Returns the As Reported XBRL tags and labels for a given ticker, statement, and date or fiscal year/fiscal quarter.

Parameters

=IntrinioReportedTags("AAPL","income_statement",2014,"FY",0,"name")

Net sales

=IntrinioReportedTags("AAPL","income_statement",2014,"FY",0,"tag")

SalesRevenueNet

=IntrinioReportedTags("AAPL","balance_sheet",7,"QTR",28,"name")

Retained earnings

=IntrinioReportedTags("AAPL","balance_sheet",7,"QTR",28,"tag")

RetainedEarningsAccumulatedDeficit

IntrinioReportedFinancials

=IntrinioReportedFinancials(ticker, statement, fiscal_year/sequence, fiscal_period/type, xbrl_tag, domain_tag)
Returns the financial data directly from the xbrl filing of the company’s financial statements.

Parameters

=IntrinioReportedFinancials("AAPL","income_statement",2014,"FY","SalesRevenueNet")

182795000000

=IntrinioReportedFinancials("AAPL","income_statement",2,"QTR","EarningsPerShareBasic")

3.08

=IntrinioReportedFinancials("AAPL","balance_sheet",2014,"FY","PropertyPlantAndEquipmentNet")

20,624,000,000

=IntrinioReportedFinancials("AAPL","balance_sheet",1,"QTR","LongTermDebt")

40,072,000,000

IntrinioBankFundamentals

=IntrinioBankFundamentals(identifier, statement, type, sequence, item)
Returns a list of available standardized fundamentals (fiscal year and fiscal period) for a given ticker and statement. Also, you may add a date and type parameter to specify the fundamentals you wish to be returned in the response.

Parameters

=IntrinioBankFundamentals("STT","RI","FY",0,"end_date")

2015-12-31

=IntrinioBankFundamentals("STT","RC","YTD",1,"fiscal_period")

Q3

=IntrinioBankFundamentals("STT","RI","QTR",0,"fiscal_year")

2015

IntrinioBankTags

=IntrinioBankTags(identifier, statement, sequence, item)
Returns the Bank Call Report or UBPR Report XBRL tags and labels for a given identifier, statement, and date or fiscal year/fiscal quarter.

Parameters

=IntrinioBankTags("STT","RI",10,"tag")

RIADB489

=IntrinioBankTags("STT","RC",20,"name")

Goodwill

IntrinioBankFinancials

=IntrinioBankFinancials(identifier, statement, fiscal_year/sequence, fiscal_period/type, tag, rounding)
Returns professional-grade historical financial data for bank and bank holding companies. This data is directly from the Call Reports and UBPR Reports filed with the FDIC & Federal Reserve.

Parameters

=IntrinioBankFinancials("STT","RI",2015,"FY","RIAD4107","K")

2,489,609

=IntrinioBankFinancials("STT","RC",2,"QTR","RCFDB529","M")

18,313.937