Hi everyone, I'm trying to get a list with my accounts and market value positions at a past date. I am using the following query:
SELECT account, value(sum(position)) FROM flag != "!" CLOSE ON 2021-01-31 GROUP By account ORDER BY account For the accounts in USD, the positions are all correct. However, for the accounts involving other commodities, value() is calculating the market value using the most recent price I have in the ledger, not the one from the past date. I've looked at this documentation <https://docs.google.com/document/d/1s0GOZMcrKKCLlP29MD7kHO4L88evrwWdIO0p4EwRBE0/edit> and it says the following: ”value”: render the amount at the market value of the last entry rendered. As I'm using CLOSE ON in the query, shouldn't value() render the market_value at the past date (in this case 2021-01-31)? Am I missing something? Thanks, Renato -- 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/CAN2Sx3WMyHO_MeJW%3DqcaifMuGEgcC2AEXF8O93x7gqipkCkF7Q%40mail.gmail.com.
