Stockopedia for AIM #5 – Consolidation

Stockopedia for AIM

Today’s post is our fifth in a series on Stockopedia for AIM – we’re working towards using the screening tool to put together an AIM IHT portfolio.

The story so far

We’ve used Stockopedia to produce nine screen and portfolios designed to find AIM stocks suitable for an IHT portfolio:

  1. The Stockopedia “Screen of Screens”
  2. A “safe” AIM screen
  3. The AIM stocks in our Family Firms portfolio
  4. The AIM 100 (minus those stocks that might not be eligible for BPR)
  5. An Economic Moats screen from Ben Hobson
  6. A neglected Stocks screen (again from Ben)
  7. A ready made Stockopedia screen based on Richard Beddard’s investing approach
  8. A hand built screen based on Phil Oakley’s investing approach
  9. A “Gold” list of stocks that have been selected by professional IGT Portfolio asset managers

Today’s task is to consolidate these lists into one and select the best 50 stocks for our portfolio.

  • At a future date, we’ll add a 10th “Silver” list of stocks that have been highlighted on Twitter or in the public portfolios of selected investors.

Downloading a CSV file from each of the screens and portfolios is straightforward in Stockopedia.

  • I downloaded 8 files and imported them into an Access database

My Access skills are pretty rusty – I haven’t used it in five years, and the version I now have (2007) is one I have never used at all.

First I had to work out how to create append queries to add all the data into a master table.

  • Using the ticker as an index key (and disallowing duplicates) meant that I got a list of uniques.
  • I also had to change all the relevant field types to numeric, since everything imported as text.

The master table has 148 records, so we need to start filtering some out.

Market cap and profitability

The first step was to exclude stocks with a market cap  of less than £50M.

  • That gets us down to 135 stocks.

The second step was to exclude stocks that aren’t making a profit.

  • This shows up as a missing PE ratio.
  • And it gets us down to 123 stocks.
Risk and Styles

Next up is a query to count the stocks by Risk Rating:

Count by Risk

By sticking to the three lowest risk groups, we can eliminate another 22 stocks.

  • That gets up down to101 stocks.

Next up are the Stock Styles:

Count by Style

There are six Styles in the list:

  • Two are positive styles (Super Stocks and High Flyers) – there are 52 in this group
  • Three are neutral styles (Neutral, Turnaround and Contrarian) – there are 45 in this group
  • One is a negative style (Falling Star) – there are four in this group.

So we can eliminate another 4 stocks, to get down to 97.

Ranks and sectors

Now we can start to set minimum Rank values to further reduce the list:

  • Setting the minimum Stock Rank to 50 gets us down to 88 stocks.
  • Setting the minimum Value Rank to 20 gets us down to 65 stocks.
  • Setting the minimum Momentum Rank to 20 gets us down to 63 stocks.
  • Setting the minimum Quality Rank to 20 keeps us at 63 stocks.
See also:  Making a Will

Let’s look at the spread of sectors and industry groups:

Count by Sector

We can exclude the financials sector, which gets us down to 57 stocks:

Here’s what we’re left with:

Count by Sector 2

Given where we are in the economic cycle, I’m not crazy about the large number of consumer cyclicals we’re left with, but that’s where we are.

  • I’m going to have to trust that the Stockopedia algorithms know what they are doing, and will get me out of any stocks that start to deteriorate.

To get down to 50 stocks, I plan to just leave out the 7 with the highest PE:

High PE

If there are any red flags when I come to buy the stocks on the final list, I can use these stocks as reserves.

So by setting the maximum PE to 27, we have our list of 50 stocks.

  • I noticed that Dewhurst is on the list twice, so I’ve removed DWHT (the more expensive of the two tickers)
  • That means putting the PE limit up to 28 to reinstate Conviviality to the list.

Final 50 part 1

Final 50 part 2

So that’s it for today – time to start buying some stocks.

  • We’ll review the numbers around a month after I finish building the portfolio.

Until next time.

Mike is the owner of 7 Circles, and a private investor living in London. He has been managing his own money for 40 years, with some success.

You may also like...

3 Responses

  1. Mike,
    fantastic work
    FYI—I notice that you have YNGA down twice
    Kind regards

  2. actually Its Young & Co’s Breweyry—-both versions of share

Leave a Reply

Your email address will not be published.


Stockopedia for AIM #5 – Consolidation

by Mike Rawson time to read: 2 min