Google Sheets Tutorial | Intrinio

Google Sheets Tutorial

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

  1. Add Intrinio Google Sheets Add-on to your Google Sheets Account
  2. Open a new sheet
  3. In the top menu, go to Add-ons -> Intrinio Financial Data -> Get Started
  4. The Intrinio sidebar should appear on the right side
  5. Enter your Access Key username and password
  6. To view your access key, click here to log in.
  7. Click Submit
  8. Select a cell and try a sample function:
    =IntrinioDataPoint("AAPL","pricetoearnings")
  9. 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