SheetsFinance Docs
Quotes & Price change

Quotes

The quote data type delivers current pricing information on over 80,000 financial assets globally 🚀 This is the go-to function for your portfolios or watchlists. Real-time data is available for selected exchanges, see Available Markets for more information. The data is output as a single cell if fully specified or as a multi-cell array if multiple metrics are selected.

Note: The quote data type was formerly called realTime. Existing formulas that use "realTime" continue to work indefinitely and remain fully backward compatible.

=SF(symbol, "quote", metric, "", options)

  • symbol is the ticker symbol of the financial asset (e.g., "AAPL"). You can use our Symbol Search to find the correct ticker symbol. Check out the Quotes Batch function if you're after real-time data on up to 5,000 stocks at the same time!

  • metric selects what metrics to display (see options below), display all metrics by using "all". If this argument is omitted the function defaults to the current real-time price ("price"), see example 1 below. Chain together as many metrics as you'd like using &, e.g., "price&open&previousClose".

  • options adjusts the formatting of the output. There is currently only one available option for this data type. You can set this field to "NH" for no header row for a multi-cell output.

The quote function has the following metrics:

  • All ("all")

  • Current Price ("price")

  • Open ("open")

  • Previous Close ("previousClose")

  • Change ("change")

  • Change % ("changePercentage")

  • Day Low ("dayLow")

  • Day High ("dayHigh")

  • Volume ("volume")

  • Quote Timestamp ("timestamp")

  • Name ("name")

  • Exchange ("exchange")

  • Market Cap ("marketCap")

  • Year High ("yearHigh")

  • Year Low ("yearLow")

  • Price Avg 50 ("priceAvg50")

  • Price Avg 200 ("priceAvg200")

  • Avg Volume ("avgVolume") - Note: This is 3-month average volume

  • Earnings Announce Date ("earningsAnnouncement")

  • P/E Ratio ("pe")

  • EPS (ttm) ("eps")

  • Shares Outstanding ("sharesOutstanding")

Tip: If you're after a large amount of real-time data at once (e.g. in a watchlist) consider using our Quotes Batch functionality.

Examples

Example 1 - Current Price

Set the subtype to "price" for the current price quote for the stock, coin or ETF.

=SF("AAPL", "quote", "price")

125.43

Current price is the default return of the quote function so a faster way to get the same information is the neater:

=SF("AAPL")

125.43

Example 2 - Single metric

Set the subtype to a single metric, e.g. "open", for the day's opening price for the stock.

=SF("AAPL", "quote", "open")

127.82

Data is returned as a single-cell number.

Example 3 - Multiple metrics

Chain together metrics with the & operator to return multiple columns of data at once. A header row is included automatically. See example 5 for removing the header row.

=SF("AAPL", "quote", "price&previousClose&changePercentage&volume")

Example 4 - All metrics

Dump all available metrics into a multi-cell array. A header row is included automatically.

=SF("AAPL", "quote", "all")

Example 5 - Multiple metrics, no header row

Here we've added "NH" as the options argument to remove the header row. Note: The extra "" must be included as a placeholder for the preceding argument.

=SF("AAPL", "quote", "price&previousClose&changePercentage&volume", "", "NH")

Was this helpful?
Was this helpful?