Calculate Total Variation

strikw · ‎10-24-2018

Hello

I would like to pick up the table within a period of one year and check day by day the price variation of the stock: opening price - closing price (this part I already made), now I need to add this calculation to see the annual variation, the way which I did only shows every day.

Thank you.

v-chuncz-msft · ‎10-25-2018

@strikw,

You may simply use SUMX Function.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

strikw · ‎10-25-2018

Hello,

I tried it and it did not work, I want it to take the closing price of the action on day 8 for example and show me the% variation in relation to the opening price on day 9, but with this formula, it only shows the variation of current day, and I want the variation from day to day.

https://imgur.com/a/sLJVbGV

.VPreçoDiaPosterior = ([.Fechamento]-[.Abertura])/[.Fechamento]*-1

Regards,

Paulo