Very politically correct way to remind that idyllrain has no Mac to code with, not just test

Hello, first time investor here, got my FSM account ready last year but decided to hold till this year to get the RM1k incentive.

I've decided to invest RM3k per year to maximise the tax rebate too.

My question is, should i just invest may be around RM1100 for one fund (to get the incentive) and then take my time to invest the remainder in the next few months? I think it would be safer to break into a few PRS funds right?

Aye, I personally prefer to go for the Dollar Cost Averaging method, and invest the remaining RM1900 over next few months.

By the way, the sifu here are mostly on Unit Trust and Bond. Even though FSM also provide a convenient platform for PRS fund, most of the PRS sifus are at this thread instead.

Since you will have a very long horizon, and I "think" the investment amount is not that much (including the yearly fees)....I would suggest go for

20% KENANGA ONEPRS GROWTH FUND
30% AMPRS - ASIA PACIFIC REITS - CLASS D
50% CIMB-PRINCIPAL PRS PLUS ASIA PACIFIC EX JAPAN EQUITY - CLASS C  

to have a more diversified coverage, instead of just focusing on 1 fund.

This post has been edited by T231H: Feb 5 2017, 10:58 AM

How to add some funds (which are not in there yet) in the file?

check the other worksheet?
if not listed there too, can see the main worksheet, there are some write up on how to get the code.

Will do some readings on the information provided. Thanks!

Eh forgive me for my ignorance. What is the RM1k prs incentive? Can share some details?

see this?
PRS Youth Incentive
http://www.ppa.my/prs/prs-youth/prs-youth-incentive/

Youth Incentive FAQS
http://www.ppa.my/prs/prs-youth/youth_faq/


This post has been edited by T231H: Feb 5 2017, 11:15 AM

Yea that's the one, for those from 20-30 years old. It used to be Rm500 only but it's RM1k this year onwards.

Oh wow, didn't know about this. Is it truly free? Just RM1k they give to you? Sure there are catches.


--------------------------------------

If anyone is interested in the foreign outflow/inflow from Bursa.



This post has been edited by contestchris: Feb 5 2017, 11:56 AM

This will be only about Bursa.

Foreign buy/sell of local unit trust funds ?

Yeah. Park RM1k with them they give you free RM1k. Both money can only be withdrawn at 55 years old.

Want to pay less income tax? Park rm3k/year (valid until 2021) get tax relief.

So far 2 methods I could think of:
1. Rewrite the excel marco to fits Mac
2. Use Virtual Machine to run windows on ur PC. E.g.: VirtualBox and etc.

Guys, just a quick question to those who keep a track of their investment returns from time to time (at least once a year).

What method of calculating your returns do you use?

Just a basic ROI: [(end year total value of holdings/total sum invested) - 1] * 100%

Or use something like IRR/XIRR?

I am asking cause I am confused about how to calculate my initial investments on 27 Dec 2016 and how to reconcile it going forward.

Sometimes it is easier to build a file from scratch, than using another person's file as a template.

If you do know some Excel, it is more simpler to make you own file instead of wasting time to review and check everything in another person's file.

I learned Excel by poking around here and there... started with the basic data or details neccessary to form the file.

Then, manually copy and paste the current NAV prices to update file - fund by fund...

Then by adding in another tab and copy (manually) all the fund prices found in the webpage into the tab, and linking the fund's price to the right nav price in the new tab. (Only need to copy and paste once, instead of copy and paste fund by fund.)

Then learned a bit about importing data from the webpage instead of opening the webpage and copy and paste manually the prices.

Voila, now can update the nav prices within a second...by pressing 2 keys, Alt+F5.

ROI and CAGR: both can be calculated line by line (purchase by purchase), and displayed on each line.
IRR: Using the XIRR function. This is like a summary of all the purchases.

Example:

Date1, Fundxxx, Amount-Paid, Units, Nav-Price, CurrentValue, RoiAmount, ROI%, CAGR
Date2, Fundxxx, Amount-Paid, Units, Nav-Price, CurrentValue, RoiAmount, ROI%, CAGR
Date3, Fundxxx, Amount-Paid, Units, Nav-Price, CurrentValue, RoiAmount, ROI%, CAGR

TotalValue = ???
TotalRoi = ???
IRR= ???

----------
- put in the appropriate formulas for CurrentValue, RoiAmount, ROI% and CAGR.

- put the necessary fields for the XIRR function out of sight on the far right of the spreadsheet.
The necessary fields for the XIRR function:
Date1, (Amount-Paid)
Date2, (Amount-Paid)
Date3, (Amount-Paid)
CurrentDate, TotalValue

Note: The amount-paid is in negative.

importing data from webpage is easy? Mind sharing..?

Maybe you don't remember... but we were talking about this several years ago on updating the nav prices by copy and paste... and then Wong Sifu said something about import data. I took the initiative to learn something new, while you come here to read for entertainment?

Okay... just pulling your leg...

Open and create a new excel file... to try out following:

- Under the "Data" pull-down menu, click the "From Web" icon to get external data from web.
- A small window opens.
- In the new window: copy and paste the address of the webpage you want into the address field, and then click the 'Go' button.

- the webpage (if the address is correct) will open. Now play around and click the section(s) you want to copy and import.
- click the 'import' button.
- Done.

===========

poke around the "small new window"... see the "Options" in its menu?... open it, and then select Formatting: None.

==========

When you want to update and refresh the data, move the cursor to any part of the imported section and press Alt+F5.

So far, I only imports from one webpage. This should work the same if there are several webpages. Just move the cursor to the appropriate section, and press Alt-F5.

This post has been edited by j.passing.by: Feb 5 2017, 05:26 PM

Haha... was here for the vietmui info only..

Let me try to follow your method and see how it goes... thanks