We have had Octal’s mtgpq.info site, and wiki.mtgpq.info for years now. I’m excited to announce a 3rd website that I’ve developed for the past few months primarily for coalitions and ultimately, for players who are looking for coalitions.
People who know me here know that I have been tracking and saving the top 10 coalition data and posted a while back what a Seasons Leaderboard would look like for coalitions and players alike. Well, I finally upgraded my Google Sheet into a full-blown web app!
It contains 3 years worth of data for the group of coalitions I play with (GoblinPile, Tormented and D3nied), plus data for the last two months of the top 10 coalitions. Most importantly, it has an upload form to help anyone who would like to save their data. This will be particularly useful for players who are looking for active coalitions or coalition leaders of competitive coalitions who would like to see the players historical scores to see if they are a fit or not (scores can be faked, though, so be warned
I developed the site using python and django and hosted it at pythonanywhere. I don’t know about you but I really don’t like clicking on links posted by random strangers unless I know it’s legit (although it feels a little different here cause it seems like we’ve known each other for a while now…), so if you’re interested in saving your data (or even just to contribute it for the sake of the project), send me a DM and I will give you the link.
Actually, I just got the idea of recording a brief youtube video and as soon as I figure out how to upload it, I’ll share the link here. Hope to hear from you!
It would be great to have the data for Gods of Theros and other coalitions that consistently finish high in events but not in the games all-time list loaded into the database. Is @Poppy99 still around?
We have collected data since 2019 of all events all 3 coalitions (MTGGOLDFISH, AlwaysMTG and Tremplers)
Excel and Access Database, pls pm me for exchanging this data…
I have been busy and haven’t updated my progress here.
About 2-3 weeks ago, I started hopping on the all-time top 200 coalitions and was able to capture 190+ screenshot of all the members of those coalitions. You might have seen me join your coalition as player DaxosFTW. I may have chatted with some of you who greeted me with a warm welcome. The result, a leaderboard that shows more than 10 items:
I do not want to upload per event, this to much work, I can provide an excel that contains all scores in the need way plus the event date and name to link the data…
The upload per event was meant for the wider audience. If you have a lot of data to load, better to just give me the data and I will load it all in one shot.
The names are converted from image to text by an OCR and it can get tripped up by the "I"s, "l"s and "1"s, same with "O"s and "0"s. Isn’t your IGN bken1234?
Thanks @Zzyzzx and @Ampersand, but asking for screenshots is a lot more work. I’m a programmer so I have automated a lot of the data gathering and unfortunately hard-coded the coordinates and locations of player names and scores onto the program. As a result, screenshots sent to me by helpful folks were rendered useless because of the different resolutions and devices they were taken from.
So, I decided to just tough it out and jump onto as many coalition with open spots as I can, and ignore their accusations of poaching. Really, I don’t want your players to join GUAJURA ;p
Appreciate the offer though. I would love to hang out and chat while on Brotastic and DimMak but at rank 21 and 22, respectively, that means I just started the work and still have 180 coalitions to go through. Yes, it’s a grind but the game has trained me to grind so I’m used to it lol.
@Larz70 Gotcha, totally understand. I was just offering because unlike many/most Top20/Top10 coalitions, we don’t rotate too much therefore we usually don’t have an open slot for long stretches.
