This is a list of example SQL queries for Beancount. It should be a reference and inspiration for users of beancount.
If you want to contribute and add your own query to this list please create an issue or submit a pull request.
For more information about the SQL-like query language for beancount visit the Beancount Query Language documentation.
Tries to replicate bean-report holdings. Shows units, book value (what you paid) and market value (what they’re worth now).
SELECT
account, units(sum(position)) AS quantity, cost(sum(position)) AS Book , convert(units(sum(position)), "USD") AS Market
WHERE
account ~ "Assets:Trading"
GROUP BY account
ORDER BY account