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