Install in Excel

This page applies to Microsoft Excel.

Before you start

Tickerdata runs as an Excel add-in, so it needs a version of Excel that supports custom functions: Excel on the web, or a Windows or Mac Excel from Microsoft 365, Office 2024, or Office 2021. Check Supported Platforms if you are not sure which one you have.

You will also need a Google account. Tickerdata accounts sign in with Google, whichever spreadsheet you use.

Install the add-in

Tickerdata is on the Microsoft Marketplace as Tickerdata. You can install it from that page, or from inside Excel:

Open the add-in store

In any workbook, go to Home → Add-ins, then More Add-ins to open the store.

Info

Older builds of Excel keep the store on **Insert** → **Get Add-ins** instead. Both lead to the same place.

Search for Tickerdata

Search for Tickerdata and click Add on the result.

Open the task pane

Excel adds a Tickerdata group to the Home tab, holding a Tickerdata button and a Refresh menu. Click Tickerdata to open the task pane.

Sign in

Click Sign in in the task pane. Excel opens a small browser window on tickerdata.com — sign in there with the Google account on your Tickerdata subscription, and the window closes on its own.

Info

Before you sign in, the pane shows an introduction and the **Sign in** button, nothing else. Afterwards it shows the account you are signed in as, whether the subscription is active, and the refresh actions.

Try a formula

In any cell, enter:

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

You should see Apple’s 2023 revenue. If the cell shows #BUSY! for a moment, that is normal — the formula is fetching.

Next steps

Quick Start — your first live quote
Excel Essentials — spilled results, #BUSY!, and reading errors
Refreshing Data in Excel — Excel never re-runs these formulas on its own