Trade counter

Discussion in 'AFL' started by jp, Apr 15, 2016.

  1. jp

    jp Active Member

    Joined:
    Jan 3, 2016
    Messages:
    123
    Likes Received:
    52
    Hey TSers
    I've unleashes my inner nerd and created a website for a little project I've been working on. It basically tracks how many trades sc teams have made:

    www.sctradecounter.com

    Would love it if you guys could have look and give me some feedback.

    Cheers
    jp
     
    • Like Like x 5
  2. TheTassieHawk

    TheTassieHawk SC fanatic Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    7,915
    Likes Received:
    6,867
    Fantastic work mate

    Is it possible to have a 2nd search box to search by team i'd ??
    Is it possible to have the results part saying "TheChampions (team Id 12345) have used X trades" - this saves you having to click on multiple links if the team name is popular

    Cheers tth
     
    • Like Like x 1
  3. That KI Guy

    That KI Guy Moderator Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    2,823
    Likes Received:
    4,557
    Nicely done jp.
    Is it possible to show who the ins and outs were for a given team?
     
    • Like Like x 1
  4. jp

    jp Active Member

    Joined:
    Jan 3, 2016
    Messages:
    123
    Likes Received:
    52
    Thanks for the comments fellas - I needed a cheer up after the tiges performance last night. Insipid!

    yeah that shouldn't be too hard. let me think on it for a bit.

    Done!

    Yeah - should be able to do that too, give me a day or so to find the time.
     
    • Like Like x 2
  5. jp

    jp Active Member

    Joined:
    Jan 3, 2016
    Messages:
    123
    Likes Received:
    52
    Also in case you were wondering I'm tracking 174,606 teams and this is the break down for how many trades they have made after round 3:

    Zero trades = 29,186
    One trade = 10,719
    Two trades = 55,009
    Three trades = 24,685
    Four trades = 55,007
     
    • Like Like x 3
  6. jp

    jp Active Member

    Joined:
    Jan 3, 2016
    Messages:
    123
    Likes Received:
    52
    Alright then, if you want to search by team id you can type "tid:XXXX" in the search box with no spaces and it should work (obviously replace XXXX with the ID you want). For example the to see the current leader suhdude would be "tid:34265"

    I just sort of hacked that together (which is pretty much how the whole thing was made) so let me know if there are any problems.
     
    • Like Like x 2
  7. TheTassieHawk

    TheTassieHawk SC fanatic Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    7,915
    Likes Received:
    6,867
    Good to see the overall trade stats, it might be handy to also see the stats for top 1000, top 5000, top 10000 and top 20000 - either raw numbers or as %s to make comparisons easier

    I expect lower numbers of 0 trades inside the top 20k or so
     
  8. jp

    jp Active Member

    Joined:
    Jan 3, 2016
    Messages:
    123
    Likes Received:
    52
    got this up and running, just go to this URL where XXX is a valid team ID

    http://www.sctradecounter.com/coach/XXX

    Currently looks like crap, but you get the info. I'll try to pretty it up in the near future.
    good to hear you thoughts?

    I'm not actually tracking the rankings :( which is a bit of an oversight.... I'll see if I can add that soon
     
    • Like Like x 2
  9. benny01

    benny01 Active Member

    Joined:
    Mar 13, 2016
    Messages:
    232
    Likes Received:
    245
    This would be great for the people doing the trading game.
     
  10. jp

    jp Active Member

    Joined:
    Jan 3, 2016
    Messages:
    123
    Likes Received:
    52
    And after round 4...

    trades 0: 14% (23946)
    trades 1: 4% (6391)
    trades 2: 14% (24383)
    trades 3: 13% (22496)
    trades 4: 22% (38608)
    trades 5: 12% (20739)
    trades 6: 22% (38043)
     
    • Like Like x 2
  11. TheTassieHawk

    TheTassieHawk SC fanatic Staff Member

    Joined:
    Jan 3, 2016
    Messages:
    7,915
    Likes Received:
    6,867
    I like it, is it possible to calculate and show the $$$$ on hand each week as well ??
     
  12. jp

    jp Active Member

    Joined:
    Jan 3, 2016
    Messages:
    123
    Likes Received:
    52
    Jeez your a hard task master tth ! :p

    Would need to back calculate to round 1 to get everyones starting bank, then carry that forward... Plus track all the price changes... I'll think about it but it might have to be a next year feature
     
  13. lsco

    lsco Mature age rookie

    Joined:
    Jan 3, 2016
    Messages:
    35
    Likes Received:
    9
    I've found a few teams that don't get found in searches. I need to get home to try a search by team ID as it is difficult/impossible to get from the iPad app.
    Team name "Andy's Arsonal" returns no results, yet I know this team existed Round 1 (my cousin's team)
    I thought it might be an apostrophe issue but other searches work for team names with apostrophes.

    Excellent work jp. I'm guessing you have not run into any issues with scraping all the teams each week, surprising as I would have implemented protections to prevent this :)
     
  14. Owen

    Owen Well-Known Member

    Joined:
    Jan 3, 2016
    Messages:
    432
    Likes Received:
    285
    Mate brilliant, I sneakily do this for my leagues manually each week in excel with big ass formulas to work out trades/cash remaining. My programming skills are non-existent otherwise I would have done what you have done! Where do you get the team lists for previous rounds, google cache? I suggest leaving the cash remaining until next years feature so the work I've done the past 4 rounds doesn't go to waste :D
     
  15. jp

    jp Active Member

    Joined:
    Jan 3, 2016
    Messages:
    123
    Likes Received:
    52
  16. jp

    jp Active Member

    Joined:
    Jan 3, 2016
    Messages:
    123
    Likes Received:
    52
    It looks like your cousin put 2 spaces between Andy's and Arsonal!

    the scrape it fairly straight forward... although walesy obviously does a better job than me

    Don't be knocking excel, I started by writing macros in VBA, and now look where I am o_O :D
    I've been collecting the data since round 1, just took me a while to make the site work too
     
    • Like Like x 1
  17. walesy

    walesy Administrator Staff Member

    Joined:
    Nov 30, 2015
    Messages:
    3,872
    Likes Received:
    2,565
    • Like Like x 1
  18. Owen

    Owen Well-Known Member

    Joined:
    Jan 3, 2016
    Messages:
    432
    Likes Received:
    285
    Hey JP I also like the 'About' section on your page, amusing, and the accuracy about tracking is a very good point.
     
    • Like Like x 2
  19. jp

    jp Active Member

    Joined:
    Jan 3, 2016
    Messages:
    123
    Likes Received:
    52
    Made a little change so you can access the individual trades direct from the main search page. Should be able to find the link pretty easily, just search for a team and click on the trade number
     
  20. jp

    jp Active Member

    Joined:
    Jan 3, 2016
    Messages:
    123
    Likes Received:
    52
    Ok I got the rankings hooked in now. So let me know if you want to see something specific. I can set it up as a weekly summary..... or something?

    Just did hte numbers for the top 1000:

    Breakdown of trades for the top 1000 coaches:
    trades 0 = 2
    trades 1= 19
    trades 2 = 56
    trades 3 = 143
    trades 4 = 247
    trades 5 = 242
    trades 6 = 171
    trades 7 = 59
    trades 8 = 68

    Ave: 4.7

    upload_2016-4-26_9-51-11.png


    I also post some of this stuff on twitter if any of you guys are on there

     
    • Like Like x 3

Share This Page