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.
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
For all versions of Windows running Excel 2010 or newer. Download Intrinio_Excel_Addin.exe
For OSX users running Excel 2011 or newer. Download Intrinio_Excel_Addin.zip
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.
The Intrinio Excel Add-in for Microsoft Excel is supported on both Windows and Mac, including the following operating systems:
Microsoft Windows
- Microsoft Windows 10 - (both 32-bit and 64-bit versions)
- Microsoft Windows 8.1 - (both 32-bit and 64-bit versions)
- Microsoft Windows 8 - (both 32-bit and 64-bit versions)
- Microsoft Windows 7 - (both 32-bit and 64-bit versions)
- Microsoft Windows Vista - (both 32-bit and 64-bit versions)
- Microsoft Windows XP - (both 32-bit and 64-bit versions)
- Microsoft Windows Server 2012
- Microsoft Windows Server 2008
Mac OS X
- Mac OS X version 10.5.8 or a later version
One of the following versions of Microsoft Office is required:
Microsoft Windows
- Microsoft Excel 2016 (both 32-bit and 64-bit versions)
- Microsoft Excel 2013 (both 32-bit and 64-bit versions)
- Microsoft Excel 2010 (both 32-bit and 64-bit versions)
Mac OS X
- Microsoft Excel 2016 (both 32-bit and 64-bit versions)
- Microsoft Excel 2011 (both 32-bit and 64-bit versions)
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.
Refer to the Intrinio Excel Add-In Tutorial
Below are all of the Excel custom functions for accessing the Intrinio API through the Excel add-in.
Complete documentation and a function data-explorer are available in the Intrinio Excel Add-In Explorer
=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.
=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
- identifier - an identifier for the company or data point, including the SEC CIK ID, FRED Series ID, or Damodaran ERP: TICKER SYMBOL | STOCK MARKET INDICES | ECONOMIC INDICES | SIC SYMBOL | RSSD ID | CENTRAL INDEX KEY | DAMODARAN ERP
- item - the specified standardized tag or series ID requested: INTRINIO DATA POINT TAGS | ECONOMIC TAGS | DAMODARAN ERP | BANK DATA POINT TAGS | CALL REPORT 031 TAGS | CALL REPORT 041 TAGS | UBPR TAGS | Y9-C REPORT TAGS
=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.
=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
- ticker - the stock market ticker symbol associated with the company's common stock or index. If the company is foreign, use the stock exchange code, followed by a colon, then the ticker. You may request up to 150 tickers at once by separating them by a coma (each ticker and item combination requested will count as 1 query of the API): TICKER SYMBOL | STOCK MARKET INDICES | ECONOMIC INDICES | SIC SYMBOL | RSSD ID
- item - the specified standardized tag requested: INTRINIO TAGS | ECONOMIC TAGS | CALL REPORT 031 TAGS | CALL REPORT 041 TAGS | UBPR TAGS | Y9-C REPORT TAGS
- sequence - an integer 0 or greater for calling a single historical data point from the first entry, based on sort order:
0..last available - start_date (optional) - the first date in which historical stock prices are delivered - historical daily prices go back to 1996 for most companies, but some go back further to the 1970s or to the date of the IPO:
YYYY-MM-DD - end_date (optional, default=today) - the last date in which historical stock prices are delivered - end of day prices are available around 5 p.m. EST and 15 minute delayed prices are updated every minute throughout the trading day:
YYYY-MM-DD - frequency (optional, returns daily historical price data otherwise) - the frequency of the historical prices & valuation data:
daily | weekly | monthly | quarterly | yearly - data_type (optional, returns trailing twelve months (TTM) for the income statement, cash flow statement and calculations, and quarterly (QTR) for balance sheet) - the type of periods requested - includes fiscal years for annual data, quarters for quarterly data and trailing twelve months for annual data on a quarterly basis OR the type of statistic requested when querying using the SIC Indices:
( FY | QTR | TTM | YTD )OR( count | sum | max | 75thpctl | mean | median | 25thpctl | min ) - show_date (optional, false by default, hence returning the value) if true, the function will return the date value instead of the data point value for the given query:
true | false
=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.
=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
- ticker - the stock market ticker symbol associated with the companies common stock securities:TICKER SYMBOL
- item - the selected observation of the historical prices:
date | open | high | low | close | volume | ex_dividend | split_ratio | adj_open | adj_high | adj_low | adj_close | adj_volume - sequence - an integer 0 or greater for calling a single stock historical stock price data point from the first entry, based on sort order:
0..last available - start_date (optional, all historical prices for the security will be queried memory, which will result in a slower loading time) - the first date in which historical stock prices are delivered - historical daily prices go back to 1996 for most companies, but some go back further to the 1970s or to the date of the IPO:
YYYY-MM-DD - end_date (optional, all historical prices for the security will be queried, which will result in a slower loading time) - the last date in which historical stock prices are delivered - end of day prices are available around 5 p.m. EST and 15 minute delayed prices are updated every minute throughout the trading day:
YYYY-MM-DD - frequency (optional, daily data will be pulled in by default) - the last date in which historical stock prices are delivered - end of day prices are available around 5 p.m. EST and 15 minute delayed prices are updated every minute throughout the trading day:
daily | weekly | monthly | quarterly | yearly
=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.
=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
- ticker - the stock market ticker symbol associated with the companies common stock securities: TICKER SYMBOL
- statement - the financial statement requested, options include the income statement, balance sheet, statement of cash flows and calculated metrics and ratios :
income_statement | balance_sheet | cash_flow_statement | calculations - type - the type of periods requested - includes fiscal years for annual data, quarters for quarterly data and trailing twelve months for annual data on a quarterly basis:
FY | QTR | TTM | YTD - sequence - an integer 0 or greater for calling a single fundamental from the first entry:
0..last available - item - the return value for the fundamental:
fiscal_year | fiscal_period | end_date | start_date
=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.
=IntrinioTags("AAPL","income_statement",0,"tag")
operatingrevenue
=IntrinioTags("AAPL","balance_sheet",3,"name")
Short-Term Investments
- ticker - the stock market ticker symbol associated with the companies common stock securities: TICKER SYMBOL
- statement - the financial statement requested, options include the income statement, balance sheet, statement of cash flows, calculated metrics and ratios, and current data points :
income_statement | balance_sheet | cash_flow_statement | calculations - sequence - an integer 0 or greater for calling a single tag from the first entry, based on order:
0..last available - item - the returned value for the data tag:
name | tag | balance | unit
=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.
=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
- ticker - the stock market ticker symbol associated with the companies common stock securities: TICKER SYMBOL
- statement - the financial statement requested, options include the income statement, balance sheet, statement of cash flows and calculated metrics and ratios :
income_statement | balance_sheet | cash_flow_statement | calculations - fiscal_year - the fiscal year associated with the fundamental OR the sequence of the requested fundamental (i.e. 0 is the first available fundamental associated with the fiscal period type):
YYYYOR0..last available - fiscal_period - the fiscal period associated with the fundamental, or the fiscal period type in association with the sequence selected in the fiscal year parameter:
FY | Q1 | Q2 | Q3 | Q4 | Q1TTM | Q2TTM | Q3TTM | Q2YTD | Q3YTDORFY | QTR | YTD | TTM - tag - the specified standardized tag: STANDARDIZED INDUSTRIAL TAGS | STANDARDIZED FINANCIAL TAGS
- rounding (optional, actuals by default) - round the returned value (actuals, thousands, millions, billions):
A | K | M | B
=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.
=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
- ticker - the stock market ticker symbol associated with the companies common stock securities:TICKER SYMBOL
- statement - the financial statement requested, options include the income statement, balance sheet and statement of cash flows:
income_statement | balance_sheet | cash_flow_statement - type - the type of periods requested - includes fiscal years for annual data, quarters for quarterly data:
FY | QTR - sequence - an integer 0 or greater for calling a single fundamental from the first entry:
0..last available - item - the selected return value from the fundamental:
fiscal_year | fiscal_period | end_date | start_date
=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.
=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
- ticker - the stock market ticker symbol associated with the companies common stock securities:TICKER SYMBOL
- statement - the financial statement requested:
income_statement | balance_sheet | cash_flow_statement - fiscal_year - the fiscal year associated with the fundamental OR the sequence of the requested fundamental (i.e. 0 is the first available fundamental associated with the fiscal period type):
YYYYOR**0..last available** - fiscal_period - the fiscal period associated with the fundamental, or the fiscal period type in association with the sequence selected in the fiscal year parameter: **
FY | Q1 | Q2 | Q3 | Q4 | Q1TTM | Q2TTM | Q3TTM | Q2YTD | Q3YTD**ORFY | QTR | YTD | TTM - item - the selected return value for the reported tags:
name | tag | domain_tag | balance | unit
=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.
=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
- ticker - the stock market ticker symbol associated with the companies common stock securities: TICKER SYMBOL
- statement - the financial statement requested, options include the income statement, balance sheet, statement of cash flows and calculated metrics and ratios:
income_statement | balance_sheet | cash_flow_statement - fiscal_year - the fiscal year associated with the fundamental OR the sequence of the requested fundamental (i.e. 0 is the first available fundamental associated with the fiscal period type):
YYYYOR0..last available - fiscal_period - the fiscal period associated with the fundamental, or the fiscal period type in association with the sequence selected in the fiscal year parameter: **
FY | Q1 | Q2 | Q3 | Q4 | Q1TTM | Q2TTM | Q3TTM | Q2YTD | Q3YTD**OR**FY | QTR | YTD | TTM** - xbrl_tag - the specified XBRL tag:
All Available XBRL Tags - domain_tag (optional) - the specified domain XBRL tag, associated with certain data points on the financial statements that have a dimension associated with the data point:
All Available Domain XBRL Tags
=IntrinioNews(identifier, item, sequence)
Returns news article data for the selected identifier (ticker symbol, CIK ID, FIGI, etc).
=IntrinioNews("AAPL","title",0)
Google challenges Apple's Siri by opening digital assistant to iPhone
=IntrinioNews("AAPL","publication_date",0)
2017-05-17 18:23:55 +0000
- identifier - an identifier for the company, including ticker symbol the SEC CIK ID, FIGI: TICKER SYMBOL | CENTRAL INDEX KEY
- item - the attribute of the news article:
title | publication_date | summary | url - sequence - an integer 0 or greater for calling a single news article from the first entry, based on sort order:
0..last available
=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.
=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
- identifier - the stock market ticker symbol associated with the companies common stock securities or the Federal Reserve RSSD ID unique identifier for the bank: TICKER SYMBOL | RSSD ID LOOKUP
- statement - the Call Report/UBPR/Y-9C financial statement requested: CALL REPORT 031 TAGS | CALL REPORT 041 TAGS | UBPR TAGS | Y9-C REPORT TAGS
- type - the type of periods requested - includes fiscal years for annual data, quarters for quarterly data and trailing twelve months for annual data on a quarterly basis:
FY | YTD - sequence - an integer 0 or greater for calling a single fundamental from the first entry:
0..last available - item - the return value for the fundamental:
fiscal_year | fiscal_period | end_date | start_date
=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.
=IntrinioBankTags("STT","RI",10,"tag")
RIADB489
=IntrinioBankTags("STT","RC",20,"name")
Goodwill
- identifier - the stock market ticker symbol associated with the companies common stock securities or the Federal Reserve RSSD ID unique identifier for the bank: TICKER SYMBOL | RSSD ID LOOKUP
- statement - the Call Report/UBPR/Y-9C financial statement requested: CALL REPORT 031 TAGS | CALL REPORT 041 TAGS | UBPR TAGS | Y9-C REPORT TAGS
- sequence - an integer 0 or greater for calling a single tag from the first entry, based on order:
0..last available - item - the returned value for the data tag:
name | tag | balance | unit
=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.
=IntrinioBankFinancials("STT","RI",2015,"FY","RIAD4107","K")
2,489,609
=IntrinioBankFinancials("STT","RC",2,"QTR","RCFDB529","M")
18,313.937
- identifier - the stock market ticker symbol associated with the companies common stock securities or the Federal Reserve RSSD ID unique identifier for the bank: TICKER SYMBOL | RSSD ID LOOKUP
- statement - the Call Report/UBPR/Y-9C financial statement requested: CALL REPORT 031 TAGS | CALL REPORT 041 TAGS | UBPR TAGS | Y9-C REPORT TAGS
- fiscal_year - the fiscal year associated with the fundamental OR the sequence of the requested fundamental (i.e. 0 is the first available fundamental associated with the fiscal period type):
YYYYOR0..last available - fiscal_period - the fiscal period associated with the fundamental, or the fiscal period type in association with the sequence selected in the fiscal year parameter:
FY | Q1 | Q2 | Q3 | Q4 | Q2YTD | Q3YTD | Q1TTM | Q2TTM | Q3TTMORFY | QTR | YTD | TTM - tag - the specified Call Report/UBPR/Y-9C XBRL Tag requested: CALL REPORT 031 TAGS | CALL REPORT 041 TAGS | UBPR TAGS | Y9-C REPORT TAGS
- rounding (optional, actuals by default) - round the returned value (actuals, thousands, millions, billions):
A | K | M | B