On Tue, Dec 19, 2023 at 12:30 PM Damien R. <[email protected]> wrote:
> Le mardi 19 décembre 2023 à 09:02:46 UTC-5, [email protected] a écrit : > > On Tue, Dec 19, 2023 at 8:54 AM Damien R. <[email protected]> wrote: > > Le lundi 18 décembre 2023 à 22:03:43 UTC-5, [email protected] a écrit : > > On Mon, Dec 18, 2023 at 9:25 PM Damien R. <[email protected]> wrote: > > Thank you! It seems pretty obvious now... sorry for the dumb question! > > > There are no dumb questions. Nothing to feel sorry about. > > > > If they had decided to sell only 50% of the commodity, what would have > been the best way to handle it in my ledger? Use a total match to sell > everything and buy back 50% of that commodity? > > > No. > You would have declared selling -3151.6173/2 units of COMMA @ 9.361 CAD, > the cash would be correspondingly half, and the inferred P/L would be half > as well. > > > I did a few tries and when selling only part of the commodity, I get > "ambiguous matches". I get that if I don't specify the cost basis beancount > is not able to match the lot I want to sale, so I really don't know how I > would write "sell 1000 COMMA, get 9361 in cash" in the context of a mutual > fund. > > > Can you run "bean-doctor context" around that transaction? It's possible > I put a heuristic on the total amount to be matched. > > > Here goes. I've shortened the list of balances before and after > transaction, lists were essentially the sames. > Yeah, that makes sense. Which ones do you want to sell? It doesn't know. You'd have to select the particular postings you want to sell (the "specific lot identification method"). That, or give that account a booking method, like FIFO or LIFO, and then it'll do it for you. > > bean-doctor context accounts/broker/broker.beancount 2108 > ** Transaction Id -------------------------------- > > Hash:d9b1a802839532df6ff5a7fa90f3d538 > Location: accounts/broker/broker.beancount:2108 > > > ** Balances before transaction -------------------------------- > > Assets:CA:Broker:COMMA 5.3522 COMMA {9.342 CAD, 2018-03-15} > Assets:CA:Broker:COMMA 1.1888 COMMA {9.337 CAD, 2018-03-28} > [...] > Assets:CA:Broker:COMMA 16.0548 COMMA {9.343 CAD, 2023-05-16} > Assets:CA:Broker:COMMA 9.5853 COMMA {9.333 CAD, 2023-05-30} > > Assets:CA:Broker:Cash -10000.00 > CAD > > Income:CA:Broker:PnL > > > ** Unbooked Transaction -------------------------------- > > 2023-06-21 * "Selling COMMA" > Assets:CA:Broker:COMMA -1000.0000 COMMA {} @ 9.361 CAD ; > Assets:CA:Broker:Cash 9361.00 CAD ; 9361 CAD > Income:CA:Broker:PnL ; > > > ** Transaction -------------------------------- > > 2023-06-21 * "Selling COMMA" > > > ** Residual and Tolerances -------------------------------- > > > > ** Balances after transaction -------------------------------- > > Assets:CA:Broker:COMMA 5.3522 COMMA {9.342 CAD, 2018-03-15} > Assets:CA:Broker:COMMA 1.1888 COMMA {9.337 CAD, 2018-03-28} > [...] > Assets:CA:Broker:COMMA 16.0548 COMMA {9.343 CAD, 2023-05-16} > Assets:CA:Broker:COMMA 9.5853 COMMA {9.333 CAD, 2023-05-30} > > Assets:CA:Broker:Cash -10000.00 > CAD > > Income:CA:Broker:PnL > > > > > Le lundi 18 décembre 2023 à 20:59:53 UTC-5, [email protected] a écrit : > > When you sell something you need to account for P/L. > You're missing an account posting for that P/L, the amount of which can be > left to be automatically calculated by Beancount, for that $124.46 > > On Mon, Dec 18, 2023 at 8:57 PM Damien R. <[email protected]> wrote: > > Hi, > > I have an investment in a mutual fund that has been converted from one > commodity to another. I'm trying to represent that in my ledger with a sale > of the first commodity (it's a total match sale as everything is sold) and > then a buy of the second one (that's how it appears on the statement): > > 2023-06-21 * "Selling Commodity A" > Assets:CA:Broker:COMMA -3151.6173 COMMA {} @ 9.361 CAD > Assets:CA:Broker:Cash 29502.29 CAD > > Bean-check gives the following error: > > Transaction does not balance: (124.4641276 CAD) > > I tried changing the tolerance for that commodity to 0.0001 but no luck > with that. Any idea what is going on and what I should to to address it? > > As I'm dealing with mutual fund issues right now, I'll piggy back on my > first question and ask what's the state of the average booking method? From > my understanding it's still not supported and from the documentation I > couldn't find how I should deal with partial sales, if I want to sale 50% > of one commodity for instance. > > > Thanks, > Damien > > -- > 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/88cc74be-3d56-4ab5-964a-53689d988663n%40googlegroups.com > <https://groups.google.com/d/msgid/beancount/88cc74be-3d56-4ab5-964a-53689d988663n%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/ffcaac38-5c91-4c9f-a1b7-ddc695bf5886n%40googlegroups.com > <https://groups.google.com/d/msgid/beancount/ffcaac38-5c91-4c9f-a1b7-ddc695bf5886n%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/5e1ea8e6-01b5-4fed-8e8c-59c227fe6732n%40googlegroups.com > <https://groups.google.com/d/msgid/beancount/5e1ea8e6-01b5-4fed-8e8c-59c227fe6732n%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/6ebd4d42-06c0-49a7-b239-970cd5beb3e2n%40googlegroups.com > <https://groups.google.com/d/msgid/beancount/6ebd4d42-06c0-49a7-b239-970cd5beb3e2n%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%2BhM-Ubc%3DYg7%2BWCgjxs%3DLjEGD3ju5xm2L4Yo0axMXoOS29A%40mail.gmail.com.
