1. Getting Started
  2. Quick Start

Quick Start Guide

Get up and running with Tickerdata in minutes with your first stock data formula.

Your First Formula

Let’s fetch your first stock quote using Tickerdata. We’ll use the TICKERDATALIVE function to get the current price of Apple stock.

Select a Cell

Click on any empty cell in your Google Sheet where you want the stock price to appear.

Enter the Formula

Type the following formula:

=TICKERDATALIVE("AAPL", "Price")

Press Enter

Press Enter to execute the formula. You should see Apple’s current stock price appear in the cell.

Info

Make sure you're logged in to Tickerdata: Extensions > Tickerdata > Log in

Understanding the Result

The TICKERDATALIVE 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)
ParameterDescriptionExample
tickerStock symbol“AAPL”, “MSFT”, “BTCUSD”
attributeData point to retrieve“Price”, “Market Cap”, “PE”

Try More Examples

Here are a few more formulas to try:

=TICKERDATALIVE("AAPL", "Market Cap")      // Market capitalization
=TICKERDATALIVE("MSFT", "PE")              // Price to earnings ratio
=TICKERDATALIVE("GOOGL", "Dividend Yield") // Dividend yield
=TICKERDATALIVE("TSLA", "Sector")          // Company sector

Tip

Not sure which attributes are available? Browse all 200+ attributes with descriptions, examples, and use cases in the Attribute Explorer.

Cryptocurrency

For crypto, combine the symbol with the currency code:

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

International Stocks

For international stocks, use exchange suffixes:

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

Building a Simple Watchlist

Create a basic stock watchlist in just a few cells:

ABC
StockPricePE
AAPL=TICKERDATALIVE(A2, "Price")=TICKERDATALIVE(A2, "PE")
MSFT=TICKERDATALIVE(A3, "Price")=TICKERDATALIVE(A3, "PE")
GOOGL=TICKERDATALIVE(A4, "Price")=TICKERDATALIVE(A4, "PE")

Tip

Notice how we reference the ticker from column A instead of hardcoding it. This makes your spreadsheet more flexible and easier to maintain.

Handling Errors

Wrap your formulas in IFERROR to handle cases where data isn’t available:

=IFERROR(TICKERDATALIVE("AAPL", "Price"), "N/A")

Next Steps