TradingView
marketreaderz
15 déc. 2023 01:57

Math Round 

OANDA:XAUUSD5
GoldOANDA

Description

⋅
Hello Reader,
This is Observer from Vietnam.

PURPOSE
I'd like to share my script for Round Math, it's for only education purpose.

I make the formula math_row(x, y) to round the value as we design and shorten the number appearance (value). It's more flexible than str.tostring(close,format.volume) or others.

HOW TO USE
Formula math_row(x,y)
- x is the value which need to be rounded or shorten
- y is the number which you want to round after "." symbol.

***Shorten***
If x < 1.000, no shorten
If x >= 1.000 and x < 1.000.000, shorten to thousand value with "K" letter
If x >= 1.000.000 and x < 1.000.000.000, shorten to million value with "M" letter
If x >= 1.000.000.000, shorten to billion value with "B" letter

***Round***
If y = 0 => no round
If y = 1 => round to format ###.#
If y = 2 => round to format ###.##
If y = 3 => round to format ###.###
If y is other => round to default format of Tradingview

EXAMPLE
math_row(1.002342, 3) = 1.002
math_row(1923.321, 2) = 1.92K
math_row(221452133, 1) = 221.5M

Hope it useful and clear to you.

Notes de version

⋅
Update on Chart

Notes de version

⋅
Revise the format of value > 1B from ###.# to #,###.#
Other cases are unnecessary to revise.

Notes de version

⋅
Revise the name

Notes de version

⋅
Update formula for negative number
educationalroundshortennumber
Commentaires
marketreaderz
⋅
I'd like to update for logics as the following:

***Shorten***
If |x| < 1.000, no shorten
If |x| >= 1.000 and |x| < 1.000.000, shorten to thousand value with "K" letter
If |x| >= 1.000.000 and |x| < 1.000.000.000, shorten to million value with "M" letter
If |x| >= 1.000.000.000, shorten to billion value with "B" letter

|x| means the absolute value of "x"
Plus