Welcome Guest ( Log In | Register )

Bump Topic Topic Closed RSS Feed

Outline · [ Standard ] · Linear+

 Fundsupermart.com v8, The MS Excel Masterclass version!

views
     
xuzen
post Jan 27 2015, 07:29 PM

Look at all my stars!!
*******
Senior Member
4,436 posts

Joined: Oct 2008


QUOTE(wongmunkeong @ Jan 27 2015, 07:21 PM)
In Excel talk, U mean something like:
IF( AND(...,...,  OR(..,.,..,..)..,...,.., OR(..,...) ...),
    "advice A",
      IF(AND(...,...,  OR(..,.,..,..)..,...,.., OR(..,...) ...),
          "advice B",
          "advice C")
)
?
laugh.gif  tongue.gif
*
rclxub.gif rclxub.gif rclxub.gif

I use solver.

Xuzen
xuzen
post Jan 27 2015, 09:24 PM

Look at all my stars!!
*******
Senior Member
4,436 posts

Joined: Oct 2008


» Click to show Spoiler - click again to hide... «


And some pink arachnid still want to go shopping at Europe! sweat.gif sweat.gif sweat.gif

Xuzen

This post has been edited by xuzen: Jan 27 2015, 09:25 PM
xuzen
post Jan 27 2015, 09:59 PM

Look at all my stars!!
*******
Senior Member
4,436 posts

Joined: Oct 2008


QUOTE(Pink Spider @ Jan 27 2015, 09:52 PM)
Sifu ajar, buy when red, sell when green! tongue.gif
*
My sifu ajar lain punya.....sell and buy to maintain the pre-set ratio.

Xuzen
xuzen
post Jan 28 2015, 11:01 AM

Look at all my stars!!
*******
Senior Member
4,436 posts

Joined: Oct 2008


QUOTE(Pink Spider @ Jan 28 2015, 10:14 AM)
A wife that gave u cold shoulders for 3 months and then 1 night give u one-time glorious, hot, steamy sex

Ada bagus ka? tongue.gif
*
The word wife and glorious, hot, steamy sex appearing in the same sentence is an oxymoron. Wife is for procreation.

Xuzen
xuzen
post Jan 28 2015, 02:27 PM

Look at all my stars!!
*******
Senior Member
4,436 posts

Joined: Oct 2008


QUOTE(TakoC @ Jan 28 2015, 02:01 PM)
Haha! Thanks to all the 3 replies above.

If aunty and uncle sure like 'Wah. This EVERYDAY interest 3.8% leh. FD one year 3.15%. PUT PUT PUT!'

Percentage wise sounds like 'WAHHHHH'. But after work out the numbers you feel 'mehhhhh' tongue.gif
*
when your capital is like RM5,000,000 the difference is basis points makes a difference. So don't pandang rendah the Difference.

Xuzen
xuzen
post Jan 29 2015, 03:04 PM

Look at all my stars!!
*******
Senior Member
4,436 posts

Joined: Oct 2008


QUOTE(Jeck10 @ Jan 29 2015, 01:57 PM)
Ah I see, thought need to fund the account when opening haha😅 btw what's the average age are you guys sifu here? If don't mind😁
*
I became financially literate at 40. cry.gif cry.gif cry.gif

If I were investing much earlier... i could be living of purely from my investment now..... rclxm9.gif

Xuzen

p/s I always have this fantasy that Pink is as beautiful as the avatar presented. Can talk dirty, can discuss investment... what a dream date. In reality Pink is probably a skinny pimpled faced nerdy boy who loves guzzling on cheap 3-in-1 coffee and working as a lowly paid accounts clerk for some chinaman company.

This post has been edited by xuzen: Jan 29 2015, 03:05 PM
xuzen
post Jan 29 2015, 03:07 PM

Look at all my stars!!
*******
Senior Member
4,436 posts

Joined: Oct 2008


QUOTE(adele123 @ Jan 29 2015, 02:16 PM)
actually my guess the people here are young cause of the aggressive mode... All equity funds. lol. or maybe just discuss about equity cause there's not much to discuss about bond.

Started 23, bond fund... now only equity funds and CMF.
*
Bond is actually a very interesting asset class especially when you get to calculate its duration, modified duration, convecity and its IRR. Buidling a portfolion of bond is as complex if not more complexs than equity fund.

Xuzen
xuzen
post Jan 30 2015, 01:41 PM

Look at all my stars!!
*******
Senior Member
4,436 posts

Joined: Oct 2008


QUOTE(Jeck10 @ Jan 29 2015, 04:42 PM)
Your 'earlier' is how early ago? biggrin.gif
*
I I started investing at age of 20 or day one of me started working.... I would be able to live off my investment purely today.

Xuzen
xuzen
post Jan 30 2015, 01:42 PM

Look at all my stars!!
*******
Senior Member
4,436 posts

Joined: Oct 2008


QUOTE(pisces88 @ Jan 30 2015, 01:05 PM)
i have a china+india fund, also giving 10+% in 1 month.. worried duno can sustain or not  sweat.gif
*
CIMB-Principle China-India Fund lor....

Xuzen
xuzen
post Jan 30 2015, 01:50 PM

Look at all my stars!!
*******
Senior Member
4,436 posts

Joined: Oct 2008


QUOTE(PhilHellmuth @ Jan 30 2015, 01:44 PM)
for some reason tak nampak in fsm, only saw greater china fund  unsure.gif
*
Thousand of apologies... is RHB-OSK China India Dynamic Growth Fund.

Xuzen
xuzen
post Jan 30 2015, 02:35 PM

Look at all my stars!!
*******
Senior Member
4,436 posts

Joined: Oct 2008


QUOTE(PhilHellmuth @ Jan 30 2015, 02:12 PM)
a quick question, is money invested via FSM somehow guarded by PIDM in case FSM collapse?

planning to put 20k into CIMB-PRINCIPAL ASIA PACIFIC DYNAMIC INCOME FUND and it got me a lil worried if FSM might collapse in the future

lol
*
Not protected by PIDM does not mean it is doom and gloom, because UT is protected by a different mechanism.

Money you transfer into FSM is put in a FSM Client Trust Account which is separate from FSM current account for their normal day to day business transaction. Your money in the CTA is then transfer to the Fund's trustee.

For example, say you want to buy Eastspring Small Cap Fund, then the fund manager who manages the Small-Cap fund uses will call up Deutchebank (fund trustee, which is a third unrelated party). The fund manager will give the instruction to Deutchebank to buy this stock or that stock as long as the assets are according to the trust deed (as stated clearly in the fund prospectus).

Money will come out from Deutchebank account and any stock sold, the proceeds will return back to Deutchebank. Hence Eastspring will not touch the money except collecting the annual expense.

In the event the fund manager cease business operation, the money at the trustee will be returned to the unit-holders.

In the event the trustee cease business operation, the money will be transferred to another trustee company (there are many of them licensed in Malaysia).

Hope this clears up the structure of UT in M'sia.

Xuzen

xuzen
post Jan 31 2015, 11:40 PM

Look at all my stars!!
*******
Senior Member
4,436 posts

Joined: Oct 2008


QUOTE(woonsc @ Jan 31 2015, 05:17 PM)
Do you guys still invest in PM funds?
*
I still have the bare minimum invested in Pub-Mut fund just to qualify to buy their awesome super-duper cheap group medical card, life and Critical Illness policy.

Xuzen


xuzen
post Feb 1 2015, 07:04 PM

Look at all my stars!!
*******
Senior Member
4,436 posts

Joined: Oct 2008


QUOTE(Kaka23 @ Feb 1 2015, 05:36 PM)
100K invested amount able to get this benefits or not?
*
Yes! Top up another 900k, get super duper awesome personalized service, a choice of personal concierge who can speak Viet, Pudonghua, or Thai... brows.gif

Xuzen
xuzen
post Feb 1 2015, 07:08 PM

Look at all my stars!!
*******
Senior Member
4,436 posts

Joined: Oct 2008


QUOTE(wongmunkeong @ Feb 1 2015, 02:11 PM)
LonPac's Term Medical + AIA's Term Life?  thumbup.gif
*
rclxms.gif
rclxm9.gif
icon_idea.gif
thumbup.gif

Xuzen
xuzen
post Feb 3 2015, 10:43 AM

Look at all my stars!!
*******
Senior Member
4,436 posts

Joined: Oct 2008


QUOTE(soul_fighter @ Feb 3 2015, 01:15 AM)
Hello, Greeting everyone!
This is my 1st post in lowyat forum although I have followed this fundsupermart thread for like one year.

I would like to ask all the Big Bros here.
I understand that history of performance of each fund does tell how well was the fund doing few years ago, however it does not indicate or foretell the performance of the fund in the future.
May some of the Bros share their thoughts or opinions on how to evaluate the potential of a fund. Is it by looking at its fund factsheet details like asset allocation or the fund top holdings? Or by evaluating the potential of the each asset and tell the potential of the fund?
Thank you. =)
*
In a normal functional market, there is a tendency for the performance to regress to the statistical mean. With this knowledge, that is why a fund with consistent performance should continue to perform well until something unexpected happen such a black swan event or change of the fund manager.

To evaluate a collective investment scheme the academian i.e., those Ivy League professors, those Nobel Prize winners and those professionals from Goldman Sach or Morgan Stanley uses something in common; Risk-Adjusted Performance.

Some of the common measuring parameters to evaluate a fund are:

i) Sharpe ratio (most common)

ii) Sortino ratio

iii) Modigliani ratio (complex but awesomely accurate)

iv) Jessen-Alpha Ratio

The above are some of the measurement to evaluate a fund performance. You can google all those terms for further explaination. You see, smart people have over the years created measuring parameters to help investor select good performing fund and to prevent them from blind investing.

Xuzen

This post has been edited by xuzen: Feb 3 2015, 10:44 AM
xuzen
post Feb 5 2015, 07:06 PM

Look at all my stars!!
*******
Senior Member
4,436 posts

Joined: Oct 2008


QUOTE(adele123 @ Feb 5 2015, 05:32 PM)
this is really turning into excel class... only missed about  1 week action or so...
*
These people ar.... so typical engineer mind-set; spending wayyyyy too much tinkering with the processes!

Ooi People! There are money to be made out there in the wider market... not by looking at your beloved Excel sheet lar! vmad.gif

Look forward and make money; not insular looking at your excel spreadsheet lar!

Xuzen


xuzen
post Feb 5 2015, 07:11 PM

Look at all my stars!!
*******
Senior Member
4,436 posts

Joined: Oct 2008


QUOTE(woonsc @ Feb 5 2015, 04:02 PM)
Calling Sifu Xuzen
*
My data as of Jan-15 underweigh Eurozone!

Latest i.e., Feb-15 data not out yet. My CIO maybe too busy eating yee-sang liao!

Xuzen
xuzen
post Feb 5 2015, 07:43 PM

Look at all my stars!!
*******
Senior Member
4,436 posts

Joined: Oct 2008


QUOTE(woonsc @ Feb 5 2015, 07:36 PM)
Manu Sensex -1.8% as of 4 Feb

ada orang sakit hati ka?
*
Sensexy is like dat wan... veli volatile leh!

Cannot tahan pedas; jangan makan cili-padi!

In professional speak, "Sensex is a highly volatile index; exposure should commensurate with one's risk level"

Xuzen

xuzen
post Feb 6 2015, 11:14 AM

Look at all my stars!!
*******
Senior Member
4,436 posts

Joined: Oct 2008


QUOTE(wongmunkeong @ Feb 5 2015, 09:51 PM)
I bet Xuzen's been tinkering with his own Excel or related-tools until he got it just the way he likes his Sharpe + whatnot ratios too  laugh.gif
U closet tinkerer U  brows.gif
*
brows.gif
brows.gif
brows.gif

Xuzen

xuzen
post Feb 7 2015, 08:50 PM

Look at all my stars!!
*******
Senior Member
4,436 posts

Joined: Oct 2008


QUOTE(Pink Spider @ Feb 7 2015, 09:15 AM)
Bond fund...bond fund...feel wanna add one more bond fund to my portfolio...

Currently very very heavy on CMF plus a bit RHB-OSK Emerging Markets Bond
*
You want awesomeness?

You can't handle the awesomeness!

I give you awesomeness now: Affin Hwang Select Bond fund.....


Esther Teo the hot and awesome FM for fixed income in Affin Hwang.

wub.gif wub.gif wub.gif

Xuzen

p/s Pink, your em gai can help you make money or not?

This post has been edited by xuzen: Feb 9 2015, 01:33 PM

3 Pages < 1 2 3 >Top
Topic ClosedOptions
 

Change to:
| Lo-Fi Version
0.0536sec    0.29    7 queries    GZIP Disabled
Time is now: 2nd December 2025 - 07:34 AM