Corporateburnout
Thinks s/he gets paid by the post
- Joined
- Sep 30, 2006
- Messages
- 1,743
6.97% YTD and 2.9% annualized. I'll take it.....
6.97% YTD and 2.9% annualized. I'll take it.....
6.97% YTD and 2.9% annualized. I'll take it.....
Backwards?
I was reading on bogleheads.org about the difficulty folks are having with getting XIRR to give legit YTD numbers. This 8.69% looks like an APR and not a YTD:8.69% YTD, XIRR. Eked out another small gain in May.
AA = 50/45/5 S/FI/C.
Thank you for the clarification Renue74. XIRR does work but produces an APR so to produce YTD you have to use the following formula to convert back.
(1+YTD)^(n/365)-1 where YTD is the XIRR result and n = number of days.
Here is a link to another spreadsheet I found which may be helpful:
http://www.gummy-stuff.org/Excel/XIRR.xls
~Moshe
I was reading on bogleheads.org about the difficulty folks are having with getting XIRR to give legit YTD numbers. This 8.69% looks like an APR and not a YTD:
You make good points. If I examine my 401k, which holds only RNWEX (EM worldwide companies), the Personalized Rate of Return since 01/01/2016 is 9.67%. Investments do rebound, but this number surprises me quite a bit.Despite what you think it looks like, this is not an APR number. I actually used the BogleheadsReturns.xls worksheet, which is close enough to IRR to not quibble about the differences. The spreadsheet is simple enough to use. Then again, I am a CPA, so I know a thing or two about spreadsheets.
I'm also not invested to any great extent in the US. If I was, my returns would be negative due to the strong increase in the CAD vs. USD this year. (I sold my US holdings on Jan 8 for a tidy gain. Maybe I should have put that in your market timing thread.)
Great market timing on that one! M* says that a person who held only RNWEX so far in 2016 is up 2.99% through 6/6/2016 (it did lose 10% in the first 3 weeks of the year).You make good points. If I examine my 401k, which holds only RNWEX (EM worldwide companies), the Personalized Rate of Return since 01/01/2016 is 9.67%. Investments do rebound, but this number surprises me quite a bit.
Great market timing on that one! M* says that a person who held only RNWEX so far in 2016 is up 2.99% through 6/6/2016 (it did lose 10% in the first 3 weeks of the year).
@Viking, thanks for the comment, clarification and the mention of currency effects.