On Tuesday, September 3, 2024 at 10:39:11 AM UTC+2 Chary Chary wrote:

On Monday, September 2, 2024 at 10:45:36 PM UTC+2 DK wrote:


 

Out of curiosity, how do you generate reports? I’ve seen you have variables 
in your reports. I have a bunch of queries saved in my beancount file, 
which I run with ‘bean-query .run’ but I’m looking for a way to generate 
more dynamic reports, potentially with variables, and even being able to 
manipulate the result of the reports (for example one report I miss is a 
monthly PnL with summary line, but it’s not possible to do it in one query 
without intermediate variables).


I use beancount from within jupyter notebook, where I do initial data 
extract using beanquery, but further manipulations (e.g. adding total 
value) in pandas.  This gives one exactly the flexibility you are looking 
for

*Here is example:*

https://colab.research.google.com/drive/1laDSOEdxMC2b9yo3zX8e-gxyomM5Zuqm?usp=sharing

*Here is more information*
https://github.com/isabekov/beancount-multiperiod-reports




This is actually better example

https://colab.research.google.com/drive/1DNmh9Jlos_LHIN2joGzs3-EKcKt6qzZr?usp=sharing

 

-- 
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/6ca1a575-345b-4281-b4d1-507d2d8681den%40googlegroups.com.

Reply via email to