Pre/Post Market Batch
πΊπΈ Important: Pre/Post market data is only available for US markets.
The prePostMarketQuote function can also be used in a batch format to access multiple stocks at the same time. Use this to track pre and post market movements of hundreds to thousands of stocks at the same time. Batch ranges support up to 5,000 symbols.
=SF(<range>, "prePostMarketQuote", metrics, "", options)<range>is a range of cells e.g.A1:A100. You can use our Symbol Search to find the correct ticker symbols.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.
HOT TIPS:
Use the options parameter to remove the header row.
IMPORTANT: Pre and post market data is currently only available for US equities.
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.
Examples
Example 1 - Batch all metrics
=SF(A1:A30, "prePostMarketQuote")
Example 2 - Batch specific metric
=SF(A1:A30, "prePostMarketQuote", "bidPrice")