It looks like you will need to group (or to link) postings by *lot*, but I
also couldn't find how to extract *lot *information in beanquery
On Tuesday, June 11, 2024 at 1:38:08 PM UTC+2 Peter 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 beancount+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/beancount/64a9defc-421b-4cd1-b48f-4bd3ec1ec3d9n%40googlegroups.com.
