Pre/Post Market
πΊπΈ Important: Pre/Post market data is only available for US markets.
The prePostMarketQuote function returns the latest pre-market and post-market quote data for US-based assets. Examples are provided below.
=SF(symbol, "prePostMarketQuote", metrics, "", options)symbolis the ticker symbol of the financial asset (e.g.,"AAPL"). You can use our Symbol Search to find the correct ticker symbol.metricsis the specific data you're after, for example"askPrice". 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. See the list of available metrics below.optionsadjusts the formatting of the output. There is only one available option forprePostMarketQuote. Set this field to"NH"for no header rows.
The prePostMarketQuote data type has the following metrics to select from:
Ask Price (
"askPrice")Bid Price (
"bidPrice")Ask Size (
"askSize")Bid Size (
"bidSize")Volume (
"volume")Timestamp (
"timestamp")
Formulas written with the earlier prePostMarket name still work and return the same quote data.
Real-time data, refreshed on demand: Pre/Post Market returns 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.
Examples
Example 1 - All metrics
=SF("AAPL", "prePostMarketQuote")
Example 2 - Specific metric
=SF("AAPL", "prePostMarketQuote", "bidPrice")
Example 3 - All metrics with no header row
=SF("AAPL", "prePostMarketQuote", "all", "", "NH")
Example 4 - Single Metric
=SF("AAPL", "prePostMarketQuote", "askPrice")
169.76