Pre/Post Market

The prePostMarket function allows you to access the latest data on pre-market and post-market movements for US-based assets. A series of examples are provided below.

=SF(symbol, "prePostMarket", 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 "ask" or "ask&bid&timestamp". You can leave this blank or set it to "all" to output ALL available data. You can also chain together multiple ratios using the & operator, for example "ask&bid". See the list of available metrics below.

• options adjusts the formatting of the output. There is only one available option for prePostMarket. Set this field to "NH" for no header rows.

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

• Ask ("ask")

• Bid ("bid")

• Ask Size ("askSize")

• Bid Size ("bidSize")

• Volume ("volume")

• Timestamp ("timestamp")

Examples

Example 1 - All metrics

=SF("AAPL", "prePostMarket")

Example 2 - Specific metrics

=SF("AAPL", "prePostMarket", "ask&bid&timestamp")

Example 3 - Specific metrics and no header row

=SF("AAPL", "prePostMarket", "ask&bid&timestamp", "", "NH")

Example 4 - Single Metric

=SF("AAPL", "prePostMarket", "ask")

169.76