SheetsFinance Docs
Quotes & Price change

Pre/Post Market Trades

🇺🇸 Important: Pre/Post market data is only available for US markets.

The prePostMarketTrade function returns the latest pre-market and post-market trade for US-based assets: the trade price, trade size, and timestamp.

=SF(symbol, "prePostMarketTrade", metrics, "", 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.

  • metrics is the specific data you're after, for example "price". You can leave this blank or set it to "all" to output ALL available data. You can also chain together multiple metrics using the & operator.

  • options adjusts the formatting of the output. Set this field to "NH" for no header rows.

The prePostMarketTrade data type has the following metrics to select from:

  • Price ("price")

  • Trade Size ("tradeSize")

  • Timestamp ("timestamp")

Real-time data, refreshed on demand: Pre/post market trades return real-time data. Run Refresh Real-time from the SheetsFinance menu to reload your pre/post formulas and pull the latest values from the data service; Refresh All reloads every SheetsFinance formula in the sheet instead.

Batch: trades for a range of symbols

prePostMarketTrade also works in batch format: pass a range of cells instead of a single symbol. See Pre/Post Market Trades Batch.

Was this helpful?
Was this helpful?