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.

Syntax

=TICKERDATALIVE(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")

Returns Apple’s current stock price.

Get Company Name

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

Returns “Microsoft Corporation”.

Get Market Cap

=TICKERDATALIVE("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
Vol Avg	Average trading volume	52,450,000
Market Cap	Total market capitalization	2,800,000,000,000
Dividend	Annual dividend per share	0.96
Dividend Yield	Dividend as % of price	0.54%
PE	Price to earnings ratio	28.5
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 Short Name	Exchange abbreviation	NASDAQ
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
DCF	Discounted cash flow value	150.25
DCF Diff	DCF vs current price diff	-15.2%
IPO Date	Initial public offering date	1980-12-12
Is Actively Trading	Trading status	TRUE

Tip

The "DCF" and "DCF Diff" attributes are great for quick valuation checks - compare the calculated intrinsic value to the current price.

Practical Examples

Building a Watchlist

Create a simple stock watchlist:

Stock	Price	Change	PE
AAPL	`=TICKERDATALIVE("AAPL", "Price")`	-	`=TICKERDATALIVE("AAPL", "PE")`
MSFT	`=TICKERDATALIVE("MSFT", "Price")`	-	`=TICKERDATALIVE("MSFT", "PE")`
GOOGL	`=TICKERDATALIVE("GOOGL", "Price")`	-	`=TICKERDATALIVE("GOOGL", "PE")`

Company Information Card

=TICKERDATALIVE("NVDA", "Company Name")    // NVIDIA Corporation
=TICKERDATALIVE("NVDA", "Sector")          // Technology
=TICKERDATALIVE("NVDA", "Industry")        // Semiconductors
=TICKERDATALIVE("NVDA", "Full Time Employees")  // 29,600
=TICKERDATALIVE("NVDA", "Country")         // US

Dividend Tracking

=TICKERDATALIVE("JNJ", "Dividend")        // Annual dividend
=TICKERDATALIVE("JNJ", "Dividend Yield")  // Yield percentage

Valuation Quick Check

=TICKERDATALIVE("AAPL", "Price")     // Current price
=TICKERDATALIVE("AAPL", "DCF")       // Intrinsic value estimate
=TICKERDATALIVE("AAPL", "DCF Diff")  // Over/undervalued %

Using with Different Asset Classes

US Stocks

Use the standard ticker symbol:

=TICKERDATALIVE("AAPL", "Price")
=TICKERDATALIVE("TSLA", "Market Cap")

Cryptocurrency

Combine the coin symbol with the fiat currency code (no hyphen):

=TICKERDATALIVE("BTCUSD", "Price")   // Bitcoin in USD
=TICKERDATALIVE("ETHUSD", "Price")   // Ethereum in USD
=TICKERDATALIVE("SOLUSD", "Price")   // Solana in USD

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):

=TICKERDATALIVE("MC.PA", "Price")        // LVMH on Paris exchange
=TICKERDATALIVE("RELIANCE.NS", "Price")  // Reliance on NSE India
=TICKERDATALIVE("7203.T", "Price")       // Toyota on Tokyo exchange
=TICKERDATALIVE("SHOP.TO", "Price")      // Shopify on Toronto exchange

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

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:
```
=TICKERDATALIVE(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...`	Fetching data	Wait or refresh via Extensions > Tickerdata > Refresh

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