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.

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.

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.