How to add in, "Add-Ins":
in Excel 2010:
1. Click on top menu: File
2. Click on left side menu: Options
3. Excel Options pop-up window: Click on Add-Ins
4. Bottom middle of screen: "Manage Excel Add-Ins" click on the "Go" button
5. Check all the items (as per earlier screenshot)
6. Click on OK.
tadaa

For Excel 2003
http://office.microsoft.com/en-us/excel-he...P001127724.aspx

Google for 2007: how to install Analysis Toolpak Excel 2007 (yes, i'm a lazy baka)
--------
Simple big pix instructions on usage:
1. Enter data only in the last 3 sheets
2. R-click on the "Website" sheet's list of data and REFRESH to grab data from PM's and East Spring's website
3. Summary sheet - enter the names of the funds U have
4. Details sheet - this is where the BUY transactions are stored and when SWITCHED/sold, minus the units from COLUMN L "Units Held (less Sold / Switched)" and mark it with red or some colors for easy spotting if U wish
5. SoldSwitched - this is where the SWITCHED/SOLD transactions are captured to count the profit/loss and track the reasons for SWITCHING/Selling like a journal.

As for the formulas - er.. i dont think the mods will take too kindly to me for conducting an "Excel workshop" via this topic
Anyhow, bloody tough to get the message across using forums - face to face or some Skype thing will be easier (ie. have the file open and i talk U through it). I bloody lazy to type VS voice/video over Skype FYI - i built all these so that i can be effectively lazy even when tracking and managing my investments

This post has been edited by wongmunkeong: Apr 8 2012, 10:05 AM

No probs - i've PMed U the details to arrange date/time. er.. i assume U do have some basics in Excel like cell references and "$" symbol is for what purpose yar

Bro - some also say use eyes to read, use brains to analyze and compare/contrast, plan then execute and manage.
Rather than just hope.
BTW, there are good mutual funds from Prudential, OSK, TA Comet, Kenanga and others. Why stop looking? Or U just waiting to be spoon-fed?
OR.. gosh.. shock.. horrors.. U are spamming around with your HUGE SIGNATURE about INTERNET MARKETING?!

Whoops hehe yup yup. Old programming kicked in
It's Eastspring Investment, my bad.

In addition to what Cherroy shared, i think the "majority of fund managers under-perform the index" study was done in US and developed countries. MY is not a developed country... yet , thus there may be several major differences which allows more fund managers to outperform their indices.

Just a 2cents' addition.

ETFs in Malaysia - yes.
http://www.bursamalaysia.com/website/bm/pr...f_products.html
Equity ETF
FBM KLCI etf (0820EA)
MyETF-DJIM25 (0821EA)
CIMB FTSE ASEAN 40 MALAYSIA (0822EA)
CIMB FTSE Xinhua China 25 (0823EA)

Fixed Income ETF
ABFMY1 (0800EA)


Are they fairly priced?
Fair is a very iffy thing to different folks

Are they even worth buying?
To me, yes with lots of IFs
To U and others, maybe, maybe not - it depends...

Er.. TakoC & Kitty, sorry for butting in ar.

I think the terms/jargon used may be confusing identification of the matter.
May i try?
Redeem / Sell back to Fund House: AMDynamic Bond whacks U for a 1% exit fee

Switch from AmDynamic to another Ambank's fund: no idea for AmDynamic but fund houses like Public Mutual (PM) and Eastspring (was PRU), $0, $25 or x.xx% depending on switching from loaded to low load OR low load to loaded funds.
Low load = very little service charged up front, like PM's bond funds 0.25%
Loaded = service charged up front of 3% to 5.5% like PM's equity funds for EPF (former) or Cash (later) investments.

Transfer is to legally move the units from one registered owner to another

KParam, Transit & Pink Spider - correct ar the above jargon?
Please correct me if i'm mistaken - i've been reading & hearing those terms since 1990s, may have slightly changed with time & usage

This post has been edited by wongmunkeong: Apr 21 2012, 01:30 PM

10 years to RM12M net worth... these people must be very affluent now themselves
I can only imagine half of that, RM6M net worth, in 10+ of my donkey years time

Jokes aside though, i guess the most important would be a growth of how much CAGR in those 10 years gua.
Heck, they may already have RM8M

This post has been edited by wongmunkeong: May 5 2012, 09:59 PM

Well, other than loans for bets on "hard/real equities", it can also be margin financing for stocks in REITs i guess.
Why such a guess?
In my humble opinion, if they are betting on hyper-inflation, one of the best bets are:
1. Get a locked-in % loan like ING's & AIA's mortgage loans which doesn't fluctuate with BLR/KLIBOR/interest rates spikes during hyper-inflation.
2. Buy "hard/real" equities like properties & commodities which will cost much more to build/generate/create in hyper-inflationary economy.
3. If one can do (1.) to execute (2.)... tadaa....

The only Q would then be how big a bet and how much can they sustain IF hyper inflation doesn't set in "in time" (ie. can they hold until it happens)

Just a thought and perhaps simplified flawed view.

er.. that's gambling/trading leh heheh, not investing UNLESS they know for sure they can sell lar before completion.
ie.
bought en-block and got xx% discount from developer,
then when "sold out", they offer these "sold out & hot items" for sale to other flippers/investors at an even higher price

whoops.. er.. degenerating from mutual funds discussion. sorry mod.

Depends on whether U believe Buffet & Munger + Lynch + Soros OR 100% market efficiency hypothesis.

To put it another way:
A believer in 100% market efficiency hypothesis, when seeing a $50 note on the parking floor, will not bother to pick it up coz they think the $50 is fake coz if it's real, someone else would have already picked it up thus, it shouldn't exist now in front of him/her.

Ok ok - let me try another way to put Efficient Market Hypothesis in perspective:

IF there are no people like Buffet / Soros / Lynch / value hunters, the market will not be as efficient.
Reason: These investors & trader hunts out the anomalies, thereby eliminating the anomalies and of course they profit from it.

Easy analogy - they are the ones picking up the $50 from the parking lot floor
WHILE the 100% believers of EMF
a. left it alone since it can't be real (see previous post)
OR
b. since it's already picked up by value hunters and anomaly traders ,
says "There, see - mana ada such a big frog jumping around" (literal KantoKnees translation).

Heheh - i'm partial to 75% to 80% market efficiency hypothesis
ie. the market BECOMES efficient and while it is BECOMING efficient, there are inefficiencies to be exploited/hunted down

Aiyo Pink Spider, picked up AND spent? How to accumulate assets fast lar like that if "windfall" all spent... unless U "spent" on assets lar

Just a thought:
One may want to check out the gov yield curve here
http://asianbondsonline.adb.org/regional/d...ent_bond_yields
just in case.

This post has been edited by wongmunkeong: May 11 2012, 09:40 AM

In my humble opinion, forecasting is like reading tea leaves
wait wait! don't shoot me yet
Why not have plans to respond (not knee-jerk reaction) to ACTUAL?
eg.
a. Continue investing as normal based on normal plans

IF FALLS like brick
b. IF KLCI falls 15%, use 25% of "special opportunity cache" to buy semi-lelong
c. IF KLCI falls ANOTHER 15% after (b)., use 25% of "special opportunity cache" to buy semi-lelong
d. IF KLCI falls ANOTHER 15% after ©., use 25% of "special opportunity cache" to buy semi-lelong
e. IF KLCI falls ANOTHER 15% after (d)., use 25% of "special opportunity cache" to buy semi-lelong
that covers 60% fall liao, er.. which is crazier than 40%+ of 2008 end/2009 early lowest

IF SHOOTS up like a rocket
f. fill in the blanks heheh
g. fill in the blanks heheh
h. fill in the blanks heheh

Just a thought - tea leaves reading may work well too

This post has been edited by wongmunkeong: May 20 2012, 12:16 PM

Eh, bro Hafiez - share share lar your "investment concept" details
I'm sure other than moi, others are interested to learn too

In addition to the probabilities of a downward market for equity funds after one buys/enter shared above by Pink Spider,
IF there's a cost incurred when Entering / Buying a fund, the remaining sum needs to "work harder" just to break-even and then profit

eg.
a. $10,000 cash put in
b. 5% service charges
Simple calculation (not actual yar): $10K *5% = $500
c. Thus, value of units received is $9,500 (ie. $10K -$500 cost)
This $9,500 value of unit MUST INCREASE/GROW BY 5.26% to just achieve break even (no profit/loss)

Just a thought

Dollar Averaging / Dollar Cost Averaging / DCA:
Systematically invest a
a. FIXED AMOUNT of $XXX
b. EVERY PERIOD (eg. monthly, bi-monthly, quarterly, etc.)
c. to diversify "over time" - avoid getting in LUMP SUM and market plunges OR bingo-ing the market, thus long run suppose to get U more units when low NAV/price and less units when high NAV/price ( )

DCA is generally useful for beginners AND is stupidly easy for UTCs / agents to make $ without effort - standing instructions mar

Personally, i'd rather put in less $ when NAV/price high & more $ (unused capital when NAV/price high) when NAV/price low, also with set periods and fixed amount allocated (though may not be used totally). This is in effect value averaging.

In my humble opinion,
IF U are really interested in growing as an investor, learn up:
a. Asset Allocation and sub-allocation
b. Value investing
c. Value Cost Averaging and a sub-method called TwinVest (a combination of Value Cost Averaging + Dollar Cost Averaging)
then only pick stocks, mutual funds, etc.

(a). to (c.) are the methodologies or "kung fu", the important stuff.
The targets/victims are "just" mutual funds, stocks, REITs, properties, etc/, secondary to match the methodologies chosen.

Just a thought

This post has been edited by wongmunkeong: May 23 2012, 12:35 PM

PuiWen, not silly lar. It's good as a 1st few steps - DCA.

BTW, i'm no sifu - just an average fellow hoping to build something to leave behind (preferably in a testamentary Trust fund, thus perpetual charity donations and family trust , lala land thinking).

Books? egads, plenty leh.
Do a search on LYN, i think several other forumers and i did post recommended books and why.
search for
books
Asset Allocation
Value averaging or VCA or Value Cost Averaging

In addition, Google's your friend - plenty of web pages on these topics.

BTW, what kind of info/description are you looking for? (since U came across those terms before)

For discussions on DCA vs VCA, have a look around here (before and after this post)
http://forum.lowyat.net/topic/690951/+1160

This post has been edited by wongmunkeong: May 23 2012, 02:44 PM

Yup, something to that effect.

Instead of plonking in EXACT $ ALLOCATED EVERY PERIOD,
i allocate and then calculate how much to put in.

The unused portion can accumulate and when NAV dives, my calculations will then put in MORE $ (from the unused portion + new period's injection)
Example below:
notice that as PSSF's NAV went up over the years, my constant periodic input of $ went lower?
Except for the last 3 entries where NAV was went down.


Please note - as per some forumers' Q asking
"How Value Cost Averaging can be done WITHOUT infinite/deep pockets"
+ "How to know that enough $ is thrown in",
this is one of the ways.
Allocate every period BUT use only $xxxxx as needed based on Value Cost Averaging + Dollar Cost Averaging calculation (the sample shared above is "TwinVest", a combination of 75% Value Cost Averaging & 25% Dollar Cost Averaging).


This post has been edited by wongmunkeong: May 25 2012, 05:30 PM