Filtering Midcap and Smallcap shares

Follow by previous post, I am going to share how to do first level filtering to shorten your list. I am going to use the http://www.shareinvestor.com/sg platform. I think you need to register to use the following function.

Step 1: choose "Edit Custom" under the "column layout".

Step 2: build the column as shown below or whatever you like. But keep the "ROE(%)" and "Net Earnings Margin(%)". We need these later.

Step 3: Choose "Custom" under the "column layout".

Step 4: Copy everything into Excel

Step 5: Sort "Net Earning Margin(%)". Largest to Smallest.

Step 6: Remove those "Net Earning Margin(%)" below 10%.

Step 7: Sort "ROE(%)". Largest to Smallest.

Step 8: Remove those "ROE(%)" below 15%.

Congratulation! You have just reduced the Midcap list from 50 to 12. You can repeat the same things for Smallcap which should reduce the list to 28. Please note that those list you "removed" may not be bad companies. ROE 15% is very close to ROE 14%. MapletreeGCC may not be a bad company, just because it doesn't has many data for analysis.

Side track a bit, do you happen to see "NOL" in Midcap? Last time this company was STI component share. But it lost money and trading at it's NAV now. So, STI component shares, or so call "blue chips" may not always be stable forever shares.

It's quite fun to learn what companies are doing and how they perform. Not only you can have more topics to talk with you friends, business talk with bosses; You can know what company to look for for your next job. Normally good companies pay good bonus...:)

I have filtered a list for you if you don't want to repeat the steps above:
https://www.dropbox.com/s/hxlraa46css0sg5/MidCap_SmallCap.xlsx