Ok,
thanks, it shows unrealized gains now for my case
[image: Unreal_fava.PNG]
Jus a few questions regarding this
1) Fava calculates unrealized gains only for things, which you track at
cost. And the things you track at cost are the things you are expected to
pay a capital gains on, and the things you pay a capital gains on is
determined by you local legislation.
So, affectively this is your local legislation which determines whether you
write like this
2024-01-01 price EUR 1.0 USD
2024-01-02 * "Opening balance "
Assets:EU:Bank 1000 EUR
Equity:Opening-Balances
Or like this
2024-01-02 * "Opening balance "
Assets:EU:Bank 1000 EUR { 1.00 USD}
Equity:Opening-Balances
Is my understanding correct?
2) In my case it calculated the unrealized gains correctly, but I could not
find any breakdown on how fava has calculated this.
Can I find any breakdown or Fava just calculates this under the hood and
gives you a final result?
I am just thinking, that in my example it was simple, but what about big
and complex ledger, would you not want to see the breakdown?
3) Is there any way to create such a Balance Sheet report for a specific
date in the past?
This report does seem to be symmetric.
If I now want to run it for EUR, it show some unrealized gains for EUR,
which I would not consider to be the case:
plugin "beancount.plugins.auto_accounts"
option "operating_currency" "EUR"
2024-01-01 price EUR 1.0 USD
2024-01-02 * "Opening balance "
Assets:EU:Bank 1000 EUR { 1.00 USD}
Equity:Opening-Balances
2024-02-01 price EUR 2 USD
[image: Unreal_fava_EUR.PNG]
On Sunday, September 8, 2024 at 6:35:20 PM UTC+2 Joshua Cabrera wrote:
> You have to book the USD cost of the EUR for it to calculate the
> gains/losses - see adjusted example below.
>
> plugin "beancount.plugins.auto_accounts"
>
> option "operating_currency" "USD"
>
> 2024-01-01 price EUR 1.0 USD
>
> 2024-01-02 * "Opening balance "
> Assets:EU:Bank 1000 EUR {{1000 USD}}
> Equity:Opening-Balances
>
> 2024-01-03 price EUR 2 USD
>
> [image: Screenshot 2024-09-08 113413.png]
> On Sunday, September 8, 2024 at 10:30:22 AM UTC-5 [email protected] wrote:
>
>> What is exactly the definition of the unrealized gains in fava in this
>> case? is it documented somewhere?
>>
>> For instance if I have a following simple ledger
>>
>> plugin "beancount.plugins.auto_accounts"
>>
>> option "operating_currency" "USD"
>>
>> 2024-01-01 price EUR 1.0 USD
>>
>> 2024-01-02 * "Opening balance "
>> Assets:EU:Bank 1000 EUR
>> Equity:Opening-Balances
>>
>> 2024-01-03 price EUR 2 USD
>>
>> Then I would expect, that on 3 January I have a 1000 USD of unrealized
>> gains due to EUR/USD change. But as far as I can see fava does not show
>> this.
>>
>> Am I missing something?
>>
>>
>> On Saturday, September 7, 2024 at 8:17:40 PM UTC+2 Joshua Cabrera wrote:
>>
>> If you use fava, you can view unrealized gains using the "at market
>> value" view in the balance sheet without any options or plugins in your
>> main.beancount file.
>>
>> Note: if you're wondering why my numbers look odd, I'm still working on
>> initializing my ledger.
>>
>> [image: Screenshot 2024-09-07 111916.png]
>>
>> On Friday, September 6, 2024 at 10:09:42 AM UTC-5 [email protected] wrote:
>>
>> - this plugin is gone
>> - make sure you have recent price declarations
>> - compute it using beanquery sql or a script
>>
>>
>> On Fri, Sep 6, 2024, 10:59 Dennis <[email protected]> wrote:
>>
>> Hello everyone,
>>
>> I just tracked all my ETF purchases over the last years and wanted to see
>> my unrealized gains.
>>
>> The documentation suggests to use a plugin:
>>
>> plugin "beancount.plugins.unrealized" "Unrealized"
>>
>> source:
>> https://beancount.github.io/docs/trading_with_beancount.html#reporting-unrealized-pl
>>
>> However, that plugin doesn't exist anymore. Is there an alternative?
>>
>> Note, I'm using Beancount v3 as it was suggested to be used by new users
>> in another mail thread here.
>>
>> Best,
>> Dennis
>>
>> --
>> 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/d73c920e-6219-41f0-ba9f-7f84eec07f93n%40googlegroups.com
>>
>> <https://groups.google.com/d/msgid/beancount/d73c920e-6219-41f0-ba9f-7f84eec07f93n%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/58f89526-82bf-4cc8-abf2-9ffbf715a04fn%40googlegroups.com.
