Found the answer for (2) as well: query.run_query(numberify=True) On Saturday, March 7, 2020 at 2:48:11 AM UTC-8, Red S wrote: > > When I go to the Holdings page in fava and click "Query", it drops me into > the query page with what's presumably the query run for the Holdings page. > > 1) However, when I run that query, the output is different from what I get > on the output page. I see one difference is, sold lots appear on the query > page, while they don't on the Holdings page. Where and how is this > filtering (and others that I'm missing) being done? > > 2) The on-screen display in both the Holdings page and query page, and > also in bean-query, has the columns requested: > account units cost price book_value market_value > acquisition_date > > However, if I download.csv, or for that matter run this query in python, > the inventory columns returned expand to one per type of commodity. For > example, there are many "units (TICKER)" column, one per ticker. How can I: > - get a single Inventory column of units (vs. multiple units column of > type Decimal, one per commodity) > - how can I get a corresponding .csv in fava? >
-- 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/ff6f82dd-7b75-4d51-9d56-0d151ec43aa7%40googlegroups.com.
