Per-asset-class asset net worth split over time

[Denis I]

Hi all,

a beancount newbie here. Given that I have a standard assets accounts 
structure:
- Assets:BankA:Checking EUR
- Assets:BankB:Checking USD
- Assets:BrokerA:APPL APPL
- Assets:BrokerA:GOOG GOOG
- Assets:BrokerA:... (more shares, some potentially sold and closed)
- Assets:BrokerB:RSU
- Assets:Pension CHF

Is there a way to build a *monthly* graph that'd show *EUR* *market values*:
- a line per each bank account
- a *single line per broker* - e.g. Assets:BrokerA and Assets:BrokerB
- a line for Assets:Pension
- (optionally) a line for total assets
 
What I tried:

1. Looking at extensions 
like fava-dashboards, fava-portfolio-returns, fava_investor, beangrow - 
these seem to offer either point-in-time asset allocation structure or a 
single portfolio over time graph.

2. Custom query similar to `SELECT year, month, root(account, 2) as 
account, convert(units(sum(position)), "USD") AS Market WHERE account ~ 
"Assets:"` - the results do not sum up to the fava balancesheet report - I 
think that in that case postings contribute only to the respective months 
when they were done - which is not a full balance at a given month.

3. Hacking fava code - the "at market value" backend call returns 
aggregated  tuples, one could try to create fake 
currencies like BrokerAUSD, but that'd require providing an explicit price 
information for these (tying them to USD would aggregete them to USD in the 
graph)

At this point I suspect that such a graph does not make sense or not useful 
for some (yet unknown to me) reason. My naive goal with such over-time 
asset group allocation is to understand what contributed to the 
growth/decline of my net assets over time - be it passive savings, 
passive/active investments or etc. Is there a better way to achieve that?


-- 
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/272d5131-c61b-4913-ae95-29480a4be193n%40googlegroups.com.

Re: Additional cookbooks?

[Daniel Schonfeld]

Fair enough! But is the taxes section ready? it says in the existing 
cookbook that's coming soon...

On Sunday, August 27, 2023 at 10:16:22 AM UTC-4 Martin Blais wrote:

> What's there is all we got.
>
>
> On Wed, Aug 16, 2023 at 5:33 PM Daniel Schonfeld  
> wrote:
>
>> Hello,
>>
>> I was wondering if the Taxes part of the cookbook has ever been completed 
>> and also if there's a similar cookbook for how to run a typical small 
>> business operation(s) as well as the owner entries for putting money into 
>> the business and taking distributions from it.
>>
>> Thanks!
>>
>> -- 
>> 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+...@googlegroups.com.
>> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/beancount/bec8b9b5-632a-4ddc-8a8d-a7b6814d0242n%40googlegroups.com
>>  
>> 
>> .
>>
>

-- 
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/322c82e0-be05-466b-885d-32b27c7b1be9n%40googlegroups.com.

Re: bean-query get last balance assertion

[Red S]

Actually, I’d been wanting this for a long time, so I just wrote it up. It’s 
here . Install via 
pip: pip3 install beancount-reds-importers, and then run bean-download 
needs-update --help

You can also simply download this single file 

 
and run it, though I’m not sure if I’ll support that in the future.

I'll write more about it in a separate post soon.
​
On Saturday, August 26, 2023 at 7:05:46 PM UTC-7 Red S wrote:

If you're handy with some scripting, it's fairly trivial to do that. You 
can adapt Fava's code that's here 

 to 
run on the shell.

On Saturday, August 26, 2023 at 5:59:05 PM UTC-7 Tim Legg wrote:

Ah, I was hoping to find a way to do it through bean-query when I'm on my 
hp stream which struggles with fava sometimes. But this works, thanks!

On Thursday, August 24, 2023 at 5:59:33 PM UTC-4 Red S wrote:

There is also a "copy balance directives" button in Fava's statistics page 
that I believe does exactly what you want.

It used to work, but I just checked, and it doesn't work on my current 
version. Perhaps it's been fixed, or needs someone to file a bug.

On Thursday, August 24, 2023 at 2:57:56 PM UTC-7 Red S wrote:

I don't know if there's a way to get it through bean-query. If you use 
Fava, it does precisely this in the feature below.

Up-to-date indicators

Fava offers colored indicators that can help you keep your accounts 
up-to-date. They are shown next to accounts that have the metadata 
fava-uptodate-indication: 
TRUE set on their Open directive. The colors have the following meaning:

   - green: The last entry for this account is a balance check that passed.
   - red: The last entry is a balance check that failed.
   - yellow: The last entry is not a balance check.

In addition, a grey dot will be shown if the account has not been updated 
in a while, as configured by the uptodate-indicator-grey-lookback-days
 option.

On Thursday, August 24, 2023 at 10:25:54 AM UTC-7 Tim Legg wrote:

Is there a bean-query or another way to list the last balance assertion for 
all or a given account?

I tend to let my accounts get stale and like a way to ask.. when was the 
last time I verified this account or all account balances.

-- 
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/883a0380-ac07-45b8-b28f-cfb6383a9138n%40googlegroups.com.

New, small utility: find out how recently each account was updated

[Red S]

bean-download is a downloader 
 that 
ships with beancount-reds-importers 
 that you can 
configure to run arbitrary commands to download your account statements. It 
now has a new feature: the needs-update subcommand.

It is helpful to know what accounts you haven’t updated in a while in your 
journal. bean-download needs-update shows a list of accounts needing 
updates, and the date of the last update (which is defined as the date of 
the last balance assertion on the account).

Install via pip3 install beancount-reds-importers.

You can filter accounts via its configuration. It handles commodity leaf 
accounts. 

*Full article is here 
*
.

Example output:
$ bean-download needs-update Last Updated Account -- 
- 2023-07-22 
Assets:Banks:MainOne 2023-02-05 
Assets:Gift-Cards-and-Credits:Amazon-com-Gift-Cards 
​

-- 
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/079a1416-6181-4562-9897-a5dab9871d55n%40googlegroups.com.

New, small utility: find out how recently each account was updated

[Red S]

It is helpful to know what accounts you haven’t updated in a while in your 
journal. bean-download is a downloader 
 that 
ships with beancount-reds-importers 
. It now has a new 
feature: bean-download needs-update shows a list of accounts needing 
updates, and the date of the last update (which is defined as the date of 
the last balance assertion on the account).

Installation: pip3 install beancount-reds-importers.

You can filter accounts via its configuration. It handles commodity leaf 
accounts. 

*Full article is here 
.*

Example output:
$ bean-download needs-update Last Updated Account -- 
- 2023-07-22 
Assets:Banks:MainOne 2023-02-05 
Assets:Gift-Cards-and-Credits:Amazon-com-Gift-Cards 
​

-- 
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/8cba13f5-4a36-4fce-99d0-c7911006b309n%40googlegroups.com.