On Wednesday, January 3, 2018 at 8:12:09 PM UTC+7, Martin Blais wrote: > In any case that should not fail either so there's a bug
With a bit more playing around, I think I understand what beancount is doing but I'm still not clear on how to achieve what I want. Using the same sample beanfile as in my original post, if I just do SELECT currency, number, cost(position), value(position) then beancount tells me curre num cost_posit value_posi ----- --- ---------- ---------- VWIUX 1 14.09 USD 14.11 USD USD -14 -14.09 USD -14.09 USD VWIUX 1 14.23 USD 14.11 USD USD -14 -14.23 USD -14.23 USD VWIUX 1 14.32 USD 14.11 USD USD -14 -14.32 USD -14.32 USD VWIUX -1 -14.09 USD -14.11 USD VWIUX -1 -14.23 USD -14.11 USD VWIUX -1 -14.32 USD -14.11 USD USD 42 42.64 USD 42.64 USD So I guess the key/problem is that the "number" isn't being treated the way I expected. Taking the $14.09 lot as an example, I expected it to have a single entry with a number of 0. But it actually has 2 entries, one with a number of +1 and one with a number of -1. Now that I see what's happening, I guess I understand why. bean-query is showing me postings, not lots. I guess I need to build up an inventory on my own? But I'm not sure that bean-query is flexible enough to let me do what I want here and only look at lots that still exist and are under water. So I'm back to being stumped about how to proceed. Do I just need to drop into python to get what I want? Cheers, Justus -- 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 [email protected]. To post to this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/be5cdbdf-2482-4285-a737-b6e04fa6d138%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
