Frequently Asked Questions

General Questions

What is Tickerdata?

Tickerdata is a Google Sheets add-on that lets you pull financial data directly into your spreadsheets using simple formulas. Access 30+ years of historical data, real-time prices, and 200+ financial metrics.

How much does Tickerdata cost?

Tickerdata offers multiple subscription tiers. Visit tickerdata.com to see current pricing. You can save by paying annually.

What’s the difference between Basic and Premium?

Both plans give you access to the core TICKERDATA and TICKERDATALIVE functions. Premium includes additional features like pre-built stock analysis templates and portfolio tracking templates. Check the pricing page for the full comparison.

What data sources does Tickerdata use?

We aggregate data from multiple financial data providers to ensure accuracy and reliability. Data sources include major exchanges, regulatory filings (SEC), and market data vendors.

Data Questions

How often does data update?

Data refresh rates depend on your subscription tier and the exchange. US exchanges (NYSE, NASDAQ) typically have real-time data, while international exchanges may have delays of 10-20 minutes.

Why is my data different from Yahoo Finance/Google Finance?

Small differences are normal due to:

Different data sources
Timing differences
Currency conversions
Adjusted vs. unadjusted prices

Info

For exact price matching, compare at the same timestamp and verify you're looking at the same data type.

Does Tickerdata support cryptocurrency?

Yes! Use the combined format with the currency code:

=TICKERDATALIVE("BTCUSD", "Price")   // Bitcoin in USD
=TICKERDATALIVE("ETHUSD", "Price")   // Ethereum in USD

Warning

The format is "BTCUSD" not "BTC" or "BTC-USD". You must include the currency code.

Does Tickerdata support international stocks?

Yes! Tickerdata supports 70+ exchanges worldwide. Use exchange suffixes for international stocks:

=TICKERDATALIVE("MC.PA", "Price")        // LVMH on Paris exchange
=TICKERDATALIVE("RELIANCE.NS", "Price")  // Reliance on NSE India
=TICKERDATALIVE("7203.T", "Price")       // Toyota on Tokyo exchange

See Supported Exchanges for the full list.

Technical Questions

Why do I get #VALUE! errors?

Common causes:

Invalid ticker symbol
Incorrect attribute name - check the Attribute Explorer for exact attribute names
Wrong format for crypto (use “BTCUSD” not “BTC”)

See Common Errors for detailed solutions.

Why do I get Error 400?

Error 400 (Bad Request) is usually caused by being signed into multiple Google accounts in the same browser. Solution: Sign out of other accounts or use a separate browser profile.

How do I refresh data manually?

Go to: Extensions > Tickerdata > Refresh

Or make any edit to a cell, then undo - this triggers a recalculation.

Can I use Tickerdata in multiple spreadsheets?

Yes! Your subscription works across all your Google Sheets documents. Just make sure you’re logged in with the same Google account linked to your Tickerdata subscription.

What’s the difference between TICKERDATA and TICKERDATALIVE?

Function	Purpose	Example
`TICKERDATALIVE`	Real-time prices and company info	`=TICKERDATALIVE("AAPL", "Price")`
`TICKERDATA`	Historical financials and metrics	`=TICKERDATA("AAPL", "Revenue", 2023)`

How do I get quarterly data?

Add the quarter parameter to TICKERDATA:

=TICKERDATA("AAPL", "Revenue", 2023, "Q1")
=TICKERDATA("AAPL", "Revenue", 2023, "Q2")

What is TTM data?

TTM stands for “Trailing Twelve Months” - it’s the sum of the last four quarters. Use it for the most current annualized data:

=TICKERDATA("AAPL", "Revenue", "ttm")

Info

Not all metrics support TTM. If you get an error, try using a specific year instead.

Account Questions

How do I check which Google account is linked?

Visit your Account Page to see which Google account is connected to your subscription.

How do I upgrade my subscription?

Visit tickerdata.com or go to Extensions > Tickerdata > Manage Subscription.

Can I cancel anytime?

Yes, you can cancel your subscription at any time. You’ll retain access until the end of your billing period.

How do I contact support?

Email: help@tickerdata.com
Help Form: Support Form

Tip

Include your spreadsheet URL and specific error messages when contacting support for faster resolution.

Feature Requests

Can you add ?[feature X]?

We love hearing from users! Submit feature requests to help@tickerdata.com or through the in-app feedback form.

Still Have Questions?

Can’t find what you’re looking for? Contact us at help@tickerdata.com or check our Common Errors guide.