yr PPA a/c number is
PPA(new NRIC number --no spacing)
try it.

for a few times, when I want to partially sell my funds, I key in the Value in RM how much I want to sell....because I don't know the current precise value of the NAV ....
FSM would sent me the details of the qty deducted to equate the value of the RM specified....few days later....guess i can update the excel file few days late.

Just ignore the mgmt. fees calculation. Nav published is NETT. except some fund has this EXTRA fees..
Performance Fee and Hurdle Value.
Performance fee of the Target Fund, namely the China Select Fund is 10% of the appreciation in the net asset value per unit during the relevant performance period above the high watermark of the Target Fund.
I got no idea what that is.....
http://www.affinhwangam.com/investment-sol...ina-select-fund

I guess this fees can be exempted from the Excel file like the Mgmt fees.....b'cos I believes this fees deduction will be "hidden" unseen...the published NAV is NETT too...hope I am right.

wow, thanks for input.

b'cos the veterans and technical sifus are crossing testing/analyzing to find possible bug(s), and improvement ideas to/in an excel file....
for the benefits of others.

with that excel file....can see easily where had all the investment currently been allocated....where heavy, too little, how much % and which one making $$, which one can be "dumped" or replaced.....then can discuss about regional exposure.
Know what one currently have first before "moving forward to FY15 strategy and other stuff", knowing them will be more value added b'cos of availed info like where had you invested, where are you gonna invest next, had what you invested made money.

for some, after learning how to use this excel file...can use it to do presentation to impress
or to get potential clients or to enhance believes from current customer base so that continue to get few % from the SC.

as for uncle like me, there is a long way before can do above....still in the in Investment detail worksheet....tried inserting a ROW...then found that "=IF(OR(Table3[[#This Row],[Transaction Type]]="Buy",Table3[[#This Row],[Transaction Type]]="Switch Buy",Table3[[#This Row],[Transaction Type]]="Platform Fee"),"...missing from the cell when compared to other above....
Tried to DRAG down that "Formula" directly from above cell to the one just created that has no formula.....after done 3 Drags..."Error message prompted...then can see a new "Arrowed lines"...
will have to try see how this really works....

This post has been edited by yklooi: Jan 25 2015, 09:18 PM


Attached thumbnail(s)

a note of caution...don't just aim for the "best returns".....

have a consideration of the "Lipper Fund Volatility Factor and Classification for Unit Trust Schemes and Recognized Funds".....
Often an investor assumes two equity funds with similar investment objectives carry the same level of risks. This assumption may not be true because investment styles and strategies adopted by the two fund managers are not the same.
https://www.fimm.com.my/wp-content/uploads/...vestorMay09.pdf

and do dome homework like monitoring fund performance to...
Evaluate resilience by looking at A Fund's Performance during market downturns

In general, the market tends to use standard deviation to measure risks. A higher standard deviation means higher price volatility and vice versa. However, since the volatility data does not actually distinguish the rise or fall in the volatility area, the level of standard deviation may not reflect the quality of a fund accurately, and it is not the proper way to find the best-performing funds. Thus, we believe that the more appropriate way is to observe a fund’s performance when the market falls, enabling us to evaluate the fund’s resilience during market downturns. Our in-house research team has also discovered that funds with higher resilience tend to outperform those with stronger short-term returns but lower resilience in the long run.
http://www.fundsupermart.com.my/main/resea...?articleNo=5459

thank you...will study more later...

I think the "better" way is to create 1 worksheet for EACH fund.....there will be almost endless entries.
but this EACH worksheet how to link to the other critical worksheet?

can or not? easy or not? what are the limitation? can people with limited excel knowledge (like me) benefits from it?
else,,,,more leh chey for polarzbearz...

in the meantime will have to learn how to use.....

This post has been edited by yklooi: Jan 25 2015, 11:33 PM

come to think of it.....can convert to "Android"...sell it at GooglePlay or AppleStore..ha-ha.

I think it was in March 2014, that the DJ dropped due to unable to meet certain econ indicators that was caused by winter storm in end of 2013?
now another "Badder" winter storm is coming.....prepare to enter US later or exit now?

NEW YORK (BLOOMBERG)- What may be a historic snow storm could bring blizzard conditions to large parts of the United States Northeast while dropping as much as 90 centimetres of snow on New York, New Jersey and Long Island and as much as 60 centimetres through eastern New England, including Boston, threatening travel delays, school cancellations and blackouts. New York Mayor Bill de Blasio warned residents to prepare as the impending snow storm threatens to be the biggest in the city's history. - See more at: http://www.straitstimes.com/news/world/uni...h.EI0wSLJh.dpuf

This post has been edited by yklooi: Jan 26 2015, 07:56 AM

Currently i am creating and "Saving" one file under 31 Dec 2013 and another another 31 Dec 2014...
i then COPY and PAste the info (YTD IRR, ROI of that year and etc) into a NEW worksheet of existing file that track the whole portfolio.
Have to do it manually...then the existing file can see the current YTD info, Overall accumulation of ROI, and yearly ROI, IRR, Xirr etc.

Unknown to your risk appetite (which is very personal and subjective)....try reading these links first before you decide.
Why do you invest?
Investing is not about picking the top-performing asset or the highest ranking fund. The purpose of investing is to make your money work for you. This requires investors to make informed, important and conscious decisions. Here are the questions that you must ask yourself before investing:

https://www.kenangainvestors.com.my/KIB/KIB...vestingFAQ.aspx

However, before you jump in and start investing your hard-earned money, there are several important things that you would need to know about yourself first.
•How much do you really need? (Future Planning)
•How much risk can you take? (Risk Level)
•How long are you willing to wait before you see profits? (Time Horizon)
http://www.fundsupermart.com.my/main/schoo...d.svdo?PageID=1

just came into my mine.
just in case polarzbearz is "Missing in Action" MIA.
The "TAIKOR of this FSM thread" will have to provide some solutions......

Pink...
If there's somethin' strange in your FSM Thread
Who ya gonna call (Pink)
If it's somethin' weird an it won't look good
Who ya gonna call (Pink)

I ain't afraid a no problem is FSM thread
I ain't afraid a no ghost in FSM thread
If you're seein' things runnin' thru your head
Who can you call (Pink)

If you're all alone pick up the phone
An call (FSM CS)

Sing it in tune of Ghostbuster....

Wow, That is much BETTER.
Any MS Access sifus wanna try?

Unknown to your risk appetite (which is very personal and subjective)....try reading these links first before you decide.
Why do you invest?
Investing is not about picking the top-performing asset or the highest ranking fund. The purpose of investing is to make your money work for you. This requires investors to make informed, important and conscious decisions. Here are the questions that you must ask yourself before investing:

https://www.kenangainvestors.com.my/KIB/KIB...vestingFAQ.aspx

However, before you jump in and start investing your hard-earned money, there are several important things that you would need to know about yourself first.
•How much do you really need? (Future Planning)
•How much risk can you take? (Risk Level)
•How long are you willing to wait before you see profits? (Time Horizon)
http://www.fundsupermart.com.my/main/schoo...d.svdo?PageID=1

if the risk appetite is ok try PRS.....govt giving youth incentives...
PRS Youth Incentive RM500
PRS Youth Incentive is an initiative by the government to encourage young individuals to start saving early for retirement.... April 23, 2014

http://www.fundsupermart.com.my/main/resea...?articleNo=4558

RSP features
https://www.fundsupermart.com.my/main/buyse...ntroduction.tpl?

3 Misconceptions Of Our Recommended Funds List
In this Idea Of The Week, we take the time to correct some popular misconceptions investors might have had with regards to the Recommended Funds List.
Author : Fundsupermart.com

http://www.fundsupermart.com.my/main/resea...?articleNo=3983

This post has been edited by yklooi: Jan 26 2015, 07:57 PM

Don't forget about this....will end this FRIDAY 30 Jan....
http://www.fundsupermart.com.my/main/resea...?articleNo=5440

goto FSM website...
Click at FUNDS INFO/FUNDS SELECTOR/under RISK RATINGS---select the Risk level that you think you liked....(ex: 6 or 7)...then press GENERATE TABLE.

a lists of funds with its performance, fees and other info of funds under the risk rating that you selected would appears, if you see fund that is of interest, click on that fund...more info of that funds would appears,...read the fund factsheets and other info....

Have fun fishing....
http://www.fundsupermart.com.my/main/fundi...fundSelect.svdo?

added note, (just ignore if you want)
are you aggressive, balanced or conservative?

It is not only important to understand the risks of the investments you are looking at, but also to understand your personal risk appetite. Sometimes, it is not a matter of what kind of risks you want to take, but a matter of what kind of risks you can take given the circumstances that you are currently in. And the best way to do it is to assess your actual experience in investing.

For instance, you might have thought that you are an aggressive investor who can cope with a high level of risk based on the results of the risk profiling test. However, in practice, if you find that you always panic too soon every time the market dips, and get overly euphoric and pump in more money whenever markets are on a roll, then high-risk investments are not so suitable for you because they are likely to cause you to lose money.
http://www.fundsupermart.com.my/main/resea...?articleNo=2266

This post has been edited by yklooi: Jan 27 2015, 06:38 AM

Guess, they are following where the money is.
moving to the regions that provide more potential of upsides.

“As a value investor, you should not buy a share just because it has dropped more than 80%. You will only buy because the share meets your investment criteria and it is undervalued.” – Dr. Tan Chong Koay