TICKERDATALIVE - Real-Time Data

Overview

The TICKERDATALIVE function retrieves real-time market data including current prices, company information, and live metrics. This is your go-to function for tracking current market conditions. In Excel it is called TICKERDATA.LIVE - see what the functions are called.

Syntax

=TICKERDATALIVE(ticker, attribute)

=TICKERDATA.LIVE(ticker, attribute)

Parameter	Required	Description
`ticker`	Yes	The stock symbol (e.g., “AAPL”, “BTCUSD”)
`attribute`	Yes	The live data metric you want to retrieve (browse all)

Basic Examples

Get Current Price

=TICKERDATALIVE("AAPL", "Price")

=TICKERDATA.LIVE("AAPL", "Price")

Returns Apple’s current stock price.

Get Company Name

=TICKERDATALIVE("MSFT", "Company Name")

=TICKERDATA.LIVE("MSFT", "Company Name")

Returns “Microsoft Corporation”.

Get Market Cap

=TICKERDATALIVE("GOOGL", "Market Cap")

=TICKERDATA.LIVE("GOOGL", "Market Cap")

Returns Google’s current market capitalization.

Available Attributes

Attribute	Description	Example Output
Price	Current stock price	178.50
Beta	Stock volatility vs market	1.25
Average Volume	Average volume (formerly “Vol Avg”)	52,450,000
Market Cap	Total market capitalization	2,800,000,000,000
Last Dividend	Annual dividend per share (formerly “Dividend”)	0.96
Dividend Yield	Dividend as % of price	0.54%
365 Day Range	52-week high/low range	124.17 - 198.23
Company Name	Full company name	Apple Inc.
Currency	Trading currency	USD
ISIN	International securities ID	US0378331005
CUSIP	North American security ID	037833100
Exchange	Primary exchange	NASDAQ
Exchange Full Name	Full exchange name	NASDAQ Global Select
Industry	Company industry	Consumer Electronics
Sector	Company sector	Technology
Country	Headquarters country	US
Full Time Employees	Number of employees	164,000
Address	Company headquarters	One Apple Park Way
IPO Date	Initial public offering date	1980-12-12
Is Actively Trading	Trading status	TRUE

Info

The legacy "Exchange Short Name" attribute still works, but it now returns the full exchange name (e.g., "NASDAQ Global Select" instead of the short code "NASDAQ"). Use "Exchange Full Name" going forward, and update any formulas that compare against short codes like "NASDAQ" or "NYSE".

Tip

Looking for a live P/E ratio? Ask the historical function for `"Price To Earnings Ratio"` with `"ttm"` - the trailing-twelve-month P/E is pre-computed from the latest data.

Practical Examples

Building a Watchlist

Create a simple stock watchlist:

Stock	Price	Change	PE (TTM)
AAPL	`=TICKERDATALIVE("AAPL", "Price")=TICKERDATA.LIVE("AAPL", "Price")`	-	`=TICKERDATA("AAPL", "Price To Earnings Ratio", "ttm")=TICKERDATA.DATA("AAPL", "Price To Earnings Ratio", "ttm")`
MSFT	`=TICKERDATALIVE("MSFT", "Price")=TICKERDATA.LIVE("MSFT", "Price")`	-	`=TICKERDATA("MSFT", "Price To Earnings Ratio", "ttm")=TICKERDATA.DATA("MSFT", "Price To Earnings Ratio", "ttm")`
GOOGL	`=TICKERDATALIVE("GOOGL", "Price")=TICKERDATA.LIVE("GOOGL", "Price")`	-	`=TICKERDATA("GOOGL", "Price To Earnings Ratio", "ttm")=TICKERDATA.DATA("GOOGL", "Price To Earnings Ratio", "ttm")`

Company Information Card

One formula per field builds a profile card - company name, sector, industry, employee count, country:

=TICKERDATALIVE("NVDA", "Company Name")

=TICKERDATA.LIVE("NVDA", "Company Name")

Dividend Tracking

=TICKERDATALIVE("JNJ", "Last Dividend")

=TICKERDATA.LIVE("JNJ", "Last Dividend")

=TICKERDATALIVE("JNJ", "Dividend Yield")

=TICKERDATA.LIVE("JNJ", "Dividend Yield")

Valuation Quick Check

Combine a live price with TTM valuation ratios from the historical function:

=TICKERDATALIVE("AAPL", "Price")

=TICKERDATA.LIVE("AAPL", "Price")

=TICKERDATA("AAPL", "Price To Earnings Ratio", "ttm")

=TICKERDATA.DATA("AAPL", "Price To Earnings Ratio", "ttm")

Using with Different Asset Classes

US Stocks

Use the standard ticker symbol:

=TICKERDATALIVE("AAPL", "Price")

=TICKERDATA.LIVE("AAPL", "Price")

Cryptocurrency

Combine the coin symbol with the fiat currency code (no hyphen). Bitcoin in US dollars:

=TICKERDATALIVE("BTCUSD", "Price")

=TICKERDATA.LIVE("BTCUSD", "Price")

Warning

For crypto, you must combine the symbol with the currency. "BTC" alone will not work - use "BTCUSD".

International Stocks

Use exchange suffixes (similar to Yahoo Finance). LVMH on the Paris exchange:

=TICKERDATALIVE("MC.PA", "Price")

=TICKERDATA.LIVE("MC.PA", "Price")

See Ticker Symbols for the rest of the suffixes.

Data Refresh

TICKERDATALIVE data updates based on market conditions:

During market hours: Quote data updates in real-time when you refresh
After hours: Use dedicated after-hours endpoints for pre-market and post-market quotes
End of day (EOD): Historical data updates after market close

To manually refresh all data: Extensions → Tickerdata → Refresh.

Excel never re-runs these formulas on its own. Refresh from Home → Tickerdata → Refresh, or from the task pane - see Refreshing Data in Excel.

Info

Data refresh rates are the same across all subscription tiers. Tier differences only affect API rate limits and available endpoints.

Pro Tips

Use cell references for flexible watchlists, e.g. =TICKERDATALIVE(A1, "Price")=TICKERDATA.LIVE(A1, "Price")
Combine with TICKERDATA for comprehensive analysis - use TICKERDATALIVE for current data and TICKERDATA for historical comparisons
Check “Is Actively Trading” to verify a stock is still tradeable before building models around it

Common Errors

Error	Cause	Solution
`#VALUE!`	Invalid ticker format	Check ticker spelling and format (see asset class formatting above)
`#N/A`	Ticker not found	Verify the ticker exists and is supported
`Loading...` (Sheets) or `#BUSY!` (Excel)	Fetching data	Wait, or refresh from the Tickerdata menu

Attribute Explorer - Search all 200+ available attributes
TICKERDATA - For historical financial data and fundamentals