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 ledger-cli+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/ledger-cli/70390e17-ab84-4fd1-942f-de95096081bbn%40googlegroups.com.