Welcome Guest ( Log In | Register )

Bump Topic Topic Closed RSS Feed
11 Pages « < 6 7 8 9 10 > » Bottom

Outline · [ Standard ] · Linear+

 Fundsupermart.com v8, The MS Excel Masterclass version!

views
     
woonsc
post Jan 31 2015, 11:12 AM

Financial Padawan
*******
Senior Member
2,032 posts

Joined: Jan 2014
From: Sabah, Malaysia
What's ILP? Investment Link Properties??
woonsc
post Jan 31 2015, 11:20 AM

Financial Padawan
*******
Senior Member
2,032 posts

Joined: Jan 2014
From: Sabah, Malaysia
QUOTE(polarzbearz @ Jan 31 2015, 11:17 AM)
Investment Linked Policy for Insurance cry.gif
*
for me.. i just pay minimum premium lol
woonsc
post Jan 31 2015, 05:17 PM

Financial Padawan
*******
Senior Member
2,032 posts

Joined: Jan 2014
From: Sabah, Malaysia
Do you guys still invest in PM funds?
woonsc
post Jan 31 2015, 05:30 PM

Financial Padawan
*******
Senior Member
2,032 posts

Joined: Jan 2014
From: Sabah, Malaysia
QUOTE(David83 @ Jan 31 2015, 05:19 PM)
No. Totally repurchased!
*
sell all back into EPF or buy FSM?

eh i thought u PM thread starter? tongue.gif rclxms.gif

This post has been edited by woonsc: Jan 31 2015, 05:30 PM
woonsc
post Feb 2 2015, 04:21 PM

Financial Padawan
*******
Senior Member
2,032 posts

Joined: Jan 2014
From: Sabah, Malaysia
QUOTE(TakoC @ Feb 2 2015, 04:18 PM)
Yup. There is. That's why my spreadsheet and FSM amount is different by RM.01
*
haha FSM slowly slipping ur money away~ biggrin.gif biggrin.gif
woonsc
post Feb 2 2015, 07:11 PM

Financial Padawan
*******
Senior Member
2,032 posts

Joined: Jan 2014
From: Sabah, Malaysia
QUOTE(TakoC @ Feb 2 2015, 06:15 PM)
This month everyone also showing good progress. Can't wait ah? Haha!
*
haha really good.. from Negative total portfolio till 4% now.. u guys?? brows.gif brows.gif
woonsc
post Feb 3 2015, 01:16 PM

Financial Padawan
*******
Senior Member
2,032 posts

Joined: Jan 2014
From: Sabah, Malaysia
QUOTE(Pink Spider @ Feb 3 2015, 12:51 PM)
aku belum kahwin blush.gif
*
Marry! rclxms.gif rclxms.gif
buy ring for next meeting~
woonsc
post Feb 3 2015, 01:27 PM

Financial Padawan
*******
Senior Member
2,032 posts

Joined: Jan 2014
From: Sabah, Malaysia
QUOTE(yklooi @ Feb 3 2015, 01:22 PM)
Read page #76 post # 1506 and # 1510 for profile pic relationship.... thumbup.gif
*
how to search? rclxub.gif rclxub.gif
woonsc
post Feb 3 2015, 04:33 PM

Financial Padawan
*******
Senior Member
2,032 posts

Joined: Jan 2014
From: Sabah, Malaysia
QUOTE(Pink Spider @ Feb 3 2015, 04:24 PM)
Today got NAV prices update meh? blink.gif

As at 29th Jan my 1-month gain is +4.65%
*
haha with your investing skills, you can afford to have 2 wifes loo~ notworthy.gif notworthy.gif notworthy.gif
woonsc
post Feb 3 2015, 04:40 PM

Financial Padawan
*******
Senior Member
2,032 posts

Joined: Jan 2014
From: Sabah, Malaysia
QUOTE(Pink Spider @ Feb 3 2015, 04:38 PM)
This one I long time no see already yawn.gif

U dunno how many unkers died on her hand brows.gif

That one I see her often...every day log in LYN see her photo, when meet her, I malu blush.gif
*
share share laa~ blush.gif

woonsc
post Feb 3 2015, 05:56 PM

Financial Padawan
*******
Senior Member
2,032 posts

Joined: Jan 2014
From: Sabah, Malaysia
QUOTE(polarzbearz @ Feb 3 2015, 05:43 PM)
As for Pink Spider, need your help to do a one-time update in the first post tongue.gif. I've made changes accordingly (based on your existing first post) in below code so you can just copy&paste easily thumbup.gif

CODE

Download here >>> [url=http://bit.ly/polarzbearzPortfolioSummary][b]polarzbearz's Portfolio Summary with Pinky's IRR Calculation[/b][/url] [url=http://bit.ly/polarzbearzPortfolioSummaryConversionTool][color=orange][b](and here for Polarzbearz's FSM-to-Spreadsheet Conversion Tool)[/b][/color][/url]
[url=https://forum.lowyat.net/uploads/attach-75/post-103975-1421671981.jpg][img]https://forum.lowyat.net/uploads/attach-75/post-103975-1421671981_thumb.jpg[/img][/url][url=https://forum.lowyat.net/uploads/attach-75/post-103975-1422956518.jpg][img]https://forum.lowyat.net/uploads/attach-75/post-103975-1422956518_thumb.jpg[/img][/url]

[i]Make sure you read the instructions as many of the cells have formula in it. You can freely modify, update, or change it to suit your needs (and even share with others if you don't mind :P )[/i]


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

*
Would love to have a husband like him~ notworthy.gif notworthy.gif

woonsc
post Feb 3 2015, 06:04 PM

Financial Padawan
*******
Senior Member
2,032 posts

Joined: Jan 2014
From: Sabah, Malaysia
QUOTE(polarzbearz @ Feb 3 2015, 06:02 PM)
rclxms.gif
user posted image cry.gif cry.gif go far far away you both

I want my dream girl only brows.gif
*
I prefer Song Ji Hyo~ tongue.gif
If i get Song and IU..

Song Ji Hyo best! flex.gif flex.gif

woonsc
post Feb 3 2015, 06:40 PM

Financial Padawan
*******
Senior Member
2,032 posts

Joined: Jan 2014
From: Sabah, Malaysia
polarzbearz leng lui ya..
I followed all ur advise..
but the transaction amount and NAv Price is cacat..

can pm ur email? so u can fast check..
I am using Excel 2010, different from yours..
woonsc
post Feb 3 2015, 07:26 PM

Financial Padawan
*******
Senior Member
2,032 posts

Joined: Jan 2014
From: Sabah, Malaysia
QUOTE(polarzbearz @ Feb 3 2015, 07:15 PM)
notworthy.gif  notworthy.gif I found the root cause (this happens when we have different locale setting. Example: my excel doesn't parse "RM 1,234.00" into Number 1234.00, it is treated as text string. But if we are using Malaysia Locale setting; RM 1,234.00 will be treated as numeric value 1234,00.

Working on it now tongue.gif
*
Love you IU~ wub.gif
woonsc
post Feb 3 2015, 07:55 PM

Financial Padawan
*******
Senior Member
2,032 posts

Joined: Jan 2014
From: Sabah, Malaysia
QUOTE(polarzbearz @ Feb 3 2015, 07:29 PM)
Released v1.1 of the Conversion Tool, can be downloaded via clicking here.

Change log:
CODE
Fixed a bug which will happen if user's locale setting is set to Malaysia (where ""RM"" will be removed from Unit Price / Investment Amount automatically by Excel) - by having two approaches:
If approach (1) to directly conversion of the value into numeric value fails (it's a text string); it'll use approach (2) where the manual trimming method will be used to remove the ""RM "" (text RM<space>) and convert it into digits.


woonsc you can try again and see if the problem persists tongue.gif

Tested on your sample data and working fine for me (excel 2013)
*
Can le.. thx..
But convert..
But when i copy, and paste as values..
The entire row of formular gone rclxub.gif rclxub.gif
woonsc
post Feb 3 2015, 09:27 PM

Financial Padawan
*******
Senior Member
2,032 posts

Joined: Jan 2014
From: Sabah, Malaysia
QUOTE(polarzbearz @ Feb 3 2015, 08:33 PM)
Do you have enough rows to "hold" those values? There's no formula in the first few columns, just formatting. Unless you dont have enough rows in the spreadsheet to hold the values (do it fund by fund, not one shot everything)
*
thx~ all good~ rclxms.gif
woonsc
post Feb 3 2015, 09:54 PM

Financial Padawan
*******
Senior Member
2,032 posts

Joined: Jan 2014
From: Sabah, Malaysia
polarzbear haha i found something.. for the fund allocation.. even ur copy and paste kan..

u see ur 2nd 3rd 4th and so on..
all refer back to $B$8
which is the 2nd fund amount.. cause the number value is fixed on 8..

woonsc
post Feb 3 2015, 10:42 PM

Financial Padawan
*******
Senior Member
2,032 posts

Joined: Jan 2014
From: Sabah, Malaysia
QUOTE(yklooi @ Feb 3 2015, 10:13 PM)
rclxms.gif  notworthy.gif woonsc and polarzbearz
thank you.
*
haha i respect polar bear more..
he did this incredible work..
I am just a normal user blush.gif ..
woonsc
post Feb 3 2015, 10:51 PM

Financial Padawan
*******
Senior Member
2,032 posts

Joined: Jan 2014
From: Sabah, Malaysia
QUOTE(wan_109 @ Feb 3 2015, 10:48 PM)
Hello guys, may I know if the Annual Expense Ratio already includes other fees listed in Fundsupermart website? For example Annual Management Charge and Trustee Fee.
*
yeap.. deducted by the FM from ur NAV everyday~

kecuali ur Front Load SC la.. nod.gif

QUOTE
Q: WHAT KIND OF CHARGES DO I HAVE TO PAY?

A: There are 2 types of charges. One is the sales charge and the other is the annual expense of the fund.
The normal sales charge for most equity funds are around 7%. However, at Fundsupermart, the advantage is that most equity funds are sold at around 2% sales charge. The sales charge is applied at purchase.

The annual expense of the fund is what is charged to the fund. This includes the fund manager's annual management fee, and other administrative fees that are incurred in the running of the fund. You do not really need to fork out additional money to pay for the annual management charge to the fund manager. They will actually deduct it from the Net Asset Value of the fund daily, and the published price will take into account of the pro-rated annual management charge.


FSM Q&A

This post has been edited by woonsc: Feb 3 2015, 10:53 PM
woonsc
post Feb 3 2015, 11:10 PM

Financial Padawan
*******
Senior Member
2,032 posts

Joined: Jan 2014
From: Sabah, Malaysia
QUOTE(wan_109 @ Feb 3 2015, 10:56 PM)
Thank you very much for your swift reply.

I'm currently targeting 3 unit trusts, namely Kenanga Syariah Growth Fund, Eastsprings Dana Investment al-Ilham and Aberdeen Islamic World Equity Fund - Class A.

Currently I'm leaning towards Eastsprings. Would you guys think that would be a good choice?

Thanks again.
*
yeah.. i looked through it briefly..
I lean more to Eastspring too..
they have similar returns somehow.. but Eastspring has lower volatility then Kenanga..
U can see the Lipper Ratings also.. Eastspring have a straight 555..
compared to Kenanga 545.. notworthy.gif notworthy.gif

but Past performance is not an indicator of future performance..
all has risk, notworthy.gif notworthy.gif

« Next Oldest · Finance, Business and Investment House · Next Newest »
 

11 Pages « < 6 7 8 9 10 > » Top
Topic ClosedOptions
 

Change to:
| Lo-Fi Version
 0.0524sec    0.73    7 queries    GZIP Disabled
Time is now: 30th November 2025 - 12:18 AM
All Rights Reserved © 2002- 2025 Vijandren Ramadass (~unite against racism~)
Removal Request
Powered by Invision Power Board © 2025  IPS, Inc.