round down/up

• 07/23/2017 at 1:05 PM #41400
  tav

  How do you round down or up in prorealtime?

  

  tav

  Participant

  Topics: 7

  Replies: 8

  Been thanked: 0 times
  07/23/2017 at 2:45 PM #41415
  robertogozzi

  ROUND() rounds numbers to the nearest whole number, the documentation is a bit poor, since it shows only the rounding of 9.60.

  I tested this fake strategy (one buy instrution is necessary to be executed) with returns wit no addiotion, adding 0.9 and 0.4, both with positive and negative values, in case you want ALWAYS round to the greatest or to the smallest whole number:

  // returns // +0.0 +0.9 +0.4 //a = round(2.0 + 0.4) // 2 3 2 //b = round(2.4 + 0.4) // 2 3 3 //c = round(2.5 + 0.4) // 3 3 3 //d = round(2.6 + 0.4) // 3 3 3 //e = round(2.7 + 0.4) // 3 4 3 a = round(-2.0 + 0.4) // -2 -1 -2 b = round(-2.4 + 0.4) // -2 -2 -2 c = round(-2.5 + 0.4) // -3 -2 -2 d = round(-2.6 + 0.4) // -3 -2 -2 e = round(-2.7 + 0.4) // -3 -2 -2 GRAPH a AS "a" GRAPH b AS "b" GRAPH c AS "c" GRAPH d AS "d" GRAPH e AS "e" buy 1 contract at market

  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

  //                             returns //                       +0.0   +0.9   +0.4   //a = round(2.0 + 0.4) //  2      3      2 //b = round(2.4 + 0.4) //  2      3      3 //c = round(2.5 + 0.4) //  3      3      3 //d = round(2.6 + 0.4) //  3      3      3 //e = round(2.7 + 0.4) //  3      4      3   a = round(-2.0 + 0.4) //  -2     -1     -2 b = round(-2.4 + 0.4) //  -2     -2     -2 c = round(-2.5 + 0.4) //  -3     -2     -2 d = round(-2.6 + 0.4) //  -3     -2     -2 e = round(-2.7 + 0.4) //  -3     -2     -2   GRAPH a AS "a" GRAPH b AS "b" GRAPH c AS "c" GRAPH d AS "d" GRAPH e AS "e"   buy 1 contract at market

   

   

   

  2 users thanked author for this post.

  Antus, icharttop

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 16454

  Been thanked: 3636 times
  07/23/2017 at 2:54 PM #41420
  robertogozzi

  So, it appears that to ALWAYS round a number to the nearest greatest whole number you have to add 0.4 (both for positive and negative numbers).

  1 user thanked author for this post.

  Marius

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 16454

  Been thanked: 3636 times
  07/23/2017 at 3:02 PM #41425
  tav

  perfect thank you!

  

  tav

  Participant

  Topics: 7

  Replies: 8

  Been thanked: 0 times
  07/23/2017 at 4:29 PM #41430
  Nicolas

  By following the link, you can find a nice little code snippet made by Pepsmile that floor and ceil a number to the nearest one.

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20828

  Been thanked: 4738 times
  02/03/2020 at 2:35 PM #118575
  dupont_a

  Hello,
  I know this topic is old but it could be helps users like me who was affected by that issue.
  I would like to get only the integer without decimal, and without a round to superior integer when my value is above 0.5

  So I’ve created this code to get only the integer.

  n= decimal number IF round(n) > n then          // Round(n) should return 2 in case of n = 1.53.         // if 2 > 1.53 n = n - 0.5                   // We substract 0.5 to be in lower round decimal         // 1.53-0.5 = 1.03 n =  round(n)                 // We can make a round of the new n                      // round(1.03) = 1 ENDIF

  1 2 3 4 5 6

  n= decimal number   IF round(n) > n then          // Round(n) should return 2 in case of n = 1.53.         // if 2 > 1.53 n = n - 0.5                   // We substract 0.5 to be in lower round decimal         // 1.53-0.5 = 1.03 n =  round(n)                 // We can make a round of the new n                      // round(1.03) = 1 ENDIF

   

  Have fun 🙂

  1 user thanked author for this post.

  Sascha

  

  dupont_a

  Participant

  Topics: 2

  Replies: 8

  Been thanked: 1 time
  02/03/2020 at 2:44 PM #118576
  Nicolas

  Thank you @dupont_a , however there are now 2 new instructions in Prorealtime v11: floor and ceil

  In a future update, the ROUND instruction will also have the capability to handle digits, such as ROUND(close,2). I’m testing it and it works fine.

   

   

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20828

  Been thanked: 4738 times
  02/03/2020 at 2:59 PM #118579
  dupont_a

  Thx Nicolas, I’m still on v10.3.
  I’m glad to learn that PRT has solved that for new version 🙂

  PS : Sorry for haven’t use  “insert PRT code” button

  

  dupont_a

  Participant

  Topics: 2

  Replies: 8

  Been thanked: 1 time
  02/03/2020 at 5:52 PM #118596
  Vonasi

  dupont_a wrote:

  PS : Sorry for haven’t use  “insert PRT code” button

  I tidied it up ! )

  

  Vonasi

  Moderator

  Topics: 192

  Replies: 5088

  Been thanked: 1810 times
• Author
  Posts