RE: Stupid question11 Aug 2019 22:43
The way I did it was to use simple excel formulas using the online microsoft help for the bits I couldnt figure out, its hard to otherwise explain on a bulletin board but I was just calculating weighted average but the was the formula I used to do the main calculation :- =AVERAGE(B2,B4) for the main average and =SUM(B2*C2, B3*C3, B4*C4)/SUM(C2:C4) for the weighted average.
Column A is number of shares
Colunm B is cost
Column c is percentage of holding (worked out in the normal way you would calculate percentage in excel ie Number of shares /Total shares as a percentage)