Tickerdata

Pull company financials and live market data straight into your worksheet with two functions. No

copy-paste, no CSV downloads, no leaving Excel.

Two functions, 400+ metrics

=TICKERDATA.DATA("AAPL", "revenue", 2023) returns reported figures — annual, quarterly or

trailing twelve months — from income statements, balance sheets, cash flow statements, ratios, key

metrics, growth rates, dividends and analyst estimates. Over 30 years of history.

=TICKERDATA.LIVE("AAPL", "price") returns live market data — price, volume, market cap,

day and 52-week ranges, sector, moving averages and period returns.

Over 400 metrics across 70+ stock exchanges worldwide, sourced from company filings and

standardised so the same metric name works for every ticker.

Built for real workbooks

• Refresh on the ribbon. Home > Tickerdata > Refresh re-runs every Tickerdata formula

  in the workbook — all of them, only the historic ones, or only the live ones.

• Task pane. Account status, refresh controls, and a Clear cached data button for when you

  need figures re-fetched immediately.

• Fast on big sheets. Requests for the same statement are collapsed into one call and

  cached, so a sheet with hundreds of formulas is not hundreds of round trips.

• Dynamic arrays. Full dividend history spills into a table from a single formula.

Before you subscribe — please read

A paid Tickerdata subscription is required. The add-in installs free; formulas return data

only while a subscription is active. Plans and pricing are at tickerdata.com. Sign-in is with a

Google account.

Supported versions of Excel:

• Excel on the web — yes
• Excel on Windows, Microsoft 365, version 1903 or later — yes
• Excel on Mac, version 16.34 or later — yes
• Excel on iPad and mobile — no
• Volume-licensed perpetual Office, 2021 and earlier — no

These are the platforms Excel custom functions run on; there is no workaround on the others.

Already using Tickerdata in Google Sheets? Your subscription covers both, but the formulas

are not identical. Excel requires the namespace prefix, so Sheets formulas do not paste across

verbatim: TICKERDATA(...) becomes TICKERDATA.DATA(...), and

TICKERDATALIVE(...) becomes TICKERDATA.LIVE(...). Metric names are unchanged.

Support

Documentation and the full metric list: tickerdata.com/docs

Questions: help@tickerdata.com