Thanks! That's really helpful. Could you modify yegle's example to include
a PnL/CapitalGains account? Are you suggesting I return principal to cash
but growth to a gains account on sale? If you could also clarify what you
mean by {} ambiguous matching syntax, I would really appreciate it.
On Tuesday, March 28, 2017 at 4:03:28 PM UTC-4, Jason Chu wrote:
>
> To better understand how inventories work, I highly recommend reading
> http://furius.ca/beancount/doc/booking. It explains why you have to
> select lots at all and the various booking methods you probably want to use.
>
> In addition, yegle's example is missing the PnL/CapitalGains account, so
> you'll actually return the wrong amount to your Roth account. The doc
> explains why.
>
> I have converted nearly every one of my sales to using the {} ambiguous
> matching syntax and I feel so much better for it.
>
> On Tue, Mar 28, 2017 at 12:08 PM yegle <[email protected] <javascript:>>
> wrote:
>
>> When you sell your holdings, you should specify which lot you want to
>> sell in the curly bracket. In your case, you should write the following.
>>
>>
>>
>> 2017-03-27 * "sell 20 shares of VGHCX"
>> Assets:Investments:Fidelity:Roth:VGHCX -20 VGHCX{200
>> USD} @205 USD
>> Assets:Investments:Fidelity:Roth
>>
>>
>> On Tue, Mar 28, 2017 at 12:04 PM, Andrew Sail <[email protected]
>> <javascript:>> wrote:
>>
>>> I'm receiving a strange error when trying to sell shares of an
>>> investment fund that I have previously purchased. Below is an example from
>>> my ledger, replaced with dummy data. In this example, I'm trying to buy 20
>>> shares of the fund at $200/each, funded from my main account, and then sell
>>> them at $205/each (the sale is obviously just for the sake of my
>>> understanding of how to use the tool).
>>>
>>> 2017-01-01 * "buy 20 shares of VGHCX"
>>> Assets:Investments:Fidelity:Roth:VGHCX 20 VGHCX{200
>>> USD}
>>> Assets:Investments:Fidelity:Roth -4000 USD
>>>
>>> 2017-03-27 * "sell 20 shares of VGHCX"
>>> Assets:Investments:Fidelity:Roth:VGHCX -20 VGHCX{205
>>> USD}
>>> Assets:Investments:Fidelity:Roth
>>>
>>> 2017-01-01 price VGHCX 200.00 USD
>>> 2017-03-27 price VGHCX 205.00 USD
>>>
>>> The error I receive is below.
>>>
>>> $ bean-check ledger.beancount
>>> /path/to/ledger.beancount:74: No position matches
>>> "Posting(account='Assets:Investments:Fidelity:Roth:VGHCX', units=-20 VGHCX,
>>> cost=CostSpec(number_per=Decimal('205.00'), number_total=None,
>>> currency='USD', date=None, label=None, merge=False), price=None, flag=None,
>>> meta={'filename': '/path/to/ledger.beancount', 'lineno': 75})" against
>>> balance (20 VGHCX {200 USD, 2017-01-01})
>>>
>>> This leads me to asking a few questions:
>>> 1) The obvious; what am I doing wrong? I simply want to sell the 20
>>> shares of VGHCX at $205/share that I own and return the funds as USD to my
>>> main account (cash).
>>> 2) If I remove the sale, only my principal shows on my ledger, my
>>> investment's growth is not shown as a part of my net worth; is this
>>> correct, or is there a deeper rooted issue?
>>> 3) Should reporting price in my ledger impact my net worth and if not,
>>> where in bean-web or fava should I be able to refer to my growth for
>>> further analysis?
>>>
>>> Thank you in advance for your help!
>>>
>>> --
>>> 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] <javascript:>.
>>> To post to this group, send email to [email protected]
>>> <javascript:>.
>>> To view this discussion on the web visit
>>> https://groups.google.com/d/msgid/beancount/2e046181-afad-4010-8df3-63b97d399a2a%40googlegroups.com
>>>
>>> <https://groups.google.com/d/msgid/beancount/2e046181-afad-4010-8df3-63b97d399a2a%40googlegroups.com?utm_medium=email&utm_source=footer>
>>> .
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>
>>
>> --
>> Yuchen Ying
>> https://about.me/yegle
>>
>> --
>> 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] <javascript:>.
>> To post to this group, send email to [email protected]
>> <javascript:>.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/beancount/CAFL5w3Xvrw96YYHYDOfFXyLK7daun9Enc7kYZjc9GVVvN7uwsg%40mail.gmail.com
>>
>> <https://groups.google.com/d/msgid/beancount/CAFL5w3Xvrw96YYHYDOfFXyLK7daun9Enc7kYZjc9GVVvN7uwsg%40mail.gmail.com?utm_medium=email&utm_source=footer>
>> .
>> For more options, visit https://groups.google.com/d/optout.
>>
>
--
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 post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/beancount/12a6c1c2-3a29-42df-b039-2a0131811ae7%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
