NAV
API Excel Sheets

Introduction

# API Endpoint
https://api.intrinio.com

Welcome to the Intrinio API! Through our Intrinio Data Marketplace, we offer a wide selection of financial data feeds sourced by our own proprietary processes as well as from many data vendors. The primary application of the Intrinio API is for use in third-party applications and integrations or for end-users utilizing the Excel add-in and Google Sheets add-on.

The Intrinio API uses HTTPS verbs and a RESTful endpoint structure, which makes it easy to request data from Intrinio. Basic Authentication is administered over HTTPS. Responses are delivered in JSON format.

If you need additional help in using the API, send us a message by clicking the Help widget in the bottom right corner at anytime.

Authentication

To authorize your access to the Intrinio API:

# With shell, you must include the username and password header
curl "https://api.intrinio.com/data_point?identifier=AAPL&item=close_price"
  -u "API_USERNAME:API_PASSWORD"

# With the '-u' option in curl, it will automatically convert the username
# and password into the appropriate header.
# If you do not use this option or it is not available to you, you must include
# a header with the basic auth credentials included as base64 encoded.
curl "https://api.intrinio.com/data_point?identifier=AAPL&item=close_price"
  -H "Authorization: Basic $BASE64_ENCODED(USERNAME:PASSWORD)"
When prompted by the Intrinio Excel add-in, either by selecting the API Keys
button on the ribbon or when prompted, enter your API Username and API Password.
When prompted by the Intrinio Google Sheets add-on on the side bar,
enter your API Username and API Password.

The Intrinio API uses Basic Authentication over HTTPS.

You can find your API Username and API Password on your User Admin Dashboard of the site. You must include your credentials with every request in order to receive access to the API.

If your API Keys cannot be authorized, a status code of 401 will be returned.

Response Codes

Each API Error Response will include a response code, a readable response
code, and a message.  These Error Responses will give you enough information
to diagnosis any potential issues with your access to the Intrinio API.
There are three errors typically seen in the Excel add-in.
You will see these errors as responses to Intrinio Functions in cells.

"Invalid API Keys" -- HTTP Response Code 401 -- Your User/Password
    API Keys are incorrect

"Visit Intrinio.com to Subscribe" -- HTTP Response Code 403 -- You
    are not subscribed to the data feed requested

"Plan Limit Reached" -- HTTP Response Code 429 -- You have hit your
    10-minute throttled limit or your daily limit for the subscription
// Intrinio API Response Codes are not utilized in the Intrinio
// Google Sheets add-on.  However, you may see various errors
// associated with Google Apps, such as:

// "Service invoked too many times in a short time:
// Properties. Try Utilities.sleep(1000) between calls."
// -- You have made too many calls via the Google Apps
// system too quickly and Google has throttled your service.

// "Service using too much computer time for one day." --
// You have made too many calls for the day and your
// access has been cut off for the remainder of the day.

Intrinio uses normal HTTP response codes to indicate the success or failure of an API request. A response code of 200 indicates success and codes in the 4xx range indicate an error that failed given the information provided, and codes in the 5xx range indicate an error with Intrinio’s servers (these are rare).

The Intrinio API uses the following error codes:

Error Code Meaning
200 OK – Everything worked as expected
401 Unauthorized – Your User/Password API Keys are incorrect
403 Forbidden – You are not subscribed to the data feed requested
404 Not Found – The end point requested is not available
429 Too Many Requests – You have hit a limit. See Limits
500 Internal Server Error – We had a problem with our server. Try again later.
503 Service Unavailable – Intrinio temporarily offline for maintenance. Please try again later.

Limits

Overview

The Intrinio API employs several reasonable limits to ensure that stable, reliable service is provided to all users. These limits can vary based on which data feeds you are subscribed to, as well as which API call you are making. The limits are grouped as: daily calls, 10-minute calls, paging, throttling, and timeouts. If you hit an API limit, the response will contain a 429 code and an explanation of the limit.

Daily Call Limits

Most data feed subscriptions have limited daily usage. This means that you can make up to a certain number of API calls in a 24-hour period (resetting at midnight Eastern). To view the limits for a data feed subscription, go to your Account page and click on Limits next to the data feed subscription in question.

10-Minute Call Limits

Some data feed subscriptions have limited 10-minute usage. This means that you can make up to a certain number of API calls in a 10-minute period. To view the limits for a data feed subscription, go to your Account page and click on Limits next to the data feed subscription in question.

Paging Limits

API endpoints that employ paging are limited by the maximum page size that you may request. This varies by endpoint:

Endpoint Maximum Page Size
/prices 50,000
/historical_data 50,000
/tags/standardized 5,000
/tags/reported 5,000
/tags/banks 5,000
/financials/standardized 5,000
/financials/reported 5,000
/financials/banks 5,000
All others 250

Throttle Limits

Users enjoying free data feed subscriptions only are limited to 100 requests-per-second.

Timeout Limits

Each request must be fulfilled within 15 seconds, otherwise it will be dropped with a 503 error. Given the flexibility of our endpoints and the complexity of potential API calls, we leave it to the users to fashion requests which can be satisfied in a reasonable time.

Coverage

Companies & Securities

U.S. Public Company Securities

Our coverage space includes all publicly traded companies in the United States. We cover all companies who are listed on the NYSE, NASDAQ and BATS Stock Exchanges. Our coverage for these companies is comprehensive, which includes historical pricing data for every publicly traded security, including non-common stock securities.

In addition, this coverage includes exchange traded funds (ETFs), various classes of common stock, American Depositary Shares (ADRs), preferred stock, warrants and much more, totaling over 9,000 securities.

International Securities

We recently added coverage for over 100,000 global publicly traded securities. This includes both active and de-listed securities. We have integrated substantially with OpenFIGI to have a unified standard securities master at the core of our architecture. With OpenFIGI, you can utilize a whole host of identifiers to query the OpenFIGI API, which will map those identifiers, to the FIGI identifier, and allow us to retrieve the correct data requested.

You can learn more about OpenFIGI here.

To access the Company Master via API, use the /companies end point in the Intrinio Master Data Feed

To access the Security Master via API, use the /securities end point in the Intrinio Master Data Feed

Indices

We offer access to hundreds of thousands of indices that cover three primary areas: stock market indices, SIC (sector/industry) indices, and economic indices.

To access the Index Master via API, use the /indices end point in the Intrinio Master Data Feed

Stock Market Indices

We have historical end-of-day values for 13 stock market indices, back to the 1950s at the earliest. The values include the daily/weekly/monthly/quarterly/yearly high, low, open, close (last price), and volume.

You can view the Stock Market Indices Master here.

SIC Indices

We offer aggregated sector and industry data based on company reported Standard Industrial Classification numbers. These indices are updated monthly, reflecting all newly reported filings. An Intrinio SIC Index is created with the following format: $SIC.XXXX.

You can view the SIC Indices Master here.

Economic Indices

We provide access to over 200,000 economic data series. Below is a list of the 1,000 most popular economic data series. However, you can access all the data series by querying the Intrinio API Indices or by going to the Federal Reserve Economic Data website. The index symbol is the same as the Series ID on FRED, however you put place a “$” before the series ID for the Intrinio API to recognize that it is an index.

You can view the Economic Indices Master here.

Damodaran Equity Risk Premiums

We offer access to Aswath Damodaran’s Equity Risk Premiums provided through his website at NYU. This data is helpful for the valuation community looking for a monthly updated ERP, calculated by one of the main authorities on valuation. This data updates each month with the latest calculation after it is published to Damodaran’s site.

You can learn more about the Damodaran ERP here.

Owners

We aggregate insider transactions and institutional holdings data to create a unified Owner Master. These are either individual or companies who own securities and must report this ownership to the SEC.

To access the Owner Master via API, use the /owners end point in the Intrinio Master Data Feed

Insider Owners

All directors, officers, 10%+ owners, and other related owners must report all insider transactions in the company when buying or selling securities. This includes open market purchases, sales, stock option grants, conversions, gifts and many other transactions. These transactions are reported in Form 3, 4 & 5 filed by the owner with the SEC.

We aggregate all direct and indirect ownership interests for each owner in related companies to provide a snapshot as to the value of the interests these insider owners control in the company.

Institutional Owners

Each quarter, firms who are institutional owners of securities must report their holdings to the SEC with form 13F. We offer access to the reported holdings data via API.

Spreadsheet Add-ins

Intrinio Excel Add-in

Intrinio offers an Excel add-in in the Intrinio App Marketplace, which 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.

Examples of how to access the API end points via the Excel add-in can be viewed by selecting the Excel option in the code examples of this documentation. We also have dedicated Intrinio Excel Add-in Documentation.

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

Intrinio Screener for Excel

Intrinio has built a screener in Excel, proving an interface to the Intrinio Securities Search API end point. The Intrinio Screener for Excel allows users to screen based on up to 500 daily parameters for free without leaving Excel Online. Users can filter based on familiar parameters such as P/E ratios and dividend yield as well as hundreds of unique items from company balance sheets and income statements. The resulting list of tickers includes the datapoints used in the screen in a nice, neat table in Excel that integrates with the Intrinio Excel add-on for further analysis.

Intrinio App Marketplace

Intrinio Screener for Excel

Microsoft Office App Store

Intrinio Screener for Excel

Intrinio Google Sheets add-on

Intrinio also has a Google Sheets add-on available through the Intrinio App Marketplace, which extends the functionality of Google Sheets by enabling you to access the Intrinio API on most mobile devices. This Google Sheets add-on works on all devices that support Google Sheets - smart phone, tablet, Chrome OS, Mac OS, Windows OS, etc. With the power of Google Sheets, Intrinio offers the most flexible access to financial data - anywhere, anytime.

Examples of how to access the API end points via the Google Sheets add-on can be viewed by selecting the Sheets option in the code examples of this documentation. We also have dedicated Intrinio Google Sheets add-on Documentation

Intrinio App Marketplace

Intrinio Google Sheet add-on

Chrome Store

Intrinio Financial Data

GitHub

intrinio-google-sheets

SDKs

We are open to working with developers in the open source community to build and maintain unofficial SDKs that simplify the usage of the Intrinio API in various programming languages. In the future, we plan on supporting Ruby, Java, Node.js, Python, PHP, .Net, and Javascript.

Node.js (Unofficial Release)

intrinio-client (npm/GitHub)

Other SDKs

In the future, we plan on supporting Ruby, R, Java, Node.js, Python, PHP, .Net, and Javascript. We are open to working with developers in the open source community to build and maintain unofficial SDKs that simplify the usage of the Intrinio API in various programming languages.

Master Data Feed

Company Master

Returns the master list of all companies covered by the Intrinio Data Marketplace. You can view the Company/Security Master here.

Endpoint

https://api.intrinio.com/companies

https://api.intrinio.com/companies?query={query-string}

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /companies
FULL URL: https://api.intrinio.com/companies

{
    "result_count": 8155,
    "page_size": 250,
    "current_page": 1,
    "total_pages": 33,
    "api_call_credits": 1,
    "data": [
        {
            "ticker": "A",
            "name": "Agilent Technologies Inc",
            "lei": "QUIX8Y7A2WP0XRMW7G29",
            "cik": "0001090872",
            "latest_filing_date": "2017-02-06"
        },
        {
            "ticker": "AA",
            "name": "Alcoa Inc",
            "lei": "ABPN11VOHLHX6QR7XQ48",
            "cik": "0000004281",
            "latest_filing_date": "2017-02-06"
        },
        ...
    ]
}
Function not available
Function not available

Security Master

Returns the master list of all securities covered by the Intrinio Data Marketplace. You can view the Company/Security Master here.

Endpoint

https://api.intrinio.com/securities

https://api.intrinio.com/securities?identifier={symbol}

https://api.intrinio.com/securities?query={query-string}

https://api.intrinio.com/securities?exch_symbol={stock-exchange-symbol}

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /securities
FULL URL: https://api.intrinio.com/securities

{
    "result_count": 55636,
    "page_size": 250,
    "current_page": 1,
    "total_pages": 223,
    "api_call_credits": 1,
    "data": [
        {
            "ticker": "000001",
            "figi_ticker": "000001:CH",
            "figi": "BBG000BZDPV5",
            "security_name": "PING AN BANK CO LTD-A",
            "market_sector": "Equity",
            "security_type": "Common Stock",
            "stock_exchange": "SHE",
            "last_crsp_adj_date": null
        },
        {
            "ticker": "000002",
            "figi_ticker": "000002:CH",
            "figi": "BBG000BZ9Z48",
            "security_name": "CHINA VANKE CO LTD -A",
            "market_sector": "Equity",
            "security_type": "Common Stock",
            "stock_exchange": "SHE",
            "last_crsp_adj_date": null
        },
        ...
    ]
}
Function not available
Function not available

Index Master

Returns indices list and information for all indices covered by Intrinio. There are three distinct types of indices: Stock Market, SIC (Sector & Industry), and Economic. You can view the Stock Market Indices Master, SIC Indices Master, and the Economic Indices Master.

Endpoint

https://api.intrinio.com/indices

https://api.intrinio.com/indices?identifier={symbol}

https://api.intrinio.com/indices?query={query-string}

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /indices
FULL URL: https://api.intrinio.com/indices

{
    "result_count": 295283,
    "page_size": 250,
    "current_page": 1,
    "total_pages": 1182,
    "api_call_credits": 1,
    "data": [
        {
            "symbol": "$00XALCATM086NEST",
            "index_name": "Harmonized Index of Consumer Prices: Overall Index Excluding Alcohol and Tobacco for Austria©"
        },
        {
            "symbol": "$00XALCBEM086NEST",
            "index_name": "Harmonized Index of Consumer Prices: Overall Index Excluding Alcohol and Tobacco for Belgium©"
        },
        ...
    ]
}
Function not available
Function not available

Owner Master

Returns owners list and information for all insider and institutional owners of securities covered by Intrinio.

Endpoint

https://api.intrinio.com/owners

https://api.intrinio.com/owners?institutional={true|false}

https://api.intrinio.com/owners?query={query-string}

https://api.intrinio.com/owners?identifier={owner_cik}

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /owners
FULL URL: https://api.intrinio.com/owners

{
    "result_count": 47240,
    "page_size": 250,
    "current_page": 1,
    "total_pages": 189,
    "api_call_credits": 1,
    "data": [
        {
            "owner_cik": "0000001800",
            "owner_name": "ABBOTT LABORATORIES"
        },
        {
            "owner_cik": "0000002110",
            "owner_name": "COLUMBIA ACORN TRUST"
        },
        ...
    ]
}
Function not available
Function not available

Stock Exchange Master

Returns stock exchange list and information for all stock exchanges covered by Intrinio.

Endpoint

https://api.intrinio.com/stock_exchanges

https://api.intrinio.com/stock_exchanges?query={query-string}

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /stock_exchanges
FULL URL: https://api.intrinio.com/stock_exchanges

{
    "result_count": 29,
    "page_size": 250,
    "current_page": 1,
    "total_pages": 1,
    "api_call_credits": 1,
    "data": [
        {
            "symbol": "^BMEX",
            "mic": "BMEX",
            "institution_name": "BME - BOLSAS Y MERCADOS ESPANOLES",
            "acronym": "BME",
            "city": "MADRID",
            "country": "SPAIN",
            "country_code": "ES",
            "website": "HTTP://WWW.BOLSASYMERCADOS.ES"
        },
        {
            "symbol": "^BVMF",
            "mic": "BVMF",
            "institution_name": "BM&FBOVESPA S.A. - BOLSA DE VALORES, MERCADORIAS E FUTUROS",
            "acronym": null,
            "city": "SAO PAULO",
            "country": "BRAZIL",
            "country_code": "BR",
            "website": "HTTP://WWW.BMFBOVESPA.COM.BR"
        },
        ...
    ]
}
Function not available
Function not available

U.S. Public Company Data Feed

Companies

Returns company list and information for all companies covered by Intrinio.

Endpoint

https://api.intrinio.com/companies

https://api.intrinio.com/companies?identifier={symbol}

https://api.intrinio.com/companies?query={query-string}

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /companies
FULL URL: https://api.intrinio.com/companies

{
    "result_count": 8132,
    "page_size": 250,
    "current_page": 1,
    "total_pages": 33,
    "api_call_credits": 1,
    "data": [
        {
            "ticker": "A",
            "name": "Agilent Technologies Inc",
            "lei": "QUIX8Y7A2WP0XRMW7G29",
            "cik": "0001090872",
            "latest_filing_date": "2017-02-06"
        },
        {
            "ticker": "AA",
            "name": "Alcoa Inc",
            "lei": "ABPN11VOHLHX6QR7XQ48",
            "cik": "0000004281",
            "latest_filing_date": "2017-02-06"
        },
        ...
    ]
}

API URI: https://api.intrinio.com
GET: /companies?identifier=AA
FULL URL: https://api.intrinio.com/companies?identifier=AA

{
    "ticker": "AA",
    "name": "Alcoa Inc",
    "lei": "ABPN11VOHLHX6QR7XQ48",
    "legal_name": "Alcoa Inc.",
    "stock_exchange": "NYSE",
    "sic": 3350,
    "short_description": "Alcoa Inc. engages in engineering and manufacturing lightweight metals worldwide. The company operates through five segments: Alumina, Primary Metals, Global Rolled Products, Engineered Products and Solutions, and Transport and Construction Soluti...",
    "long_description": "Alcoa Inc. engages in engineering and manufacturing lightweight metals worldwide. The company operates through five segments: Alumina, Primary Metals, Global Rolled Products, Engineered Products and Solutions, and Transport and Construction Solutions. The Alumina segment mines for bauxite, refines it for producing alumina, and sells alumina directly to external smelter customers, or to customers who process it into industrial chemical products. The Primary Metals segment produces and sells primary aluminum to external customers and traders. This segment also sells aluminum powder, scrap, and excess energy, as well as purchases and resells metals. The Global Rolled Products segment produces and sells aluminum sheets and plates to the packaging end market for the production of aluminum cans, as well as to the aerospace, automotive, commercial transportation, building and construction, and industrial products end markets. This segment also produces aseptic foils for the packaging end market. The Engineered Products and Solutions segment offers fastening systems, including titanium, steel, and nickel alloys; seamless rolled rings, such as nickel alloys; investment castings, including airfoils and forged jet engine components; and various forging and extrusion metal products. This segment serves aerospace, commercial transportation, power generation, oil and gas, industrial products, automotive, and land and sea defense end markets. The Transport and Construction Solutions segment provides integrated aluminum structural systems, architectural extrusions, and forged aluminum commercial vehicle wheels, as well as aluminum products. The segment serves nonresidential building and construction, commercial transportation, and industrial products end markets. The company sells its products directly to customers, as well as through distributors, agents, and alumina traders. Alcoa Inc. was founded in 1888 and is based in New York, New York.",
    "ceo": "Klaus-Christian Kleinfeld",
    "company_url": "http://www.alcoa.com",
    "business_address": "390 PARK AVENUE, NEW YORK, NY 10022-4608",
    "mailing_address": "390 PARK AVENUE, NEW YORK, NY 10022-4608",
    "business_phone_no": "2128362732",
    "hq_address1": "390 Park Avenue",
    "hq_address2": null,
    "hq_address_city": "New York",
    "hq_address_postal_code": "10022",
    "entity_legal_form": "INCORPORATED",
    "securities": [
        {
            "ticker": "AA",
            "figi_ticker": "AA:US",
            "figi": "BBG000B9WH86",
            "security_name": "ALCOA INC",
            "market_sector": "Equity",
            "security_type": "Common Stock",
            "stock_exchange": "NYSE",
            "last_crsp_adj_date": "2016-10-06",
            "composite_figi": "BBG000B9WH86",
            "figi_uniqueid": "EQ0010004600001000",
            "share_class_figi": "BBG001S5C3C2",
            "figi_exch_cntry": "US",
            "currency": "USD",
            "mic": "XNYS",
            "exch_symbol": "^XNYS",
            "etf": false,
            "delisted_security": false,
            "primary_listing": true
        },
        {
            "ticker": "AA$",
            "figi_ticker": "AA$:US",
            "figi": null,
            "security_name": "ALCOA INC. $3.75 PREFERRED STOCK",
            "market_sector": null,
            "security_type": null,
            "stock_exchange": "NYSE",
            "last_crsp_adj_date": null,
            "composite_figi": null,
            "figi_uniqueid": null,
            "share_class_figi": null,
            "figi_exch_cntry": null,
            "currency": "USD",
            "mic": "XNYS",
            "exch_symbol": "^XNYS",
            "etf": false,
            "delisted_security": true,
            "primary_listing": true
        },
        {
            "ticker": "AA$B",
            "figi_ticker": "AA$B:US",
            "figi": null,
            "security_name": "ALCOA INC. DEPOSITORY SHARES REPRESENTING 1/10TH PREFERRED CONVERTILBLE CLASS B SERIES 1",
            "market_sector": null,
            "security_type": null,
            "stock_exchange": "NYSE",
            "last_crsp_adj_date": null,
            "composite_figi": null,
            "figi_uniqueid": null,
            "share_class_figi": null,
            "figi_exch_cntry": null,
            "currency": "USD",
            "mic": "XNYS",
            "exch_symbol": "^XNYS",
            "etf": false,
            "delisted_security": true,
            "primary_listing": true
        },
        {
            "ticker": "AA.V",
            "figi_ticker": "AA.V:US",
            "figi": null,
            "security_name": "ALCOA CORPORATION COMMON STOCK WHEN ISSUED",
            "market_sector": null,
            "security_type": null,
            "stock_exchange": "NYSE",
            "last_crsp_adj_date": null,
            "composite_figi": null,
            "figi_uniqueid": null,
            "share_class_figi": null,
            "figi_exch_cntry": null,
            "currency": "USD",
            "mic": "XNYS",
            "exch_symbol": "^XNYS",
            "etf": false,
            "delisted_security": true,
            "primary_listing": true
        },
        {
            "ticker": "185",
            "figi_ticker": "185:GF",
            "figi": "BBG00F5NPYJ8",
            "security_name": "ALCOA CORP",
            "market_sector": "Equity",
            "security_type": "Common Stock",
            "stock_exchange": "FRA",
            "last_crsp_adj_date": null,
            "composite_figi": "BBG00F5NPYH0",
            "figi_uniqueid": "EQ0000000052613686",
            "share_class_figi": "BBG00B3T3HF1",
            "figi_exch_cntry": "GF",
            "currency": "EUR",
            "mic": "XFRA",
            "exch_symbol": "^XFRA",
            "etf": false,
            "delisted_security": false,
            "primary_listing": false
        }
    ],
    "cik": "0000004281",
    "latest_filing_date": "2017-02-06",
    "hq_state": "New York",
    "hq_country": "United States of America",
    "inc_state": "Pennsylvania",
    "inc_country": "United States of America",
    "employees": 60000,
    "entity_status": "ACTIVE",
    "sector": "Basic Materials",
    "industry_category": "Metals & Mining",
    "industry_group": "Aluminum",
    "template": "industrial",
    "standardized_active": true
}
Function not available
Function not available

Securities

Returns security list and information for all securities covered by Intrinio.

Endpoint

https://api.intrinio.com/securities

https://api.intrinio.com/securities?identifier={symbol}

https://api.intrinio.com/securities?query={query-string}

https://api.intrinio.com/securities?exch_symbol={stock-exchange-symbol}

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /securities
FULL URL: https://api.intrinio.com/securities

{
    "result_count": 55636,
    "page_size": 250,
    "current_page": 1,
    "total_pages": 223,
    "api_call_credits": 1,
    "data": [
        {
            "ticker": "000001",
            "figi_ticker": "000001:CH",
            "figi": "BBG000BZDPV5",
            "security_name": "PING AN BANK CO LTD-A",
            "market_sector": "Equity",
            "security_type": "Common Stock",
            "stock_exchange": "SHE",
            "last_crsp_adj_date": null
        },
        {
            "ticker": "000002",
            "figi_ticker": "000002:CH",
            "figi": "BBG000BZ9Z48",
            "security_name": "CHINA VANKE CO LTD -A",
            "market_sector": "Equity",
            "security_type": "Common Stock",
            "stock_exchange": "SHE",
            "last_crsp_adj_date": null
        },
        ...
    ]
}

API URI: https://api.intrinio.com
GET: /securities?identifier=AA
FULL URL: https://api.intrinio.com/securities?identifier=AA

{
    "ticker": "AA",
    "figi_ticker": "AA:US",
    "figi": "BBG000B9WH86",
    "security_name": "ALCOA INC",
    "market_sector": "Equity",
    "security_type": "Common Stock",
    "stock_exchange": "NYSE",
    "last_crsp_adj_date": "2016-10-06",
    "composite_figi": "BBG000B9WH86",
    "figi_uniqueid": "EQ0010004600001000",
    "share_class_figi": "BBG001S5C3C2",
    "figi_exch_cntry": "US",
    "currency": "USD",
    "mic": "XNYS",
    "exch_symbol": "^XNYS",
    "etf": false,
    "delisted_security": false,
    "primary_listing": true
}
Function not available
Function not available

Indices

Returns indices list and information for all indices covered by Intrinio.

Endpoint

https://api.intrinio.com/indices

https://api.intrinio.com/indices?identifier={symbol}

https://api.intrinio.com/indices?query={query-string}

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /indices
FULL URL: https://api.intrinio.com/indices

{
    "result_count": 295283,
    "page_size": 250,
    "current_page": 1,
    "total_pages": 1182,
    "api_call_credits": 1,
    "data": [
        {
            "symbol": "$SPX",
            "index_name": "S&P 500 Index",
            "continent": "North America",
            "country": "United States of America"
        },
        {
            "symbol": "$SSEC",
            "index_name": "Shanghai Composite Index",
            "continent": "Asia",
            "country": "China"
        },
        ...
    ]
}

API URI: https://api.intrinio.com
GET: /indices?identifier=$SPX
FULL URL: https://api.intrinio.com/indices?identifier=$SPX

{
    "symbol": "$SPX",
    "index_name": "S&P 500 Index",
    "continent": "North America",
    "country": "United States of America",
    "index_type": "stock_market"
}
Function not available
Function not available

Securities Search/Screener

Returns security list and information all securities that match the given conditions. The API call credits required for each call is equal to the number of conditions specified.

Endpoint

https://api.intrinio.com/securities/search?conditions={conditions}

Intrinio Screener for Excel

Microsoft Office App Store

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /securities/search?conditions=open_price~gt~10.50,pricetoearnings~gt~10
FULL URL: https://api.intrinio.com/securities/search?conditions=open_price~gt~10.50,pricetoearnings~gt~10

{
    "result_count": 2523,
    "page_size": 250,
    "current_page": 1,
    "total_pages": 11,
    "api_call_credits": 2,
    "data": [
        {
            "ticker": "A",
            "open_price": 46.43,
            "pricetoearnings": "0.319834E2"
        },
        {
            "ticker": "AAC",
            "open_price": 17.84,
            "pricetoearnings": "0.891935E2"
        },
        ...
    ]
}
Function not available

The Screener API can be accessed through the Intrinio Screener for Excel
Function not available

The return values will correspond to the data tags in the conditions. Ticker will always be included.

Data Point

Returns the most recent data point for a selected identifier (ticker symbol, stock market index symbol, CIK 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.

Endpoint

https://api.intrinio.com/data_point?identifier={symbol}&item={tag}

https://api.intrinio.com/data_point?identifier={symbol1,symbol2}&item={tag1,tag2}

Excel Function

=IntrinioDataPoint(identifier, item)

Sheets Function

=IntrinioDataPoint(identifier, item)

Parameters

Limits

You may request up to 150 identifier/item combinations at a time. For example, you may request 1 identifier and 150 items, or 150 identifiers and 1 item, or 12 identifiers and 12 items (144 combinations), or anywhere in between.

Return Values

API URI: https://api.intrinio.com
GET: /data_point?identifier=AAPL&item=name
FULL URL: https://api.intrinio.com/data_point?identifier=AAPL&item=name

{
  "identifier": "AAPL",
  "item": "name",
  "value": "Apple Inc."
}

API URI: https://api.intrinio.com
GET: /data_point?identifier=0000320193&item=ticker
FULL URL: https://api.intrinio.com/data_point?identifier=0000320193&item=ticker

{
  "identifier": "0000320193",
  "item": "ticker",  
  "value": "AAPL"
}

API URI: https://api.intrinio.com
GET: /data_point?identifier=AAPL&item=pricetoearnings
FULL URL: https://api.intrinio.com/data_point?identifier=AAPL&item=pricetoearnings

{
  "identifier": "AAPL",
  "item": "pricetoearnings",
  "value": 17.8763
}

API URI: https://api.intrinio.com
GET: /data_point?identifier=AAPL&item=totalrevenue
FULL URL: https://api.intrinio.com/data_point?identifier=AAPL&item=totalrevenue

{
  "identifier": "AAPL",
  "item": "totalrevenue",
  "value": 199800000000.0
}

API URI: https://api.intrinio.com
GET: /data_point?identifier=GOOGL&item=price_date,close_price,percent_change
FULL URL: https://api.intrinio.com/data_point?identifier=GOOGL&item=price_date,close_price,percent_change

NOTE: While this is a single API Call, it is considered a Dimensional Call, which counts as 3 API Calls against the subscription plan.

{
  "result_count": 3,
  "api_call_credits": 3,
  "data": [
    {
      "identifier": "GOOGL",      
      "item": "price_date",
      "value": "2015-10-30"
    },
    {
      "identifier": "GOOGL",
      "item": "close_price",
      "value": 737.39
    },
    {
      "identifier": "GOOGL",       
      "item": "percent_change",
      "value": -0.01
    }
  ]
}

API URI: https://api.intrinio.com
GET: /data_point?identifier=GOOGL,AAPL&item=price_date,close_price,percent_change
FULL URL: https://api.intrinio.com/data_point?identifier=GOOGL,AAPL&item=price_date,close_price,percent_change

NOTE: While this is a single API Call, it is considered a Dimensional Call, which counts as 6 API Calls against the subscription plan.

{
  "result_count": 6,
  "api_call_credits": 6,
  "data": [
    {
      "identifier": "GOOGL",      
      "item": "price_date",
      "value": "2015-10-30"
    },
    {
      "identifier": "GOOGL",
      "item": "close_price",
      "value": 737.39
    },
    {
      "identifier": "GOOGL",       
      "item": "percent_change",
      "value": -0.01
    }
    {
      "identifier": "AAPL",      
      "item": "price_date",
      "value": "2015-10-30"
    },
    {
      "identifier": "AAPL",
      "item": "close_price",
      "value": 119.5
    },
    {
      "identifier": "AAPL",       
      "item": "percent_change",
      "value": -0.0085
    }
  ]
}

API URI: https://api.intrinio.com
GET: /data_point?identifier=$SPX&item=close_price
FULL URL: https://api.intrinio.com/data_point?identifier=$SPX&item=close_price

{
  "identifier": "$SPX",
  "item": "close_price",
  "value": 1884.09
}
=IntrinioDataPoint("AAPL","name")

Apple Inc.

=IntrinioDataPoint("0000320193","ticker")

AAPL

=IntrinioDataPoint("AAPL","pricetoearnings")

17.8763

=IntrinioDataPoint("AAPL","totalrevenue")

199800000000.0

=IntrinioDataPoint("$GDP","value")

18,034.8

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

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

Apple Inc.

=IntrinioDataPoint("0000320193","ticker")

AAPL

=IntrinioDataPoint("AAPL","pricetoearnings")

17.8763

=IntrinioDataPoint("AAPL","totalrevenue")

199800000000.0

=IntrinioDataPoint("$GDP","value")

18,034.8

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

0.0612

Historical Data

Returns the 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 parameter. All other historical data points are returned as their value on a certain day based on filings reported as of that date.

Endpoint

https://api.intrinio.com/historical_data?identifier={symbol}&item={tag}

Excel Function

=IntrinioHistoricalData(identifier, item, sequence, start_date, end_date, frequency, type, show_date)

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /historical_data?identifier=AAPL&item=totalrevenue
FULL URL: https://api.intrinio.com/historical_data?identifier=AAPL&item=totalrevenue

{
    "identifier": "AAPL",
    "item": "totalrevenue",
    "result_count": 30,
    "page_size": 50000,
    "current_page": 1,
    "total_pages": 1,
    "api_call_credits": 1,
    "data": [
        {
            "date": "2016-06-25",
            "value": 220288000000.0
        },
        {
            "date": "2016-03-26",
            "value": 227535000000.0
        },
        ...
    ]
}

API URI: https://api.intrinio.com
GET: /historical_data?identifier=AAPL&item=totalrevenue&type=QTR
FULL URL: https://api.intrinio.com/historical_data?identifier=AAPL&item=totalrevenue&type=QTR

{
    "identifier": "AAPL",
    "item": "totalrevenue",
    "result_count": 32,
    "page_size": 50000,
    "current_page": 1,
    "total_pages": 1,
    "api_call_credits": 1,
    "data": [
        {
            "date": "2016-06-25",
            "value": 42358000000.0
        },
        {
            "date": "2016-03-26",
            "value": 50557000000.0
        },
        ...
    ]
}

API URI: https://api.intrinio.com
GET: /historical_data?identifier=AAPL&item=pricetoearnings&start_date=2014-01-01&end_date=2015-01-01
FULL URL: https://api.intrinio.com/historical_data?identifier=AAPL&item=pricetoearnings&start_date=2014-01-01&end_date=2015-01-01

{
    "identifier": "AAPL",
    "item": "pricetoearnings",
    "result_count": 252,
    "page_size": 50000,
    "current_page": 1,
    "total_pages": 1,
    "api_call_credits": 1,
    "data": [
        {
            "date": "2014-12-31",
            "value": 14.602
        },
        {
            "date": "2014-12-30",
            "value": 14.8851
        },
        ...
    ]
}

API URI: https://api.intrinio.com
GET: /historical_data?identifier=$SPX&item=close_price&start_date=2010-01-01&end_date=2010-01-30
FULL URL: https://api.intrinio.com/historical_data?identifier=$SPX&item=close_price&start_date=2010-01-01&end_date=2010-01-30

{
    "identifier": "$SPX",
    "item": "close_price",
    "result_count": 19,
    "page_size": 50000,
    "current_page": 1,
    "total_pages": 1,
    "api_call_credits": 1,
    "data": [
        {
            "date": "2010-01-29",
            "value": 1073.869995
        },
        {
            "date": "2010-01-28",
            "value": 1084.530029
        },
        ...
    ]
}

=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
Function not available

Prices

Returns professional-grade historical stock prices for a security or stock market index. New EOD prices are available at 5p.m. EST and intraday prices are updated every minute during the trading day from IEX. Historical prices are available back to 1996 or the IPO date, with some companies with data back to the 1970s. Stock market index historical price data is available back to the 1950s at the earliest. Data from Quandl, QuoteMedia and the Federal Reserve Economic Data.

Endpoint

https://api.intrinio.com/prices?identifier={symbol}

Excel Function

=IntrinioHistoricalPrices(identifier, item, sequence, start_date, end_date, frequency)

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /prices?identifier=AAPL
FULL URL: https://api.intrinio.com/prices?identifier=AAPL

{
    "result_count": 9024,
    "page_size": 50000,
    "current_page": 1,
    "total_pages": 1,
    "api_call_credits": 1,
    "data": [
        {
            "date": "2016-09-23",
            "open": 114.42,
            "high": 114.79,
            "low": 111.55,
            "close": 112.71,
            "volume": 52481151.0,
            "ex_dividend": 0.0,
            "split_ratio": 1.0,
            "adj_open": 114.42,
            "adj_high": 114.79,
            "adj_low": 111.55,
            "adj_close": 112.71,
            "adj_volume": 52481151.0
        },
        {
            "date": "2016-09-22",
            "open": 114.35,
            "high": 114.94,
            "low": 114.0,
            "close": 114.62,
            "volume": 31073984.0,
            "ex_dividend": 0.0,
            "split_ratio": 1.0,
            "adj_open": 114.35,
            "adj_high": 114.94,
            "adj_low": 114.0,
            "adj_close": 114.62,
            "adj_volume": 31073984.0
        }
        ...
    ]
}
=IntrinioHistoricalPrices("AAPL","open",0)

107.39

=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")

107.57
Function not available

Exchange Prices

Returns professional-grade historical stock prices for all securities traded on a stock exchange for a single specified day. Historical prices are available back to 1996 or the IPO date, with some companies with data back to the 1970s.

Endpoint

https://api.intrinio.com/prices/exchange?identifier={stock-exchange-symbol}&price_date{YYYY-MM-DD}

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /prices/exchange?identifier=^XNAS&price_date=2016-12-05
FULL URL: https://api.intrinio.com/prices/exchange?identifier=^XNAS&price_date=2016-12-05

{
    "result_count": 3043,
    "page_size": 250,
    "current_page": 1,
    "total_pages": 13,
    "api_call_credits": 1,
    "data": [
        {
            "ticker": "AAAP",
            "figi_ticker": "AAAP:US",
            "figi": "BBG007K5CTL0",
            "date": "2016-12-05",
            "open": 29.6,
            "high": 30.21,
            "low": 29.4,
            "close": 29.5,
            "volume": 100519.0,
            "ex_dividend": 0.0,
            "split_ratio": 1.0,
            "adj_open": 29.6,
            "adj_high": 30.21,
            "adj_low": 29.4,
            "adj_close": 29.5,
            "adj_volume": 100519.0
        },
        {
            "ticker": "AAL",
            "figi_ticker": "AAL:US",
            "figi": "BBG005P7Q881",
            "date": "2016-12-05",
            "open": 46.45,
            "high": 46.5401,
            "low": 45.58,
            "close": 45.72,
            "volume": 5199774.0,
            "ex_dividend": 0.0,
            "split_ratio": 1.0,
            "adj_open": 46.45,
            "adj_high": 46.5401,
            "adj_low": 45.58,
            "adj_close": 45.72,
            "adj_volume": 5199774.0
        },
        ...
    ]
}
Function not available
Function not available

Company SEC Filings

Returns the complete list of SEC filings for a company.

Endpoint

https://api.intrinio.com/companies/filings?identifier={symbol}

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /companies/filings?identifier=AAPL
FULL URL: https://api.intrinio.com/companies/filings?identifier=AAPL

{
    "result_count": 1015,
    "page_size": 250,
    "current_page": 1,
    "total_pages": 5,
    "api_call_credits": 1,
    "data": [
        {
            "filing_date": "2016-09-23",
            "accepted_date": "2016-09-23 18:33:57 +0000",
            "period_ended": "2016-09-21",
            "accno": "0001628280-16-019756",
            "report_type": "4",
            "filing_url": "https://www.sec.gov/Archives/edgar/data/320193/000162828016019756/0001628280-16-019756-index.htm",
            "report_url": "https://www.sec.gov/Archives/edgar/data/320193/000162828016019756/xslF345X03/wf-form4_147467002403491.xml",
            "instance_url": null
        },
        {
            "filing_date": "2016-09-23",
            "accepted_date": "2016-09-23 18:35:58 +0000",
            "period_ended": "2016-09-21",
            "accno": "0001628280-16-019757",
            "report_type": "4",
            "filing_url": "https://www.sec.gov/Archives/edgar/data/320193/000162828016019757/0001628280-16-019757-index.htm",
            "report_url": "https://www.sec.gov/Archives/edgar/data/320193/000162828016019757/xslF345X03/wf-form4_147467014510458.xml",
            "instance_url": null
        },
        ...
    ]
}
Function not available
Function not available

Company News

Returns the most recent news stories for a company.

Endpoint

https://api.intrinio.com/news

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /news?identifier=AAPL
FULL URL: https://api.intrinio.com/news?identifier=AAPL

{
    "result_count": 250,
    "page_size": 250,
    "current_page": 1,
    "total_pages": 14,
    "api_call_credits": 1,
    "data": [
        {
            "title": "[$$] How will Twitter's suitors reap its value?",
            "publication_date": "2016-09-25 12:12:33 +0000",
            "url": "http://www.ft.com/cms/s/8d81a6da-82e6-11e6-8897-2359a58ac7a5,s01=1.html?ftcamp=traffic/partner/feed_headline/us_yahoo/auddev",
            "summary": "[at Financial Times] - Twitter may finally be running out of time. News at the end of last week that Google and cloud software company Salesforce have both held preliminary discussions about a possible acquisition have underlined ..."
        },
        {
            "title": "If Apple built a car, here are the companies it would probably work with",
            "publication_date": "2016-09-25 12:00:00 +0000",
            "url": "http://finance.yahoo.com/news/apple-built-car-companies-probably-120000342.html",
            "summary": "If Apple built a car, here are the companies it would probably work with"
        },
        ...
    ]
}
Function not available
Function not available

Standardized Fundamentals

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.

Endpoint

https://api.intrinio.com/fundamentals/standardized?identifier={symbol}&statement={statement}

Excel Function

=IntrinioFundamentals(identifier, statement, type, sequence, item)

Sheets Function

=IntrinioFundamentals(identifier, statement, type, sequence, item)

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /fundamentals/standardized?identifier=AAPL&statement=income_statement&type=FY
FULL URL: https://api.intrinio.com/fundamentals/standardized?identifier=AAPL&statement=income_statement&type=FY

{
    "result_count": 9,
    "page_size": 250,
    "current_page": 1,
    "total_pages": 1,
    "api_call_credits": 1,
    "data": [
        {
          "fiscal_year": 2015,
          "end_date": "2015-09-26",
          "start_date": "2014-09-28",
          "fiscal_period": "FY",
          "filing_date": "2015-10-28 16:31:09 +0000"
        },
        {
          "fiscal_year": 2014,
          "end_date": "2014-09-27",
          "start_date": "2013-09-29",
          "fiscal_period": "FY",
          "filing_date": "2015-10-28 16:31:09 +0000"
        },
        ...
    ]
}
=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
=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

Standardized Tags and Labels

Returns the As Reported XBRL tags and labels for a given ticker, statement, and date or fiscal year/fiscal quarter.

Endpoint

https://api.intrinio.com/tags/standardized?identifier={symbol}&statement={statement}

Excel Function

=IntrinioTags(identifier, statement, sequence, item)

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

Return Values

API URI: https://api.intrinio.com
GET: /tags/standardized?identifier=AAPL&statement=income_statement
FULL URL: https://api.intrinio.com/tags/standardized?identifier=AAPL&statement=income_statement

{
    "result_count": 43,
    "page_size": 5000,
    "current_page": 1,
    "total_pages": 1,
    "api_call_credits": 1,
    "data": [
        {
            "name": "Operating Revenue",
            "tag": "operatingrevenue",
            "parent": "totalrevenue",
            "factor": "+",
            "balance": "credit",
            "type": "operating",
            "units": "usd"
        },
        {
            "name": "Other Revenue",
            "tag": "otherrevenue",
            "parent": "totalrevenue",
            "factor": "+",
            "balance": "credit",
            "type": "operating",
            "units": "usd"
        },
        ...
    ]
}
=IntrinioTags("AAPL","income_statement",0,"tag")

operatingrevenue

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

Short-Term Investments
Function not available

Standardized Financials

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.

Endpoint

https://api.intrinio.com/financials/standardized?identifier={symbol}&statement={statement}&fiscal_year={fiscal_year}&fiscal_period={fiscal_period}

Excel Function

=IntrinioFinancials(identifier, statement, fiscal_year, fiscal_period, tag, rounding)

OR

=IntrinioFinancials(identifier, statement, sequence, type, tag, rounding)

Sheets Function

=IntrinioFinancials(identifier, statement, fiscal_year, fiscal_period, tag, rounding)

OR

=IntrinioFinancials(identifier, statement, sequence, type, tag, rounding)

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /financials/standardized?identifier=AAPL&statement=income_statement&fiscal_year=2015&fiscal_period=FY
FULL URL: https://api.intrinio.com/financials/standardized?identifier=AAPL&statement=income_statement&fiscal_year=2015&fiscal_period=FY

{
    "result_count": 23,
    "page_size": 5000,
    "current_page": 1,
    "total_pages": 1,
    "api_call_credits": 1,
    "data": [
        {
            "tag": "operatingrevenue",
            "value": 233715000000.0
        },
        {
            "tag": "totalrevenue",
            "value": 233715000000.0
        },
        ...
    ]
}
=IntrinioFinancials("AAPL","income_statement",2015,"FY","operatingrevenue","A")

233,715,000,000

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

123.328

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

37,037

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

233,715,000,000

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

123.328

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

37,037

As Reported Fundamentals

Returns a list of available as reported fundamentals (fiscal year, fiscal period, start date, and end date) 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.

Endpoint

https://api.intrinio.com/fundamentals/reported?identifier={symbol}&statement={statement}

Excel Function

=IntrinioReportedFundamentals(identifier, statement, type, sequence, item)

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /fundamentals/reported?identifier=AAPL&statement=income_statement&type=FY
FULL URL: https://api.intrinio.com/fundamentals/reported?identifier=AAPL&statement=income_statement&type=FY

{
    "result_count": 9,
    "page_size": 250,
    "current_page": 1,
    "total_pages": 1,
    "api_call_credits": 1,
    "data": [
        {
            "fiscal_year": 2015,
            "end_date": "2015-09-26",
            "start_date": "2014-09-28",
            "fiscal_period": "FY",
            "filing_date": "2015-10-28 16:31:09 +0000"
        },
        {
            "fiscal_year": 2014,
            "end_date": "2014-09-27",
            "start_date": "2013-09-29",
            "fiscal_period": "FY",
            "filing_date": "2015-10-28 16:31:09 +0000"
        },
        ...
    ]
}
=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
Function not available

As Reported XBRL Tags and Labels

Returns the As Reported XBRL tags and labels for a given ticker, statement, and date or fiscal year/fiscal quarter.

Endpoint

https://api.intrinio.com/tags/reported?identifier={symbol}&statement={statement}

Excel Function

=IntrinioReportedTags(identifier, statement, fiscal_year, fiscal_period, sequence, item)

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /tags/reported?identifier=AAPL&statement=income_statement&fiscal_year=2015&fiscal_period=FY
FULL URL: https://api.intrinio.com/tags/reported?identifier=AAPL&statement=income_statement&fiscal_year=2015&fiscal_period=FY

{
    "result_count": 19,
    "page_size": 5000,
    "current_page": 1,
    "total_pages": 1,
    "api_call_credits": 1,
    "data": [
        {
            "name": "Net sales",
            "tag": "SalesRevenueNet",
            "balance": "credit",
            "unit": "usd",
            "domain_tag": null,
            "abstract": false,
            "sequence": 1,
            "depth": 1,
            "factor": "+"
        },
        {
            "name": "Cost of sales",
            "tag": "CostOfGoodsAndServicesSold",
            "balance": "debit",
            "unit": "usd",
            "domain_tag": null,
            "abstract": false,
            "sequence": 2,
            "depth": 1,
            "factor": "-"
        },
        ...
    ]
}
=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
Function not available

As Reported Financials

Returns the As Reported Financials directly from the financial statements of the XBRL filings from the company.

Endpoint

https://api.intrinio.com/financials/reported?identifier={symbol}&statement={statement}&fiscal_year={fiscal_year}&fiscal_period={fiscal_period}

Excel Function

=IntrinioReportedFinancials(identifier, statement, fiscal_year, fiscal_period, xbrl_tag, domain_tag)

OR

=IntrinioReportedFinancials(identifier, statement, sequence, type, xbrl_tag, domain_tag)

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /financials/reported?identifier=AAPL&statement=income_statement&fiscal_year=2015&fiscal_period=FY
FULL URL: https://api.intrinio.com/financials/reported?identifier=AAPL&statement=income_statement&fiscal_year=2015&fiscal_period=FY

{
    "result_count": 16,
    "page_size": 5000,
    "current_page": 1,
    "total_pages": 1,
    "api_call_credits": 1,
    "data": [
        {
            "xbrl_tag": "SalesRevenueNet",
            "domain_tag": null,
            "value": 233715000000.0
        },
        {
            "xbrl_tag": "CostOfGoodsAndServicesSold",
            "domain_tag": null,
            "value": 140089000000.0
        },
        ...
    ]
}
 =IntrinioReportedFinancials("AAPL","income_statement",2015,"FY","SalesRevenueNet")

233715000000

=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

Function not available

Insider Transactions & Ownership Data Feed

Reports all insider transactions for owners and companies. Insiders must file Form 4, 5, or 6 with the SEC after any transaction. Provides transaction details for both non-derivative and derivative transactions for all owners. Ownership holdings are aggregated by both owners and by companies, with the value of the holdings as of the previous trading day.

Owners

Returns owners list and information for all insider and institutional owners of securities covered by Intrinio. Includes detailed info for a single owner and the ability to query by name.

Endpoint

https://api.intrinio.com/owners?institutional=false

https://api.intrinio.com/owners?institutional=false&query={query-string}

https://api.intrinio.com/owners?identifier={owner_cik}

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /owners?institutional=false
FULL URL: https://api.intrinio.com/owners?institutional=false

{
    "result_count": 106185,
    "page_size": 250,
    "current_page": 1,
    "total_pages": 425,
    "api_call_credits": 1,
    "data": [
        {
            "owner_cik": "0000001800",
            "owner_name": "ABBOTT LABORATORIES"
        },
        {
            "owner_cik": "0000002488",
            "owner_name": "ADVANCED MICRO DEVICES INC"
        },
        ...
    ]
}

API URI: https://api.intrinio.com
GET: /owners?query=Musk
FULL URL: https://api.intrinio.com/owners?query=Musk

{
    "result_count": 4,
    "page_size": 250,
    "current_page": 1,
    "total_pages": 1,
    "api_call_credits": 1,
    "data": [
        {
            "owner_cik": "0001310611",
            "owner_name": "Musket David B"
        },
        {
            "owner_cik": "0001494730",
            "owner_name": "Musk Elon"
        },
        {
            "owner_cik": "0001494731",
            "owner_name": "Musk Kimbal"
        },
        {
            "owner_cik": "0001626280",
            "owner_name": "Muskus Richard A Jr."
        }
    ]
}

API URI: https://api.intrinio.com
GET: /owners?identifier=0001494730
FULL URL: https://api.intrinio.com/owners?identifier=0001494730

{
    "cik_id": "0001494730",
    "name": "Musk Elon",
    "state": null,
    "state_inc": null,
    "country_inc": null,
    "business_address": null,
    "business_phone_no": null,
    "mailing_address": "C/O TESLA MOTORS, INC., 3500 DEER CREEK ROAD, PALO ALTO CA 94304",
    "institutional": false
}
Function not available
Function not available

Insider Transactions by Company

Returns a list of all insider transactions in a company. Criteria for being an insider include being a director, officer, or 10%+ owner in the company. Transactions are detailed for both non-derivative and derivative transactions by the insider.

Endpoint

https://api.intrinio.com/companies/insider_transactions?identifier={symbol}

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /companies/insider_transactions?identifier=TSLA
FULL URL: https://api.intrinio.com/companies/insider_transactions?identifier=TSLA

{
    "result_count": 1108,
    "page_size": 250,
    "current_page": 1,
    "total_pages": 5,
    "api_call_credits": 1,
    "data": [
        {
            "owner_cik": "0001650649",
            "owner_name": "FIELD JOHN DOUGLAS",
            "filing_date": "2016-09-07",
            "filing_url": "https://www.sec.gov/Archives/edgar/data/1318605/000167051216000006/xslF345X03/primary_doc.xml",
            "director": false,
            "officer": true,
            "ten_percent_owner": false,
            "other_relation": false,
            "officer_title": "VP, Engineering",
            "derivative_transaction": false,
            "security_title": "Common Stock",
            "transaction_date": "2016-09-05",
            "deemed_execution_date": null,
            "transaction_type_code": "M",
            "amount_of_shares": 563.0,
            "acquisition_disposition_code": "A",
            "transaction_price": 0.0,
            "total_shares_owned": 12055.0,
            "ownership_type_code": "D",
            "report_line_number": 1
        },
        {
            "owner_cik": "0001650649",
            "owner_name": "FIELD JOHN DOUGLAS",
            "filing_date": "2016-09-07",
            "filing_url": "https://www.sec.gov/Archives/edgar/data/1318605/000167051216000006/xslF345X03/primary_doc.xml",
            "director": false,
            "officer": true,
            "ten_percent_owner": false,
            "other_relation": false,
            "officer_title": "VP, Engineering",
            "derivative_transaction": false,
            "security_title": "Common Stock",
            "transaction_date": "2016-09-05",
            "deemed_execution_date": null,
            "transaction_type_code": "M",
            "amount_of_shares": 3593.0,
            "acquisition_disposition_code": "A",
            "transaction_price": 0.0,
            "total_shares_owned": 15648.0,
            "ownership_type_code": "D",
            "report_line_number": 2
        },
        ...
    ]
}
Function not available
Function not available

All Filings

Non-Derivative Transaction

Derivative Transaction

Insider Ownership by Company

Endpoint

https://api.intrinio.com/companies/insider_ownership?identifier={symbol}

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /companies/insider_ownership?identifier=TSLA
FULL URL: https://api.intrinio.com/companies/insider_ownership?identifier=TSLA

{
    "result_count": 21,
    "page_size": 250,
    "current_page": 1,
    "total_pages": 1,
    "api_call_credits": 1,
    "data": [
        {
            "owner_cik": "0001494730",
            "owner_name": "Musk Elon",
            "last_reported_date": "2016-05-26",
            "value": 6451844000.0,
            "amount": 31100719.0
        },
        {
            "owner_cik": "0001495013",
            "owner_name": "Kohler Herbert",
            "last_reported_date": "2012-06-25",
            "value": 2692938000.0,
            "amount": 12981144.0
        },
        ...
    ]
}
Function not available
Function not available

Insider Transactions By Owner

Returns a list of all insider transactions by an owner in as many companies as the owner may be considered an insider. Criteria for being an insider include being a director, officer, or 10%+ owner in the company. Transactions are detailed for both non-derivative and derivative transactions by the insider.

Endpoint

https://api.intrinio.com/owners/insider_transactions?cik={owner_cik}

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /owners/insider_transactions?identifier=0001494730
FULL URL: https://api.intrinio.com/owners/insider_transactions?identifier=0001494730

{
    "result_count": 94,
    "page_size": 250,
    "current_page": 1,
    "total_pages": 1,
    "api_call_credits": 1,
    "data": [
        {
            "ticker": "TSLA",
            "company_cik": "0001494730",
            "company_name": "Tesla Motors Inc",
            "filing_date": "2016-05-26",
            "filing_url": "https://www.sec.gov/Archives/edgar/data/1318605/000149473016000008/xslF345X03/edgardoc.xml",
            "director": true,
            "officer": true,
            "ten_percent_owner": true,
            "other_relation": false,
            "officer_title": "CEO",
            "derivative_transaction": false,
            "security_title": "Common Stock",
            "transaction_date": "2016-05-25",
            "deemed_execution_date": null,
            "transaction_type_code": "S",
            "amount_of_shares": 2782670.0,
            "acquisition_disposition_code": "D",
            "transaction_price": 213.22,
            "total_shares_owned": 31100644.0,
            "ownership_type_code": "I",
            "report_line_number": 1
        },
        {
            "ticker": "TSLA",
            "company_cik": "0001494730",
            "company_name": "Tesla Motors Inc",
            "filing_date": "2016-05-23",
            "filing_url": "https://www.sec.gov/Archives/edgar/data/1318605/000149473016000007/xslF345X03/edgardoc.xml",
            "director": true,
            "officer": true,
            "ten_percent_owner": true,
            "other_relation": false,
            "officer_title": "CEO",
            "derivative_transaction": false,
            "security_title": "Common Stock",
            "transaction_date": "2016-05-19",
            "deemed_execution_date": null,
            "transaction_type_code": "M",
            "amount_of_shares": 2147986.0,
            "acquisition_disposition_code": "A",
            "transaction_price": 6.63,
            "total_shares_owned": 31727328.0,
            "ownership_type_code": "I",
            "report_line_number": 1
        },
        ...
    ]
}
Function not available
Function not available

All Filings

Non-Derivative Transaction

Derivative Transaction

Insider Holdings by Owner

A list of all ownership interests and the value of their interests by a single owner. A single owner may own insider interests in a number of companies.

Endpoint

https://api.intrinio.com/owners/insider_holdings?cik={owner_cik}

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /owners/insider_holdings?cik=0001494730
FULL URL: https://api.intrinio.com/owners/insider_holdings?cik=0001494730

{
    "result_count": 2,
    "page_size": 250,
    "current_page": 1,
    "total_pages": 1,
    "api_call_credits": 1,
    "data": [
        {
            "ticker": "TSLA",
            "company_cik": "0001318605",
            "company_name": "Tesla Motors Inc",
            "last_reported_date": "2016-05-26",
            "value": 6451844000.0,
            "amount": 31100719.0
        },
        {
            "ticker": "SCTY",
            "company_cik": "0001408356",
            "company_name": "SolarCity Corp",
            "last_reported_date": "2016-02-12",
            "value": 420311000.0,
            "amount": 21845674.0
        }
    ]
}
Function not available
Function not available

Institutional Holdings Data Feed

Institutional Holdings are reported each quarter by Institutional Owners by filing Form 13-F with the SEC. Institutional Holdings in securities are represented by CUSIP number by the firm. Holdings data includes the value and number of shares, and voting control.

Owners

Returns owners list and information for all institutional owners of securities covered by Intrinio. Includes detailed info for a single owner and the ability to query by name.

Endpoint

https://api.intrinio.com/owners?institutional=true

https://api.intrinio.com/owners?institutional=true&query={query-string}

https://api.intrinio.com/owners?identifier={owner_cik}

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /owners?institutional=true
FULL URL: https://api.intrinio.com/owners?institutional=true

{
    "result_count": 10701,
    "page_size": 250,
    "current_page": 1,
    "total_pages": 43,
    "api_call_credits": 1,
    "data": [
        {
            "owner_cik": "0000002110",
            "owner_name": "COLUMBIA ACORN TRUST"
        },
        {
            "owner_cik": "0000002230",
            "owner_name": "ADAMS DIVERSIFIED EQUITY FUND, INC."
        },
        ...
    ]
}

API URI: https://api.intrinio.com
GET: /owners?query=Wisconsin
FULL URL: https://api.intrinio.com/owners?query=Wisconsin

{
    "result_count": 6,
    "page_size": 250,
    "current_page": 1,
    "total_pages": 1,
    "api_call_credits": 1,
    "data": [
        {
            "owner_cik": "0000854157",
            "owner_name": "STATE OF WISCONSIN INVESTMENT BOARD"
        },
        {
            "owner_cik": "0000887833",
            "owner_name": "WELLS FARGO BANK WISCONSIN NATIONAL ASSOCIATION"
        },
        {
            "owner_cik": "0000926833",
            "owner_name": "WISCONSIN CAPITAL MANAGEMENT LLC"
        },
        {
            "owner_cik": "0001066266",
            "owner_name": "WISCONSIN ASSET MANAGEMENT LLC"
        },
        {
            "owner_cik": "0001662497",
            "owner_name": "JBS WISCONSIN PROPERTIES, LLC"
        },
        {
            "owner_cik": "0001672728",
            "owner_name": "WISCONSIN ALUMNI RESEARCH FOUNDATION"
        }
    ]
}

API URI: https://api.intrinio.com
GET: /owners?identifier=0001494730
FULL URL: https://api.intrinio.com/owners?identifier=0000854157

{
    "owner_cik": "0000854157",
    "owner_name": "STATE OF WISCONSIN INVESTMENT BOARD"
    "state": "Wisconsin",
    "state_inc": "Wisconsin",
    "country_inc": "United States of America",
    "business_address": "121 EAST WILSON STREET, MADISON, WI 53703",
    "business_phone_no": "6082662381",
    "mailing_address": "P.O. BOX 7842, 121 EAST WILSON STREET, MADISON, WI 53707",
    "institutional": true,
}
Function not available
Function not available

Institutional Holdings by Owner

Endpoint

https://api.intrinio.com/owners/institutional_holdings?cik={owner_cik}

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /owners/institutional_holdings?cik=0000854157
FULL URL: https://api.intrinio.com/owners/institutional_holdings?cik=0000854157

{
    "result_count": 1307,
    "page_size": 250,
    "current_page": 1,
    "total_pages": 6,
    "api_call_credits": 1,
    "data": [
        {
            "cusip": "060505104",
            "ticker": "BAC",
            "security_name": "Bank of America Corporation Common Stock",
            "security_type": "Common Stock",
            "title_of_class": "COM",
            "stock_exchange": "NYSE",
            "period_ended": "2016-06-30",
            "value": 157505000.0,
            "amount": 11869261.0,
            "type": "SH",
            "investment_discretion": "SOLE",
            "other_manager": " ",
            "sole_voting_authority": 11869261.0,
            "shared_voting_authority": 0.0,
            "no_voting_authority": 0.0
        },
        {
            "cusip": "369604103",
            "ticker": "GE",
            "security_name": "General Electric Company Common Stock",
            "security_type": "Common Stock",
            "title_of_class": "COM",
            "stock_exchange": "NYSE",
            "period_ended": "2016-06-30",
            "value": 287416000.0,
            "amount": 9130107.0,
            "type": "SH",
            "investment_discretion": "SOLE",
            "other_manager": " ",
            "sole_voting_authority": 9130107.0,
            "shared_voting_authority": 0.0,
            "no_voting_authority": 0.0
        },
        ...
    ]
}
Function not available
Function not available

Institutional Owners by Security

Endpoint

https://api.intrinio.com/securities/institutional_ownership?identifier={symbol}

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /securities/institutional_ownership?identifier=AAPL
FULL URL: https://api.intrinio.com/securities/institutional_ownership?identifier=AAPL

{
    "result_count": 2332,
    "page_size": 250,
    "current_page": 1,
    "total_pages": 10,
    "api_call_credits": 1,
    "data": [
        {
            "owner_cik": "0000102909",
            "owner_name": "VANGUARD GROUP INC",
            "period_ended": "2016-06-30",
            "value": 31681440000.0,
            "amount": 331395817.0,
            "sole_voting_authority": 10414679.0,
            "shared_voting_authority": 1119643.0,
            "no_voting_authority": 319861495.0,
            "prev_amount": 329987175.0,
            "amount_chg": 1408642.0,
            "amount_pct_chg": 0.004269
        },
        {
            "owner_cik": "0000093751",
            "owner_name": "STATE STREET CORP",
            "period_ended": "2016-06-30",
            "value": 19981552000.0,
            "amount": 209011754.0,
            "sole_voting_authority": 0.0,
            "shared_voting_authority": 0.0,
            "no_voting_authority": 0.0,
            "prev_amount": 215644530.0,
            "amount_chg": -6632776.0,
            "amount_pct_chg": -0.030758
        },
        ...
    ]
}
Function not available
Function not available

Economic Data Feed

Access the massive repository of economic data from the Federal Reserve Economic Data system via the Intrinio API. Fetch the most recent data point for an index, or refine your search with historical data.

Economic Indices

Returns indices list and information for all indices covered by Intrinio.

Endpoint

https://api.intrinio.com/indices?type=economic

https://api.intrinio.com/indices?identifier={symbol}&type=economic

https://api.intrinio.com/indices?query={query-string}&type=economic

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /indices?type=economic
FULL URL: https://api.intrinio.com/indices?type=economic

{
    "result_count": 294706,
    "page_size": 250,
    "current_page": 1,
    "total_pages": 1179,
    "api_call_credits": 1,
    "data": [
        {
            "symbol": "$00XALCATM086NEST",
            "index_name": "Harmonized Index of Consumer Prices: Overall Index Excluding Alcohol and Tobacco for Austria©",
            "fred_symbol": "00XALCATM086NEST",
            "update_frequency": "monthly",
            "last_updated": "2015-12-16 16:09:25 +0000",
            "description": "The Harmonized Index of Consumer Prices category...",
            "observation_start": "1996-01-01",
            "observation_end": "2015-11-01",
            "popularity": 20,
            "seasonal_adjustment": "Not Seasonally Adjusted",
            "seasonal_adjustment_short": "NSA",
            "units": "Index 2005=100",
            "units_short": "Index 2005=100",
            "index_type": "economic"
        },
        {
            "symbol": "$00XALCBEM086NEST",
            "index_name": "Harmonized Index of Consumer Prices: Overall Index Excluding Alcohol and Tobacco for Belgium©",
            "fred_symbol": "00XALCBEM086NEST",
            "update_frequency": "monthly",
            "last_updated": "2015-12-16 16:09:26 +0000",
            "description": "The Harmonized Index of Consumer Prices category...",
            "observation_start": "1996-01-01",
            "observation_end": "2015-11-01",
            "popularity": 0,
            "seasonal_adjustment": "Not Seasonally Adjusted",
            "seasonal_adjustment_short": "NSA",
            "units": "Index 2005=100",
            "units_short": "Index 2005=100",
            "index_type": "economic"
        },
        ...
    ]
}

API URI: https://api.intrinio.com
GET: /indices?type=sic
FULL URL: https://api.intrinio.com/indices?type=economic&query=GDP

{
    "result_count": 6918,
    "page_size": 250,
    "current_page": 1,
    "total_pages": 28,
    "api_call_credits": 1,
    "data": [
        {
            "symbol": "$AFGBCAGDPGDPPT",
            "index_name": "Current Account Balance for Afghanistan",
            "fred_symbol": "AFGBCAGDPGDPPT",
            "update_frequency": "yearly",
            "last_updated": "2015-12-04 19:11:01 +0000",
            "description": null,
            "observation_start": "2004-01-01",
            "observation_end": "2015-01-01",
            "popularity": 0,
            "seasonal_adjustment": "Not Seasonally Adjusted",
            "seasonal_adjustment_short": "NSA",
            "units": "Percent of GDP",
            "units_short": "% of GDP",
            "index_type": "economic"
        },
        {
            "symbol": "$AFGDGDPGDPPT",
            "index_name": "Total External Debt for Afghanistan",
            "fred_symbol": "AFGDGDPGDPPT",
            "update_frequency": "yearly",
            "last_updated": "2015-12-04 19:11:03 +0000",
            "description": null,
            "observation_start": "2004-01-01",
            "observation_end": "2015-01-01",
            "popularity": 11,
            "seasonal_adjustment": "Not Seasonally Adjusted",
            "seasonal_adjustment_short": "NSA",
            "units": "Percent of GDP",
            "units_short": "% of GDP",
            "index_type": "economic"
        },
        ...
    ]
}

API URI: https://api.intrinio.com
GET: /indices?identifier=$GDP
FULL URL: https://api.intrinio.com/indices?identifier=$GDP

{
    "symbol": "$GDP",
    "index_name": "Gross Domestic Product",
    "fred_symbol": "GDP",
    "update_frequency": "quarterly",
    "last_updated": "2015-12-22 13:51:18 +0000",
    "description": "BEA Account Code: A191RC1  Gross domestic product (GDP), the featured measure of U.S. output, is the market value of the goods and services produced by labor and property located in the United States.    For more information, see the Guide to the National Income and Product Accounts of the United States (NIPA) - (http://www.bea.gov/national/pdf/nipaguid.pdf)",
    "observation_start": "1947-01-01",
    "observation_end": "2015-07-01",
    "popularity": 91,
    "seasonal_adjustment": "Seasonally Adjusted Annual Rate",
    "seasonal_adjustment_short": "SAAR",
    "units": "Billions of Dollars",
    "units_short": "Bil. of $",
    "index_type": "economic"
}
Function not available
Function not available

Data Point

Returns the most recent median data point for an Economic index for a selected tag. The complete list of Economic Indices can be found here. The complete list of Economic tags available through this function are available here.

Endpoint

https://api.intrinio.com/data_point?identifier={symbol}&item={tag}

https://api.intrinio.com/data_point?identifier={symbol1,symbol2}&item={tag1,tag2}

Excel Function

=IntrinioDataPoint(identifier, item)

Sheets Function

=IntrinioDataPoint(identifier, item)

Parameters

Limits

You may request up to 150 identifier/item combinations at a time. For example, you may request 1 identifier and 150 items, or 150 identifiers and 1 item, or 12 identifiers and 12 items (144 combinations), or anywhere in between.

Return Values

API URI: https://api.intrinio.com
GET: /data_point?identifier=$GDP&item=level
FULL URL: https://api.intrinio.com/data_point?identifier=$GDP&item=level

{
    "identifier": "$GDP",
    "item": "level",
    "value": 18436.5
}

API URI: https://api.intrinio.com
GET: /data_point?identifier=$GDP&item=yr_percent_change
FULL URL: https://api.intrinio.com/data_point?identifier=$GDP&item=yr_percent_change

{
    "identifier": "$GDP",
    "item": "yr_percent_change",
    "value": 0.024347
}
=IntrinioDataPoint("$GDP","level")

18,436.5

=IntrinioDataPoint("$GDP","yr_percent_change")

0.024347

=IntrinioDataPoint("$GDP","level")

18,436.5

=IntrinioDataPoint("$GDP","yr_percent_change")

0.024347

Historical Data

Returns the historical data for for an identifier for a selected tag. The complete list of tags available through this function are available here.

Endpoint

https://api.intrinio.com/historical_data?identifier={symbol}&item={tag}

Excel Function

=IntrinioHistoricalData(identifier, item, sequence, start_date, end_date, frequency, type, show_date)

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /historical_data?identifier=$GDP&item=level
FULL URL: https://api.intrinio.com/historical_data?identifier=$GDP&item=level

{
    "identifier": "$GDP",
    "item": "level",
    "result_count": 278,
    "page_size": 50000,
    "current_page": 1,
    "total_pages": 1,
    "api_call_credits": 1,
    "data": [
        {
            "date": "2016-04-01",
            "value": 18436.5
        },
        {
            "date": "2016-01-01",
            "value": 18281.6
        },
        ...
    ]
}

API URI: https://api.intrinio.com
GET: /historical_data?identifier=$GDP&item=yr_percent_change
FULL URL: https://api.intrinio.com/historical_data?identifier=$GDP&item=yr_percent_change

{
    "identifier": "$GDP",
    "item": "yr_percent_change",
    "result_count": 274,
    "page_size": 50000,
    "current_page": 1,
    "total_pages": 1,
    "api_call_credits": 1,
    "data": [
        {
            "date": "2016-04-01",
            "value": 0.024347
        },
        {
            "date": "2016-01-01",
            "value": 0.028003
        },
        ...
    ]
}

=IntrinioHistoricalData("$GDP","level",0)

18,436.5

=IntrinioHistoricalData("$GDP","level",1)

18,281.6

=IntrinioHistoricalData("$GDP","yr_percent_change",0)

0.024347

=IntrinioHistoricalData("$GDP","yr_percent_change",1)

0.028003

Function not available

U.S. Sector & Industry Data Feed

Access aggregated sector and industry metrics and statistics for over 500 SIC Codes. Fetch the most recent data point, or refine your search with historical data.

To access the SIC Indices Master via API, use the /indices?type=sic end point in the Intrinio Master Data Feed

SIC Indices

Returns indices list and information for all indices covered by Intrinio.

Endpoint

https://api.intrinio.com/indices?type=sic

https://api.intrinio.com/indices?identifier={symbol}&type=sic

https://api.intrinio.com/indices?query={query-string}&type=sic

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /indices?type=sic
FULL URL: https://api.intrinio.com/indices?type=sic

{
    "result_count": 565,
    "page_size": 250,
    "current_page": 1,
    "total_pages": 3,
    "api_call_credits": 1,
    "data": [
        {
            "symbol": "$SIC.1",
            "index_name": "Agriculture, Forestry, And Fishing",
            "continent": "North America",
            "country": "United States",
            "index_type": "sic"
        },
        {
            "symbol": "$SIC.10",
            "index_name": "Mining",
            "continent": "North America",
            "country": "United States",
            "index_type": "sic"
        },
        ...
    ]
}

API URI: https://api.intrinio.com
GET: /indices?type=sic
FULL URL: https://api.intrinio.com/indices?type=sic&query=mining

{
    "result_count": 5,
    "page_size": 250,
    "current_page": 1,
    "total_pages": 1,
    "api_call_credits": 1,
    "data": [
        {
            "symbol": "$SIC.10",
            "index_name": "Mining",
            "continent": "North America",
            "country": "United States",
            "index_type": "sic"
        },
        {
            "symbol": "$SIC.1000",
            "index_name": "METAL MINING",
            "continent": "North America",
            "country": "United States",
            "index_type": "sic"
        },
        {
            "symbol": "$SIC.1200",
            "index_name": "COAL MINING",
            "continent": "North America",
            "country": "United States",
            "index_type": "sic"
        },
        {
            "symbol": "$SIC.1220",
            "index_name": "Bituminous Coal & Lignite Mining",
            "continent": "North America",
            "country": "United States",
            "index_type": "sic"
        },
        {
            "symbol": "$SIC.3532",
            "index_name": "Mining Machinery",
            "continent": "North America",
            "country": "United States",
            "index_type": "sic"
        }
    ]
}

API URI: https://api.intrinio.com
GET: /indices?identifier=$SIC.20
FULL URL: https://api.intrinio.com/indices?identifier=$SIC.20

{
    "symbol": "$SIC.20",
    "index_name": "Manufacturing",
    "continent": "North America",
    "country": "United States",
    "index_type": "sic"
}
Function not available
Function not available

Data Point

Returns the most recent median data point for a SIC index for a selected tag. The complete list of SIC Indices can be found here. The complete list of tags available through this function are available here. All duration period values are returned as trailing twelve months and instant period types are returned as of the most recent quarter.

Endpoint

https://api.intrinio.com/data_point?identifier={symbol}&item={tag}

https://api.intrinio.com/data_point?identifier={symbol1,symbol2}&item={tag1,tag2}

Excel Function

=IntrinioDataPoint(identifier, item)

Sheets Function

=IntrinioDataPoint(identifier, item)

Parameters

Limits

You may request up to 150 identifier/item combinations at a time. For example, you may request 1 identifier and 150 items, or 150 identifiers and 1 item, or 12 identifiers and 12 items (144 combinations), or anywhere in between.

Return Values

API URI: https://api.intrinio.com
GET: /data_point?identifier=$SIC.3500&item=name
FULL URL: https://api.intrinio.com/data_point?identifier=$SIC.3500&item=totalrevenue

{
    "identifier": "$SIC.3500",
    "item": "totalrevenue",
    "value": 637274000.0
}

API URI: https://api.intrinio.com
GET: /data_point?identifier=$SIC.3500&item=pricetoearnings
FULL URL: https://api.intrinio.com/data_point?identifier=$SIC.3500&item=pricetoearnings

{
    "identifier": "$SIC.3500",
    "item": "pricetoearnings",
    "value": 21.6242
}
=IntrinioDataPoint("$SIC.3500","totalrevenue")

637,274,000.0

=IntrinioDataPoint("$SIC.3500","pricetoearnings")

21.6242

=IntrinioDataPoint("$SIC.3500","totalrevenue")

637,274,000.0

=IntrinioDataPoint("$SIC.3500","pricetoearnings")

21.6242

Historical Data

Returns the 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 parameter. All other historical data points are returned as their value on a certain day based on filings reported as of that date.

Endpoint

https://api.intrinio.com/historical_data?identifier={symbol}&item={tag}

Excel Function

=IntrinioHistoricalData(identifier, item, sequence, start_date, end_date, frequency, type, show_date)

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /historical_data?identifier=$SIC.3500&item=totalrevenue
FULL URL: https://api.intrinio.com/historical_data?identifier=$SIC.3500&item=totalrevenue&frequency=monthly&type=median

{
    "identifier": "$SIC.3500",
    "item": "totalrevenue",
    "result_count": 108,
    "page_size": 50000,
    "current_page": 1,
    "total_pages": 1,
    "api_call_credits": 1,
    "data": [
        {
            "date": "2016-08-31",
            "value": 637274000.0
        },
        {
            "date": "2016-07-31",
            "value": 637274000.0
        },
        ...
    ]
}

API URI: https://api.intrinio.com
GET: /historical_data?identifier=$SIC.3500&item=totalrevenue
FULL URL: https://api.intrinio.com/historical_data?identifier=$SIC.3500&item=pricetoearnings&frequency=yearly&type=25thpctl

{
    "identifier": "$SIC.3500",
    "item": "pricetoearnings",
    "result_count": 9,
    "page_size": 50000,
    "current_page": 1,
    "total_pages": 1,
    "api_call_credits": 1,
    "data": [
        {
            "date": "2015-12-31",
            "value": 13.5348
        },
        {
            "date": "2014-12-31",
            "value": 14.83125
        },
        ...
    ]
}
=IntrinioHistoricalData("$SIC.3500","totalrevenue,1,,,"monthly","median")

637,274,000.0

=IntrinioHistoricalData("$SIC.3500","totalrevenue,1,,,"monthly","median","true")

2016-07-31

=IntrinioHistoricalData("$SIC.3500","open_price",2,,,"yearly","25thpctl")

15.884325

=IntrinioHistoricalData("$SIC.3500","open_price",2,,,"yearly","25thpctl","true")

2013-12-31

Function not available

U.S. Bank Data Feed

Banks

Returns bank list and information for all banks covered by Intrinio.

Endpoints

https://api.intrinio.com/banks

https://api.intrinio.com/banks?query={query-string}

https://api.intrinio.com/banks?rssd_id={rssd_id}

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /banks
FULL URL: https://api.intrinio.com/banks

{
    "result_count": 6049,
    "page_size": 250,
    "current_page": 1,
    "total_pages": 25,
    "api_call_credits": 1,
    "data": [
        {
            "rssd_id": 423841,
            "name": "Wenona State Bank",
            "fdic_certificate_number": 17401
        },
        {
            "rssd_id": 1897270,
            "name": "Mohave State Bank",
            "fdic_certificate_number": 33508
        },
        ...
    ]
}

API URI: https://api.intrinio.com
GET: /banks?query=C1
FULL URL: https://api.intrinio.com/banks?query=C1

{
    "result_count": 1,
    "page_size": 250,
    "current_page": 1,
    "total_pages": 1,
    "api_call_credits": 1,
    "data": [
        {
            "rssd_id": 2362074,
            "name": "C1 Bank",
            "fdic_certificate_number": 34092
        }
    ]
}

API URI: https://api.intrinio.com
GET: /banks?rssd_id=2362074
FULL URL: https://api.intrinio.com/banks?rssd_id=2362074

{
    "rssd_id": 2362074,
    "name": "C1 Bank",
    "fdic_certificate_number": 34092,
    "address": "100 5th Street South",
    "city": "Saint Petersburg",
    "state": "Florida",
    "zip_code": "33701",
    "county": "Pinellas",
    "state_and_county_no": 12103,
    "state_no": 12,
    "url": "WWW.C1BANK.COM",
    "total_branches": 35,
    "domestic_branches": 35,
    "foreign_branches": 0,
    "asset_concentration_no": 4,
    "asset_concentration": "Commercial Lending Specialization",
    "occ_charter_number": null,
    "fdic_geo_region_no": 5,
    "fdic_supervisory_region": "Atlanta",
    "fdic_supervisory_region_no": 5,
    "frb_district_no": 6,
    "frb_district": "Atlanta",
    "ots_district_no": 2,
    "ots_district": "Southeast",
    "occ_district_no": 5,
    "regulator": "FDIC",
    "state_charter": true,
    "federal_charter": false,
    "fdic_field_office": "Tampa",
    "bank_class": "NM",
    "chartering_agency": "STATE",
    "conservatorship": false,
    "interstate_branches": true,
    "s_corp": false,
    "trust_fiduciary_services": false,
    "community_bank": false,
    "cmsa_no": null,
    "cmsa": null,
    "msa_no": 8280,
    "msa": "Tampa-St. Petersburg-Clearwater, FL",
    "csa_no": null,
    "csa": null,
    "cbsa_no": 45300,
    "cbsa": "Tampa-St. Petersburg-Clearwater, FL",
    "cbsa_metro_no": 45300,
    "cbsa_metro": "Tampa-St. Petersburg-Clearwater, FL",
    "cbsa_division_no": null,
    "cbsa_division": null,
    "last_update": "2013-08-05",
    "last_structural_change": "2013-08-02",
    "established_on": "1995-11-17",
    "deposit_insurance_date": "1995-11-17",
    "active": true,
    "form31_filer": false,
    "holding_company": [
        {
            "rssd_id": 4558901,
            "name": "C1 Financial, Inc.",
            "city": "Saint Petersburg",
            "state": "FL"
        }
    ]
}
Function not available
Function not available
# Asset Concentration
1 International Specialization
2 Agricultural Specialization
3 Credit-card Specialization
4 Commercial Lending Specialization
5 Mortgage Lending Specialization
6 Consumer Lending SpecializationI
7 Other Specialized < $1 Billion
8 All Other < $1 Billion
9 All Other > $1 Billion
# FRB District
01 Boston
02 New York
03 Philadelphia
04 Cleveland
05 Richmond
06 Atlanta
07 Chicago
08 St. Louis
09 Minneapolis
10 Kansas city
11 Dallas
12 San Francisco
CODE BANK CLASS
N commercial bank, national (federal) charter and Fed member, supervised by the Office of the Comptroller of the Currency (OCC)
SM commercial bank, state charter and Fed member, supervised by the Federal Reserve (FRB)
NM commercial bank, state charter and Fed nonmember, supervised by the FDIC SB
SA savings associations, state or federal charter, supervised by the Office of Thrift Supervision (OTS)
OI insured U.S. branch of a foreign chartered institution (IBA)

Bank Holding Company Node

Bank Holding Companies

Returns bank holding company list and information for all bank holding companies covered by Intrinio.

Endpoints

https://api.intrinio.com/banks/holding_companies

https://api.intrinio.com/banks/holding_companies?query={query-string}

https://api.intrinio.com/banks/holding_companies?rssd_id={rssd_id}

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /banks/holding_companies
FULL URL: https://api.intrinio.com/banks/holding_companies

{
    "result_count": 8179,
    "page_size": 250,
    "current_page": 1,
    "total_pages": 33,
    "api_call_credits": 1,
    "data": [
        {
            "rssd_id": 1139523,
            "name": "First Sandoval Bancorp, Inc."
        },
        {
            "rssd_id": 1099421,
            "name": "First Bancorp Of Sparta, Ltd."
        },
        ...
    ]
}

API URI: https://api.intrinio.com
GET: /banks/holding_companies?query=Morgan
FULL URL: https://api.intrinio.com/banks/holding_companies?query=Morgan

{
    "result_count": 16,
    "page_size": 250,
    "current_page": 1,
    "total_pages": 1,
    "api_call_credits": 1,
    "data": [
        {
            "rssd_id": 1832132,
            "name": "J.P. MORGAN EQUITY HOLDINGS, INC."
        },
        {
            "rssd_id": 3917873,
            "name": "Scott Morgan Bancorp, Inc."
        },
        ...
    ]
}

API URI: https://api.intrinio.com
GET: /banks/holding_companies?rssd_id=1039502
FULL URL: https://api.intrinio.com/banks/holding_companies?rssd_id=1039502

{

    "rssd_id": 1039502,
    "name": "Jpmorgan Chase & Co.",
    "city": "New York",
    "state": "NY",
    "banks": [
        {
            "rssd_id": 852218,
            "name": "JPMorgan Chase Bank, National Association",
            "fdic_certificate_number": 628,
            "address": "1111 Polaris Parkway",
            "city": "Columbus",
            "state": "Ohio",
            "zip_code": "43240",
            "county": "Delaware",
            "state_and_county_no": 39041,
            "state_no": 39,
            "url": "http://www.jpmorganchase.com",
            "total_branches": 5446,
            "domestic_branches": 5544,
            "foreign_branches": 197,
            "asset_concentration_no": 1,
            "asset_concentration": "International Specialization",
            "occ_charter_number": 8,
            "fdic_geo_region_no": 9,
            "fdic_supervisory_region": "Chicago",
            "fdic_supervisory_region_no": 16,
            "frb_district_no": 4,
            "frb_district": "Washington",
            "ots_district_no": 3,
            "ots_district": "Central",
            "occ_district_no": 3,
            "regulator": "OCC",
            "state_charter": false,
            "federal_charter": true,
            "fdic_field_office": "Columbus",
            "bank_class": "N",
            "chartering_agency": "OCC",
            "conservatorship": false,
            "interstate_branches": true,
            "s_corp": false,
            "trust_fiduciary_services": true,
            "community_bank": false,
            "cmsa_no": null,
            "cmsa": null,
            "msa_no": 1840,
            "msa": "Columbus, OH",
            "csa_no": 198,
            "csa": "Columbus-Marion-Zanesville, OH",
            "cbsa_no": 18140,
            "cbsa": "Columbus, OH",
            "cbsa_metro_no": 18140,
            "cbsa_metro": "Columbus, OH",
            "cbsa_division_no": null,
            "cbsa_division": null,
            "last_update": "2015-09-24",
            "last_structural_change": "2015-08-31",
            "established_on": "1824-01-01",
            "deposit_insurance_date": "1934-01-01",
            "active": true,
            "form31_filer": true
        }
    ]
}
Function not available
Function not available

Bank Branches

Returns bank branch list and information for all bank branches covered by Intrinio.

Endpoints

https://api.intrinio.com/banks/branches

https://api.intrinio.com/banks/branches?rssd_id={rssd_id}

https://api.intrinio.com/banks/branches?uninumber={uninumber}

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /banks/branches
FULL URL: https://api.intrinio.com/banks/branches

{
    "result_count": 250,
    "page_size": 250,
    "current_page": 1,
    "total_pages": 374,
    "api_call_credits": 1,
    "data": [
        {
            "uninumber": 1,
            "branch_number": 7636,
            "branch_name": "Southington Main Branch",
            "rssd_id": 480228,
            "bank_name": "Bank of America, National Association"
        },
        {
            "uninumber": 3,
            "branch_number": 8203,
            "branch_name": "Portland - One City Center Branch",
            "rssd_id": 480228,
            "bank_name": "Bank of America, National Association"
        },
        ...
    ]
}

API URI: https://api.intrinio.com
GET: /banks/branches?rssd_id=2362074
FULL URL: https://api.intrinio.com/banks/branches?rssd_id=2362074

{
    "result_count": 32,
    "page_size": 250,
    "current_page": 1,
    "total_pages": 1,
    "api_call_credits": 1,
    "data": [
        {
            "uninumber": 45104,
            "branch_number": 8,
            "branch_name": "Pinellas Park Branch",
            "rssd_id": 2362074,
            "bank_name": "C1 Bank"
        },
        {
            "uninumber": 56232,
            "branch_number": 0,
            "branch_name": "C1 Bank",
            "rssd_id": 2362074,
            "bank_name": "C1 Bank"
        },
        ...
    ]
}

API URI: https://api.intrinio.com
GET: /banks/branches?uninumber=56232
FULL URL: https://api.intrinio.com/banks/branches?uninumber=56232

{
    "rssd_id": 2362074,
    "bank_name": "C1 Bank"
    "uninumber": 56232,
    "branch_number": 0,
    "branch_name": "C1 Bank",
    "address": "100 5th Street South",
    "city": "Saint Petersburg",
    "state": "FL",
    "zip_code": "33701",
    "county": "Pinellas",
    "country": "United States",
    "central_city": "Saint Petersburg",
    "latitude": 27.770275932,
    "longitude": -82.64009368,
    "location_quality": "M",
    "location_method": "100.0",
    "state_and_county_no": 103,
    "state_no": 12,
    "place_num": 93042,
    "branch_service_type": 11,
    "main_office": true,
    "msa_no": 45300,
    "msa": "Tampa-St. Petersburg-Clearwater, FL",
    "csa_no": null,
    "csa": null,
    "cbsa_division_no": null,
    "cbsa_division": null,
    "established_on": "1995-11-17",
    "acquired_on": null,
    "deposits": [
        {
            "reported_date": "2015-06-30",
            "year": 2015,
            "total_deposits": 390047000.0
        },
        {
            "reported_date": "2014-06-30",
            "year": 2014,
            "total_deposits": 336016000.0
        },
        {
            "reported_date": "2013-06-30",
            "year": 2013,
            "total_deposits": 262213000.0
        },
        ...
    ]
}
Function not available
Function not available
CODE BRANCH SERVICE TYPE
11 Full Service, brick and mortar office
12 Full Service, retail office
13 Full Service, cyber office
21 Limited Service, administrative office
22 Limited Service, military facility
23 Limited Service, drive-through facility
24 Limited Service, loan production office
25 Limited Service, consumer credit office
26 Limited Service, contractual office
27 Limited Service, messenger office
28 Limited Service, retail office
29 Limited Service, mobile/seasonal office
30 Limited Service, trust office”

Deposits History Node

Failed Banks

Returns failed bank list and information for all failed banks covered by Intrinio.

Endpoints

https://api.intrinio.com/banks/failed

https://api.intrinio.com/banks/failed?query={query-string}

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /banks/failed
FULL URL: https://api.intrinio.com/banks/failed

{
    "result_count": 3554,
    "page_size": 250,
    "current_page": 1,
    "total_pages": 15,
    "api_call_credits": 1,
    "data": [
        {
            "fin_id": 1967,
            "name": "The Jefferson Guaranty Bank",
            "city": "Metairie",
            "state": "Louisiana",
            "effective_date": "1988-01-13",
            "insurance_fund": "FDIC",
            "transaction_type": "A/A ",
            "charter_class": "NM ",
            "failed_or_assistance": "ASSISTANCE",
            "total_deposits": 274423000.0,
            "total_assets": 292381000.0,
            "estimated_fdic_loss": 57525000.0
        },
        {
            "fin_id": 10377,
            "name": "High Trust Bank",
            "city": "Stockbridge",
            "state": "Georgia",
            "effective_date": "2011-07-15",
            "insurance_fund": "DIF",
            "transaction_type": "PA ",
            "charter_class": "NM ",
            "failed_or_assistance": "FAILURE",
            "total_deposits": 177221000.0,
            "total_assets": 180340000.0,
            "estimated_fdic_loss": 73127000.0
        },
        ...
    ]
}

Function not available
Function not available
CODE CHARTER CLASS
N National chartered commercial bank supervised by the Office of the Comptroller of the Currency
SM State charter Fed member commercial bank supervised by the Federal Reserve
NM State charter Fed nonmember commercial bank supervised by the FDIC
SA State or federal charter savings association supervised by the Office of Thrift Supervision or Office of the Comptroller of the Currency
SB State charter savings bank supervised by the FDIC

Data Point

Returns the most recent data point for a selected identifier (ticker symbol or RSSD ID) for a selected tag. The complete list of tags available through the Bank Data Feed using this function are available here. All duration period values are returned as trailing twelve months and instant period types are returned as of the most recent quarter.

Endpoint

https://api.intrinio.com/data_point?identifier={symbol/rssd}&item={tag}

https://api.intrinio.com/data_point?identifier={symbol1/rssd,symbol2/rssd}&item={tag1,tag2}

Excel Function

=IntrinioDataPoint(identifier, item)

Sheets Function

=IntrinioDataPoint(identifier, item)

Parameters

Limits

You may request up to 150 identifier/item combinations at a time. For example, you may request 1 identifier and 150 items, or 150 identifiers and 1 item, or 12 identifiers and 12 items (144 combinations), or anywhere in between.

Return Values

API URI: https://api.intrinio.com
GET: /data_point?identifier=C&item=bank_name
FULL URL: https://api.intrinio.com/data_point?identifier=C&item=bank_name

{
    "identifier": "C",
    "item": "bank_name",
    "value": "Citibank, National Association"
}

API URI: https://api.intrinio.com
GET: /data_point?identifier=852218&item=bank_name
FULL URL: https://api.intrinio.com/data_point?identifier=852218&item=bank_name

{
    "identifier": "2362074",
    "item": "bank_name",
    "value": "C1 Bank"
}

API URI: https://api.intrinio.com
GET: /data_point?identifier=852218&item=total_branches
FULL URL: https://api.intrinio.com/data_point?identifier=852218&item=total_branches

{
    "identifier": "2362074",
    "item": "total_branches",
    "value": 35
}

API URI: https://api.intrinio.com
GET: /data_point?identifier=2362074&item=RIAD4435
FULL URL: https://api.intrinio.com/data_point?identifier=2362074&item=RIAD4435

{
    "identifier": "2362074",
    "item": "RIAD4435",
    "value": 13423000.0
}

API URI: https://api.intrinio.com
GET: /data_point?identifier=2362074&item=RCON0081
FULL URL: https://api.intrinio.com

{
    "identifier": "2362074",
    "item": "RCON0081",
    "value": 16633000.0
}
=IntrinioDataPoint("C","bank_name")

Citibank, National Association

=IntrinioDataPoint(2362074,"bank_name")

C1 Bank

=IntrinioDataPoint(2362074,"total_branches")

35

=IntrinioDataPoint(2362074,"RIAD4435")

13423000.0

=IntrinioDataPoint(2362074,"RCON0081")

16633000.0
=IntrinioDataPoint("C","bank_name")

Citibank, National Association

=IntrinioDataPoint(2362074,"bank_name")

C1 Bank

=IntrinioDataPoint(2362074,"total_branches")

35

=IntrinioDataPoint(2362074,"RIAD4435")

13423000.0

=IntrinioDataPoint(2362074,"RCON0081")

16633000.0

Historical Data

Returns the 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 parameter. All other historical data points are returned as their value on a certain day based on filings reported as of that date.

Endpoint

https://api.intrinio.com/historical_data?identifier={symbol}&item={tag}

Excel Function

=IntrinioHistoricalData(identifier, item, sequence, start_date, end_date, frequency, type, show_date)

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /historical_data?identifier=2362074&item=RIAD4435
FULL URL: https://api.intrinio.com/historical_data?identifier=2362074&item=RIAD4435

{
    "identifier": "2362074",
    "item": "RIAD4435",
    "result_count": 34,
    "page_size": 50000,
    "current_page": 1,
    "total_pages": 1,
    "api_call_credits": 1,
    "data": [
        {
            "date": "2016-06-30",
            "value": 7096000.0
        },
        {
            "date": "2016-03-31",
            "value": 3417000.0
        },
        ...
    ]
}

API URI: https://api.intrinio.com
GET: /historical_data?identifier=2362074&item=RCON0081
FULL URL: https://api.intrinio.com/historical_data?identifier=2362074&item=RCON0081

{
    "identifier": "2362074",
    "item": "RCON0081",
    "result_count": 49,
    "page_size": 50000,
    "current_page": 1,
    "total_pages": 1,
    "api_call_credits": 1,
    "data": [
        {
            "date": "2016-06-30",
            "value": 16633000.0
        },
        {
            "date": "2016-03-31",
            "value": 16332000.0
        },
        ...
    ]
}
=IntrinioHistoricalData("2362074","RIAD4435",0)

7096000.0

=IntrinioHistoricalData("AAPL","RCON0081",1)

16332000.0

Function not available

Bank Fundamentals

Returns a list of available bank fundamentals (fiscal year, fiscal period, start date, and end date) for a given ticker/rssd_id and statement. Statements are from the bank call reports, UBPR reports, and Y-9C reports filed with the FDIC & Federal Reserve. Also, you may add a date and type parameter to specify the fundamentals you wish to be returned in the response.

Endpoint

https://api.intrinio.com/fundamentals/banks?identifier={symbol}&statement={statement}

Excel Function

=IntrinioBankFundamentals(identifier, statement, type, sequence, item)

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /fundamentals/banks?identifier=2362074&statement=RI&type=FY
FULL URL: https://api.intrinio.com/fundamentals/banks?identifier=2362074&statement=RI&type=FY

{
    "result_count": 12,
    "page_size": 250,
    "current_page": 1,
    "total_pages": 1,
    "api_call_credits": 1,
    "data": [
        {
            "statement_code": "RI",
            "end_date": "2015-12-31",
            "start_date": "2015-01-01",
            "months": 12,
            "fiscal_year": 2015,
            "fiscal_period": "FY",
            "report": "call_report"
        },
        {
            "statement_code": "RI",
            "end_date": "2014-12-31",
            "start_date": "2014-01-01",
            "months": 12,
            "fiscal_year": 2014,
            "fiscal_period": "FY",
            "report": "call_report"
        },
        ...
    ]
}
=IntrinioBankFundamentals(2362074,"RI","FY",0,"fiscal_year")

2015

=IntrinioBankFundamentals(2362074,"RI","FY",0,"report")

"call_report"

=IntrinioBankFundamentals(2362074,"RI","FY",1,"fiscal_period")

FY

=IntrinioBankFundamentals(2362074,"RI","FY",1,"end_date")

2014-12-31

Function not available

Bank XBRL Tags and Labels

Returns the Bank XBRL tags and labels for a given ticker/RSSD ID, statement, and date or fiscal year/fiscal quarter.

Endpoint

https://api.intrinio.com/tags/banks?identifier={symbol}&statement={statement}

Excel Function

=IntrinioBankTags(identifier, statement, sequence, item)

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /tags/banks?identifier=2362074&statement=RI&fiscal_year=2015&fiscal_period=FY
FULL URL: https://api.intrinio.com/tags/banks?identifier=2362074&statement=RI&fiscal_year=2015&fiscal_period=FY

{
    "result_count": 89,
    "page_size": 5000,
    "current_page": 1,
    "total_pages": 1,
    "api_call_credits": 1,
    "data": [
        {
            "name": "Schedule RI - Income Statement",
            "tag": "RI",
            "unit": "String",
            "sequence": 1,
            "depth": 1,
            "abstract": true
        },
        {
            "name": "Savings deposits (includes MMDAs)",
            "tag": "RIAD0093",
            "unit": "Monetary",
            "sequence": 2,
            "depth": 4,
            "abstract": false
        },
        ...
    ]
}
=IntrinioBankTags(2362074,"RI",1,"name")

Savings deposits (includes MMDAs)

=IntrinioBankTags(2362074,"RI",1,"tag")

RIAD0093
Function not available

Bank Financials

Returns the Bank Financials directly from the financial statements of the call report, UBPR report, and Y-9C XBRL filings from the bank issued with the FDIC.

Endpoint

https://api.intrinio.com/financials/banks?identifier={symbol}&statement={statement}&fiscal_year={fiscal_year}&fiscal_period={fiscal_period}

Excel Function

=IntrinioBankFinancials(identifier, statement, fiscal_year, fiscal_period, tag, rounding)

OR

=IntrinioBankFinancials(identifier, statement, sequence, type, tag, rounding)

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /financials/banks?identifier=2362074&statement=RI&fiscal_year=2015&fiscal_period=FY
FULL URL: https://api.intrinio.com/financials/banks?identifier=2362074&statement=RI&fiscal_year=2015&fiscal_period=FY

{
    "result_count": 76,
    "page_size": 5000,
    "current_page": 1,
    "total_pages": 1,
    "api_call_credits": 1,
    "data": [
        {
            "tag": "RIADA518",
            "value": 1503000.0
        },
        {
            "tag": "RIAD4056",
            "value": 0.0
        },
        ...
    ]
}
 =IntrinioBankFinancials(2362074,"RI",2015,"FY","RIAD0093")

2,006,000

=IntrinioBankFinancials(2362074,"RI",0,"FY","RIAD4107")

77,739,000

Function not available

IEX Real-Time Price Data Feed

Overview

The Intrinio IEX Real-Time Price Feed uses the WebSockets protocol to push out prices to clients in real time. For more information on WebSockets, visit:

https://developer.mozilla.org/en-US/docs/Web/API/WebSockets_API

Upon connection, the system will send you the last recorded bid/ask/last quotes, even during off-hours. So you will notice that the first quote update will come through immediately upon connection, and it will have an older timestamp. All quotes afterwards are live updates.

Important: You will need to send a heartbeat message every 30 seconds in order to stay connected: { "topic": "phoenix", "event": "heartbeat", "payload": {}, "ref": null }

NodeJS SDK

Use the official Intrinio NodeJS SDK for IEX here: https://github.com/intrinio/intrinio-realtime-node-sdk

'use strict';
var IntrinioRealtime = require('intrinio-realtime')

// Create an IntrinioRealtime instance
var ir = new IntrinioRealtime({
  username: "INTRINIO_API_USERNAME",
  password: "INTRINIO_API_PASSWORD",
})

// Listen for quotes
ir.onQuote(quote => {
  var { ticker, type, price, size, timestamp } = quote
  console.log("QUOTE: ", ticker, type, price, size, timestamp)
})

// Join channels
ir.join("AAPL", "MSFT", "GE")

EDI Security Prices Data Feed

Securities

Returns security list and information for all securities covered by Intrinio. Data from EDI is mapped to the OpenFIGI security master, which ensures all data represented is for a specified security.

Endpoint

https://api.intrinio.com/securities

https://api.intrinio.com/securities?identifier={symbol}

https://api.intrinio.com/securities?query={query-string}

https://api.intrinio.com/securities?exch_symbol={stock-exchange-symbol}

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /securities?exch_symbol=^XTSE
FULL URL: https://api.intrinio.com/securities?exch_symbol=^XTSE

{
  "result_count": 3019,
  "page_size": 250,
  "current_page": 1,
  "total_pages": 13,
  "api_call_credits": 1,
  "data": [
    {
      "ticker": "ABC",
      "figi_ticker": "ABC:CN",
      "figi": "BBG000C961K5",
      "security_name": "ASIA BIO-CHEM GROUP CORP",
      "market_sector": "Equity",
      "security_type": "Common Stock",
      "stock_exchange": "TSE",
      "last_crsp_adj_date": null
    },
    {
      "ticker": "AB/H",
      "figi_ticker": "AB/H:CN",
      "figi": "BBG000BXBPV2",
      "security_name": "ASBESTOS CORP LTD",
      "market_sector": "Equity",
      "security_type": "Common Stock",
      "stock_exchange": "TSE",
      "last_crsp_adj_date": null
    },
    ...
  ]
}

API URI: https://api.intrinio.com
GET: /securities?identifier=FNV:CT
FULL URL: https://api.intrinio.com/securities?identifier=FNV:CT

{
    "ticker": "FNV",
    "figi_ticker": "FNV:CT",
    "figi": "BBG000TRN7T6",
    "security_name": "FRANCO-NEVADA CORP",
    "market_sector": "Equity",
    "security_type": "Common Stock",
    "stock_exchange": "TSE",
    "last_crsp_adj_date": null,
    "composite_figi": "BBG000TRN6Z1",
    "figi_uniqueid": "EQ0000000004963575",
    "share_class_figi": "BBG001STGSR5",
    "figi_exch_cntry": "CT",
    "currency": "CAD",
    "mic": "XTSE",
    "exch_symbol": "^XTSE",
    "etf": false,
    "delisted_security": false,
    "primary_listing": true
}
Function not available
Function not available

Stock Exchange Master

Returns stock exchange list and information for all stock exchanges covered by Intrinio.

Endpoint

https://api.intrinio.com/stock_exchanges

https://api.intrinio.com/stock_exchanges?query={query-string}

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /stock_exchanges
FULL URL: https://api.intrinio.com/stock_exchanges

{
    "result_count": 29,
    "page_size": 250,
    "current_page": 1,
    "total_pages": 1,
    "api_call_credits": 1,
    "data": [
        {
            "symbol": "^BMEX",
            "mic": "BMEX",
            "institution_name": "BME - BOLSAS Y MERCADOS ESPANOLES",
            "acronym": "BME",
            "city": "MADRID",
            "country": "SPAIN",
            "country_code": "ES",
            "website": "HTTP://WWW.BOLSASYMERCADOS.ES"
        },
        {
            "symbol": "^BVMF",
            "mic": "BVMF",
            "institution_name": "BM&FBOVESPA S.A. - BOLSA DE VALORES, MERCADORIAS E FUTUROS",
            "acronym": null,
            "city": "SAO PAULO",
            "country": "BRAZIL",
            "country_code": "BR",
            "website": "HTTP://WWW.BMFBOVESPA.COM.BR"
        },
        ...
    ]
}
Function not available
Function not available

Data Point

Returns the most recent data point for a selected identifier (ticker symbol, FIGI, etc.) for a selected tag. The complete list of tags available through this function are available here. All data points are returned as their most recent value.

Endpoint

https://api.intrinio.com/data_point?identifier={symbol}&item={tag}

https://api.intrinio.com/data_point?identifier={symbol1,symbol2}&item={tag1,tag2}

Excel Function

=IntrinioDataPoint(identifier, item)

Sheets Function

=IntrinioDataPoint(identifier, item)

Parameters

Limits

You may request up to 150 identifier/item combinations at a time. For example, you may request 1 identifier and 150 items, or 150 identifiers and 1 item, or 12 identifiers and 12 items (144 combinations), or anywhere in between.

Return Values

API URI: https://api.intrinio.com
GET: /data_point?identifier=FNV:CT&item=close_price
FULL URL: https://api.intrinio.com/data_point?identifier=FNV:CT&item=close_price

{
  "identifier": "FNV:CT",
  "item": "close_price",
  "value": 80.28
}

API URI: https://api.intrinio.com
GET: /data_point?identifier=FNV:CT&item=price_date,close_price,open_price
FULL URL: https://api.intrinio.com/data_point?identifier=FNV:CT&item=price_date,close_price,open_price

NOTE: While this is a single API Call, it is considered a Dimensional Call, which counts as 3 API Calls against the subscription plan.

{
  "result_count": 3,
  "api_call_credits": 3,
  "data": [
    {
      "identifier": "FNV:CT",
      "item": "price_date",
      "value": "2016-12-30"
    },
    {
      "identifier": "FNV:CT",
      "item": "close_price",
      "value": 80.28
    },
    {
      "identifier": "FNV:CT",
      "item": "open_price",
      "value": 83.01
    }
  ]
}

=IntrinioDataPoint("FNV:CT","close_price")

80.28

=IntrinioDataPoint("FNV:CT","open_price")

83.01

=IntrinioDataPoint("FNV:CT","close_price")

80.28

=IntrinioDataPoint("FNV:CT","open_price")

83.01

Historical Data

Returns the historical data for for a selected identifier (ticker symbol, FIGI or other identifier) for a selected tag. The complete list of tags available through this function are available here.

Endpoint

https://api.intrinio.com/historical_data?identifier={symbol}&item={tag}

Excel Function

=IntrinioHistoricalData(identifier, item, sequence, start_date, end_date, frequency, type, show_date)

Parameters

Return Values


API URI: https://api.intrinio.com
GET: /historical_data?identifier=FNV:CT&item=close_price&start_date=2010-01-01&end_date=2010-01-30
FULL URL: https://api.intrinio.com/historical_data?identifier=FNV:CT&item=close_price&start_date=2010-01-01&end_date=2010-01-30

{
  "identifier": "FNV:CT",
  "item": "close_price",
  "result_count": 20,
  "page_size": 50000,
  "current_page": 1,
  "total_pages": 1,
  "api_call_credits": 1,
  "data": [
    {
      "date": "2010-01-29",
      "value": 27.04
    },
    {
      "date": "2010-01-28",
      "value": 28.1
    },
    ...
  ]
}

=IntrinioHistoricalData("FNV:CT","close_price",0)

80.28

Function not available

Prices

Returns historical stock prices for a security from the Exchange Data International Data Feeds. New EOD prices are available as soon as they are posted by the various exchanges. At this time we do not offer intraday pricing for the exchanges covered by EDI. Historical prices are available back to 2007 or the IPO date.

Endpoint

https://api.intrinio.com/prices?identifier={symbol}

Excel Function

=IntrinioHistoricalPrices(identifier, item, sequence, start_date, end_date, frequency)

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /prices?identifier=FNV:CT
FULL URL: https://api.intrinio.com/prices?identifier=FNV:CT

{
  "result_count": 2278,
  "page_size": 50000,
  "current_page": 1,
  "total_pages": 1,
  "api_call_credits": 1,
  "data": [
    {
      "date": "2016-12-30",
      "open": 83.01,
      "high": 84.24,
      "low": 80.22,
      "close": 80.28,
      "volume": 534318,
      "ex_dividend": 0,
      "split_ratio": 1,
      "adj_open": 83.01,
      "adj_high": 84.24,
      "adj_low": 80.22,
      "adj_close": 80.28,
      "adj_volume": 534318
    },
    {
      "date": "2016-12-29",
      "open": 81.66,
      "high": 82.97,
      "low": 81,
      "close": 82.92,
      "volume": 524929,
      "ex_dividend": 0,
      "split_ratio": 1,
      "adj_open": 81.66,
      "adj_high": 82.97,
      "adj_low": 81,
      "adj_close": 82.92,
      "adj_volume": 524929
    },
    ...
  ]
}
=IntrinioHistoricalPrices("FNV:CT","open",0)

83.01

=IntrinioHistoricalPrices("FNV:CT","date",0,"2012-01-01","2012-12-31")

2012-12-31

=IntrinioHistoricalPrices("FNV:CT","adj_close",0,"2012-01-01","2012-12-31")

56.78

Function not available

Exchange Prices

Returns historical stock prices for all securities traded on a stock exchange for a single specified day from the Exchange Data International Data Feeds. Historical prices are available back to 2007 or the IPO date.

Endpoint

https://api.intrinio.com/prices/exchange?identifier={stock-exchange-symbol}&price_date{YYYY-MM-DD}

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /prices/exchange?identifier=^XTSE&price_date=2016-12-30
FULL URL: https://api.intrinio.com/prices/exchange?identifier=^XTSE&price_date=2016-12-30

{
    "result_count": 3043,
    "page_size": 250,
    "current_page": 1,
    "total_pages": 13,
    "api_call_credits": 1,
    "data": [
        {
          "ticker": "AAB",
          "figi_ticker": "AAB:CT",
          "figi": "BBG000D2T2D0",
          "date": "2016-12-30",
          "open": 0.16,
          "high": 0.16,
          "low": 0.155,
          "close": 0.155,
          "volume": 39000,
          "ex_dividend": 0,
          "split_ratio": 1,
          "adj_open": 0.16,
          "adj_high": 0.16,
          "adj_low": 0.155,
          "adj_close": 0.155,
          "adj_volume": 39000
        },
        {
          "ticker": "AAR-U",
          "figi_ticker": "AAR-U:CT",
          "figi": "BBG000RQ99F7",
          "date": "2016-12-30",
          "open": 5.58,
          "high": 5.61,
          "low": 5.49,
          "close": 5.59,
          "volume": 453794,
          "ex_dividend": 0,
          "split_ratio": 1,
          "adj_open": 5.58,
          "adj_high": 5.61,
          "adj_low": 5.49,
          "adj_close": 5.59,
          "adj_volume": 453794
        },
        ...
    ]
}
Function not available
Function not available

EDI Corporate Actions Data Feed

Securities

Returns security list and information for all securities covered by Intrinio. Data from EDI is mapped to the OpenFIGI security master, which ensures all data represented is for a specified security.

Endpoint

https://api.intrinio.com/securities

https://api.intrinio.com/securities?identifier={symbol}

https://api.intrinio.com/securities?query={query-string}

https://api.intrinio.com/securities?exch_symbol={stock-exchange-symbol}

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /securities?exch_symbol=^XTSE
FULL URL: https://api.intrinio.com/securities?exch_symbol=^XTSE

{
  "result_count": 3019,
  "page_size": 250,
  "current_page": 1,
  "total_pages": 13,
  "api_call_credits": 1,
  "data": [
    {
      "ticker": "ABC",
      "figi_ticker": "ABC:CN",
      "figi": "BBG000C961K5",
      "security_name": "ASIA BIO-CHEM GROUP CORP",
      "market_sector": "Equity",
      "security_type": "Common Stock",
      "stock_exchange": "TSE",
      "last_crsp_adj_date": null
    },
    {
      "ticker": "AB/H",
      "figi_ticker": "AB/H:CN",
      "figi": "BBG000BXBPV2",
      "security_name": "ASBESTOS CORP LTD",
      "market_sector": "Equity",
      "security_type": "Common Stock",
      "stock_exchange": "TSE",
      "last_crsp_adj_date": null
    },
    ...
  ]
}

API URI: https://api.intrinio.com
GET: /securities?identifier=FNV:CT
FULL URL: https://api.intrinio.com/securities?identifier=FNV:CT

{
    "ticker": "FNV",
    "figi_ticker": "FNV:CT",
    "figi": "BBG000TRN7T6",
    "security_name": "FRANCO-NEVADA CORP",
    "market_sector": "Equity",
    "security_type": "Common Stock",
    "stock_exchange": "TSE",
    "last_crsp_adj_date": null,
    "composite_figi": "BBG000TRN6Z1",
    "figi_uniqueid": "EQ0000000004963575",
    "share_class_figi": "BBG001STGSR5",
    "figi_exch_cntry": "CT",
    "currency": "CAD",
    "mic": "XTSE",
    "exch_symbol": "^XTSE",
    "etf": false,
    "delisted_security": false,
    "primary_listing": true
}
Function not available
Function not available

Stock Exchange Master

Returns stock exchange list and information for all stock exchanges covered by Intrinio.

Endpoint

https://api.intrinio.com/stock_exchanges

https://api.intrinio.com/stock_exchanges?query={query-string}

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /stock_exchanges
FULL URL: https://api.intrinio.com/stock_exchanges

{
    "result_count": 29,
    "page_size": 250,
    "current_page": 1,
    "total_pages": 1,
    "api_call_credits": 1,
    "data": [
        {
            "symbol": "^BMEX",
            "mic": "BMEX",
            "institution_name": "BME - BOLSAS Y MERCADOS ESPANOLES",
            "acronym": "BME",
            "city": "MADRID",
            "country": "SPAIN",
            "country_code": "ES",
            "website": "HTTP://WWW.BOLSASYMERCADOS.ES"
        },
        {
            "symbol": "^BVMF",
            "mic": "BVMF",
            "institution_name": "BM&FBOVESPA S.A. - BOLSA DE VALORES, MERCADORIAS E FUTUROS",
            "acronym": null,
            "city": "SAO PAULO",
            "country": "BRAZIL",
            "country_code": "BR",
            "website": "HTTP://WWW.BMFBOVESPA.COM.BR"
        },
        ...
    ]
}
Function not available
Function not available

Security Corporate Actions

Returns all corporate actions for a security. Events 45+ types of corporate actions such as: Announcements and Annual Shareholder Meetings, Ex-date, Dividend pay date, Splits, Buy Backs, M&A and Takeovers, Bankruptcies and much more

Endpoint

https://api.intrinio.com/securities/corporate_actions?identifier={symbol}

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /securities/corporate_actions?identifier=AAPL:US
FULL URL: https://api.intrinio.com/securities/corporate_actions?identifier=AAPL:US

{
  "result_count": 1,
  "page_size": 250,
  "current_page": 1,
  "total_pages": 1,
  "api_call_credits": 1,
  "data": [
    {
      "event_id": 1080388,
      "event_code": "DIV",
      "date_data": {
        "ex_date": "2017-02-09",
        "fye_date": "2017-09-27",
        "pay_date": "2017-02-16",
        "record_date": "2017-02-13",
        "period_end_date": "2016-12-27",
        "declaration_date": "2017-01-31"
      },
      "rate_data": {
        "gross_dividend": 0.57
      },
      "field_data": {
        "marker": "INT",
        "dap_flag": "N",
        "tba_flag": "F",
        "frequency": "QTR",
        "approx_flag": "F",
        "div_rescind": "F",
        "nil_dividend": "F",
        "rescind_cash_div": "F",
        "rescind_stock_div": "F"
      }
    }
  ]
}
Function not available
Function not available

Stock Exchange Corporate Actions

Returns all corporate actions for all securities listed on a specified stock exchange. A subscription to the EDI Corporate Actions Data Feed for a specific country will permit access to all stock exchanges in that country (ie, US includes NASDAQ, NYSE, BATS). Events 45+ types of corporate actions such as: Announcements and Annual Shareholder Meetings, Ex-date, Dividend pay date, Splits, Buy Backs, M&A and Takeovers, Bankruptcies and much more

Endpoint

https://api.intrinio.com/stock_exchange/corporate_actions?identifier={stock-exchange-symbol}

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /stock_exchange/corporate_actions?identifier=^XNAS
FULL URL: https://api.intrinio.com/stock_exchange/corporate_actions?identifier=^XNAS

{
  "result_count": 1712,
  "page_size": 250,
  "current_page": 1,
  "total_pages": 7,
  "api_call_credits": 1,
  "data": [
    {
      "ticker": "CPA",
      "figi_ticker": "CPA:US",
      "figi": "BBG000C298Z6",
      "event_id": 1086457,
      "event_code": "DIV",
      "date_data": {
        "ex_date": "2017-02-24",
        "fye_date": "2017-12-31",
        "pay_date": "2017-03-15",
        "record_date": "2017-02-28",
        "period_end_date": "2017-03-31",
        "declaration_date": "2017-02-15"
      },
      "rate_data": {
        "gross_dividend": 0.51
      },
      "field_data": {
        "marker": "INT",
        "dap_flag": "N",
        "tba_flag": "F",
        "frequency": "QTR",
        "approx_flag": "F",
        "div_rescind": "F",
        "nil_dividend": "F",
        "rescind_cash_div": "F",
        "rescind_stock_div": "F"
      }
    },
    {
      "ticker": "SLF",
      "figi_ticker": "SLF:US",
      "figi": "BBG000LRMW74",
      "event_id": 721472,
      "event_code": "AGM",
      "date_data": {
        "agm_date": "2017-05-10",
        "fye_date": "2016-12-31"
      },
      "rate_data": {

      },
      "field_data": {
        "agm_egm": "AGM",
        "agm_time": ":",
        "country_code": "US"
      }
    },
    ...
  ]
}
Function not available
Function not available

Zacks Current Estimates Data Feeds

Data Point

Returns the most recent data point for a selected identifier (ticker symbol, FIGI, CIK ID, etc.) for a selected tag.

Endpoint

https://api.intrinio.com/data_point?identifier={symbol}&item={tag}

https://api.intrinio.com/data_point?identifier={symbol1,symbol2}&item={tag1,tag2}

Excel Function

=IntrinioDataPoint(identifier, item)

Sheets Function

=IntrinioDataPoint(identifier, item)

Parameters

Limits

You may request up to 150 identifier/item combinations at a time. For example, you may request 1 identifier and 150 items, or 150 identifiers and 1 item, or 12 identifiers and 12 items (144 combinations), or anywhere in between.

Return Values

API URI: https://api.intrinio.com
GET: /data_point?identifier=AAPL&item=target_price_mean_est
FULL URL: https://api.intrinio.com/data_point?identifier=AAPL&item=target_price_mean_est

{
  "identifier": "AAPL",
  "item": "target_price_mean_est",
  "value": 130.965
}

API URI: https://api.intrinio.com
GET: /data_point?identifier=BBG000B9XRY4&item=fy_1_sales_est_mean
FULL URL: https://api.intrinio.com/data_point?identifier=BBG000B9XRY4&item=fy_1_sales_est_mean

{
  "identifier": "BBG000B9XRY4",
  "item": "fy_1_sales_est_mean",
  "value": 227424420000
}

API URI: https://api.intrinio.com
GET: /data_point?identifier=BBG000B9XRY4&item=rating_mean
FULL URL: https://api.intrinio.com/data_point?identifier=BBG000B9XRY4&item=rating_mean

{
  "identifier": "BBG000B9XRY4",
  "item": "rating_mean",
  "value": 1.6
}

API URI: https://api.intrinio.com
GET: /data_point?identifier=AAPL&item=ltg_est_mean
FULL URL: https://api.intrinio.com/data_point?identifier=AAPL&item=ltg_est_mean

{
  "identifier": "AAPL",
  "item": "ltg_est_mean",
  "value": 0.10885
}

API URI: https://api.intrinio.com
GET: /data_point?identifier=BBG000B9XRY4&item=rating_cnt_strong_buys,rating_cnt_buys,rating_cnt_holds,rating_cnt_sells,rating_cnt_strong_sells,rating_mean
FULL URL: https://api.intrinio.com/data_point?identifier=BBG000B9XRY4&item=rating_cnt_strong_buys,rating_cnt_buys,rating_cnt_holds,rating_cnt_sells,rating_cnt_strong_sells,rating_mean

NOTE: While this is a single API Call, it is considered a Dimensional Call, which counts as 6 API Calls against the subscription plan.

{
  "result_count": 6,
  "api_call_credits": 6
  "data": [
    {
      "identifier": "BBG000B9XRY4",
      "item": "rating_cnt_strong_buys",
      "value": 22
    },
    {
      "identifier": "BBG000B9XRY4",
      "item": "rating_cnt_buys",
      "value": 4
    },
    {
      "identifier": "BBG000B9XRY4",
      "item": "rating_cnt_holds",
      "value": 4
    },
    {
      "identifier": "BBG000B9XRY4",
      "item": "rating_cnt_sells",
      "value": 0
    },
    {
      "identifier": "BBG000B9XRY4",
      "item": "rating_cnt_strong_sells",
      "value": 2
    },
    {
      "identifier": "BBG000B9XRY4",
      "item": "rating_mean",
      "value": 1.6
    }
  ]
}

API URI: https://api.intrinio.com
GET: /data_point?identifier=GOOGL,AAPL&item=target_price_median_est,target_price_high_est,target_price_low_est,target_price_cnt_est,target_price_std_dev_est
FULL URL: https://api.intrinio.com/data_point?identifier=GOOGL,AAPL&item=target_price_median_est,target_price_high_est,target_price_low_est,target_price_cnt_est,target_price_std_dev_est

NOTE: While this is a single API Call, it is considered a Dimensional Call, which counts as 10 API Calls against the subscription plan.

{
  "result_count": 10,
  "api_call_credits": 10,
  "data": [
    {
      "identifier": "GOOGL",
      "item": "target_price_median_est",
      "value": 950
    },
    {
      "identifier": "AAPL",
      "item": "target_price_median_est",
      "value": 130
    },
    {
      "identifier": "GOOGL",
      "item": "target_price_high_est",
      "value": 1080
    },
    {
      "identifier": "AAPL",
      "item": "target_price_high_est",
      "value": 185
    },
    {
      "identifier": "GOOGL",
      "item": "target_price_low_est",
      "value": 700
    },
    {
      "identifier": "AAPL",
      "item": "target_price_low_est",
      "value": 82
    },
    {
      "identifier": "GOOGL",
      "item": "target_price_cnt_est",
      "value": 29
    },
    {
      "identifier": "AAPL",
      "item": "target_price_cnt_est",
      "value": 29
    },
    {
      "identifier": "GOOGL",
      "item": "target_price_std_dev_est",
      "value": 75.493
    },
    {
      "identifier": "AAPL",
      "item": "target_price_std_dev_est",
      "value": 20.956
    }
  ]
}

=IntrinioDataPoint("AAPL","target_price_mean_est")

130.965

=IntrinioDataPoint("BBG000B9XRY4","rating_mean")

1.6

=IntrinioDataPoint("AAPL","ltg_est_mean")

0.10885

=IntrinioDataPoint("AAPL","fy_1_sales_est_mean")

$227,424,420,000.00

=IntrinioDataPoint("AAPL","target_price_mean_est")

130.965

=IntrinioDataPoint("BBG000B9XRY4","rating_mean")

1.6

=IntrinioDataPoint("AAPL","ltg_est_mean")

0.10885

=IntrinioDataPoint("AAPL","fy_1_sales_est_mean")

$227,424,420,000.00

Zacks Historical Estimates Data Feeds

Data Point

Returns the most recent data point for a selected identifier (ticker symbol, FIGI, CIK ID, etc.) for a selected tag.

Endpoint

https://api.intrinio.com/data_point?identifier={symbol}&item={tag}

https://api.intrinio.com/data_point?identifier={symbol1,symbol2}&item={tag1,tag2}

Excel Function

=IntrinioDataPoint(identifier, item)

Sheets Function

=IntrinioDataPoint(identifier, item)

Parameters

Limits

You may request up to 150 identifier/item combinations at a time. For example, you may request 1 identifier and 150 items, or 150 identifiers and 1 item, or 12 identifiers and 12 items (144 combinations), or anywhere in between.

Return Values

API URI: https://api.intrinio.com
GET: /data_point?identifier=AAPL&item=target_price_mean_est
FULL URL: https://api.intrinio.com/data_point?identifier=AAPL&item=target_price_mean_est

{
  "identifier": "AAPL",
  "item": "target_price_mean_est",
  "value": 130.965
}

API URI: https://api.intrinio.com
GET: /data_point?identifier=AAPL&item=fy_2020_sales_est_median
FULL URL: https://api.intrinio.com/data_point?identifier=AAPL&item=fy_2020_sales_est_median

{
  "identifier": "AAPL",
  "item": "fy_2020_sales_est_median",
  "value": 242644000000
}

API URI: https://api.intrinio.com
GET: /data_point?identifier=BBG000B9XRY4&item=fy_1_sales_est_mean
FULL URL: https://api.intrinio.com/data_point?identifier=BBG000B9XRY4&item=fy_1_sales_est_mean

{
  "identifier": "BBG000B9XRY4",
  "item": "fy_1_sales_est_mean",
  "value": 227424420000
}

API URI: https://api.intrinio.com
GET: /data_point?identifier=BBG000B9XRY4&item=fy_2020_eps_est_median
FULL URL: https://api.intrinio.com/data_point?identifier=BBG000B9XRY4&item=fy_2020_eps_est_median

{
  "identifier": "AAPL",
  "item": "fy_2020_eps_est_median",
  "value": 10.81
}

API URI: https://api.intrinio.com
GET: /data_point?identifier=BBG000B9XRY4&item=rating_mean
FULL URL: https://api.intrinio.com/data_point?identifier=BBG000B9XRY4&item=rating_mean

{
  "identifier": "BBG000B9XRY4",
  "item": "rating_mean",
  "value": 1.6
}

API URI: https://api.intrinio.com
GET: /data_point?identifier=AAPL&item=ltg_est_mean
FULL URL: https://api.intrinio.com/data_point?identifier=AAPL&item=ltg_est_mean

{
  "identifier": "AAPL",
  "item": "ltg_est_mean",
  "value": 0.10885
}

API URI: https://api.intrinio.com
GET: /data_point?identifier=BBG000B9XRY4&item=rating_cnt_strong_buys,rating_cnt_buys,rating_cnt_holds,rating_cnt_sells,rating_cnt_strong_sells,rating_mean
FULL URL: https://api.intrinio.com/data_point?identifier=BBG000B9XRY4&item=rating_cnt_strong_buys,rating_cnt_buys,rating_cnt_holds,rating_cnt_sells,rating_cnt_strong_sells,rating_mean

NOTE: While this is a single API Call, it is considered a Dimensional Call, which counts as 6 API Calls against the subscription plan.

{
  "result_count": 6,
  "api_call_credits": 6
  "data": [
    {
      "identifier": "BBG000B9XRY4",
      "item": "rating_cnt_strong_buys",
      "value": 22
    },
    {
      "identifier": "BBG000B9XRY4",
      "item": "rating_cnt_buys",
      "value": 4
    },
    {
      "identifier": "BBG000B9XRY4",
      "item": "rating_cnt_holds",
      "value": 4
    },
    {
      "identifier": "BBG000B9XRY4",
      "item": "rating_cnt_sells",
      "value": 0
    },
    {
      "identifier": "BBG000B9XRY4",
      "item": "rating_cnt_strong_sells",
      "value": 2
    },
    {
      "identifier": "BBG000B9XRY4",
      "item": "rating_mean",
      "value": 1.6
    }
  ]
}

API URI: https://api.intrinio.com
GET: /data_point?identifier=GOOGL,AAPL&item=target_price_median_est,target_price_high_est,target_price_low_est,target_price_cnt_est,target_price_std_dev_est
FULL URL: https://api.intrinio.com/data_point?identifier=GOOGL,AAPL&item=target_price_median_est,target_price_high_est,target_price_low_est,target_price_cnt_est,target_price_std_dev_est

NOTE: While this is a single API Call, it is considered a Dimensional Call, which counts as 10 API Calls against the subscription plan.

{
  "result_count": 10,
  "api_call_credits": 10,
  "data": [
    {
      "identifier": "GOOGL",
      "item": "target_price_median_est",
      "value": 950
    },
    {
      "identifier": "AAPL",
      "item": "target_price_median_est",
      "value": 130
    },
    {
      "identifier": "GOOGL",
      "item": "target_price_high_est",
      "value": 1080
    },
    {
      "identifier": "AAPL",
      "item": "target_price_high_est",
      "value": 185
    },
    {
      "identifier": "GOOGL",
      "item": "target_price_low_est",
      "value": 700
    },
    {
      "identifier": "AAPL",
      "item": "target_price_low_est",
      "value": 82
    },
    {
      "identifier": "GOOGL",
      "item": "target_price_cnt_est",
      "value": 29
    },
    {
      "identifier": "AAPL",
      "item": "target_price_cnt_est",
      "value": 29
    },
    {
      "identifier": "GOOGL",
      "item": "target_price_std_dev_est",
      "value": 75.493
    },
    {
      "identifier": "AAPL",
      "item": "target_price_std_dev_est",
      "value": 20.956
    }
  ]
}

API URI: https://api.intrinio.com
GET: /data_point?identifier=GOOGL,AAPL&item=fy_2018_sales_est_median
FULL URL: https://api.intrinio.com/data_point?identifier=GOOGL,AAPL&item=fy_2018_sales_est_median

NOTE: While this is a single API Call, it is considered a Dimensional Call, which counts as 2 API Calls against the subscription plan.

{
  "result_count": 2,
  "api_call_credits": 2,
  "data": [
    {
      "identifier": "GOOGL",
      "item": "fy_2018_sales_est_median",
      "value": 96374650000
    },
    {
      "identifier": "AAPL",
      "item": "fy_2018_sales_est_median",
      "value": 242897000000
    }
  ]
}
=IntrinioDataPoint("AAPL","target_price_mean_est")

130.965

=IntrinioDataPoint("BBG000B9XRY4","rating_mean")

1.6

=IntrinioDataPoint("GOOGL","fy_2018_sales_est_median")

96,374,650,000.00

=IntrinioDataPoint("AAPL","fy_2018_sales_est_median")

$242,897,000,000.00

=IntrinioDataPoint("AAPL","ltg_est_mean")

0.10885

=IntrinioDataPoint("AAPL","fy_1_sales_est_mean")

$227,424,420,000.00

=IntrinioDataPoint("AAPL","target_price_mean_est")

130.965

=IntrinioDataPoint("BBG000B9XRY4","rating_mean")

1.6

=IntrinioDataPoint("AAPL","ltg_est_mean")

0.10885

=IntrinioDataPoint("AAPL","fy_1_sales_est_mean")

$227,424,420,000.00

=IntrinioDataPoint("GOOGL","fy_2018_sales_est_median")

96,374,650,000.00

=IntrinioDataPoint("AAPL","fy_2018_sales_est_median")

$242,897,000,000.00

Historical Data

Returns the historical data for for a selected identifier (ticker symbol, CIK, FIGI) for a selected Zack’s Historical tag.

Endpoint

https://api.intrinio.com/historical_data?identifier={symbol}&item={tag}

Excel Function

=IntrinioHistoricalData(identifier, item, sequence, start_date, end_date, frequency, type, show_date)

Parameters

Return Values

API URI: https://api.intrinio.com
GET: /historical_data?identifier=AAPL&item=fy_2018_eps_est_median
FULL URL: https://api.intrinio.com/historical_data?identifier=AAPL&item=fy_2018_eps_est_median

{
  "identifier": "AAPL",
  "item": "fy_2018_eps_est_median",
  "result_count": 82,
  "page_size": 50000,
  "current_page": 1,
  "total_pages": 1,
  "api_call_credits": 1,
  "data": [
    {
      "date": "2016-12-20",
      "value": 10
    },
    {
      "date": "2016-11-11",
      "value": 10
    },
    {
      "date": "2016-10-27",
      "value": 10.045
    },
    {
      "date": "2016-10-26",
      "value": 10.09
    },
    {
      "date": "2016-10-24",
      "value": 10.24
    },
    ...
  ]
}

API URI: https://api.intrinio.com
GET: /historical_data?identifier=AAPL&item=target_price_mean_est
FULL URL: https://api.intrinio.com/historical_data?identifier=AAPL&item=target_price_mean_est

{
  "identifier": "AAPL",
  "item": "target_price_mean_est",
  "result_count": 1008,
  "page_size": 50000,
  "current_page": 1,
  "total_pages": 1,
  "api_call_credits": 1,
  "data": [
    {
      "date": "2016-12-04",
      "value": 130.965
    },
    {
      "date": "2016-11-27",
      "value": 131.034
    },
    {
      "date": "2016-11-14",
      "value": 131.107
    },
    {
      "date": "2016-10-27",
      "value": 131
    },
    {
      "date": "2016-10-26",
      "value": 130.857
    },
  ...
  ]
}

API URI: https://api.intrinio.com
GET: /historical_data?identifier=AAPL&item=rating_mean
FULL URL: https://api.intrinio.com/historical_data?identifier=AAPL&item=rating_mean

{
  "identifier": "AAPL",
  "item": "rating_mean",
  "result_count": 1199,
  "page_size": 50000,
  "current_page": 1,
  "total_pages": 1,
  "api_call_credits": 1
  "data": [
    {
      "date": "2016-12-21",
      "value": 1.6
    },
    {
      "date": "2016-12-18",
      "value": 1.6
    },
    {
      "date": "2016-11-27",
      "value": 1.6
    },
    {
      "date": "2016-10-27",
      "value": 1.6
    },
    {
      "date": "2016-10-25",
      "value": 1.6
    },
    {
      "date": "2016-09-15",
      "value": 1.5
    },
    {
      "date": "2016-09-08",
      "value": 1.5
    },
    {
      "date": "2016-08-10",
      "value": 1.5
    },
    ...
  ]
}

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

$10.00

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

108.521

=IntrinioHistoricalData("AAPL","rating_mean",0,"2010-01-01","2010-02-01")

1.3
Function not available