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
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
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.
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
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.
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
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
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)
Jeez your a hard task master tth ! 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
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
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
Is this him?http://www.sctradecounter.com/coach/135868 On my phone at the Min, but will have a closer look when I get back to my pc
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 I've been collecting the data since round 1, just took me a while to make the site work too
Just moved the posts for the TS version over to here: http://tooserious.net/forum/threads/myleagues-testing-thread.89418/#qbbQEIXi4q0swrAj.97 Didn't want to crush any discussions on this one with bug reports for my shonkiness.
Hey JP I also like the 'About' section on your page, amusing, and the accuracy about tracking is a very good point.
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
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 I also post some of this stuff on twitter if any of you guys are on there