NeatoMan

I would do that if I knew how. Don't know the syntax or what is even possible. I can concatenate each account ID into a url that would return a result from the API. I have no idea how to automate that list of urls to return a list of results, or even if that's how I should proceed, or the proper syntax, etc. Something that is so simple logically is obviously not so simple to someone who has never programmed this stuff before.

Could you suggest any links where one can go to learn how to do this? I have no clue where to start, or even what terms to put into a google search. Seems like it should be a very easy task to accomplish, I just have no idea where to start. remember I'm a total newb at this.

I have a list of account ID's from a bunch of battles in one column in excel. For each ID I am trying to get their PR rating. Can this be done strictly within excel (i.e. query WoT's API by referencing one cell at a time?)

I'm a total newb. I haven't done any in decades (pascal, basic). been reading up on python so let's go with that.

thanks, but what I really need is a way to automate pulling player PRs off the API. That's the rate limiting step.

I'm a newb at this. Currently, I do it manually by copy/paste accountID's in batches of 100 at a time, copy/paste results into an online JSON converter, and then copy/paste into excel. This works fine for small samples, but I want to be able to automate it. Anybody got a script to do this, or can help me set up the process? All I need are player PR's (global_rating) from their accountID's. I pick up quickly on this stuff, just never did it before. many thanks

@Android25 sorry for the late response. If you still have that data, I'd love to have it.

OK slowly figuring it out. Gotta go 100 accounts at a time, but I think I can manage.

I'm a total noob when it comes to APIs. Wondering if someone already had some of that data mined from work on earlier WN series.

for now just looking for stuff that's displayed in sigs; player win rates, avg tier, dpg, kpg

yep. I got no reply by e-mail, so looking for another approach. I'd be happy if someone has any of the old data used during the development of WN8 or determining expected WN8 values. IIRC it was initially done on 100000 players.

I've been trying to access data from vbaddict for a long time without success. Basically am looking for server data that would be used for WN8 expected values, like player average tier, average damage, kpg, win rates, etc. Where to go, what to do? any help would be appreciated.

I've collected Margin of victory data (difference in surviving players between teams) from 6k of my games going all the way back to patch 8.0. It mirrors what Lester posted quite well. Margin per patch (version) Margin per Battle Tier Margin vs win chance

It's actually the other way around. Higher tiers generate more stomps. My guess is that once the ball gets rolling it's harder to stop. In the low tiers outnumbered teams can still put up a decent last stand.