Calculate Total Variation

[strikw]

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]

@strikw,

You may simply use SUMX Function.

[strikw]

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