dtlive.com.au Data View!

Data View is a powerful search tool that will let you search by the criteria you want. You can search the full year (all rounds) or just recent ones to show form. Search by ownership to look for a unique or whatever you desire. Here are some suggested links to help you get started.

Recent Form (last 5 weeks): Def | Mid | Ruc | Fwd |
Best Uniques (min 5 games):: Def | Mid | Ruc | Fwd |

By Player

Age:
Position:
Team:

By Fantasy Stats

Position:
Start Price:
Current Price:
Games Played:
Average:
Ownership (%):

By Fixture

time (soon)
Season:
Location:
Opposition:
Rounds (All | None | Last 3 | Last 5):
| Clear
SELECT `afl_allplayers`.`OurPlayerID`, `afl_allplayers`.`FirstName`, `afl_allplayers`.`LastName`, `afl_yearshistorically`.`TeamID`, `afl_yearshistorically`.`StartPrice`, `afl_yearshistorically`.`EndPrice`, `afl_yearshistorically`.`BE`, `afl_yearshistorically`.`Position`, `afl_yearshistorically`.`OwnershipPercentage`, COUNT(TotalScore) As `GamesPlayed`, SUM(TotalScore) As `TotalPoints`, Round(AVG(TotalScore),1) As `Average`, Round(`afl_yearshistorically`.`EndPrice` / SUM(TotalScore)) as `Eco`, (SUM(TotalScore)/(((SELECT SUM(GameLengthSeconds) FROM afl_games,afl_dtscores WHERE afl_dtscores.OurPlayerID = `afl_allplayers`.`OurPlayerID` AND afl_dtscores.GameID = afl_games.GameID AND afl_dtscores.`GameID` IN () AND (`HomeTeam` = `afl_yearshistorically`.`TeamID` OR `AwayTeam` = `afl_yearshistorically`.`TeamID`)) * (AVG(TOGPerc)/100)) / 60)) as `PPM` FROM `afl_dtscores`, `afl_allplayers`, `afl_yearshistorically` WHERE `afl_dtscores`.`OurPlayerID` = `afl_allplayers`.`OurPlayerID` AND `afl_dtscores`.`GameID` IN () AND `afl_dtscores`.`OurPlayerID` = `afl_yearshistorically`.`OurPlayerID` AND `afl_yearshistorically`.`FormatID` = 3 AND `afl_yearshistorically`.`Year` = 2024 AND `DetailedPosition` IN ('Midfielder') AND `afl_yearshistorically`.`TeamID` != 10 GROUP BY `afl_dtscores`.`OurPlayerID`
i Player Position Start $ $ Change Price $ Own (%) Games Avg Points PPM Eco PR BE14