Outline ·
[ Standard ] ·
Linear+
Fundsupermart.com v4, Manage your own unit trust portfolio
|
TakoC
|
Oct 23 2013, 05:18 PM
|
|
QUOTE(Pink Spider @ Oct 23 2013, 05:14 PM) For the sake of non-regulars, put full name lar Yea lor, I also regretting switching out from Ponzi Quantum to Select Asia Opp  Luckily it's not much, ratio 1/3 Select opp + 2/3 Quantum Ponzi Hey, where's your dildo?  Can switch half of Select Opp to PGSF, and half to Quantum. Thoughts? Shoosh.. show you sexy back
|
|
|
|
|
|
TakoC
|
Oct 23 2013, 05:25 PM
|
|
QUOTE(Pink Spider @ Oct 23 2013, 05:21 PM) Yeah, now I'm slowly building up Pacific Global Stars instead of Hwang Select Asia Opp. If it still remain that way, I might even switch all back to Quantum Ponzi. Eh, I thought u wanna dump PGSF before?  Leaving my PGSF as it is since it's doing quite well. Second purpose is to hedge it against OSK GEYF- still a bit shaky. If switch out partial of my Select Opp, I don't know how to record my books already (don't know how to record loss) This post has been edited by TakoC: Oct 23 2013, 05:27 PM
|
|
|
|
|
|
TakoC
|
Oct 23 2013, 05:30 PM
|
|
QUOTE(Pink Spider @ Oct 23 2013, 05:27 PM) Are u using my MS Excel worksheet to record? GEYF is always US+Europe heavy, PGSF will rotate according to Pacific Mutual's markets assessment though it has always been around 2/3 Asia + 1/3 US+Europe. PGSF is "spicier" compared to GEYF.  I used gark work sheet and alter to my style. I vaguely remember yours quite complicated and you record switch out everything in the table itself. Maybe can share with me your work sheet again
|
|
|
|
|
|
TakoC
|
Oct 23 2013, 05:46 PM
|
|
QUOTE(Pink Spider @ Oct 23 2013, 05:34 PM) Okay. Let's say 378.87 of AmAsia Pacific. How would you record it? You cannot just delete the whole of row '5' right? Although you are selling 378.87 units, the amount will not be RM235 already. So how would you record it? Assuming you buying Hwang Select Income, that would be straight forward. You just record like how you buy it. Edit: Okay. I saw your switch sell column (row 25). So you will record your switch sell in the table itself. RM556.20 is the total proceed of selling the 1,000 units right? This post has been edited by TakoC: Oct 23 2013, 05:47 PM
|
|
|
|
|
|
TakoC
|
Oct 23 2013, 06:04 PM
|
|
QUOTE(Pink Spider @ Oct 23 2013, 05:55 PM) Yes. Negative cashflow is purchase Positive cashflow is sale Dividends, as u should know by now, does not result in cash flow (e.g. row 18), it only results in additional units All calculations are by formula, go study it closely and u will see how the profit/(loss) and IRR figures come about  For my side, my profit/(loss) ROI and IRR figures are calculated in seperate tabs. So I headache how to calculate for my IRR figures. Btw, I don't remember your worksheet looking like that. Much messier than that.
|
|
|
|
|
|
TakoC
|
Oct 24 2013, 08:11 AM
|
|
QUOTE(Pink Spider @ Oct 23 2013, 09:25 PM) Is that an insult or a compliment? My worksheet has always been that, just that I deleted some data, else u guys will know how much is my portfolio  My holding of Hwang funds on continuing weakness...past 6-months period, they underperformed Eastspring GEM, Pacific GSF and OSK-UOB GEY. That's why, NEVER assume that past winners will continue its winning streak  Neither. Just remember the whole column being more cramped up
|
|
|
|
|
|
TakoC
|
Oct 28 2013, 06:19 PM
|
|
yawn* So quiet around here. Everyone hibernating?
|
|
|
|
|