* Ben Luey <milehigh1...@gmail.com> [2021-07-19 08:14]: > 1) Do this all on the query side. Is there a sql query I can run > that would do a convert for each transaction that matches some > criteria and then sum that? Let's assume I've already input the > USD/CAD exchange rate for all transaction dates into beancount.
This query will convert from USD to CAD on the date of the transaction: SELECT date, narration, CONVERT(position, 'CAD', date) WHERE account ~ 'Expenses:Test' -- Martin Michlmayr https://www.cyrius.com/ -- 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/YPYPVFj80xhVjO3v%40jirafa.cyrius.com.