QUOTE(Xenopher @ Nov 18 2020, 09:06 PM)
I could be wrong but I think the difference is due to MWR being non-annualized and XIRR being annualized.
IRR is annualized. XIRR I think is not...Investment StashAway Malaysia, Multi-Region ETF at your fingertips!
|
Nov 18 2020, 09:15 PM
|
All Stars
10,339 posts Joined: Jan 2003 |
|
|
|
|
Nov 18 2020, 09:18 PM
|
Senior Member
4,697 posts Joined: Apr 2007 |
QUOTE(WhitE LighteR @ Nov 18 2020, 07:44 PM) the mwr number u get from SA? then its curious indeed. I always thought its calculated the same way. https://www.investopedia.com/terms/m/money-...hted-return.asp https://docs.google.com/spreadsheets/d/e/2P...d=0&single=true Honestly I dont know how they count. Theoretically MWR should be same with XIRR. Maybe I am using "my cash flow" (my deposits/withdrawal if any) but they are using "their cash flow" (i.e. actual investment/dividends/withdrawals) This post has been edited by polarzbearz: Nov 18 2020, 09:19 PM |
|
Nov 18 2020, 09:22 PM
|
Senior Member
4,697 posts Joined: Apr 2007 |
QUOTE(WhitE LighteR @ Nov 18 2020, 09:15 PM) IIRC - both IRR and XIRR are annualised but the only difference is where XIRR is made to ADAPT to irregular cash flows, whereas IRR requires a periodical (and expected) cash flow for result to be accurate.100% sure XIRR annualised as it's the base formula that many of us here use to track our portfolio, including my own published excel tracker |
|
Nov 18 2020, 09:26 PM
Show posts by this member only | IPv6 | Post
#10404
|
Senior Member
5,216 posts Joined: Jan 2007 From: KL Malaysia |
QUOTE(polarzbearz @ Nov 18 2020, 09:18 PM) » Click to show Spoiler - click again to hide... « Honestly I dont know how they count. Theoretically MWR should be same with XIRR. Maybe I am using "my cash flow" (my deposits/withdrawal if any) but they are using "their cash flow" (i.e. actual investment/dividends/withdrawals) |
|
Nov 18 2020, 09:29 PM
|
Senior Member
4,697 posts Joined: Apr 2007 |
QUOTE(Quazacolt @ Nov 18 2020, 09:26 PM) I just realized that I also made extra top up (aside from monthly DCA) during March crash This post has been edited by polarzbearz: Nov 18 2020, 09:30 PM WhitE LighteR liked this post
|
|
Nov 18 2020, 09:35 PM
|
All Stars
10,339 posts Joined: Jan 2003 |
QUOTE(polarzbearz @ Nov 18 2020, 09:22 PM) IIRC - both IRR and XIRR are annualised but the only difference is where XIRR is made to ADAPT to irregular cash flows, whereas IRR requires a periodical (and expected) cash flow for result to be accurate. In this case likely their MWR is not annualized.100% sure XIRR annualised as it's the base formula that many of us here use to track our portfolio, including my own published excel tracker |
|
Nov 18 2020, 09:42 PM
|
Senior Member
2,861 posts Joined: Jul 2005 From: Penang |
QUOTE(polarzbearz @ Nov 18 2020, 07:08 PM) Not really.. Using the same start date MWR gives me about 48% since first deposit, whereas XIRR gives me about 22% XIRR. yes, finally sifu you come in!Cash Flow is exactly the same. I also realized their MWR,TWR whatever RRR not equal to your / Excel / my XIRR which is easily detailed out and TVM proper. WhitE LighteR liked this post
|
|
Nov 18 2020, 10:24 PM
|
Senior Member
4,697 posts Joined: Apr 2007 |
QUOTE(idyllrain @ Sep 26 2015, 12:24 AM) That's basically ROI after averaging out the cost/unit. This post from idyllrain actually explained XIRR/IRR/ROI/CAGR very well if anyone's interested. From very old tered XIRR and IRR are both Excel functions that calculate IRR. The main difference is that XIRR can deal with random dates, while IRR assumes the values you give it to be periodic. The XIRR function gives you an annualized rate though, so if your data is less than year it'll give you big numbers: Here are some examples of the different return rate formulas used: Note that ROI and CAGR (a.k.a Annualized return) calculated the same values for all scenarios, these two measures are not time-sensitive: ROI measures the absolute return over cost of investment irrespective of how long it will take to get that rate, CAGR gives you the average return per year that your investment is compounding at. IRR on the other hand takes into account the time-value of money, i.e. RM10 today is worth more than RM10 next year. To understand IRR more, you'll need to learn about NPV (Net Present Value, i.e what's the current value of a particular sum of money that you will get in the future). I'm still trying to figure out what's with the MWR % but from StashAway's explanation, it seems like they also factored in "your timing" (ironically something we've been preaching AGAINST.... ) » Click to show Spoiler - click again to hide... « Anyway, I'll stick with my excel QUOTE(lee82gx @ Nov 18 2020, 09:42 PM) yes, finally sifu you come in! Sifu 404 not found kucimiao got laI also realized their MWR,TWR whatever RRR not equal to your / Excel / my XIRR which is easily detailed out and TVM proper. This post has been edited by polarzbearz: Nov 18 2020, 10:26 PM Quazacolt and WhitE LighteR liked this post
|
|
|
|
Nov 19 2020, 12:34 AM
Show posts by this member only | IPv6 | Post
#10409
|
Junior Member
161 posts Joined: Apr 2020 |
Anyone invested with Akru? Thinking about dipping Mt ties in just to explore
|
|
Nov 19 2020, 10:05 AM
|
Senior Member
3,049 posts Joined: May 2005 |
Wah lau all the technical talk here. Can sum up for layman ar?
|
|
Nov 19 2020, 10:09 AM
|
All Stars
10,339 posts Joined: Jan 2003 |
|
|
Nov 19 2020, 11:16 AM
|
Junior Member
309 posts Joined: Jan 2003 |
QUOTE(joshtlk1 @ Nov 19 2020, 12:34 AM) pretty much very new, there's a thread talking about it.I just started early this month, put in small amount to test water. joshtlk1 liked this post
|
|
Nov 19 2020, 11:22 AM
|
Senior Member
2,861 posts Joined: Jul 2005 From: Penang |
QUOTE(polarzbearz @ Nov 18 2020, 10:24 PM) This post from idyllrain actually explained XIRR/IRR/ROI/CAGR very well if anyone's interested. From very old tered I've given it some brain juice, and my guess right now, without completely dissecting every single transaction the porfolio has done, is that the returns in Stashaway breaks down all of your individual purchases every time, so for example if one of the deposits bought you 0.2unit of XLV, another 0.1 of AAXJ at XYZ price etc, how does it work out in the current tally.I'm still trying to figure out what's with the MWR % but from StashAway's explanation, it seems like they also factored in "your timing" (ironically something we've been preaching AGAINST.... ) » Click to show Spoiler - click again to hide... « Anyway, I'll stick with my excel Sifu 404 not found kucimiao got la Stashaway's own explanation on the returns makes no sense to me without an example calculation..lol. But XIRR still makes more sense to me, since it is the equivalent of cash flow into a fixed return, annualized. |
|
Nov 19 2020, 03:30 PM
Show posts by this member only | IPv6 | Post
#10414
|
Junior Member
370 posts Joined: Jan 2003 From: Jalan Anfield 8 |
guys .. ive been investing SAsince early this year didnt deposit monthly but every now and then .. once in a while i will open the app to have a look at my invested value
any idea why somedays when i have a look the amount is lesser than what i invested and some days its more than the invested amount? risk index is 22% btw This post has been edited by vam: Nov 19 2020, 03:30 PM |
|
|
|
Nov 19 2020, 03:34 PM
|
Senior Member
3,131 posts Joined: Nov 2008 From: KL |
QUOTE(vam @ Nov 19 2020, 03:30 PM) guys .. ive been investing SAsince early this year didnt deposit monthly but every now and then .. once in a while i will open the app to have a look at my invested value Err coz its supposed to?any idea why somedays when i have a look the amount is lesser than what i invested and some days its more than the invested amount? risk index is 22% btw You expecting it to be like EPF and ASNB? |
|
Nov 19 2020, 03:45 PM
|
Junior Member
171 posts Joined: Jun 2014 |
QUOTE(vam @ Nov 19 2020, 03:30 PM) guys .. ive been investing SAsince early this year didnt deposit monthly but every now and then .. once in a while i will open the app to have a look at my invested value because the value will rise and fall..any idea why somedays when i have a look the amount is lesser than what i invested and some days its more than the invested amount? risk index is 22% btw u dont actually gain the profit or incur the loss until u withdraw. |
|
Nov 19 2020, 03:52 PM
Show posts by this member only | IPv6 | Post
#10417
|
Junior Member
370 posts Joined: Jan 2003 From: Jalan Anfield 8 |
QUOTE(honsiong @ Nov 19 2020, 03:34 PM) QUOTE(4eyeco @ Nov 19 2020, 03:45 PM) because the value will rise and fall.. ah i see ... i actually tot it works like the SA simple just that the risk is higher u dont actually gain the profit or incur the loss until u withdraw. so you guys actually withdraw when you expect it to drop and deposit it back when you expect it to rise? This post has been edited by vam: Nov 19 2020, 03:54 PM |
|
Nov 19 2020, 04:14 PM
|
Junior Member
275 posts Joined: Aug 2013 |
QUOTE(vam @ Nov 19 2020, 03:52 PM) ah i see ... i actually tot it works like the SA simple just that the risk is higher Risk means how much the value can fluctuate from its 'fair value', so yes it can goes into negative region.so you guys actually withdraw when you expect it to drop and deposit it back when you expect it to rise? Correct way to invest recommended by StashAway in short: Every month put in a fixed amount from your active income, ignore the ups and downs, consistently do this for years until you need that money. I suggest you can go read up their articles (under Learn>Insights). Quite a lot of useful knowledge regarding investment. honsiong liked this post
|
|
Nov 19 2020, 04:24 PM
|
All Stars
15,671 posts Joined: Nov 2007 |
|
|
Nov 19 2020, 05:05 PM
|
Junior Member
309 posts Joined: Jan 2003 |
QUOTE(vam @ Nov 19 2020, 03:52 PM) ah i see ... i actually tot it works like the SA simple just that the risk is higher I don't think you know what are you investing in.... as SA consists of multiple ETFsso you guys actually withdraw when you expect it to drop and deposit it back when you expect it to rise? but that's what SA for... meant for the dummys like me who don't know how to pick correct stocks to invest. This post has been edited by blur19755: Nov 19 2020, 05:09 PM brokenbomb, Quazacolt, and 4 others liked this post
|
Change to: | 0.0198sec
0.63
6 queries
GZIP Disabled
Time is now: 29th March 2024 - 02:03 PM |