Skip to content

FIRST() Function

By Optuma Team · Updated 2019-06-18

The FIRST() function can be used to get the first value of a bar (closing value by default) or indicator (see also LAST() function).

For example, FIRST() in a watchlist column will return the closing value of the first bar of the data series.

FIRST(BARDATE()) will return the date of the first bar, which can be formatted as a Date column in a watchlist, ie February 8th 1984 for ANZ.

FIRST() Function Example

Choose which categories of cookies you allow. Strictly-necessary cookies are always on. You can change this any time via the "Cookie Settings" link in the footer.

  • Functional

    Remember preferences like dismissed banners and your dark-mode choice.

  • Analytics

    Help us understand how the site is used so we can improve it.

  • Marketing

    Measure our advertising and help us reach people who may be interested in Optuma.