REquire a spreadsheet for calculating STCG or LTCG

#1
Hey guys,
I need a spreadsheet to calculate capital gains on shares..
Actually i hv a spreadsheet containing data like

Opening balance ( date,qty, rate etc.)
Purchase(date, qty, rate etc.),
Sale (date, qty, rate etc.)
Closing Balance (date, qty, rate etc.)
Then i need excel to calculate the gain inn diff columns STCG and LTCG...
and yes..this is diff.for diff.stocks...

Plz guys if anyone can help me on this...IDk anywhere to ask for help...if need more info get back to me at [email protected]

thanks
 

Similar threads