NixTrader for R20 – Finals edition

Just the basics this week.  I’m a bit pressed for time after writing earlier article on Monday.  Let’s go …

Updated Tables – Team Averages & Next Games

Updated tables showing DT performance for each team, both for and against, are below.  The right hand panel has the averages for just the last 5 rounds so you can see more recent form.  Each table is ranked according to the number in the shaded column.  Teams are bundled together in colour groups of 6 ideally, although sometimes there are more or less than 6 as equal teams are kept together.

R19 Team Avgs FOR

R19 Team Avgs AGST

Some points of interest:

  • Collingwood have replaced Essendon at top of the FOR table.
  • Essendon have given up so many 100s recently that they have become a Green team.
  • Brisbane is best performer in restricting 100s over the last 5 weeks.

The Next Rounds table below covers all the remaining games and shows which teams have the most helpful coming fixture for DT scores.  DT Finals rounds are shown in purple.  Two new columns were added on the right of this table showing the ownership percentage for each team.  The teams retain their colour coding from the above 2 tables so it is a bit easier to understand.

R20 Lead up Games

Some points of interest

  • Of all the teams that score consistent high DT points FOR (the blue teams), only one – Freo is at the top of the table.  Significantly all the other blue teams are towards the bottom of the table.
  • Essendon and Collingwood, the teams with the highest ownership, are at the bottom of the table.
  • Other than Freo, the teams with the best run are mostly teams with lowest FOR points (grey teams).
  • Take care about considering GWS as easy (green), over the last 5 weeks they would be a red team.

 

NixTrader Spreadsheet

Here is link to download spreadsheet (Excel2007) – NixTrader2013 R20 pub

 

Reminders from previous weeks:

  • The team of the current overall leader is in NixTrader spreadsheet when you download it.  You can look at this team to see if you can learn anything from it, before replacing it with your own team.
  • If you used the spreadsheet from previous rounds, you can just select your blocks of players’ names from there and copy and paste them into this round’s spreadsheet.
  • After lockout, you can also use NixTrader to start planning for next week.  Just enter your players’ actual scores in the column for the current round to update your watchlist or trades.
  • Younglings:  if you don’t have Excel2007 software on your device you can still download the file, put it on a usb stick and ask around to find someone with Excel2007 software and ask to borrow their computer for an hour or so.
  • Mac users have reported Brandon Ellis (Richmond) is placed as an Adelaide player in bye and draw tables.  This doesn’t occur in Windows Excel.  Mac users should be aware of this if you add Brandon Ellis to your spreadsheet.

 

Good luck to everyone in their first finals round.

Any comments, questions or suggestions please post below, or tweet to @NixTrader.

I expect users are familiar with the spreadsheet now so I will not post the instructions and technical notes any more.  If anyone needs to see them they were last posted with NixTrader for Round 19.  You can look them up there.

5 Comments

  • Thanks a lot mate!!

  • Does Carlton’s easy schedule make Kade Simpson worth a look? And if GWS have been more like a Red of late, would it be worth trading in Barlow next week?

    • Simpson too hit & miss imo scores like a defender & should be 1 next season, I’d look at Wellingham as a POD tbh with WCE injuries plus Essendon are easy to score against atm so he should get plenty of midfield game time + low B/E, lock in Barlow get him in just don’t put the C on him, GWS & Carlton have annoying tagging habits targeting opposition guns as only the 1 & only pig got away from these 2 teams. 2nd/3rd choice mids tend to rack up against GWS.

      Another POD to consider is libba not this week but next week for the last 3 weeks he had 115, 120 & 144 earlier in the season on Adelaide, BL & Melbourne who are his last 3 opponents.

    • I agree with thrust of comments you’ve already had.

      Simpson is too unreliable for a finals DT mid – in fact it’s hard to get a firm line on any of the Carlton high DT scorers, I think Malthouse changes their roles around to try different things.

      Barlow looks less likely to be tagged than others at Freo (e.g. Hill, Fyfe, Mundy are more damaging) so I don’t seen them playing GWS as reason not to trade him in.