Jump to content

Data mining – finding cheap and un-loved stocks using IG filters

Recommended Posts

In this article I will go through a quick set of criteria, build a filter and see what comes out the other end.

 

With the FTSE100 at all time highs, let’s look through that selection (the UK 100 stocks) and try and find potential trade opportunities.

The overall index has moved up over the preceding months but how does that resonate with particular stocks.

Which have been left behind, and

Can we find any hidden gems  that may be worth further inspection?

 

To help answer these questions we will use IG’s own tools designed to help investors filter through the vast population of stocks and hone in on those that meet a set of criteria: Data mining.

 

From the classic IG trading platform, go to the ‘Research’ button and click on Market Screener (or simply click on this link for our market screener), a new tab will open.dm_screening1.JPG

 

From here the first thing I have done is clicked ‘Reset’ to clear any pre-existing filters: we have a blank canvas now.

Scroll down to the bottom of the list and you will see there are 10+ pages of stocks, this is too many to review, so let’s focus on refining that list.

dm_screening2.JPG

 

From the left-hand-side I selected the group we are interested in. In this piece I want to look at those within the overall 100 index. So I click this selector on the left-hand side under ‘Index’

dm_screening3.JPG

 

 – the screener tells us we have limited to 102 stocks (not sure why its 102, I’d expect 100, but its close enough for now)

dm_screening4.JPG

 

Now let’s dig a bit deeper. I am looking for those unloved stocks that have not benefited from the moves encountered by the FTSE over the last month or so. We click ‘Select Fundamentals’.

dm_screening5.JPG

 

First thing we’ll add is a screen to identify shares that have not moved positively in price over the last two or so months. This suggests they have not moved in step with the index through November and December '17. So I select the criteria shown

dm_screening6.JPG

 

We use the tolerance sliders to set our criteria. I want to select shares that have not realised good gains over the last 13 weeks – I set my maximum to 5% (gain) and minimum to -15% (suggests share has actually fallen in price)

dm_screening7.JPG

 

I am also going to retrieve shares that have a lowly PE rating. With the Cyclically Adjusted PE (CAPE) now standing above 30 (source: SCSW Jan-18) setting our PE ratio threshold to a maximum of 13 means we are excluding the highly rated stocks that are up on a par with the CAPE, and looking for those that are less favourably rated. Same again, 'Select fundamentals' and pick our criteria...

dm_screening8.JPG

 

Lastly, I want to obtain some form of 'comfort' in the stock I am buying. We can add in the ratio Price/Tangible Book, and this at least gives us the certainly that the stocks will be backed by some form of physical asset (store, stock, merchandise, fittings, cash etc) There is no hard-and-fast rule here, but let’s set the maximum slider to 2.5 = that is to say the stocks we are screening for will have a share price that is no more than 2.5 x tangible assets per share. The lower this value, the nearer the shares are in comparison to their book value (the assets as recognised on the balance sheet)

dm_screening9.JPG

 

Right, let’s recap.

  • We know the FTSE 100 is at an all time high, or thereabouts
  • We know CAPE sits above 30 (read this as average PE of 30 across the market)
  • We are looking for FTSE100 shares that have not risen in step with the FTSE index over the 2017 Christmas period- as we hope there will be some anomalies
  • We are looking for lowly rated shares – those not trading on high multiples, and certainly less than CAPE
  • Also we want some kind of asset backed security, so will ensure the shares are no more expensive than 2.5x the tangible asset value.

 

Our results are below. We get 7 shares returned from this screen:

  • MKS
  • SBRY
  • UU.
  • BDEV
  • 3i.
  • SSE
  • LGEN

dm_screening10.JPG

Interestingly, I have positions in two of these shares already and am betting exactly that the shares are under-rated and due a positive correction in the near term. We also talked about LGEN in another thread, where our contributor,  has an interest

 

Of these 7 there are a few things to note:

  • MKS is down 10% over the prior 13 weeks
  • SBRY is strongly asset backed at only 0.86 of its tangible asset value
  • Both 3i and SSE are on strikingly low PE ratios

 

  • I think this provides an opportunity for further investor research:
  • What PE ratios do the competitors of 3i and SSE trade on, is there a sector anomaly that could be exploited?
  • Is MKS set for an easy 10% gain in the coming weeks (results imminent for Christmas period)
  • Is SBRY offering a quick 15% trade whilst its share price is selling for less than the per share asset backing?

 

Let me know any thoughts you might have – again, this is not advice but a chance to look into some techniques for valuing unloved shares and potentially exploiting anomalies in solid FTSE100 companies..

Is this useful? 

What would you do differently?

We could follow this on and look at mining for solid dividends another time..

  • Like 1
  • Great! 2

Share this post


Link to post

Well the news is starting to flow, so we can look at our trade ideas and establish if the calls made were indeed fortuitous.

 

Today (10 Jan 18) sees the release of SBRY trading statement Q3 covering the 15 weeks to 6 January 2018.

 

My assertion was SBRY had not benefited from the overall index move in the run-up to Christmas, but it was nonetheless a quality company and I was expecting positive news.

 

https://www.investegate.co.uk/sainsbury-j--plc--sbry-/rns/third-quarter-trading-statement/201801100700034219B/

 

I quite like the way this reads - especially for a retailer in the current climate of increased competition (Aldi, Lidl on the scene), inflation and rising input costs due to exchange rate movements.

The headline reads 

'strong Christmas week, with record sales, over 340,000 online grocery orders and stellar growth in Argos Fast Track delivery and collection. Online accounted for 20% of the Group's sales during the quarter'

 

SBRY is integrating the Argos acquisition and synergies from the Argos deal seem to be driving the benefits to the bottom line. EBITDA related synergies are expected to rise to £80m-£85m, and in turn this will result in 2017/18 underlying profit to be moderately ahead of published consensus. E.G. ahead of forecasts. Note 1 of the RNS tells us: 2017/18 UPBT consensus estimate of £559m, as published on 5 January 2018 on j.sainsbury.co.uk/investors/analyst.consensus

 

If PBT is expected to be 'moderately ahead' of £559m, I'll assume 'moderate' means 4%, raising the profit target for 17/18 to £581m.

 

This resets our EPS estimate to: 26-27p and at 251p gives a PE of 9.6.


Additionally, SBRYs three-year cost savings target of £500m is on track to achieve £185m  this year, exceeding our three-year target and forecast to exceed £500m by £40m, so their could yet be more surprises to the upside for this share.

 

Thoughts?

 

So the strategy seems to be working and the RNS reiterates four key areas of the business where [we] can differentiate ourselves

 

 

 

  • Great! 1

Share this post


Link to post
Guest TinkerTrader

this is incredibly useful!

why doesn't this have a billion likes?

Share this post


Link to post

Very good point @TinkerTrader, I can only assume by the date it was posted by @rimmy2000 that it sneaked under the radar over the new year period, thanks for highlighting it and getting it back up on the board.

  • Like 1

Share this post


Link to post

You're not wrong TinkerTrader - fantastic post and something worth promoting ... so I did! You should now see this on the home pack and on the 'our picks' section. We actually asked @rimmy2000 if we could post this in MyIG which we did back in Feb I think? 

Anyway - very useful!

  • Thanks 1

Share this post


Link to post

I’m going to follow these steps and post results for companies on Monday after the open. 

Looking forward to a dividend post too :) 

great and very useful post thanks 

  • Like 1
  • Thanks 1

Share this post


Link to post
On 7/12/2018 at 5:16 PM, Guest TinkerTrader said:

this is incredibly useful!

why doesn't this have a billion likes?

Thanks @TinkerTrader. I appreciate you reading my article. I get quite busy at times, however I will create something similar soon for dividend paying ideas. With the markets undergoing (potentially) a bit of turbulence then we might want to look at stocks that provide some level of income to switch into to ride out the storm! I might get chance this week..

  • Like 1
  • Great! 1

Share this post


Link to post

@xhwu, I'm glad I posted the link to this thread for you, if you liked the OPs don't for get to give them a 'like'.

As @TinkerTrader  points out above "why doesn't this have a billion likes?"

The original 2 posts only have 3 likes between them out of some 800 views and I know for a fact I gave 2 of them. 

Share this post


Link to post

Example of a volume screener. 

@LoneStockTrader

Instead of looking for the next stock tip or subscribing to an expensive stock watchlist service, simply scan daily for stocks up on unusually high volume. Not all of those stocks will be big winners. But almost all big winners will appear in that list on the day they break out.

 

image.thumb.png.6d277ff6910f6369101c43ae1212feb7.png

Share this post


Link to post

Join the conversation

You are posting as a guest. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
You are posting as a guest. If you have an account, please sign in.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Member Statistics

    • Total Topics
      7,237
    • Total Posts
      35,866
    • Total Members
      45,865
    Newest Member
    fefcoweb
    Joined 18/08/19 18:33
  • Posts

    • @Mercury, I see you have started to look at Coffee. Excellent. If you look at both Arabica and London (Robusta) then one could argue that we are witnessing oversold conditions especially if you look at longer term timeframes like the 'Monthly' and potentially the 'Weekly'.  For me it is about identifying potential breakouts. We may see that in the days and weeks to come but right now at this moment in time both on the 'daily' are trading below 20, 50, 100 and 200 DMA's so it is still bearish for me. It is one I am monitoring closely.  Commodities can offer some excellent trading opportunities and produce some of the strongest trends. I do not use or apply EWT but if you can use it to effectively increase your chances of success which leads to a greater chance of profiting then all the best. 👍
    • I was watching a TV series called "This Giant Beast That is the Global Economy " starring and narrated by Kal Penn, actor in "House" and speech writer with Obama.  It doesn't really cover any new concepts, although there were a few interesting observation in their, like what the most important commodity in the global economy is... (I wont spoil it for anyone who hasn't seen it yet and wants to but it was not that obvious and is blindingly obvious in retrospect). One thing that did pop out that I though was relevant for the forum was that the price of coffee is way too low for farmers to make money.  The logical conclusion of this is that they will farm something else and supply will be curtailed and then prices will go up, the basic perpetual cycle of supply and demand change.  This very basic fundamentals proposition motivated me to look at coffee on the charts to see if there was a building opportunity and I think there may be.  I will preface my analytical assessment with the statement that I know very little about the coffee industry other than how to select a great bean type as a consumer and make a great flat white. If I look at the long term charts (Quarterly/Monthly) I see that coffee trades in a large range from about 4000 to 34000 at the extremes (or $0.40 - $3.40 per US pound if you prefer).  This seems to represent the classic economics supply and demand curve in candle pricing form.  With the available data we can see a set of cycles between the market top and bottom zones that in the main run fairly directly between the zones.  At this point my thesis would be that if you catch the market right at either extreme you can hold until price reaches the opposite end of the range (net 30,000 points or so).  For best results you want a straight run rather than one with large reversals. If I apply EWT to the chart I see a series of 1-5s and A-B-C, although this is arguably less relevant than for markets that do not operate between such obvious ranges as the key is obviously to look at trading when the market enters, or more correctly, then exits the range extremes zones.  Still it is interesting to see that the run up in the mid 70s was a motive 1-5 that still marks the high point in price.  After that I see a series of massive A-B-Cs culminating in a slightly lower high extreme price in the late 1990s than that printed in the 70s (still went into the market top zone though). This high then produced a 1-5 down to the lowers price on the chart around 2002.  The next move up to 2011 could be either an A-B-C or a 1-5 and the current move looks decidedly like an A-B-C.  If the 2011 move is an A-B-C and the current move is also an A-B-C then I would expect the current move to be a larger wave B that ends higher than the previous low and spawns a massive rally that ends higher than the previous high and is a 1-5 that goes pretty much straight up.  Either way the current move is and A-B-C so will end higher than the previous low and as most of the bear moves end inside the market bottom zone I can reasonable conclude that this move will end somewhere between 4200 - 8000. Let's look at a shorter term charts to see if we can refine this.  I have 2 weekly charts attached, the first of which shows the bearish move down from 2011 and the second of which zooms in on the final wave C of C.  In the first chart I can see a clear A-B-C structure to all 3 of the larger A-B-C wave form of the bearish move.  This confirms an A-B-C and not a 1-5 and also confirms that the market is in a final wave C of C, which will spawn that Bull market.  I also have a nice upper resistance trend line and 2 possible lower lines (both may be valid) with a lot of good current (green circle) and prior pivot (purple circle) touches. If we look at the second weekly chart the wave C of the larger wave C (from the wave B pink) is cutting a clean 1-5 pattern and looks to have just completed the 3-4 part of this.  The rally to wave 4 (blue) is in a-b-c, which you would expect of a retrace so the next bearish phase should be a final wave 5 that will mark the end of the overall bear market.  I would be looking for price to hit one of the lower channel lines but inside or on the 8000 level ideally.  Note all previous moves that did not make it to the extremes zone were not wave Cs (As or Bs) and all the 5 did.  So the conclusion to this is that all wave Cs or motives 1-5s penetrate the extremes zones of the range but As and Bs tend not to.  Also 1-5 waves tend to run hard and fast and make more extreme price tops.  The current move looks line a Wave C that would spawn a 1-5. Finally looking at the daily chart the current bearish phase looks to have put in a 1-2 (green) of that final 1-5 I am looking for.  I will be tracking this for the 3-4-5 and other signals to see if I can spot the turn.  As and when price breaks out of the upper weekly trend line resistance I think a strong bull market will be in play that could be a motive 1-5 that makes it into the extreme market top zone.  In all of the bull turns through there has been a strong short term retrace so the best strategy might be to let the turn happen and spot the initial retrace turn.  In these agri type commodities getting in on such a range extremes turn has to be the way to play it.  I will be tracking this one with interest for a while but it will require some time still to mature I think. 
    • I last posts around 2-3 weeks ago on this thread and I have seen Litecoin go down towards the lower $70's. It is currently trading at $76-77 at the time of writing this post.  Litecoin's chart looks pretty ugly. It is currently trading below its 20, 50, 100 and 200 DMA's which is very bearish.  Only really Bitcoin (significantly) and Bitcoin Cash are trading above their 200 DMA's on the 'daily.  Litecoin will need some very bullish news or a big move from Altcoins / Bitcoin otherwise it could easily fall down into the 60's.  After the halving event, it seems, Litecoin has been heavily sold. This capital may now shift to Bitcoin. That is my suspicion and assumption and the price action will confirm this. I will be interested to see if the divergence between Bitcoin and Litecoin increases. 
×
×