Pre/Post Market Trades Batch
πΊπΈ Important: Pre/Post market data is only available for US markets.
The prePostMarketTrade function can also be used in a batch format to access multiple stocks at the same time. Use this to track the latest pre and post market trades of hundreds to thousands of stocks at the same time. Batch ranges support up to 5,000 symbols.
=SF(<range>, "prePostMarketTrade", 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"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.optionsadjusts the formatting of the output. Set this field to"NH"for no header rows.
HOT TIPS:
Use the options parameter to remove the header row.
The prePostMarketTrade data type has the following metrics to select from:
Price (
"price")Trade Size (
"tradeSize")Timestamp (
"timestamp")
Examples
Example 1 - Batch all metrics
=SF(A1:A30, "prePostMarketTrade")Example 2 - Batch specific metric
=SF(A1:A30, "prePostMarketTrade", "price")