Hi.
For tax purposes for some mutual funds, I need to figure out the total cost
basis of the the units I have, along with the sale price, so that the total
cost minus total cost price of the units sold this year will be the capital
gain. In this example:
2016-04-01 * Buy MF 1
Assets 10 "MF1" @ 10.00 INR
MyBankAccount
2016-04-02 * Buy MF 2
Assets 20 "MF2" @ 12.00 INR
MyBankAccount
2016-05-01 * Buy MF 1
Assets 10 "MF1" @ 11.00 INR
MyBankAccount
2017-01-01 * Sell MF 1
Assets -10 "MF1" {10.00 INR} [2016-04-01] @ 13.00 INR
Assets -5 "MF1" {11.00 INR} [2016-05-01] @ 13.00 INR
CapitalGain -40.00 INR
MyBankAccount 195.00 INR
2017-01-01 * Sell MF 2
Assets -10 "MF2" {12.00 INR} [2016-04-02] @ 13.50 INR
CapitalGain -15.00 INR
MyBankAccount 135.00 INR
You can see that I've sold 15 MF1 units whose total cost is 10 * 10 + 5 *
11 = 155 INR, and the total sale price is 195, giving me a capital gain of
40.00 INR. Similarly, I've sold 10 MF2 units, so my cost is 120 INR and
sale value is 135.00 INR.
What I need is a query (or queries) that will take the above file and give
me the total cost price (i.e. 155 + 120 = 275 INR) and total sale price
(195 + 135 = 330 INR). How can I get these numbers? I've coded up a hackish
Python program, but since the information to infer these is present in the
posts, it would be nice to get it directly from ledger.
Thanks.
Kumar
--
---
You received this message because you are subscribed to the Google Groups
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
