Hello,

I am just getting started with bean-query, attempting to generate annual 
net worth reports.

Here is my current query:

SELECT getitem(open_meta(account), 'name') as name, value(sum(position)) AS 
balance FROM CLOSE ON 2021-01-01 CLEAR WHERE getitem(open_meta(account), 
'report') = 'true' GROUP BY name ORDER BY name

Though I am closing the accounts on 2021-01-01, the value function is using 
the latest price in my beancount file, rather than the last price from the 
year 2020.

Would love to figure out where I'm going wrong, thanks!

-David

-- 
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 view this discussion on the web visit 
https://groups.google.com/d/msgid/beancount/0956b7a3-187e-444f-8149-5dae7b351c15n%40googlegroups.com.

Reply via email to