Thank you I'll definitely take a look at your money weighted implementation.
I have to admin I'm blindly trusting the spreadsheet, and I haven't checked the formulas. The spreadsheet entries are not equal spaced and the unequal periods do not reflect exact date of deposit/withdrawal, so I don't know how far it's off. On Wednesday, February 6, 2019 at 9:47:04 AM UTC-5, Justus Pendleton wrote: > > On Wednesday, February 6, 2019 at 10:38:05 AM UTC+7, igor.s...@gmail.com > 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 beancount+unsubscr...@googlegroups.com. To post to this group, send email to beancount@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/6f89309f-aca8-4cc5-875a-308e746abf58%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.