18 Replies Latest reply: Dec 25, 2015 6:30 AM by PAUL YEO RSS

    How to compute Average Stock ( Base on Jan 2015 Open Stock )

    PAUL YEO

      Hi All

       

       

      I need to compute :-

       

       

      when at Jan 2015 , Average Stock = 1 ( 1+1)/2=1 , which is Jan Open Stock + Jan Close Stock.

       

       

      when at Feb 2015 , Average Stock = 1 ( 1+2)/2=1.5 , which is Jan Open Stock + Feb Close Stock.

       

       

      ..

      ..

       

       

      when at Dec 2015 , Average Stock = 1 ( 1+12)/2=6.5 , which is Jan Open Stock + Dec Close Stock.

       

       

      May i know how to do ?

       

       

      Now my result on Average Stock is wrong.

       

      Enclosed my QV Doc

       

       

      Paul