Frequently Asked Questions

General Questions

What is Tickerdata?

Tickerdata is a Google Sheets add-on and a Microsoft Excel add-in 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.

Does Tickerdata work in Excel?

Yes. The Excel add-in runs on:

A one-off Office 2021 licence needs its updates: custom-function support arrived in the November 2023 release. Volume-licensed Office LTSC 2021 stays on version 2108 and works as-is. Supported Platforms has the detail.

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 major exchanges and regulatory filings (SEC) to ensure accuracy and reliability.

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

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

=TICKERDATA.LIVE("BTCUSD", "Price")   // Bitcoin in USD
=TICKERDATA.LIVE("ETHUSD", "Price")   // Ethereum in USD

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

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

See Supported Exchanges for the full list.

Technical Questions

Why do I get #VALUE! errors?

Common causes:

1. Invalid ticker symbol
2. Incorrect attribute name - check the Attribute Explorer for exact attribute names
3. 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?

In Google Sheets, go to: Extensions > Tickerdata > Refresh

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

In Excel, use the Refresh menu in the Tickerdata group on the Home tab - All, Historic, or Live - or the same actions in the task pane. Excel never re-runs a custom function on its own, so cells keep showing the last computed value until you refresh.

Can I use Tickerdata in multiple spreadsheets?

Yes! Your subscription works across all your Google Sheets documents and Excel workbooks - one subscription covers both platforms. 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?

In Excel the same two functions are named TICKERDATA.LIVE and TICKERDATA.DATA.

Do my Sheets formulas work in Excel?

Not by copy and paste. Excel requires the TICKERDATA. namespace prefix — TICKERDATA becomes TICKERDATA.DATA, and TICKERDATALIVE becomes TICKERDATA.LIVE — so a formula pasted across unchanged shows #NAME? until it is renamed. Attribute names are identical on both platforms.

How do I get quarterly data?

Add the quarter parameter to TICKERDATA:

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

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

What is TTM data?

TTM stands for “Trailing Twelve Months”. Use it for the most current annualized data. How the value is produced depends on the type of metric:

• Income statement and cash flow metrics (e.g., Revenue, Net Income, Free Cash Flow): the sum of the last four reported quarters
• Ratios, key metrics, and per-share values (e.g., PE Ratio, ROE): pre-computed TTM figures, calculated for you
• Balance sheet metrics (e.g., Total Assets, Total Debt): the most recent reported quarter (point-in-time values are never summed)

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

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

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. Sign-in is Google-only on both Sheets and Excel, so the same account links your subscription on either platform.

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

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.