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..

Link to comment

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

 

 

 

Link to comment
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..

Link to comment
  • 6 months later...
  • 4 weeks later...

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

Link to comment

Archived

This topic is now archived and is closed to further replies.

  • image.png

  • Posts

    • The start of China's annual National People's Congress saw a muted response, with the Hang Seng index falling over 2% after Beijing set a modest 5% growth target for 2024 without any major fiscal stimulus measures. However, mainland Chinese shares rose amid suspected state-backed buying of exchange-traded funds tracking the CSI 300 index. Global markets are bracing for an eventful week with Fed Chair Jerome Powell's testimony, the US jobs report, the ECB's policy decision, and the UK budget. Investors are continue to search for cues on the Fed's future rate hike path, with the Atlanta Fed president suggesting no pressure to ease policy amid sticky inflation risks.   
    • Gold Elliott Wave Analysis - is it heading toward 2200? Function - Counter-trend Mode - Corrective Structure - Zigzag Position - Wave 5 of (5) Direction - Upwards for Wave 5 of (5) Gold has exhibited a bullish trend in the current week, surpassing the crucial level of 2100 and inching closer to achieving a new all-time high. By examining the daily chart, we can discern the formation of a promising bullish pattern. The fourth wave denoted as wave (4) in red, concluded at 1616 in October 2022. Subsequently, a bullish diagonal pattern has been unfolding as part of the fifth wave, known as wave (5), which belongs to a higher degree wave 5 in blue. The recent rapid surge in price can be attributed to wave 4 of (5) finding support at the significant level of 2000. As a result, wave 5 of (5) is currently progressing rapidly, and it is highly anticipated to follow a three-wave structure towards the next noteworthy level at 2200, easily surpassing the 2100 threshold. Transitioning to the H4 time frame, our analysis predicts a three-wave subdivision, identified as blue wave a-b-c, for wave 5. Considering the impulsive nature of the upward movement from $1984, we believe that it will ultimately complete the first wave, namely blue wave a. At present, blue wave a is in the process of concluding its third sub-wave, (iii) of a. Subsequently, sub-wave (iv) may retest the key level of 2100 before sub-wave (v) ultimately concludes blue wave a. In summary, based on our analysis, the recommended strategy for traders is to consider buying the dip in Gold at this time. Traders have the option to either trade the conclusion of wave (iv) for (v) of blue wave a on the lower time frame or await the completion of blue wave b at significantly lower prices. Following this, blue wave c of 5 would be expected to propel Gold towards the 2200 mark. This analysis presents potential opportunities for traders to explore strategic entry points and benefit from the bullish momentum of Gold. Technical Analyst : Sanmi Adeagbo          
    • AAPL Elliott Wave Analysis Trading Lounge Daily Chart, 5 March 24 Apple Inc., (AAPL) Daily Chart AAPL Elliott Wave Technical Analysis FUNCTION: Counter Trend MODE: Corrective   STRUCTURE: Flat POSITION: Minute {c} of wave 2.   DIRECTION: Completion of wave {c} of 2.   DETAILS: Today we are looking at two different count on the daily and 4H chart. On the daily I am exploring the possibility of a wave {c} in the making, headed towards the lower end of MG2 at 165$, to then start finding support.     AAPL Elliott Wave Analysis Trading Lounge 4Hr Chart, 5 March 24 Apple Inc., (AAPL) 4Hr Chart AAPL Elliott Wave Technical Analysis FUNCTION: Counter Trend   MODE: Corrective STRUCTURE: Flat   POSITION: Wave {c} of 2.   DIRECTION: Acceleration higher into wave (iii) of {c}. DETAILS: Here we have a top in wave 1 where we previously had a wave {b} top. Looking for similar downside targets towards 165$. Welcome to our AAPL Elliott Wave Analysis Trading Lounge, your hub for comprehensive insights into Apple Inc. (AAPL) using Elliott Wave Technical Analysis. Let's delve into the market dynamics as of the Daily Chart on 5th March 2024.     * AAPL Elliott Wave Technical Analysis – Daily Chart* Our analysis reveals a counter trend function with a corrective mode, characterized by a flat structure. Positioned in Minute {c} of wave 2, we anticipate the completion of wave {c} of 2. Today, we're exploring two different counts on both the daily and 4Hr charts. *AAPL Elliott Wave Technical Analysis – 4Hr Chart* Here, we maintain a counter trend function with a corrective mode, identified by a flat structure. Positioned in Wave {c} of 2, we anticipate acceleration higher into wave (iii) of {c}. This analysis follows a previous top in wave 1, where we observed a wave {b} top. We anticipate similar downside targets toward $165.  
×
×
  • Create New...
us