There's an existing script that does this, or something very like it at least, so looking at how it works is probably the best place to start
https://groups.google.com/d/topic/beancount/O34K2lBYSGg/discussion -- 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/da270441-7c75-46a2-a4bd-999c5dbb633b%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
