Troubleshooting Common Errors

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.

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.

Solutions:

// Wrong - using company name
=TICKERDATALIVE("Apple", "Price")

// Correct - using ticker symbol
=TICKERDATALIVE("AAPL", "Price")

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

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

2. Close all browser tabs and quit the browser completely
3. Reopen the spreadsheet - Don’t restore the previous session
4. Log in again: Extensions > Tickerdata > Log in
5. 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

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, try a specific year
=TICKERDATA("AAPL", "Revenue", "ttm")        // May not work for all metrics
=TICKERDATA("AAPL", "Revenue", 2023)         // Use specific year instead

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 logged into Google Sheets with the same 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