Re: Closing multiple accounts in one shot.

2023-03-12 Thread Martin Blais
Nice plugin! Should be part of the core. On Sun, Mar 12, 2023 at 4:18 PM Stefano Mihai Canta wrote: > Actually, yes. > > > https://github.com/redstreet/beancount_reds_plugins/tree/main/beancount_reds_plugins/autoclose_tree#readme > > On Sun, Mar 12, 2023, 11:48 Martin Blais wrote: > >> No.

Custom dashboards in Fava

2023-03-12 Thread Andreas Gerstmayr
Hi everyone, I've written a new Fava extension which may be of interest to some of you interested in additional Fava charts. It allows creating custom dashboards in Fava, combining Beancount queries and Apache ECharts. The dashboards are defined in a `dashboards.yaml` configuration file,

Re: Closing multiple accounts in one shot.

2023-03-12 Thread Stefano Mihai Canta
Actually, yes. https://github.com/redstreet/beancount_reds_plugins/tree/main/beancount_reds_plugins/autoclose_tree#readme On Sun, Mar 12, 2023, 11:48 Martin Blais wrote: > No. > > On Sun, Mar 12, 2023 at 10:02 AM Bman Q wrote: > >> Title, i have 20+ accounts i want to close >> >> 2018-04-01

Re: Aggregate accounts on income statement

2023-03-12 Thread Daniel González
Char, That is a great resource! Thanks for sharing. I will look into that for more customized reports than what I can get with Fava. Dan, Thanks! That works perfectly for me, given how I have my Expense accounts structured On Sunday, March 12, 2023 at 7:23:23 AM UTC-7 dan...@grinta.net wrote:

Re: Closing multiple accounts in one shot.

2023-03-12 Thread Martin Blais
No. On Sun, Mar 12, 2023 at 10:02 AM Bman Q wrote: > Title, i have 20+ accounts i want to close > > 2018-04-01 open Expenses:Business:DivA:Hosting > 2018-04-01 open Expenses:Business:DivA:Contractors > ... > 2018-04-01 open Expenses:Business:DivA:OfficeSupplies > > Is there a way to close them

Re: Aggregate accounts on income statement

2023-03-12 Thread Daniele Nicolodi
On 11/03/23 20:27, Daniel González wrote: Hi, I'm generating an income statement (with only my expenses) like this: SELECT account, sum(position) FROM OPEN ON 2023-03-01 CLOSE ON 2023-03-30 WHERE account ~ "Expenses" GROUP BY 1 ORDER BY 1 But I have some subdivisions of my accounts that I

Re: Is it fine to combine several small stock purchase transactions in one?

2023-03-12 Thread Daniele Nicolodi
On 11/03/23 21:23, Bman Q wrote: When buying low volume stock often i have to split purchase in many 1-3k buy limit orders (which in turn often getting split in 5+ execution trades, some of the trades can be just 8 stock lol), so basically what for normal stock can be 1 buy transaction i can

Closing multiple accounts in one shot.

2023-03-12 Thread Bman Q
Title, i have 20+ accounts i want to close 2018-04-01 open Expenses:Business:DivA:Hosting 2018-04-01 open Expenses:Business:DivA:Contractors ... 2018-04-01 open Expenses:Business:DivA:OfficeSupplies Is there a way to close them all in one shot? like 2023-03-01 close Expenses:Business:DivA:* --

Re: Aggregate accounts on income statement

2023-03-12 Thread Chary Chary
Not sure it can be done in beanquery, but here is example how it can easily be done in pandas https://www.isabekov.pro/multiperiod-hledger-style-reports-in-beancount-pivoting-a-table/ In general it seems like using beanquery together with pandas in jupyter notebook is the best way forward for