Match History

R2D20·5/12/2015, 7:44:57 PM·1 votes·526 views
http://matchhistory.na.leagueoflegends.com/

Hello!

I wanted to post this for a couple of reasons -

  1. I think the match history is fantastic, love what is done with it (I had stopped playing for a few years and this didn't exist back then but does now that I've started again), kudos to you guys!

  2. Would it be possible to export match history data to .csv? I'd love to customize how I look at my matches to get better, and think this would be a great feature so that I can pivot and create customized views based off of games/champs/roles and so on. I use excel a lot for work and data really helps things click for me.

Thanks in advance for thoughts and feedback!

4 Comments

MVDuneCats5/12/2015, 8:37:16 PM2 votes

Here's a rather roundabout solution that might work for you in the mean time.

LoLGears is a program that checks the debug logs of the games you played and displays some stats. It probably doesn't give you the kind of analysis that you want. However, it stores the information it parses from game logs into its own local database. I wanted to remove some games from my database last night and found that all I had to do was download an sqlite DB browser. I'm betting you can use a DB browser to export those records into a file that Excel can open.

R2D205/27/2015, 4:35:54 PM1 votes

I tried building a macro off of pulling the plain text off the match history web page but the KDA being formatted as #/#/# gave excel issues because it placed it in one column. @Nitsuabo do you have any thoughts/suggestions on how to pull down match history since I find it unlikely you'd be able to include a .csv download link? I know you're a data scientist and thought you might have some insight on this?