On Wednesday, February 6, 2019 at 10:38:05 AM UTC+7, [email protected] wrote: > > The reason I'm working on these queries is I'd like to compute time valued > rate of returns (example spreadsheet if someone's interested > https://www.bogleheads.org/wiki/Calculating_personal_returns). If anyone > has suggestions on different workflow with beancount, please let me know. >
FWIW, I posted a money-weighted returns calculator a few weeks ago. https://groups.google.com/forum/#!topic/beancount/7GbNHLiN0mg At the time, I was planning on also adding time-weighted returns but after thinking about it for a while, decided that it was somewhere between impossible & a fool's errand in beancount. The thing with time-weighted returns is you have to have equal-length periods of time. With beancount, that means you rely on the user to update the price database on exact dates. Every 30 days (not every month!). Every day. Or whatever. I don't do that and I'd be surprised if many people are actually that rigorous about it, especially with historical data that they imported into beancount. Of course, you could just go for "good enough" and not care that the price database isn't fine grained enough to give you equal-length periods of time. I guess you could argue that it is "close enough" (but how far off is it? how do you know?)...but when combined with my general feeling that time-weighted returns are mostly meaningless for individual investors anyway....I ended up not implementing it. -- 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/5081843f-dced-4df2-8c3f-24dc330fbe2b%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
