Welcome Guest ( Log In | Register )

Bump Topic Topic Closed RSS Feed

Outline · [ Standard ] · Linear+

 Fundsupermart.com v8, The MS Excel Masterclass version!

views
     
wongmunkeong
post Jan 20 2015, 06:26 PM

Barista FIRE
Group Icon
Elite
5,608 posts

Joined: May 2011
From: Here, There, Everywhere


QUOTE(Pink Spider @ Jan 20 2015, 06:08 PM)
Some k/tard who think they're genius suddenly appear yawn.gif
*
Shd intro crazy unit fund trading cat to it - these "geniuses" with bad YingWen deserves each other laugh.gif
wongmunkeong
post Jan 22 2015, 11:22 AM

Barista FIRE
Group Icon
Elite
5,608 posts

Joined: May 2011
From: Here, There, Everywhere


Give it another 6 to 8 mths, then buy Bolehland "after the holocaust" tongue.gif
wongmunkeong
post Jan 22 2015, 12:19 PM

Barista FIRE
Group Icon
Elite
5,608 posts

Joined: May 2011
From: Here, There, Everywhere


QUOTE(Pink Spider @ Jan 22 2015, 11:59 AM)
hole...what? blink.gif
*
your definition may be "hole-a-cost" laugh.gif
in normal definition - "after the devastation", thus after most people say "die lar die lar.. not going to touch that kaka no more.." brows.gif

This post has been edited by wongmunkeong: Jan 22 2015, 12:38 PM
wongmunkeong
post Jan 22 2015, 12:40 PM

Barista FIRE
Group Icon
Elite
5,608 posts

Joined: May 2011
From: Here, There, Everywhere


QUOTE(felixmask @ Jan 22 2015, 12:15 PM)
ur crystall ball give you hintz...... biggrin.gif
*
well humans being emotional creatures (mostly, not all)
look at the past histories of extreme fear & greed
and one can get an indication.

no crystal balls - just common sense if fear / dissatisfaction / hated market keeps going negatively at the same or faster rate.
wongmunkeong
post Jan 23 2015, 11:41 AM

Barista FIRE
Group Icon
Elite
5,608 posts

Joined: May 2011
From: Here, There, Everywhere


QUOTE(adele123 @ Jan 23 2015, 11:22 AM)
don't worry uncle, i actually just suggesting to him to make changes, shouldn't affect the actual user. i'm super free at work, so took the time to analyse it, if any mistakes la. main priority is of course still trying to make life easy. otherwise, too complicated, defeats the purpose of the spreadsheet.

woonsc i would do it for free, if i have the expertise to create an almost flawless and user friendly spreadsheet. tongue.gif

i remember looking at wong sifu spreadsheet that he shared, walao,  rclxub.gif
*
heheh mine's anal retentive la - i go by each transaction tracking returns/losses & why bought/sold
AND total overall tracking PER FUND
AND distribution units are re-distributed into respective transactions

too big a headache for normal folks - i'm an otaku / no-liffer sweat.gif
wongmunkeong
post Jan 24 2015, 11:24 AM

Barista FIRE
Group Icon
Elite
5,608 posts

Joined: May 2011
From: Here, There, Everywhere


QUOTE(xuzen @ Jan 24 2015, 11:10 AM)
Is it just me or do you guys notice the UT are mostly green again after the blood bath in Qtr4Yr2014.

All mine are green and a portfolio gain of 2.7% since Dec 14 (was in negative territory in Dec).

Xuzen
*
no fun.. green je.. sweat.gif
wongmunkeong
post Jan 26 2015, 01:15 PM

Barista FIRE
Group Icon
Elite
5,608 posts

Joined: May 2011
From: Here, There, Everywhere


QUOTE(Pink Spider @ Jan 26 2015, 10:02 AM)
LOL

I kesian polarzbearz laugh.gif
*
Good to have another techie investor onboard thumbup.gif
Excel has it's limitations, especially without macro or VBA-coding.

Knowing the limitation, best i could do (for anal-retentive detailed tracking) was to break it down to:
1. Summary page (see by fund & by fund overall performance)
2. Details Held -see by EACH transaction's net profit/loss - simple & CAGR
3. Details Sold / Switched - see by EACH transaction's net profit/loss - simple & CAGR

Hopeful that another PoV can do better, thus i can learn & absorb heheh.

IMHO - the best option is to use MS Access - transactions all in tables data entry, then a click-of-a-button
Query-Reports will show necessary summary and another to show details.
wongmunkeong
post Jan 26 2015, 09:06 PM

Barista FIRE
Group Icon
Elite
5,608 posts

Joined: May 2011
From: Here, There, Everywhere


QUOTE(yklooi @ Jan 26 2015, 06:34 PM)
hmm.gif Wow,  rclxm9.gif  thumbup.gif  rclxms.gif  That is much BETTER.
Any MS Access sifus wanna try?  icon_question.gif  notworthy.gif  notworthy.gif
*
i can do - after i retire like U lar & have $ + time on hand notworthy.gif

BTW, Shanghai Index back to and BREACHED its highest EVUH for 12, 6 & 3 months'
hehe - those who were shaken out earlier due to the margin clamp down... doh.gif
those who bought the fear made >=5% gua
7%+ drop, now higher LESS 2% service charge gua.. sweat.gif

This post has been edited by wongmunkeong: Jan 26 2015, 09:11 PM
wongmunkeong
post Jan 27 2015, 07:21 PM

Barista FIRE
Group Icon
Elite
5,608 posts

Joined: May 2011
From: Here, There, Everywhere


QUOTE(xuzen @ Jan 27 2015, 06:58 PM)
I will be as general as possible... it is using a predetermined set of parameters and imputed into a preset sequence of decision trees to come to an optimal risk adjusted return portfolio.

in layman talk, it is trying very hard to be si peh kiasi & kiasu as much as possible!

BTW, the few earlier post pink, WMK, polarbearz were talking abt excel this excel that... I also pusing kepala  rclxub.gif

Xuzen
*
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
wongmunkeong
post Jan 29 2015, 03:51 PM

Barista FIRE
Group Icon
Elite
5,608 posts

Joined: May 2011
From: Here, There, Everywhere


QUOTE(Pink Spider @ Jan 29 2015, 03:11 PM)
My avatar is my em gái wub.gif

Skinny - checked
Pimpled - years ago vmad.gif
3-in-1 - why need 3-in-1 when got office tea lady make Nescafe? tongue.gif
Lowly paid - checked sad.gif
Chinaman company - checked

xuzen...stalks me shocking.gif
*
beware - after a session of beer guzzling, "going-back" to "lam tenh" - wake up to find... ohmy.gif
hehe - seriously though, wished i was so "in the know" when 20s as U + a few younger ones, proper investing, not tikam and no emergency buffer sweat.gif

Xuzen - i'm 40+ and i AM STILL financially semi-illiterate cry.gif
wongmunkeong
post Jan 30 2015, 03:41 PM

Barista FIRE
Group Icon
Elite
5,608 posts

Joined: May 2011
From: Here, There, Everywhere


QUOTE(woonsc @ Jan 30 2015, 03:36 PM)
The terms "bear" and "bull" are thought to derive from the way in which each animal attacks its opponents. That is, a bull will thrust its horns up into the air, while a bear will swipe down. These actions were then related metaphorically to the movement of a market: if the trend was up, it was considered a bull market; if the trend was down, it was a bear market.

http://www.investopedia.com/ask/answers/129.asp
*
hehe - personally i look at bears like doing UPper cut (happy buying time for me)
vs
bulls goring people DOWN (nervous time for me)
i wired-wrongly gua sweat.gif

just a thought notworthy.gif
wongmunkeong
post Jan 30 2015, 03:53 PM

Barista FIRE
Group Icon
Elite
5,608 posts

Joined: May 2011
From: Here, There, Everywhere


QUOTE(woonsc @ Jan 30 2015, 03:44 PM)
rclxms.gif  value investor spotted
*
eh? kiamsiap & grocery-shopping methodology lar...
Protein (normal equities), Carbo (real estate equities), Fibre (fixed income)
buy enough when needed
buy more to keep & future use if discounted (can keep & sure needed wan mar)

simplistic fler here laugh.gif

This post has been edited by wongmunkeong: Jan 30 2015, 03:54 PM
wongmunkeong
post Feb 1 2015, 02:11 PM

Barista FIRE
Group Icon
Elite
5,608 posts

Joined: May 2011
From: Here, There, Everywhere


QUOTE(xuzen @ Jan 31 2015, 11:40 PM)
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
*
LonPac's Term Medical + AIA's Term Life? thumbup.gif
wongmunkeong
post Feb 1 2015, 07:51 PM

Barista FIRE
Group Icon
Elite
5,608 posts

Joined: May 2011
From: Here, There, Everywhere


QUOTE(Kaka23 @ Feb 1 2015, 07:28 PM)
Thanks for the info! Sigh.. dont have that amount of $$
*
Xuzen's pulling yr leg lar
If my memory serves me (RAM access a bit cacat without coffee...), the amount needed is something like EQUAL TO PREMIUM of the selected insurance or thereabouts.
wongmunkeong
post Feb 1 2015, 09:18 PM

Barista FIRE
Group Icon
Elite
5,608 posts

Joined: May 2011
From: Here, There, Everywhere


QUOTE(Kaka23 @ Feb 1 2015, 08:03 PM)
ooo... TQ

Still my investment in PM too far off for this minimum entitlement.. tongue.gif
*
er.. my medical PM-LonPac is RM900+ pa
death PM-AIA is RM1,100+/- pa

wongmunkeong
post Feb 5 2015, 09:51 PM

Barista FIRE
Group Icon
Elite
5,608 posts

Joined: May 2011
From: Here, There, Everywhere


QUOTE(TakoC @ Feb 5 2015, 09:17 PM)
All these people kena poison already. Nerds  tongue.gif
*
TakoC - nerds built the Internet, Web, etc leh
Even FSM platform and thus made it cost effective for all.

Anyhow, any tools that make this CLEAR & provides FOCUS, why not?
It takes a bit of time & effort to learn & use a tool effectively mar, thus the discussions & debugging brows.gif

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

Polarbearz - thinkerers & builders build, thankless task but the "baby" created & the help it provides - thumbup.gif
Sorry i didn't give a hand in debugging or suggestions - been hectic handling latest official stupidies lately + my approach is very different, all pure numbers, charts dilute it for me laugh.gif
Your baby looks good! notworthy.gif

wongmunkeong
post Feb 12 2015, 08:00 AM

Barista FIRE
Group Icon
Elite
5,608 posts

Joined: May 2011
From: Here, There, Everywhere


QUOTE(David83 @ Feb 12 2015, 06:29 AM)
I didn't receive it.

Maybe Gold and above. brows.gif
*
er.. nope, not that trigger / criteria too
i didnt get it either

must be platinum... shocking.gif
wongmunkeong
post Feb 19 2015, 07:57 AM

Barista FIRE
Group Icon
Elite
5,608 posts

Joined: May 2011
From: Here, There, Everywhere


QUOTE(Woopy_901 @ Feb 19 2015, 07:52 AM)
Guys, first of all happy holidays! Want to ask, usually u guys prefer periodic topup like monthly or topup when the time is right? Which one better?
*
The better one is the one that U have planned & committed to for the long term brows.gif
else main tikam sahaja.
wongmunkeong
post Feb 26 2015, 10:04 AM

Barista FIRE
Group Icon
Elite
5,608 posts

Joined: May 2011
From: Here, There, Everywhere


QUOTE(adele123 @ Feb 26 2015, 09:26 AM)
i think you need to know how IRR is calculated. these people know and they are just mentioning those IRR numbers for fun. IRR is only good measure for investment >1 year IMO. or at least over a long enough period.

they probably invested 2 weeks to get those numbers.

actual return is very much less.
*
yeah Sis.
Some folks are newbies (ok lar) OR wood (literal translation from "kayu") that they can't tell a friendly banter/joke from genuine competition or discussion. laugh.gif
wongmunkeong
post Feb 27 2015, 12:28 PM

Barista FIRE
Group Icon
Elite
5,608 posts

Joined: May 2011
From: Here, There, Everywhere


QUOTE(Pink Spider @ Feb 27 2015, 11:39 AM)
At home piap apa... doh.gif
*
cicaks laugh.gif
piap paip better for zzz than beer mar

anyhow - hey, one be thinking..
did U notice that most of the discussion these days are about fund picking / country picking?
VS
a holistic, action-able plan - from how much to invest consistently, monthly/quarterly/etc, DCA or VCA for Core and/or satellite funds DCA/VCA/value/tembak?

This post has been edited by wongmunkeong: Feb 27 2015, 12:28 PM

3 Pages < 1 2 3 >Top
Topic ClosedOptions
 

Change to:
| Lo-Fi Version
0.0603sec    0.34    7 queries    GZIP Disabled
Time is now: 13th December 2025 - 12:13 AM