Report changes in market value of portfolio
Balint
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')