Hey all I got a math problem I am not sure how to put into a formula nor an

excel formula

here is the nature of the answer I need

lets say we have X priced at 100

every 1 it moves I will add 1 position

so at 101 it will add a position

102 another position

103 another

at the end of the day lets say the item closes at 106 and 106 is also the

high for the day

the profit should then be 106-100 + 105-100 etc etc

yielding a total profit of

6+5+4+3+2+1 = 21

anyone know how to encode this all into excel? hope I made sense

## Bookmarks