Jump to content
Sign in to follow this  

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 can post now and register later. 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.

Sign in to follow this  

  • Member Statistics

    • Total Topics
      6,564
    • Total Posts
      29,468
    • Total Members
      39,016
    Newest Member
    Jamespound
    Joined 21/04/19 08:07
  • Posts

    • Looking at Lumber then it seems to me that it needs to hold the $30000 level. If it can defend and hold that then there could be further upside this year. If not then it could begin going down into the late $20000's. This is a personal assumption which now will need to be tested based on current price behaviour.  In my opinion, for any trend followers who are short, they must hold (even if they do not add to their positions on further price declines) until there is a clear trend reversal. This should execute their stop loss / trailing stop. In my opinion, for any trend followers who are waiting on the sidelines that do not want to short, then they must wait patiently until there is a clear trend reversal signalling / indicating a trend reversal to warrant a long trade initiation. 
    • One thing to remember is that Platinum is trading at a cheaper price than Gold. Gold and Silver have left Platinum behind since the rally started back in August of last year. It seems Platinum has had enough and wants to begin to assert some authority on the price action.  Platinum of course has several important industrial uses. I think Platinum will try and hit the $1000 dollar area as that is an important psychological price point and these rallies love nice round numbers as a target. This is seen time and time again in Commodities. Platinum is both an industrial metal and a precious metal.  Platinum is also known at the 'Rich Man's Gold'. This could lead to a reversal in pricing between Platinum and Gold. Platinum should be more expensive than Gold and so there could be a shift in speculative capital from Gold into Platinum. Platinum could attract extra volatility as Gold and Silver are more liquid markets.  I do not know what will happen in the future for Platinum prices but I shall follow the price action closely. Platinum will not follow any of my thoughts or assumptions as to what I think may happen. Platinum is not obliged to follow any of my trading strategies or plans. Platinum may not follow the path I have mapped out in my mind and nor does it have to. Platinum will do what it will do just like any other Commodity. As a trader the key is whether I can profit from the price action or not. Prices can change like the weather and so can traders views and opinions. I know from my experience that on many occasions the price action changes my views and opinions. There is absolutely nothing wrong with that. If this did not happen due to stubbornness, ego or I know best attitude then it would be worth worrying about. 
    • Bitcoin is trying to break out when looking at the 'daily'. It will be interesting if it can and if it does then whether the other 'alt coins' follow.
    • Both Gold and Silver are still following my road map however both have hit an interesting juncture, which could prove to be an early turning point.  I am still favouring the Fib 50% for Gold, a long term reliable Fib level for this market (however it does not occur at a strong price action support level this time so a further deeper retrace could be on the cards) and if that happens then Silver retesting the long term supporting trend line is also on the cards. So much for that, what about the case for the current levels? Gold: Complex form retrace (EWT) completed (that is an A-B-C with internal A-B-C forms on each leg) Pos Mom Divergence at the current price point on Daily and 4 Hourly charts RSI and Stochastic both over sold Credible 1-5 wave down to current price point Bounce off the Fib 38% and associated support zone  Potential Triangle breakout and retest then rally away on 4 Hourly chart Similar on Silver, although perhaps less compelling.  I might expect a further drop on Silver with Gold holding or rallying slowly.  I am Long Gold at the Fib 38% with tight stops just below the turning point for a very low exposure trade.  For me this was worth the small loss if Gold carries on down but there may be another chance to get Long on a near term EWT 1-2.  And maybe Platinum is showing the way...  
    • GBPUSD also still following my road map.  First chance for a rally for me is the Fib 62% zone where the previous channel breakout occurred and a previous retest failed.  Chance for a test of strong support at Fib 6/78% cannot be ruled out and this pair is spiky so could easily occur.  All aligned to directional price action on EUR and AUD as well.
  • Our picks

    • Could the price of pork increase by 78% in China by 2020? - EMEA Brief 18 Apr
      The African swine fever disease has reached Southeast Asia and parts of Europe, including the world’s biggest producer of Pork, China. A prediction from the Japanese bank Nomura, is that this could cause prices to rise by 78% in China by 2020, to 33 yuan per kilogram from 18.5 yuan

      Global PMIs come into focus today, with eurozone and US figures released in the wake of a poorer Japanese number this morning. Pinterest has priced its IPO at $19 per share, above the previously indicated range but still lower than in private funding rounds two years ago.
      • 1 reply
×
×