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"
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.
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