In order to generate this you need to produce this as a side-effect of the booking process (which involves matching the incomplete posting spec to the inventory contents). I think I've wanted to make this part of the core - an important part I should say - but at the time I switched to building Johnny ( https://github.com/edgebips/johnny) for more sophisticated trading (options with adjustments to multiple legs) and never built it in. I documented this for the rewrite, as I think it's important: https://docs.google.com/document/d/1qPdNXaz5zuDQ8M9uoZFyyFis7hA0G55BEfhWhrVBsfc/edit#heading=h.1on91pqrb473
So right now, unfortunately no. On Tue, Jun 11, 2024 at 7:38 AM Peter <[email protected]> wrote: > Hey there, > > Is there a way to list a history of all lots for a given commodity? I am > using FiFo and I would like to create some sort of spreadsheet that lists > all lots with their buy date and sell date (if there is one). > > So, these transactions > > 2023-06-01 * "Buy shares" > Assets:Investments:Stocks 50 AAPL {300.00 USD} > Assets:Bank:Checking > > 2023-07-01 * "Buy shares" > Assets:Investments:Stocks 50 AAPL {400.00 USD} > Assets:Bank:Checking > > 2023-08-01 * "Buy shares" > Assets:Investments:Stocks 50 AAPL {500.00 USD} > Assets:Bank:Checking > > 2023-12-01 * "Sell shares" > Assets:Investments:Stocks -75 AAPL {500.00 USD} > Assets:Bank:Checking 37,500 USD > Income:Capital:Gains > > 2024-01-01 * "Sell shares" > Assets:Investments:Stocks -25 AAPL {500.00 USD} > Assets:Bank:Checking 12,500 USD > Income:Capital:Gains > Should become something like this: > > +-----------+------------+-----+-------+------------+-----+-------+--------+-----------------+--------------------------+ > | Commodity | Bought | Qty | Price | Sold | Qty | Price | PnL | Duration > (days) | Held more than 145 days? | > +-----------+------------+-----+-------+------------+-----+-------+--------+-----------------+--------------------------+ > | AAPL | 2023-06-01 | 50 | 300 | 2023-12-01 | 50 | 500 | 10,000 | 150 | Y | > +-----------+------------+-----+-------+------------+-----+-------+--------+-----------------+--------------------------+ > | AAPL | 2023-07-01 | 50 | 400 | 2023-12-01 | 25 | 500 | 5000 | 120 | N | > +-----------+------------+-----+-------+------------+-----+-------+--------+-----------------+--------------------------+ > | | | | | 2024-01-01 | 25 | 500 | 5000 | 150 | Y | > +-----------+------------+-----+-------+------------+-----+-------+--------+-----------------+--------------------------+ > | AAPL | 2023-08-01 | 50 | 500 | | | | | | | > +-----------+------------+-----+-------+------------+-----+-------+--------+-----------------+--------------------------+ > Is this possible? If so, how? > > Regards > > -- > You received this message because you are subscribed to the Google Groups > "Beancount" 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/beancount/2b279e0f-255e-4783-951c-6b53042fcd5dn%40googlegroups.com > <https://groups.google.com/d/msgid/beancount/2b279e0f-255e-4783-951c-6b53042fcd5dn%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "Beancount" 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/beancount/CAK21%2BhPg9Au1q2eb9pjN3dtw12C%3DaejG3Cghexdav4UnwSRfvA%40mail.gmail.com.
