Glad to know they help :). I'm just running HEAD from master in beanquery <https://github.com/beancount/beanquery> (which doesn't seem to have releases yet). #balances was added in this commit <https://github.com/beancount/beanquery/commit/5267ab9af778e85ce13fdcdcce74fd08aba64554>, I believe. Hope that helps!
On Monday, October 16, 2023 at 1:13:47 AM UTC-7 koro...@gmail.com wrote: > Hi Red, > > Thanks a lot for your inspiring work - especially for detailed articles! > > I'm trying to run BQL query for your article: > SELECT account, max(date) FROM #balances WHERE account ~ "^Assets:.*Bank" > GROUP BY account > > But I get error: > Unknown token: LexToken(error,'#balances WHERE account ~ "^Assets:.*Bank" > GROUP BY account',1,31) > > I use beancount 2.3.5 for now and bean-query supplied with it. > > Do you use another version of bean-query? > > On Tuesday, August 29, 2023 at 7:39:21 AM UTC+3 Red S wrote: > >> It is helpful to know what accounts you haven’t updated in a while in >> your journal. bean-download is a downloader >> <https://reds-rants.netlify.app/personal-finance/direct-downloads/> that >> ships with beancount-reds-importers >> <https://github.com/redstreet/beancount_reds_importers>. It now has a >> new feature: bean-download needs-update shows a list of accounts needing >> updates, and the date of the last update (which is defined as the date of >> the last balance assertion on the account). >> >> Installation: pip3 install beancount-reds-importers. >> >> You can filter accounts via its configuration. It handles commodity leaf >> accounts. >> >> *Full article is here >> <https://reds-rants.netlify.app/personal-finance/how-up-to-date-are-my-accounts/>.* >> >> Example output: >> $ bean-download needs-update Last Updated Account -------------- >> --------------------------------------------------------- 2023-07-22 >> Assets:Banks:MainOne 2023-02-05 >> Assets:Gift-Cards-and-Credits:Amazon-com-Gift-Cards >> >> > -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/beancount/9e08cacd-b78c-4c49-b148-f28230f2e7fcn%40googlegroups.com.