Skip to content

Floor Function

By Optuma Team · Updated 2019-04-15

The FLOOR() function can be used to round a value down to the nearest integer. For example, to round down the 22 day standard deviation of the close:

FLOOR(STD(CLOSE(), BARS=22))

This is how it compares without the Floor function. Values above 2 are rounded down to 2, above 1 rounded down to 1, and below 1 is zero:

Floor 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.