Hi,
I'd like to track the changes in the market value of an equity portfolio on
a monthly basis as part of one of my recurring reports.
I struggle to get the results from the ~reg --monthly~ reports
Example ledger file including the market prices:
D 9,999,999.99 USD
P 2020-07-15 STOCK 107 USD
P 2020-08-01 STOCK 110 USD
P 2020-09-01 STOCK 105 USD
P 2020-10-01 STOCK 109 USD
2020/07/01 * Test
Expenses:Irregular:Investment -1000 USD
Equity 10 STOCK @ USD 100
The following two commands works, but don't do the monthly groupings
ledger reg Equity --market
ledger reg Equity -X USD
2020-07-01 Test Equity
1,000.00 USD 1,000.00 USD
2020-07-15 Commodities revalued <Revalued>
70.00 USD 1,070.00 USD
2020-08-01 Commodities revalued <Revalued>
30.00 USD 1,100.00 USD
2020-09-01 Commodities revalued <Revalued>
-50.00 USD 1,050.00 USD
2020-10-01 Commodities revalued <Revalued>
40.00 USD 1,090.00 USD
However when I add the --monthly flag the <Revalued> transactions disappear
(also without the --collapse)
ledger reg Equity -X USD --monthly --collapse
2020-07-01 - 2020-07-31 Equity
1,070.00 USD 1,070.00 USD
What I'd like to get :
2020-07-01 - 2020-07-31 Equity
1,070.00 USD 1,070.00 USD
2020-08-01 - 2020-08-31 ??
30.00 USD 1,100.00 USD
2020-09-01 - 2020-09-30 ??
-50.00 USD 1,050.00 USD
2020-10-01 - 2020-10-31 ??
40.00 USD 1,090.00 USD
I also tried including the VALUE property on the initial transaction, or
via an automated transaction on all Equity transactions with no luck (this
didn't seem to work at all).
; VALUE:: market(amount, date, 'USD')
Cheers,
Balint
--
---
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].
To view this discussion on the web visit
https://groups.google.com/d/msgid/ledger-cli/70390e17-ab84-4fd1-942f-de95096081bbn%40googlegroups.com.
