Hmm, the original snapshot code was from Polarzbearz. Anyhow, here are the fixes. Since you probably already have data in your files, you should fix this yourself with the following instructions (it's easy, so don't worry).

Fixing Instructions: Part A

That should fix the error that you saw. Now if you click on the "Capture Snapshot Only" button again you might see another error. This should be another easy fix (see Part B)

Fixing Instructions: Part B

I've only tested on Excel 2011, you can try the same fixes on Excel 2016. Let me know if you encounter issues.

Updated files if you want to start fresh (I recommend you apply the fixes above rather than having to reenter all your data again):
[attachmentid=8491160]
[attachmentid=8491133]

2) just because you might be slightly risk averse, doesn't mean 60% bond fund is 'logical'. I have only 4 - 5 % in bond fund, seems like very high risk but not really. Because i have other non-invested asset, held in cash. So, you can still be 'balance' without buying so much bond funds. There are other ways to 'balance' it.

Hi. I just got my fsm account approved last week. Ihave RM5k to invest in FSM. Can you all suggest the portfolio that are shariah compliant.

by drop I would means the uncertainty. But you guys have a point. Procrastination do have the cost.

On the side note, do platform fees considered when they calculate NAV & annualized return shown in the website?

If you compare with Malaysian funds, malaysian bonds sucks. See the results from Trump tantrum.


See the pic above.

I am just showing why affin hawng is superior to malaysian bond fund. Never say never. Things can happen again.

there are polarzbear's file for window and mac version
have you been using the polarzbears file for MAC OS version all these while?

oohh,...

i think, normally for other window file when I want to want to run with Macro,...I have to save as macro enable file to enable that file to run it.

does mac needs to do that too?

may I suggest you download the mac file again,
just copy a few data,....test to see if I can work?

if it can work,....copy all the data to this new file...
if it cannot work,....
.......have to wait for the 'creator" to come in to assist.....unless some other is kind enough to assist.

Last year, I passed an Excel file with macro to my friend and he could not run it in his Mac Air. Later learnt that macro part was not included in the Excel Win to Excel Mac package.

Any Mac user can confirm this?

Thanks.

P/S That is one of the reasons why I have not migrated to Mac as I have a lot work in Excel macro.

Hi screwedpeep, I uploaded two files in this post: https://forum.lowyat.net/index.php?showtopi...post&p=83747364

The 2016 file is for 64bit, while the 2011 file is 32bit. My fault for naming them 2011/2016 instead of 32bit/64bit.

AIYH Would you please update the first post with these files instead?

I have similar thoughts too. Nothing against the great Excel file did by our fellow LYN members, but despite all the instructions here, I still fail to utilize it appropriately. If anyone found any alternatives (for Excel-newbies like me), kindly enlighten me.

Hi all, want to ask some advice. I'm using Polarbearz spreadsheet and keying in all my FSM transaction as of date. No issues with buying and selling transaction. but when comes to dividend from the Fund, the number of units does not tally with the amount.

For eg, 18 Apr 2017, CIMB fund gave a div of RM 131.62 @ 0.3393 NAV price. My transaction history shows 387.91 units added. I keyed in the transaction type as Dividend, Transaction Amt = RM 131.62, NAV = 0.3393 but the final unit comes out as 131.62 units.

Should i use the Transaction manual adj to change the units qty?

For instance, you might have thought you are an aggressive investor who can cope with a high level of risk. However, in practice, if you find that you always panic too soon every time the market dips, and get overly euphoric and pump in more money whenever markets are on a roll, then high-risk investments may not so suitable for you because they are likely to cause you to lose money.

New Malaysian fund onboard by eastspring.

KUALA LUMPUR: Eastspring Investments Bhd has introduced its Islamic small capital (small-cap) fund, which will concentrate on syariah-compliant domestic stocks with potential returns in the medium to long term.

Eastspring chief executive officer Raymond Tang Chee Kin said that to date syariah funds under management in the local market recorded an 8% growth to RM96.7 billion. In comparison, the returns of FTSE Bursa Malaysia small-cap syariah index was 73.83% while that of FTSE Bursa Malaysia KLCI was 39.56%. 
"Even though the returns of syariah index is slightly lower than the conventional stocks returns at 82.16%, we can see the gains from syariah counters improving," he told reporters after launching the Islamic Small-Cap Fund in Kuala Lumpur on Thursday.

Tang said a minimum 70% of the net asset value (NAV) would go to syariah-compliant equities and equity-related securities and a minimum 1% of asset allocation would be channeled to Islamic deposits or Islamic liquid assets. 

"The small-cap segment is under-researched and under-servingly traded beyond its intrinsic value, so Eastspring will use this opportunity to unearth these small-cap companies and exploit the pricing inefficiencies," he added.

The initial issue price for the fund is 50 sen per unit for 21 days of the initial offer period beginning Thursday.

The minimum initial investment is RM1,000 and the minimum additional investment is RM100. As at March this year, the funds managed by the company stood at RM40 billion. - Bernama

Today maybe is a busy day, too many callers.

maybe you ask here we can help faster than them

Yes don't blindly follow anyone. Find what you are comfortable with and stick to it.

In other news, Eastspring Islamic Small Cap is out, might be a decent sub for the now-closed Eastspring Small Cap?