Sum of Digits of Index Closing Price

Widzo · 2021-04-28T14:20:33+00:00

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.

Viewing 4 posts - 1 through 4 (of 4 total)

Author

Posts
04/28/2021 at 3:20 PM #168293 quote

Widzo
Participant

Junior

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.

04/28/2021 at 3:55 PM #168298 quote
robertogozzi
Moderator

Legend
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
```
04/28/2021 at 4:01 PM #168299 quote

Widzo
Participant

Junior

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

robertogozzi thanked this post

04/28/2021 at 4:06 PM #168300 quote
robertogozzi
Moderator

Legend
The correct comment in line 7 is:
```
//save the new N (693)
```
Author

Posts