Forum Discussion

strikw's avatar
strikw
Icon for Helper I rankHelper I
7 years ago

Calculate Total Variation

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.

Need Help

2 Replies

    • strikw's avatar
      strikw
      Icon for Helper I rankHelper I
      7 years ago

      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