Viren Bhanot wrote:
> ------=_Part_465578_1855231031.1755491538787
> Content-Type: multipart/alternative; 
>       boundary="----=_Part_465579_1569482801.1755491538787"
>
> ------=_Part_465579_1569482801.1755491538787
> Content-Type: text/plain; charset="UTF-8"
>
>
> I cannot understand how to actually *use* beancount to do *anything*. From 
> what I see, *bean-report* doesn't exist anymore, and certainly not in my 
> installation of beancount from AUR on Arch (btw).
>
> If I load my ledger into *fava*, I see some poorly-designed plots not 
> useful for analyses. I don't get the fuss. The plot area is too small, the 
> colours don't contrast well, the tooltips often goes off-screen, or covers 
> the plot so I cannot see where I am. Also, from what I can see, there is no 
> way to limit the plots to just 2023 or 2024 etc. The most useful view is 
> the Treemap of Expenses, but even their the text contrast is poor and I 
> can't seem to generate it year-by-year. The documentation also seems 
> non-existent.
>
> The act of actually wrangling ten years of financial data into beancount 
> was meditative, and a task I enjoyed thoroughly. But now what? How can I 
> answer questions like:
>
> * What is my net worth?
...


  hello,

  i ran across this one and repeately was cranky about it but
eventually found the solution i needed:

  $ alias netw='bean-query ledger.bc "SELECT convert(SUM(position),'\''USD'\'') 
as amount where account ~ '\''Assets|Liabilities'\''" | tail -1 | cut -d '\'' 
'\'' -f 2'

  which is my bashrc alias for netw, i use this several times
a day when i'm actively doing any beancount updates or i'm
trading.


  it can be simplified to:

   $ bean-query ledger.bc "SELECT convert(SUM(position),'\''USD'\'') as amount 
where account ~ '\''Assets|Liabilities'\''"


  the other one i use frequently are the current balances query:

  $ alias bal='bean-query \-f text ledger.bc "SELECT account, 
units(sum(position)) GROUP BY 1 ORDER BY 1" '

  from that i can grep for the specific item like:

  $ bal | grep PnL | grep <symbol> 


  i don't use fava as i don't like point and click types of
interfaces unless i really have to.

  as you've found out you can do range of date queries there
but i don't look at those kinds of things very often.

  and for FIRE i got fired long before that became popular.
Sept 1, 1996.  almost 30yrs ago already!  eek!  time sure goes
by quickly.


  fin

-- 
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 visit 
https://groups.google.com/d/msgid/beancount/o2qonl-bf5.ln1%40anthive.com.

Reply via email to