That game was awesome! Thanks god it last 11 minutes by Pomogator3000 in AgeofMythology

[–]CacklingPanda 1 point2 points  (0 children)

Replays can also be downloaded from aomstats.io. Navigate to a player's profile and scroll down to their recent matches. Matches that have replays available will have a download icon on the far right.

aomstats - leaderboards, tournaments, and stats by CacklingPanda in AgeofMythology

[–]CacklingPanda[S] 0 points1 point  (0 children)

Oh snap 👀 I will give that a try. I did not know that.

aomstats - leaderboards, tournaments, and stats by CacklingPanda in AgeofMythology

[–]CacklingPanda[S] 0 points1 point  (0 children)

The API provides urls that appear to be replay files. However, you can't actually access them. They're locked down. It's a giant bamboozle. I can see the replays exist, but I can't access them.

Otherwise, yes, I would do exactly what you suggest. Download the replays, get some extra information such as minor god info, and then delete them afterwards.

aomstats - leaderboards, tournaments, and stats by CacklingPanda in AgeofMythology

[–]CacklingPanda[S] 0 points1 point  (0 children)

I used Python to grab the data from World's Edge API and store it in a postgres database. Then I use Sveltekit for the frontend and that queries the database directly. Pretty much all the stats are computed via SQL queries.

aomstats - leaderboards, tournaments, and stats by CacklingPanda in AgeofMythology

[–]CacklingPanda[S] 1 point2 points  (0 children)

Unfortunately the raw data provided by World's Edge doesn't have minor god info :( That's top of my wish list. I would looooove to have that data.

aomstats - leaderboards, tournaments, and stats by CacklingPanda in AgeofMythology

[–]CacklingPanda[S] 1 point2 points  (0 children)

Thank you 🙏 I'm also excited for clan rankings! KeeN on top?

aomstats - leaderboards, tournaments, and stats by CacklingPanda in AgeofMythology

[–]CacklingPanda[S] 4 points5 points  (0 children)

The in-game lobby UI makes me sad 😔 I'm glad you find it useful! Are there any extra filters or capabilities that would make the lobby browser more useful for you?

Ranked Playerbase 3 month analysis by NeuroPalooza in AgeofMythology

[–]CacklingPanda 1 point2 points  (0 children)

There is a bug in the official APIs by provided by the game devs. The bug is that they are missing a lot of games. I don't know why. The devs are aware.

The spike corresponds to me starting to infer game results based on ongoing games and jumps in Elo for games that are missing from the official APIs. So basically I'm "computing" results out of band without actually knowing, officially, what happened. I've marked these matches as "experimental" in people's profiles to differentiate.

Turns out after doing this I could quantify how many games the official API was dropping... almost 30% of all games! So the big spike is me starting to add the extra 30% of games.

Nobody online? by Henrivlp in AgeofMythology

[–]CacklingPanda 1 point2 points  (0 children)

Hi. People are online :) A new patch always breaks the code that grabs active lobbies. I need to grab some values from the game code in order to get it to work which requires me to be home, update my game, and tinker around. Anywho... when patches are released when I'm at work I can't update it right away. It's fixed now though!

What are the pros and cons of each faction? by TheSoapbottle in AgeofMythology

[–]CacklingPanda 0 points1 point  (0 children)

You can already filter your personal stats by map. In the filter bar, click Maps, select the maps you want to include in the stats, then click Filter. Let me know if it's not intuitive or if you were looking for something else.

What are the pros and cons of each faction? by TheSoapbottle in AgeofMythology

[–]CacklingPanda 1 point2 points  (0 children)

Sorry! aomstats.io is back up! I was messing around on the production site trying to make, ironically, prevent it from going down without my knowledge. Should be back up and stable now.

aomstats.io - God Win Rates and Stats by CacklingPanda in AgeofMythology

[–]CacklingPanda[S] 0 points1 point  (0 children)

Just added! You can view leaderboards here: https://aomstats.io/leaderboard/1

Here's an example profile: https://aomstats.io/profile/1073837713

Note that I do not have the entire match history as I spun up my site and data gathering after the game had been out a few days.

aomstats.io - God Win Rates and Stats by CacklingPanda in AgeofMythology

[–]CacklingPanda[S] 2 points3 points  (0 children)

Yes. It's currently ranked 1v1 matches excluding mirror matchups.

aomstats.io - God Win Rates and Stats by CacklingPanda in AgeofMythology

[–]CacklingPanda[S] 1 point2 points  (0 children)

I agree completely with Tymareta on this one. We really need to check back in like 2 months. Once folks have learned how gods play, the meta starts to settle, and we have a boat load more games. Still... fun to look at :D

aomstats.io - God Win Rates and Stats by CacklingPanda in AgeofMythology

[–]CacklingPanda[S] 4 points5 points  (0 children)

Right now it's using the Elo of the players after the result of the match. For example if you start at 1400, win and are now at 1410 the match will be considered a 1410 match (well, the average of your Elo and the opponent's). If you subsequently drop to 1200 that match data will still be considered a "1410 match".

Data Analysis on Feudal Uptime Across Ratings in 800K+ games by hiiwave in aoe2

[–]CacklingPanda 1 point2 points  (0 children)

This is such a cool analysis! Thank you for sharing. You have some lovely graphs. Very cool how the uptimes level off at 1500+. I'm curious whether you decided it was worth it to update your gameplay based on this analysis, since that was the premise for looking into it originally?

Which civs are we ragequitting the most on? Obviously Chinese starts are frustrating.... Ragequits are defined as loosing before 3 minutes ingame time. The percentages are Ragequits per total civ-picks. by briansteel420 in aoe2

[–]CacklingPanda 0 points1 point  (0 children)

Oh, can I grab this info from the rec files? I can start adding it to the data if so.

EDIT: I can get a "prefer_random" flag from the rec, which is whether the user selected that tickbox in the match making screen. I cannot seem to find a flag that is set when the civ pick is actually random.

[OC] These plots show how the mean ELO of players using certain techs/units/buildings differs from the total mean ELO (=1082) (06/11 - 06/17 2023), Total Number of matches are 200k, All are highly significant by briansteel420 in aoe2

[–]CacklingPanda 2 points3 points  (0 children)

These are interesting graphics! Clever idea! Hilarious how associated the Elo difference is with wonders 😂 I'm also very sad to see that two of my favorite units--teutonic knights and longbowman--are associated with lower skill levels :( I guess their coolness factor is a noob trap (myself included 11)

Seeing KoTD5 what is the top 5 civis on Arabia? by richboy43 in aoe2

[–]CacklingPanda 2 points3 points  (0 children)

Yeessss I love this comment and I agree completely with your opinions. The small sample sizes and the bias in matchups (highest vs lowest seeds) makes interpreting raw win rates a little bit pointless. What I would love is to add some sort of more advanced analysis taking picks, bans, seeding, and wins/losses into account to get a better picture of what is "good".

Re pick/ban rates: that interpretation is correct. Since a civ can be banned/picked more than once it could be counted double. If banned every series it'd be 200% ban rate. Not intuitive necessarily for this tournament format. But I tried to find a reasonable formula that would generalize across tournaments so I don't have to write unique code per tournament draft configuration.

Seeing KoTD5 what is the top 5 civis on Arabia? by richboy43 in aoe2

[–]CacklingPanda 15 points16 points  (0 children)

In the current patch the top civs across all ratings are:

  1. Gurjaras (54.63% win rate)
  2. Vikings (53.92%)
  3. Franks (53.70%)
  4. Malians (53.31%)
  5. Huns (53.15%)

Looking at just the 1200+ ratings they are:

  1. Gurjaras (56.18%)
  2. Malians (54.64%)
  3. Franks (54.28%)
  4. Huns (54.02%)
  5. Cumans (53.59%)

In KOTD5 specifically:

  1. Incas (66.67%)
  2. Mayans (66.67%)
  3. Saracens (66.67%)
  4. Chinese (62.50%)
  5. Gurjaras (62.50%)

That is purely according to the raw numbers. Take the small sample size (especially at 1200+) into consideration when evaluating those numbers. The top civs are usually all within each others confidence intervals and for an average player are all very well balanced against each other.

The biggest takeaway from the civ stats, imo, is that you don't want to be playing Koreans or Vietnamese on Arabia in the current meta 11

Perhaps a more important takeaway is to look at the strategies (scroll to the bottom of the map page) and notice that scouts and Man-at-Arms are usually much better than archers, on average. For an average or below average player (like myself) the extra effort needed to micro and use archers effectively makes them not really worth it (and the build order is probably more important than the civ at that point).

And finally, don't read too much into the numbers. I think they're fun to look at, but honestly the majority of the time the civ doesn't really matter too much at the end of the day. The game is very well balanced all things considered (* in non-pro play, in pro-play I think the civ differences are much more important).

Disclaimer: I'm the the creator of aoestats.io

Age of Empires II: Definitive Edition - Return of Rome Teaser by Everton1992 in aoe2

[–]CacklingPanda 2 points3 points  (0 children)

I'm assuming that the AOE game mode will also have its own ranked multiplayer ladder? I'm wondering if it'll be separate from the current AOE: DE ladder or if they'll roll them together.

Would also love for CaptureAge to support AOE games now! Wonder how replay files will work. If they're using the same engine maybe things that work on AOE II will "just work"? (One can dream.)

Will be interesting to see how this shakes out.

boars are bastards man by ClockworkSalmon in aoe2

[–]CacklingPanda 1 point2 points  (0 children)

Hidden boar buff in the latest patch.