To self-answer my first question, the winning combination seems to be:
SELECT last(date) as on_date, convert(value(sum(position)),'USD') as
Net_Worth
WHERE account ~ 'Assets:*.' or account ~ 'Liabilities:*.'
On Sat, May 19, 2018 at 2:55 PM Filip Miletic (Филип Милетић) <
fil...@gmail.com>
Hi all.
I'd like to use BQL to compute net worth change over time. As first step I
just want to compute
net worth and work from there.
So I formulate the query:
SELECT sum(value(position)) as Net_Worth
WHERE account ~ 'Assets:*.' or account ~ 'Liabilities:*.'
Ideally, the output of the above