Sum of Digits of Index Closing Price

• 04/28/2021 at 3:20 PM #168293
  Widzo

  I have been looking at the mathematical functions but unfortunately I cannot find the mathematical formula for sum of digits e.g. 6939 = 6+9+3+9 = 27

  For example, if I want to code the sum of digits for an index price re FTSE 100 at close, 6939, what will be the formula in code? Kindly help please.

  

  Widzo

  Participant

  Topics: 4

  Replies: 3

  Been thanked: 1 time
  04/28/2021 at 3:55 PM #168298
  robertogozzi

  There’s no built-in function to manipulate single digits.

  You can achieve that by a doing some divisions and multiplications by ten, then rounding the number to subtract the result from the original number to get the desired digit:

  N = 6939 //it can be CLOSE, ... etc or ROUND(CLOSE),... etc to make it an integer T = 0 //right to left WHILE N > 0 //exit the iteration when N = 0 x = round((N / 10) - 0.5) * 10 //get 693.9, then 693.0, then 6930 T = T + (N - x) //T = itself + 9 (actually 6939 - 6930) N = x / 10 //save the new N (6930) WEND //repeat for the next digit

  1 2 3 4 5 6 7 8

  N = 6939          //it can be CLOSE, ... etc or ROUND(CLOSE),... etc to make it an integer T = 0 //right to left WHILE N > 0                         //exit the iteration when N = 0    x = round((N / 10) - 0.5) * 10   //get 693.9, then 693.0, then 6930    T = T + (N - x)                  //T = itself + 9 (actually 6939 - 6930)    N = x / 10                       //save the new N (6930) WEND                                //repeat for the next digit

   

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 17188

  Been thanked: 4064 times
  04/28/2021 at 4:01 PM #168299
  Widzo

  Roberto, thanks for your prompt reply and this is really helpful.

   

  1 user thanked author for this post.

  robertogozzi

  

  Widzo

  Participant

  Topics: 4

  Replies: 3

  Been thanked: 1 time
  04/28/2021 at 4:06 PM #168300
  robertogozzi

  The correct comment in line 7 is:

  //save the new N (693)

  1	//save the new N (693)

   

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 17188

  Been thanked: 4064 times
• Author
  Posts