Intrinio Data in Google Sheets
The Intrinio Google Sheets add-on extends the functionality of Google Sheets by enabling you to access the Intrinio API without any programming experience. 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.
Getting Started
-
Add
Intrinio Google Sheets Add-on
to your Google Sheets Account
- Open a new sheet
-
In the top menu, go to
Add-ons -> Intrinio Financial Data -> Get Started
- The Intrinio sidebar should appear on the right side
-
Enter your Access Key username and password
To view your access key, click here to log in.
- Click Submit
-
Select a cell and try a sample function:
=IntrinioDataPoint("AAPL","pricetoearnings")
- Hit Enter, wait a few moments for it to load, and you should see data populated in the cell
More Examples
Try these functions to demonstrate the breadth of Intrinio data:
-
Get the trailing 12-month operating revenue for a company:
=IntrinioDataPoint("AAPL","operatingrevenue")
-
Get the trailing dividend yield for a company:
=IntrinioDataPoint("AAPL","trailing_dividend_yield")
-
Get the current fiscal year average Wall Street consensus EPS for a company:
=IntrinioDataPoint("AAPL","current_yr_ave_eps_est")
-
Get the total revenue for a company in the fiscal year 2012:
=IntrinioFinancials("AAPL","income_statement",2012,"FY","totalrevenue","M")
Go Forth and Build
We can't wait to see what you will build using Intrinio data.
Documentation
For a detailed reference, see the
Documentation.
Developer Program
If you are interested in getting 6 months of extended access to all of our data feeds, take a look at the
Developer Program.
We Are Here to Help
If you run into any trouble feel free to
chat with us.
Go to my Account