Active currency holdings and average cost booking

2019-11-25 Thread Red S
I'm trying to get a list of currencies active as of a given date in order to download prices. However, I get way more currencies than are truly active because I have accounts that need average cost booking, which I've so far booked this way until that feature is available: 2016-01-06 * "buy"

Re: can bean-query report include accounts with zero amounts?

2019-11-25 Thread John Rakestraw
Thanks Martin. My current use case involves a report from a limited set of accounts -- no need to see accounts with zero position if I'm running the report without the WHERE restriction. If nothing else, then perhaps I could export to csv and write macros in a spreadsheet to build the report.

Re: can bean-query report include accounts with zero amounts?

2019-11-25 Thread Martin Blais
What I'm thinking is that something else could be done if the accounts are open during the period to ensure they appear with a zero sum. I'm not sure how to do that generically yet though (I'm trying to do this very generically because the query tool will eventually move out of the context of Beanc