Re: Cashflow query

2017-08-08 Thread Martin Blais
No plans.
If you'd like to automate, you can write a very brief Python script that
calls this:
https://bitbucket.org/blais/beancount/src/5987cd6616df03acba98142c1939ae0ff2842451/beancount/query/query.py?at=default&fileviewer=file-view-default#query.py-13


On Tue, Aug 8, 2017 at 12:37 PM, Jason Chu  wrote:

> I'm pretty sure it's possible to write a cashflow bean query something
> like this:
>
> select root(account, 4), convert(sum(position), 'USD') FROM
> has_account('Assets') OPEN ON 2017-01-01 WHERE not account ~ 'Assets' group
> by 1 order by 1;
>
> This shows me all the transactions that included a Assets account, but
> doesn't output any balances of those Asset accounts (they're a bit
> nonsensical).
>
> It would be nice to be able to substitute different accounts in the from
> and the where, if I wanted to dig into cash flow from a particular account,
> but it's annoying to keep the two strings in sync.  Are the any thoughts on
> adding support for parameters to either bean-query or fava?  Then I could
>
> run "Cashflow" "Assets:US:Bank"
>
> to see where all my money went from that particular bank account.
>
> --
> 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 post to this group, send email to beancount@googlegroups.com.
> To view this discussion on the web visit https://groups.google.com/d/
> msgid/beancount/CAFFHUgta_G09gtN7Nb5H%2BxA_0kU1-
> X4YyVDt8A1JXhOuV8EZ4w%40mail.gmail.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 post to this group, send email to beancount@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/beancount/CAK21%2BhOR4wu5yYnZAOiEXi248nAEdwVqumWd_XPAO1OWUusAHQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.


Cashflow query

2017-08-08 Thread Jason Chu
I'm pretty sure it's possible to write a cashflow bean query something like
this:

select root(account, 4), convert(sum(position), 'USD') FROM
has_account('Assets') OPEN ON 2017-01-01 WHERE not account ~ 'Assets' group
by 1 order by 1;

This shows me all the transactions that included a Assets account, but
doesn't output any balances of those Asset accounts (they're a bit
nonsensical).

It would be nice to be able to substitute different accounts in the from
and the where, if I wanted to dig into cash flow from a particular account,
but it's annoying to keep the two strings in sync.  Are the any thoughts on
adding support for parameters to either bean-query or fava?  Then I could

run "Cashflow" "Assets:US:Bank"

to see where all my money went from that particular bank account.

-- 
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 post to this group, send email to beancount@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/beancount/CAFFHUgta_G09gtN7Nb5H%2BxA_0kU1-X4YyVDt8A1JXhOuV8EZ4w%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.