QUOTE(Pink Spider @ Jan 20 2015, 06:08 PM)
Shd intro crazy unit fund trading cat to it - these "geniuses" with bad YingWen deserves each other Fundsupermart.com v8, The MS Excel Masterclass version!
Fundsupermart.com v8, The MS Excel Masterclass version!
|
|
Jan 20 2015, 06:26 PM
Return to original view | Post
#21
|
|
Elite
5,608 posts Joined: May 2011 From: Here, There, Everywhere |
|
|
|
|
|
|
Jan 22 2015, 11:22 AM
Return to original view | Post
#22
|
|
Elite
5,608 posts Joined: May 2011 From: Here, There, Everywhere |
Give it another 6 to 8 mths, then buy Bolehland "after the holocaust"
|
|
|
Jan 22 2015, 12:19 PM
Return to original view | Post
#23
|
|
Elite
5,608 posts Joined: May 2011 From: Here, There, Everywhere |
|
|
|
Jan 22 2015, 12:40 PM
Return to original view | Post
#24
|
|
Elite
5,608 posts Joined: May 2011 From: Here, There, Everywhere |
QUOTE(felixmask @ Jan 22 2015, 12:15 PM) 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. |
|
|
Jan 23 2015, 11:41 AM
Return to original view | Post
#25
|
|
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. heheh mine's anal retentive la - i go by each transaction tracking returns/losses & why bought/soldwoonsc i would do it for free, if i have the expertise to create an almost flawless and user friendly spreadsheet. i remember looking at wong sifu spreadsheet that he shared, walao, 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 |
|
|
Jan 24 2015, 11:24 AM
Return to original view | Post
#26
|
|
Elite
5,608 posts Joined: May 2011 From: Here, There, Everywhere |
|
|
|
|
|
|
Jan 26 2015, 01:15 PM
Return to original view | Post
#27
|
|
Elite
5,608 posts Joined: May 2011 From: Here, There, Everywhere |
QUOTE(Pink Spider @ Jan 26 2015, 10:02 AM) Good to have another techie investor onboard 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. |
|
|
Jan 26 2015, 09:06 PM
Return to original view | Post
#28
|
|
Elite
5,608 posts Joined: May 2011 From: Here, There, Everywhere |
QUOTE(yklooi @ Jan 26 2015, 06:34 PM) i can do - after i retire like U lar & have $ + time on hand 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... those who bought the fear made >=5% gua 7%+ drop, now higher LESS 2% service charge gua.. This post has been edited by wongmunkeong: Jan 26 2015, 09:11 PM |
|
|
Jan 27 2015, 07:21 PM
Return to original view | Post
#29
|
|
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 Excel talk, U mean something like: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 Xuzen IF( AND(...,..., OR(..,.,..,..)..,...,.., OR(..,...) ...), "advice A", IF(AND(...,..., OR(..,.,..,..)..,...,.., OR(..,...) ...), "advice B", "advice C") ) ? |
|
|
Jan 29 2015, 03:51 PM
Return to original view | Post
#30
|
|
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 beware - after a session of beer guzzling, "going-back" to "lam tenh" - wake up to find... Skinny - checked Pimpled - years ago 3-in-1 - why need 3-in-1 when got office tea lady make Nescafe? Lowly paid - checked Chinaman company - checked xuzen...stalks me 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 Xuzen - i'm 40+ and i AM STILL financially semi-illiterate |
|
|
Jan 30 2015, 03:41 PM
Return to original view | Post
#31
|
|
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. hehe - personally i look at bears like doing UPper cut (happy buying time for me)http://www.investopedia.com/ask/answers/129.asp vs bulls goring people DOWN (nervous time for me) i wired-wrongly gua just a thought |
|
|
Jan 30 2015, 03:53 PM
Return to original view | Post
#32
|
|
Elite
5,608 posts Joined: May 2011 From: Here, There, Everywhere |
QUOTE(woonsc @ Jan 30 2015, 03:44 PM) 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 This post has been edited by wongmunkeong: Jan 30 2015, 03:54 PM |
|
|
Feb 1 2015, 02:11 PM
Return to original view | Post
#33
|
|
Elite
5,608 posts Joined: May 2011 From: Here, There, Everywhere |
|
|
|
|
|
|
Feb 1 2015, 07:51 PM
Return to original view | Post
#34
|
|
Elite
5,608 posts Joined: May 2011 From: Here, There, Everywhere |
|
|
|
Feb 1 2015, 09:18 PM
Return to original view | Post
#35
|
|
Elite
5,608 posts Joined: May 2011 From: Here, There, Everywhere |
|
|
|
Feb 5 2015, 09:51 PM
Return to original view | Post
#36
|
|
Elite
5,608 posts Joined: May 2011 From: Here, There, Everywhere |
QUOTE(TakoC @ Feb 5 2015, 09:17 PM) TakoC - nerds built the Internet, Web, etc lehEven 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 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 U closet tinkerer U Polarbearz - thinkerers & builders build, thankless task but the "baby" created & the help it provides - 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 Your baby looks good! |
|
|
Feb 12 2015, 08:00 AM
Return to original view | Post
#37
|
|
Elite
5,608 posts Joined: May 2011 From: Here, There, Everywhere |
|
|
|
Feb 19 2015, 07:57 AM
Return to original view | Post
#38
|
|
Elite
5,608 posts Joined: May 2011 From: Here, There, Everywhere |
|
|
|
Feb 26 2015, 10:04 AM
Return to original view | Post
#39
|
|
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. yeah Sis.they probably invested 2 weeks to get those numbers. actual return is very much less. 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. |
|
|
Feb 27 2015, 12:28 PM
Return to original view | Post
#40
|
|
Elite
5,608 posts Joined: May 2011 From: Here, There, Everywhere |
QUOTE(Pink Spider @ Feb 27 2015, 11:39 AM) cicaks 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 |
|
Topic ClosedOptions
|
| Change to: | 0.0603sec
0.34
7 queries
GZIP Disabled
Time is now: 13th December 2025 - 12:13 AM |