1. Troubleshooting
  2. Common Errors

Troubleshooting Common Errors

Solutions for common Tickerdata errors and issues.

Overview

This guide covers common errors you might encounter when using Tickerdata and how to resolve them.

Error 400 (Bad Request)

Cause: Being signed into multiple Google accounts in the same browser session.

Warning

This is one of the most common issues. Google Sheets gets confused when multiple accounts are active.

Solutions:

  1. Sign out of other Google accounts - Keep only the account linked to Tickerdata signed in
  2. Use a separate browser profile - Create a dedicated Chrome/Firefox profile for your Tickerdata spreadsheets
  3. Use Incognito/Private mode - Sign in with only your Tickerdata-linked account

Error: #VALUE!

Cause: Invalid parameter, ticker symbol, or attribute.

In Excel every Tickerdata problem arrives as #VALUE! - it is the only error a custom function can return. Hover over the cell, or click the warning marker beside it, to read the message that says which problem it was.

Solutions:

// Wrong - using company name
=TICKERDATALIVE("Apple", "Price")
// Correct - using ticker symbol
=TICKERDATALIVE("AAPL", "Price")
// Wrong - using company name
=TICKERDATA.LIVE("Apple", "Price")
// Correct - using ticker symbol
=TICKERDATA.LIVE("AAPL", "Price")

Error: #NAME?

Cause: Excel does not recognise the function name, which means the add-in is not loaded in this workbook.

Solutions:

  1. Open the task pane - Home → Tickerdata. If the button is not on the ribbon, the add-in is not installed for this account.
  2. Reinstall - Home → Add-ins → More Add-ins (or Insert → Get Add-ins on older builds), search for Tickerdata, and add it again.
  3. Check the name - Excel needs the namespace: TICKERDATA.DATA and TICKERDATA.LIVE, not the Google Sheets spellings.

Error: #SPILL!

Cause: The result needs more cells than it has. Something is sitting in the range it was going to fill.

Solution: Click the cell - Excel outlines the range it was trying to write - and clear whatever is inside that outline. Excel Essentials covers which requests return a table rather than a single value.

Message: Your Tickerdata session has expired

Cause: The sign-in on this machine has lapsed. The cell shows #VALUE! and the message on hover reads “your Tickerdata session has expired”.

Solution: Open the task pane from Home → Tickerdata, click Sign in, then refresh the workbook’s formulas.

Error: #N/A

Cause: Data not available for the requested ticker, time period, or attribute.

Solutions:

  1. Check if the ticker exists - Verify the symbol is correct and supported
  2. Verify the time period - Not all metrics are available for all years
  3. Check data availability - Some metrics aren’t available for all stocks
=IFERROR(TICKERDATALIVE("TICKER", "Price"), "Data unavailable")
=IFERROR(TICKERDATA.LIVE("TICKER", "Price"), "Data unavailable")

Error: Data Not Loading

Cause: Google Sheets caching or sync issues.

Solutions:

  1. Hard refresh your browser:
    • Windows: Ctrl+Shift+R
    • Mac: Cmd+Shift+R

Info

Google Sheets aggressively caches data. A simple refresh often isn't enough - you need a hard refresh to fully reload the add-on.
  1. Close all browser tabs and quit the browser completely
  2. Reopen the spreadsheet - Don’t restore the previous session
  3. Log in again: Extensions > Tickerdata > Log in
  4. Refresh functions: Extensions > Tickerdata > Refresh

Error: Function Not Recognized

Cause: Tickerdata not properly installed or enabled.

Solutions:

  1. Verify installation: Extensions > Add-ons > Manage add-ons
  2. Reinstall if needed:
    • Uninstall Tickerdata
    • Search for “Tickerdata” and click “Individual Install”
  3. Log in: Extensions > Tickerdata > Log in
  4. Refresh: Extensions > Tickerdata > Refresh

Warning

Known Google Bug: When copying a Google Sheet that contains an add-on, the script may not copy correctly. If you've copied a sheet (like the Tickerdata DIY Toolkit), you may need to uninstall and reinstall the add-on in the copied sheet.

Error: Data Looks Stale

Cause: Excel never re-runs a Tickerdata formula on its own, and its own Calculate Now and Refresh All do not reach these formulas.

Solution: Refresh from Home → Tickerdata → Refresh, or from the task pane. If the value still looks old, it is being served from the cache - use Clear cached data in the task pane, then refresh. See Refreshing Data in Excel.

Error: No Data for Metric

Cause: The requested metric doesn’t exist for the specified ticker or time period.

Solutions:

  1. Check TTM support - Not all metrics support TTM (trailing twelve months)
  2. Try a different year - Some historical data may not be available
  3. Verify the metric name - Check the TICKERDATA attributes list

If TTM doesn’t work for a metric, use a specific year instead:

=TICKERDATA("AAPL", "Revenue", 2023)
=TICKERDATA.DATA("AAPL", "Revenue", 2023)

Error: Rate Limit

Cause: Too many API calls in a short period.

Solutions:

  1. Reduce function calls - Consolidate where possible
  2. Use cell references - Avoid duplicate lookups for the same ticker
  3. Check your subscription - Higher tiers have higher limits

Subscription Issues

Cause: Account or payment problems.

Solutions:

  1. Verify active subscription at tickerdata.com
  2. Check linked account: Visit the Account Page to see which Google account is linked
  3. Ensure correct Google account - You must be signed in to your spreadsheet with the same Google account linked to your Tickerdata subscription

Getting More Help

If you can’t resolve your issue:

  1. Check the FAQ - Frequently Asked Questions
  2. Search documentation - Use Cmd+K to search
  3. Contact support - help@tickerdata.com

Tip

When contacting support, include your spreadsheet URL and the specific error message for faster resolution.

Didn't find what you came for?

Tell us the sheet you're trying to make and we'll point you at the right numbers.

Tell us what you're trying to make →