Investors Engine: Financials for Sheets™

The Investors Engine add-on gives you two ways to bring data into a spreadsheet:

• Get Data sidebar: Enter a ticker, select annual or quarterly data, and click Get Data. The add-on creates one sheet for each selected dataset, named <TICKER>: <Statement> (e.g. NVDA: Balance Sheet).
• =IE() custom function: Return a single value, a trailing-twelve-month value, or a range of annual or quarterly values. Range results expand horizontally into adjacent empty cells.
• Nine datasets are available: Income Statement, Balance Sheet, Cash Flow, Valuation, Margins, Efficiency, Financial Health, Per Share, and Other.

• An active Investors Engine Premium subscription.
• A Google account with edit access to the spreadsheet you want to use.

1. Open a Google Sheets spreadsheet and go to Extensions → Add-ons → Get add-ons.
2. Open the Investors Engine Marketplace listing or search for “Investors Engine”, then click Install.
3. Approve the requested permissions when prompted by Google.

1. Visit Settings → Integrations.
2. Click Create token, give it a name (e.g. “Sheets”), and copy the ie_… value. The full token is shown only once.
3. Return to your spreadsheet and open the add-on sidebar from Extensions → Investors Engine → Open sidebar, paste the token into the API token field, and click Save.

Your token is stored per Google account and reused across every spreadsheet in which you open the add-on. To support the =IE() custom function, the add-on also stores a copy in that spreadsheet. Logout clears the account copy and the copy in the current spreadsheet. Revoke the token from Settings to disable it everywhere.

1. Enter a ticker (e.g. AAPL).
2. Pick Annual or Quarterly.
3. Set how many periods you want (default 10).
4. Open the Statements dropdown to choose which tabs to populate. All 9 are selected by default; uncheck the ones you don’t need.
5. Click Get Data.

The add-on creates one sheet for each selected dataset. Running the request again for the same ticker replaces the contents of those sheets. Running it for another ticker creates a separate set of sheets.

The custom function syntax is:

=IE(symbol, metric, period, frequency, currency)

Examples:

=IE("AAPL", "Revenue", 2024)
=IE("MSFT", "Net Income", "2020:2024")
=IE("GOOG", "P/E", "TTM")
=IE("NVDA", "Operating Margin %", "Q3-2024", "quarterly")

A range period like "2020:2024" returns five values as an array that expands horizontally into adjacent empty cells.

Supported period formats

• 2024 : full fiscal year
• "TTM" : trailing twelve months
• "Q3-2024" : a specific quarter
• "2020:2024" : an annual range that expands across adjacent cells
• "Q1-2023:Q4-2024" : a quarterly range that expands across adjacent cells
• "2024-09-28" : an exact fiscal period-end date

Metric names

You can use the display name ("Revenue"), a common alias ("Sales"), or the canonical snake_case key ("net_income"). Open the Single Cell tab in the sidebar to browse the full list with an autocomplete search.

#ERROR! Invalid Investors Engine API token

Your token was revoked or copied incorrectly. Open the sidebar, click Logout, then paste a fresh token from Settings → Integrations.

#ERROR! Pro subscription required for this symbol/metric

The add-on requires an active Premium subscription. Upgrade your plan from the Pricing page to enable data access.

#ERROR! Daily limit reached

Each user has a 10,000-call daily quota, which resets at midnight UTC. To reduce calls, reference an existing result cell instead of repeating the same =IE() custom function in multiple cells.

Data looks stale after I updated something

The add-on can cache each ticker, dataset, and currency combination for up to 6 hours within a spreadsheet. Wait for the cached result to expire before requesting it again. Logging out does not clear this cache.

Unknown metric

The metric name doesn't match any display name, alias, or backend key. Open the Single Cell tab in the sidebar to see the full searchable list.

Investors Engine: Financials for Sheets™ requests only the Google permissions required for the add-on to operate in Google Sheets and write requested financial data to your spreadsheet. It does not use your other Google Drive files to provide the add-on, and Investors Engine does not sell Google user data. The add-on uses a one-way hash of your Google account email to enforce the single-account license without sending the email address itself to Investors Engine.

Your API token is stored for your Google account and copied into each spreadsheet where you connect the add-on so custom functions can authenticate. Spreadsheet editors with access to its Apps Script properties may be able to access that copy. Do not connect the add-on to a spreadsheet shared with people you do not trust. You can revoke the token at any time from Settings → Integrations.

For full details, see our Privacy Policy and Terms of Service.

Email [email protected] with the ticker, formula, and error message you’re seeing, and we’ll get back to you.