anilbaheti
New Member
Hi
I am attaching a template, wherein I can calculate average cost in first block, which in reality does not matches with actual average due to FIFO concept applied when selling a share/stock. I am unable to figure out how to get to the actual average cost.
Appreciate if someone can help on this template.
PS: I did go through below link, it does not matches with average and the template requires buy and sell to be two different block.
Regards
Anil
I am attaching a template, wherein I can calculate average cost in first block, which in reality does not matches with actual average due to FIFO concept applied when selling a share/stock. I am unable to figure out how to get to the actual average cost.
Appreciate if someone can help on this template.
PS: I did go through below link, it does not matches with average and the template requires buy and sell to be two different block.
How to get average cost of remaining (unsold) stock?
Here is my excel sheet having buying details on the left and the selling details on the right. A2 is the total buying average. I2 is the total selling average. E2 is the remaining Stock. E4 is the Cell where I need to get the desired result of average cost of remaining (unsold) stock. I have...
chandoo.org
Regards
Anil
Attachments

12.1 KB Views: 6