Fundsupermart.com v8, The MS Excel Masterclass version!
|
|
 Feb 3 2015, 05:01 PM
Return to original view | Post
#261
|
 
Senior Member
8,188 posts Joined: Apr 2013  
|
QUOTE(zDarkForceSz @ Feb 3 2015, 04:54 PM) Climb climb just a few post before.   wow, you spotted his posting....missed it under all this avatar things.Pity him...have to read back some postings....Thaipusum day.... Ponzi 1.0 Affinhwang Select Asia Quantum fund Ponzi 2.0 Cimb Pricipal Asia Pacific Dynamic Income fund |
|
|
|
|
|
Feb 3 2015, 10:13 PM
Return to original view | Post
#262
|
|
Senior Member
8,188 posts Joined: Apr 2013
|
 woonsc and polarzbearzthank you. Attached thumbnail(s) 
|
|
|
Feb 3 2015, 11:17 PM
Return to original view | Post
#263
|
|
Senior Member
8,188 posts Joined: Apr 2013
|
QUOTE(wan_109 @ Feb 3 2015, 10:56 PM) Thank you very much for your swift reply. while waiting for more value able replies.....I'm currently targeting 3 unit trusts, namely Kenanga Syariah Growth Fund, Eastsprings Dana Investment al-Ilham and Aberdeen Islamic World Equity Fund - Class A. Currently I'm leaning towards Eastsprings. Would you guys think that would be a good choice? Thanks again.  Unknown to your % of allocation into the 3 funds with your investable monies? Kenanga & eastspring both are focused in heavy M'sia equities....am I right? IF they are 1/3 each....then you are 60% malaysia focused, and 8% in US and 14% in Europe... do you want a more diversified portfolio? if you want try download the Polarzbearz portfolio summary file in post#1, then READ the instructions before key in the details to see where is the allocation goes to in your portfolio. |
|
|
Feb 3 2015, 11:29 PM
Return to original view | Post
#264
|
|
Senior Member
8,188 posts Joined: Apr 2013
|
QUOTE(woonsc @ Feb 3 2015, 11:26 PM)  u used the allocation yourself? no problem?? if used the above allocation for the past few years...good rewards.... but if used it in 2014...with M'sia being the worst under performing mkts in Asia......then kena teruk lah. |
|
|
Feb 3 2015, 11:37 PM
Return to original view | Post
#265
|
|
Senior Member
8,188 posts Joined: Apr 2013
|
QUOTE(woonsc @ Feb 3 2015, 11:30 PM) haha yeah.. i invested 40% in MY last year oh...I am still using my own not so perfect low level excel format.... Bloody red.. What i meant was u used the excel?? still hesitate to really DARE to try out "polarzbearz"'s creation. noob in that kind of higher level excel stuffs. just like a "vir....." (Madonna song) touching that thing for the very 1st time...so exciting and scare of getting hurt and don't know what to do.... will have to try it someday....after learning how to insert the rows first. |
|
|
Feb 3 2015, 11:45 PM
Return to original view | Post
#266
|
|
Senior Member
8,188 posts Joined: Apr 2013
|
QUOTE(woonsc @ Feb 3 2015, 11:40 PM) haha i googled and hear the song.. sooo old school..  the allocation got a bit problem for me still.. but the IRR is nice~   Old school for old people......she is like a goddess idol to some...    |
|
|
|
|
|
Feb 4 2015, 10:30 AM
Return to original view | Post
#267
|
|
Senior Member
8,188 posts Joined: Apr 2013
|
QUOTE(woonsc @ Feb 4 2015, 10:27 AM) no no no bukan that.. to help polarzthe formular that calculates the percentage in portfolio.. what is the name of that worksheet? location you already mention... |
|
|
Feb 4 2015, 03:01 PM
Return to original view | Post
#268
|
|
Senior Member
8,188 posts Joined: Apr 2013
|
QUOTE(TakoC @ Feb 4 2015, 02:49 PM) Can someone update me what's new in the spreadsheet ah? Like iPhone iOS update like that. Must say what's news one ma or fix what bug? Haha! in the "Changelog" worksheet in the excel file.....got list down what has been changed. |
|
|
Feb 4 2015, 03:21 PM
Return to original view | Post
#269
|
|
Senior Member
8,188 posts Joined: Apr 2013
|
wouldn't it be nice IF inside the portfolio Summary worksheet.... can add 1 or 2 more charts that cater for Regions.... now can see by countries...cannot see by regions Guess have to add in the existing worksheet the Charts required. also,...in the investment detail worksheet just beside the current Profit/loss (RM)...would it be nicer to have Current Profit/loss in %...just before the IRR? Btw,....  just managed to learn how to add in the rows in the Investment details worksheet.....not yet test whether any thing else needs to be added/modified to make the newly added rows "link able" to other required areas.This post has been edited by yklooi: Feb 4 2015, 03:42 PM |
|
|
Feb 4 2015, 06:04 PM
Return to original view | Post
#270
|
|
Senior Member
8,188 posts Joined: Apr 2013
|
woonsc...after i had inserted rowS and rowS into the "Investment details" and "Fund allocation" worksheets.
do i need to add in any linkages? like the formulas and others? if yes, where & how?  |
|
|
Feb 4 2015, 07:31 PM
Return to original view | Post
#271
|
|
Senior Member
8,188 posts Joined: Apr 2013
|
QUOTE(woonsc @ Feb 4 2015, 06:39 PM) Erm.. when u press on the rows, do it have any formula? when I clicked on the newly added rows....no formula....the old one has.FOr my Excel 2010, i need to insert blank rows into the funds.. Then i will.. erm.. how to say.. like select the top row ( with formula) then drag down using the small square at the bottom right.. will try your method on the next version of the excel file. Thanks |
|
|
Feb 4 2015, 08:11 PM
Return to original view | Post
#272
|
|
Senior Member
8,188 posts Joined: Apr 2013
|
QUOTE(polarzbearz @ Feb 4 2015, 07:50 PM) Regions chart is in my plan, but was pushed down to lowest priority due to other stuff If you don't mind, maybe you can help me with tagging countries to regions; and how "specific" do we need to go on regions (i.e. ASEAN, xxx asia, etc) or just a simple ones like " Asia Pacific | European Union | Americas | Others" ? pink and others...what is your suggestion?I think make a charts that are "open"...which means users can opt to select or include the countries at their own fancy, and user can change the title of the grouping to their fancy too. like for me,...I consider China and Japan as North Asia region...but some sifus say Japan should be under develop countries classification. currently I have M'sia Asean Asean x M'sia North Asia Europe, US, UK & others BRI mine (above) may NOT be correct....just that I liked that.  a good reference is follow MSCI http://www.msci.com/products/indexes/ click at the MSCI country and regional indexes will list the countries covered (for EM.....it has 3 regions) for your ease of programming and to avoid dispute...follow the MSCI indexes is best.  (group some countries into "others" as some countries are not in FSM funds...some have but the % allocated is very minimal to have impact to the overall portfolio) This post has been edited by yklooi: Feb 4 2015, 08:26 PM |
|
|
Feb 4 2015, 08:22 PM
Return to original view | Post
#273
|
|
Senior Member
8,188 posts Joined: Apr 2013
|
QUOTE(woonsc @ Feb 4 2015, 08:18 PM)  OH no.. can i just clear content and copy the allocation only?? BUT in the meantime...try to PLAY around this Version 1.6 and try to detect bugs and provide improvement suggestion |
|
|
|
|
|
Feb 4 2015, 08:33 PM
Return to original view | Post
#274
|
|
Senior Member
8,188 posts Joined: Apr 2013
|
QUOTE(polarzbearz @ Feb 4 2015, 08:27 PM) The new version with new chart etc. won't be out so fast I wanna rest For now I'll only focus on fixing bugs and make this version stable   oh no....that is soooo not you yes, take some rest... all users would appreciate your effort and work. .............. 20 hours REST should be ok right?  |
|
|
Feb 4 2015, 08:42 PM
Return to original view | Post
#275
|
|
Senior Member
8,188 posts Joined: Apr 2013
|
QUOTE(woonsc @ Feb 4 2015, 08:36 PM) oh my.. haha horrible boss spotted ;P without him can happens meh? Attached thumbnail(s) 
|
|
|
Feb 4 2015, 08:45 PM
Return to original view | Post
#276
|
|
Senior Member
8,188 posts Joined: Apr 2013
|
QUOTE(polarzbearz @ Feb 4 2015, 08:40 PM) 20 hours mana cukup. at least 1 month (except got bugs lar) ok-lah.....those who know some basic excel can do chartsif they know how to do chart...they can just add into your worksheet the charts, to display the data required. but ...just so incomplete.... |
|
|
Feb 4 2015, 10:58 PM
Return to original view | Post
#277
|
|
Senior Member
8,188 posts Joined: Apr 2013
|
QUOTE(woonsc @ Feb 4 2015, 10:33 PM) Ur spreadsheet need tambah ROI too~ hahaha WHAT? the excel file got no ROI?ROI for each fund, IRR for each fund ROI for the portfolio, IRR for the portfolio. what about XIRR? is it same as IRR? |
|
|
Feb 4 2015, 11:17 PM
Return to original view | Post
#278
|
|
Senior Member
8,188 posts Joined: Apr 2013
|
QUOTE(woonsc @ Feb 4 2015, 11:12 PM) you can add into the excel file the ROI. |
|
|
Feb 5 2015, 07:42 AM
Return to original view | Post
#279
|
|
Senior Member
8,188 posts Joined: Apr 2013
|
QUOTE(woonsc @ Feb 4 2015, 10:33 PM) IRR just like quoted by Ur spreadsheet need tambah ROI too~ hahaha QUOTE(polarzbearz @ Feb 4 2015, 09:45 PM) my portfolio ROI & IRR macam super-inflated and fake one, because of short term ROI for Manulife India is at best 60% unless sell buy sell buy sell buyThis post has been edited by yklooi: Feb 5 2015, 07:48 AM Attached thumbnail(s) 
|
|
|
Feb 5 2015, 01:35 PM
Return to original view | Post
#280
|
|
Senior Member
8,188 posts Joined: Apr 2013
|
QUOTE(polarzbearz @ Feb 5 2015, 01:16 PM) You can easily customize the spreadsheet That's the reason I didn't password protect those worksheets and open it for everyone to edit; I only password protect the "CHANGELOGS" to prevent frauds but like pink spider said, calculating is ROI is very tricky - how you define "Cost of Investment"? do you include funds received from selling the units OR should you exclude them? it's not as straightforward to calculate ROI as compared to ROI for other stuff -i.e. one time purchase, then sell it off at a go an example would be: Invest RM1000, zero service charge, NAV at RM0.50; total holdings 2000 units; current portfolio value = RM0.50 x 2000 = RM1000 Sell 1000 units at RM0.55 NAV, gained RM550 from it (actual profit = RM50); current portfolio value = RM0.55 x 1000 = RM550 (another paper profit of RM50); total profit = RM100 so RM100 / RM1000? or RM100 / RM500? technically speaking your current investment is only RM500, since you cashed out the another half already. I might be wrong tho i was thinking of adding into the excel file ROIROI of each fund.....Cost of purchase vs current cost of the fund ROI of portfolio.....Total cost invested vs current cost available Simple BUT not sure if that is correct...  |
|
Topic ClosedOptions
|
| Change to: |  0.0497sec
 0.79
 7 queries
 GZIP Disabled
Time is now: 2nd December 2025 - 07:45 PM |
Quote