Quick Start Guide
Get up and running with Tickerdata in minutes with your first stock data formula.
Before You Start
You need Tickerdata installed and signed in.
Install it from the Google Workspace Marketplace, then sign in from Extensions → Tickerdata → Log in.
Install it from the Excel add-in store, then open the task pane with the Tickerdata button on the Home tab and click Sign in. Formulas return an error until you do.
Your First Formula
Let’s fetch your first stock quote. We’ll ask for the current price of Apple stock.
Select a Cell
Click on any empty cell where you want the stock price to appear.
Enter the Formula
Type the following formula:
=TICKERDATALIVE("AAPL", "Price")=TICKERDATA.LIVE("AAPL", "Price")Press Enter
Press Enter to run the formula. Apple’s current stock price appears in the cell.
Understanding the Result
The live function returns real-time market data for the specified ticker symbol. The second parameter specifies which data point you want to retrieve.
Basic Syntax
=TICKERDATALIVE(ticker, attribute)=TICKERDATA.LIVE(ticker, attribute)| Parameter | Description | Example |
|---|---|---|
| ticker | Stock symbol | “AAPL”, “MSFT”, “BTCUSD” |
| attribute | Data point to retrieve | “Price”, “Market Cap”, “Beta” |
Try More Examples
Market capitalization:
=TICKERDATALIVE("AAPL", "Market Cap")=TICKERDATA.LIVE("AAPL", "Market Cap")Price to earnings ratio, trailing twelve months:
=TICKERDATA("MSFT", "Price To Earnings Ratio", "ttm")=TICKERDATA.DATA("MSFT", "Price To Earnings Ratio", "ttm")Company sector:
=TICKERDATALIVE("TSLA", "Sector")=TICKERDATA.LIVE("TSLA", "Sector")Tip
Cryptocurrency
For crypto, combine the symbol with the currency code:
=TICKERDATALIVE("BTCUSD", "Price")=TICKERDATA.LIVE("BTCUSD", "Price")International Stocks
For international stocks, use exchange suffixes. LVMH on the Paris exchange:
=TICKERDATALIVE("MC.PA", "Price")=TICKERDATA.LIVE("MC.PA", "Price")Building a Simple Watchlist
Put your tickers in column A, then reference the cell instead of hardcoding the symbol:
=TICKERDATALIVE(A2, "Price")=TICKERDATA.LIVE(A2, "Price")=TICKERDATA(A2, "Price To Earnings Ratio", "ttm")=TICKERDATA.DATA(A2, "Price To Earnings Ratio", "ttm")Fill both formulas down beside the tickers and the whole watchlist updates when you change column A.
Handling Errors
Wrap your formulas in IFERROR to handle cases where data isn’t available:
=IFERROR(TICKERDATALIVE("AAPL", "Price"), "N/A")=IFERROR(TICKERDATA.LIVE("AAPL", "Price"), "N/A")Next Steps
- Browse the Attribute Explorer to discover all 200+ available data points
- Learn about all available ticker formats including crypto and international stocks
- Explore TICKERDATA for historical financial data
- Build a Portfolio Tracker template
Didn't find what you came for?
Tell us the sheet you're trying to make and we'll point you at the right numbers.