sqrt

Description

Returns the square root of a number.

Syntax

Like many functions in DataPrime, sqrt supports two notations, function and method notation. These interchangeable forms allow flexibility in how you structure expressions.

sqrt(number: number): number

(number: number).sqrt(): number

Arguments

Example

Use case: Compute rate of return over 2 years

Calculate the rate of return for an asset purchase and sale by taking the square root of the price ratio and subtracting 1.

Example data

{
    "buyer": "Chris",
    "asset": "DataDog",
    "bought_at_price": 100,
    "sold_at_price": 10
}

Example query

create ror from (sqrt(sold_at_price / bought_at_price) - 1)

create ror from ((sold_at_price / bought_at_price).sqrt() - 1)

Example output

{
    "buyer": "Chris",
    "asset": "DataDog",
    "bought_at_price": 100,
    "sold_at_price": 10,
    "ror": -0.683772233983162
}