Use Excel to Calculate Gain/Loss and Weighted Average of Stock Investments

[@robertjennings5558]

That was a great video. The best explanation I've encountered. Thanks for sharing.

[@FFFF-td2hl]

I need a formula for weighted average gain in a row instead of only 3 stocks= =

[@jamesperry3837]

Hey that was pretty cool. Thanks for sharing.

[@gustavdippenaar5150]

HI there how do you do the gain/loss for a whole year with monthly updates? thanks

[@yajama3]

Can u explain this one? Sales: 6/5/12 sold 25 shares of ABC stock for $700... On 9/5/12 sold 25 shares of ABC stock for $500 ... Purchases: on 6/5/10 bought 10 shares ABC stock for $150... 7/5/10 bght 20 shares of ABC stock $250... 8/5/10 bght 15 shares ABC stock $225 ... 8/7/10 bght 5 shares ABC stock $100 and I suppose to pair it in group of (15) to find the Capital Gain/Loss?

[@SuperSweetLevres]

very helpful, thank you!

[@julesboss79]

well i have 40 lines, do you expect me do to them one by one.....

[@dopeynoi1420]

copy paste

[@SynxS]

Let's try this with a student loan budget, shall we !

[@HarrySoon08]

I use MarketXLS for this. It worked great for me.

[@cirrjuchavz5639]

What about the tax and commissions?

[@WildineS]

Thank youuuuuuu

[@rodaneroach8821]

Thank you your a life saver