Visualising transfer market data

General gameplay questions can be posted here.
Hellbound81
Posts: 3988
Joined: Wed Jan 11, 2012 10:42 am

Re: Visualising transfer market data

Post by Hellbound81 » Thu Apr 23, 2020 8:46 am

Would you mind doing a graph for say the top 20 most expensive 16yos and 21yos with their ratings ?
Image South Africa NAT Team (Assistant: Season 36-38)
Image South Africa U19 Team (Manager: Season 32-35, Assistant: Season 38-41)

Bottybot
Posts: 19
Joined: Mon Dec 16, 2019 10:01 pm

Re: Visualising transfer market data

Post by Bottybot » Thu Apr 23, 2020 12:11 pm

Hellbound81 wrote:
Thu Apr 23, 2020 8:46 am
Would you mind doing a graph for say the top 20 most expensive 16yos and 21yos with their ratings ?
Done and done! Ranked from all the transfers I have saved. (edit: From season 43 + season 44)

16 y/o's:
max 16.png
21 y/o's:
max_21.png
Max of all age groups:
max_all_ages.png
I should note that the wages for these might be a bit off, as I haven't taken into account the % discount from the value displayed while the player was on the market.

I was going to post these as text to make them more accessible, but unfortunately phpBB deletes any excess spaces when I try to copy and paste it all...

edit: I could actually post these with the rest of their stats at the time of sale as well? Although a lot of the players would be hidden now they're off the market so I'm not sure what the general stance on releasing that info would be.
You do not have the required permissions to view the files attached to this post.
Last edited by Bottybot on Fri Apr 24, 2020 12:29 am, edited 1 time in total.

GM-crowfan65
CAPT
Posts: 19932
Joined: Fri Jan 04, 2008 6:17 am
Location: Look...up in the sky
Contact:

Re: Visualising transfer market data

Post by GM-crowfan65 » Thu Apr 23, 2020 12:21 pm

I would prefer that stats aren't published tbh
Some managers are secretive about their players
Master Crowfan of the Blessed Spreadsheet
Image Current Aust U20 Asst
GarageTM Foundation Member

Kaidus
Posts: 1030
Joined: Mon Oct 15, 2012 12:21 pm

Re: Visualising transfer market data

Post by Kaidus » Thu Apr 23, 2020 2:14 pm

Theres definitely something wrong with that data - I think some of the "16yr olds" are from last season not this. I specifically remember Dom Sheed being discussed a good few weeks ago, want to say beginning of March.

Bottybot
Posts: 19
Joined: Mon Dec 16, 2019 10:01 pm

Re: Visualising transfer market data

Post by Bottybot » Fri Apr 24, 2020 12:28 am

Kaidus wrote:
Thu Apr 23, 2020 2:14 pm
Theres definitely something wrong with that data - I think some of the "16yr olds" are from last season not this. I specifically remember Dom Sheed being discussed a good few weeks ago, want to say beginning of March.
I should have made it more clear that those tables were from all the sales I had recorded- so the spotty data from last season + the complete data from this season. Here is data from just this season (which is mostly the same thanks to the ... good eye catching the old players!)

Season 44 data to date (technically starting from Apr 1):

16 y/o's:
max 16 s44w2.png
21 y/o's:
max 21 s44w2.png
All agegrouos:
max all s44w2.png
You do not have the required permissions to view the files attached to this post.

Bottybot
Posts: 19
Joined: Mon Dec 16, 2019 10:01 pm

Re: Visualising transfer market data

Post by Bottybot » Sun May 03, 2020 10:44 am

For something a little different...

I matched players with certain skills and compared their prices to find the biggest difference paid. I used the following attributes to match the skills: Batting, bowling, keeping, fielding, endurance, technique, power, age, and bowler type.

For a complete match in skills, the biggest difference was $524,000! ($525,000 vs $1000)

16 years old | Right Arm Fast Medium
Batting ordinary | Endurance ordinary
Bowling ordinary | Technique poor
Keeping poor | Power poor
Fielding ordinary

Ratings: 24,140 vs 20,064
Wage: 785 vs 700
Experience: poor vs dreadful
Talents: Accumulator + Prodigy vs Gifted (Power)
Day of season: 17 vs 27

___


The highest non 16 year old complete match had a difference of $151,820. ($176,319 vs $24,499)

28 years old | Right Arm Medium
Batting poor | Endurance spectacular
Bowling spectacular | Technique spectacular
Keeping dreadful | Power spectacular
Fielding expert

Ratings: 58,853 vs 56,043
Wages: 14,074 vs 13,300
Experience: outstanding vs reliable
Talents: Old Ball Bowler vs Safe Hands
Day of season: 25 vs 63

* wages include discount at the time of purchase

Bottybot
Posts: 19
Joined: Mon Dec 16, 2019 10:01 pm

Re: Visualising transfer market data

Post by Bottybot » Sat May 23, 2020 2:46 am

The archiver is still chugging away, collecting sales data. and it's just passed 11k total listings recorded. There'll be a big summary at the end of the season, but for now, here's a more readable version of the age sales by week graphs I've been posting previously.
s43w5 sales volume table.png
The color gradient changes from green (20th percentile) to yellow (50th percentile) to red (99th percentile).
You do not have the required permissions to view the files attached to this post.

GM-crowfan65
CAPT
Posts: 19932
Joined: Fri Jan 04, 2008 6:17 am
Location: Look...up in the sky
Contact:

Re: Visualising transfer market data

Post by GM-crowfan65 » Sat May 23, 2020 3:29 am

And sorry mate what is the numbers across the top -1, 0 ,1 etc
Master Crowfan of the Blessed Spreadsheet
Image Current Aust U20 Asst
GarageTM Foundation Member

BanditKeith
Posts: 1499
Joined: Fri Apr 12, 2013 10:50 pm
Location: In America

Re: Visualising transfer market data

Post by BanditKeith » Sat May 23, 2020 3:54 am

There's a label for that.

Also very interesting to see that EoS 21 year olds are more than all other ages put together in their week.
And now, It's time for some Bandit Keith fan service...

Post Reply