• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EDT 18:23
CEST 00:23
KST 07:23
  • Home
  • Forum
  • Calendar
  • Streams
  • Liquipedia
  • Features
  • Store
  • EPT
  • TL+
  • StarCraft 2
  • Brood War
  • Smash
  • Heroes
  • Counter-Strike
  • Overwatch
  • Liquibet
  • Fantasy StarCraft
  • TLPD
  • StarCraft 2
  • Brood War
  • Blogs
Forum Sidebar
Events/Features
News
Featured News
[ASL21] Ro16 Preview Pt2: All Star10Team Liquid Map Contest #22 - The Finalists16[ASL21] Ro16 Preview Pt1: Fresh Flow9[ASL21] Ro24 Preview Pt2: News Flash10[ASL21] Ro24 Preview Pt1: New Chaos0
Community News
2026 GSL Season 1 Qualifiers14Maestros of the Game 2 announced92026 GSL Tour plans announced15Weekly Cups (April 6-12): herO doubles, "Villains" prevail1MaNa leaves Team Liquid24
StarCraft 2
General
Maestros of the Game 2 announced 2026 GSL Tour plans announced Team Liquid Map Contest #22 - The Finalists MaNa leaves Team Liquid Blizzard Classic Cup @ BlizzCon 2026 - $100k prize pool
Tourneys
2026 GSL Season 1 Qualifiers Sparkling Tuna Cup - Weekly Open Tournament GSL CK: More events planned pending crowdfunding RSL Revival: Season 5 - Qualifiers and Main Event Master Swan Open (Global Bronze-Master 2)
Strategy
Custom Maps
[D]RTS in all its shapes and glory <3 [A] Nemrods 1/4 players [M] (2) Frigid Storage
External Content
Mutation # 522 Flip My Base The PondCast: SC2 News & Results Mutation # 521 Memorable Boss Mutation # 520 Moving Fees
Brood War
General
Data needed ASL21 Strategy, Pimpest Plays Discussions ASL21 General Discussion Pros React To: ASL S21, Ro.16 Group C BGH Auto Balance -> http://bghmmr.eu/
Tourneys
[ASL21] Ro16 Group C [ASL21] Ro16 Group D [Megathread] Daily Proleagues [ASL21] Ro16 Group B
Strategy
Simple Questions, Simple Answers What's the deal with APM & what's its true value Any training maps people recommend? Fighting Spirit mining rates
Other Games
General Games
Diablo IV Dawn of War IV Nintendo Switch Thread Starcraft Tabletop Miniature Game General RTS Discussion Thread
Dota 2
The Story of Wings Gaming
League of Legends
G2 just beat GenG in First stand
Heroes of the Storm
Simple Questions, Simple Answers Heroes of the Storm 2.0
Hearthstone
Deck construction bug Heroes of StarCraft mini-set
TL Mafia
Vanilla Mini Mafia Mafia Game Mode Feedback/Ideas TL Mafia Community Thread Five o'clock TL Mafia
Community
General
US Politics Mega-thread Russo-Ukrainian War Thread Things Aren’t Peaceful in Palestine Canadian Politics Mega-thread YouTube Thread
Fan Clubs
The IdrA Fan Club
Media & Entertainment
[Manga] One Piece Anime Discussion Thread [Req][Books] Good Fantasy/SciFi books Movie Discussion!
Sports
2024 - 2026 Football Thread McBoner: A hockey love story Formula 1 Discussion Cricket [SPORT]
World Cup 2022
Tech Support
[G] How to Block Livestream Ads
TL Community
The Automated Ban List
Blogs
Sexual Health Of Gamers
TrAiDoS
lurker extra damage testi…
StaticNine
Broowar part 2
qwaykee
Funny Nicknames
LUCKY_NOOB
Iranian anarchists: organize…
XenOsky
Customize Sidebar...

Website Feedback

Closed Threads



Active: 1439 users

[Exel sheet] Win Loss Ratio by race

Forum Index > SC2 General
Post a Reply
b0rt
Profile Joined July 2010
Germany3 Posts
August 14 2010 12:12 GMT
#1
Hi everyone,

I've been looking for a way in bnet to get your stats shown by race, but couldn't find any. If anyone knows a way to see how many games you've played each race, won, loss etc... plz tell us! Maybe blizzard will ship this awesome function later on.
But until then, I just started a little exel sheet where you can just put your results after you play. All the arithmetics is done for you, all you have to do is to increase the proper cell counter by one (or more, if you played more, obviously).
Here's a preview:

[image loading]

I think its self-explanatory for most of it. The ratio cells turn red or green, depending on the ratio. If you're above 1, its green (you win more than you lose with that race), otherwise it turns red. The ratio is wins/losses. So it's not the percentage some may know from the signatures. Just try to get over 1

In this fictional example in the picture, you could see the following:

- Terran is by far your best race, you really suck with Protoss, Zerg is alright
- you seem to have a little trouble against zerg in general
etc...

Here's the download:
Starcraft_winloss_by_race.xls

Feel free to comment, suggest or add features and share.

btw I just saw a minor flaw in the diagrams on the right: the bars would sometimes not start at zero, making them hard to compare with each other.
It's fixed in the downloadable .xls


Goobus
Profile Joined May 2010
Hong Kong587 Posts
Last Edited: 2010-08-14 12:22:55
August 14 2010 12:22 GMT
#2
Thanks for doing this! I'm also doing something like this, but adding in analysis for which build you lose against the most, which player, etc.

Good work!

EDIT: feel free to use these ideas. I'm probably too lazy to finish what I started.
Mikilatov
Profile Blog Joined May 2008
United States3897 Posts
August 14 2010 12:28 GMT
#3
This is pretty cool. I'm gonna actually use this.

Thanks!
♥ I used to lasso the shit out of your tournaments =( ♥ | Much is my hero. | zizi yO~ | Be Nice, TL.
ZomgTossRush
Profile Blog Joined May 2010
United States1041 Posts
August 14 2010 12:40 GMT
#4
So if i am reading this right, this isn't automatic?

Great idea, but I don't want to scrummage through games trying to figure out my current stats.

But for those who have just a few games, this is perfect for them. Thanks for the contribution.
Coaching for 1v1 and Team games at Gosucoaching.com
b0rt
Profile Joined July 2010
Germany3 Posts
August 14 2010 12:43 GMT
#5
unfortunately you have to enter the data manually.
If there is a way to have it automated, of course, that would be awesome.
Keiras
Profile Joined January 2009
Czech Republic57 Posts
August 14 2010 12:48 GMT
#6
If you save all the replays you want to have statistics of, you can use sc2gears http://www.teamliquid.net/forum/viewmessage.php?topic_id=124689 . It has multi-rep analysis function which basicly does the same and some extra fancy stuff.
cuppatea
Profile Joined April 2010
United Kingdom1401 Posts
August 14 2010 12:49 GMT
#7
On August 14 2010 21:40 zomgtossrush wrote:
So if i am reading this right, this isn't automatic?

Great idea, but I don't want to scrummage through games trying to figure out my current stats.

But for those who have just a few games, this is perfect for them. Thanks for the contribution.


I think the idea is you update it as you play, so you get your stats from this point onwards, rather than go back through your entire game hisory to work out your ratios from the start.

It's just a shame that the best option for finding out your win ratios per matchup is to manually update an excel spreadsheet, when in WC3 this information was on your main profile page..
Please log in or register to reply.
Live Events Refresh
Next event in 1h 37m
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
elazer 369
PiGStarcraft160
ProTech130
SpeCial 11
CosmosSc2 1
StarCraft: Brood War
Artosis 307
Dota 2
monkeys_forever550
League of Legends
Doublelift4519
Counter-Strike
minikerr17
Heroes of the Storm
Liquid`Hasu503
Other Games
summit1g9814
Grubby4467
tarik_tv3090
shahzam521
C9.Mang0304
KnowMe97
Mew2King52
Trikslyr37
ViBE17
Organizations
Other Games
BasetradeTV262
StarCraft 2
angryscii 25
Blizzard YouTube
StarCraft: Brood War
BSLTrovo
[ Show 19 non-featured ]
StarCraft 2
• mYiSmile141
• musti20045 30
• davetesta14
• Reevou 4
• Dystopia_ 4
• Kozan
• sooper7s
• AfreecaTV YouTube
• intothetv
• IndyKCrew
• LaughNgamezSOOP
• Migwel
StarCraft: Brood War
• STPLYoutube
• ZZZeroYoutube
• BSLYoutube
Other Games
• imaqtpie1166
• WagamamaTV489
• Shiphtur317
• Scarra51
Upcoming Events
Replay Cast
1h 37m
Escore
11h 37m
RSL Revival
18h 37m
Big Brain Bouts
18h 37m
PiG vs DeMusliM
Reynor vs Bunny
Replay Cast
1d 1h
WardiTV Map Contest Tou…
1d 12h
Ladder Legends
1d 16h
uThermal 2v2 Circuit
1d 16h
BSL
1d 20h
Sparkling Tuna Cup
2 days
[ Show More ]
WardiTV Map Contest Tou…
2 days
Ladder Legends
2 days
BSL
2 days
CranKy Ducklings
3 days
Replay Cast
3 days
Wardi Open
3 days
Afreeca Starleague
3 days
Soma vs hero
Monday Night Weeklies
3 days
Replay Cast
4 days
Replay Cast
4 days
Afreeca Starleague
4 days
Leta vs YSC
Replay Cast
6 days
The PondCast
6 days
Liquipedia Results

Completed

Proleague 2026-04-22
RSL Revival: Season 4
NationLESS Cup

Ongoing

BSL Season 22
ASL Season 21
CSL 2026 SPRING (S20)
IPSL Spring 2026
KCM Race Survival 2026 Season 2
StarCraft2 Community Team League 2026 Spring
WardiTV TLMC #16
Nations Cup 2026
IEM Rio 2026
PGL Bucharest 2026
Stake Ranked Episode 1
BLAST Open Spring 2026
ESL Pro League S23 Finals
ESL Pro League S23 Stage 1&2
PGL Cluj-Napoca 2026
IEM Kraków 2026

Upcoming

Escore Tournament S2: W4
Acropolis #4
BSL 22 Non-Korean Championship
CSLAN 4
Kung Fu Cup 2026 Grand Finals
HSC XXIX
uThermal 2v2 2026 Main Event
Maestros of the Game 2
2026 GSL S2
RSL Revival: Season 5
2026 GSL S1
XSE Pro League 2026
IEM Cologne Major 2026
Stake Ranked Episode 2
CS Asia Championships 2026
Asian Champions League 2026
IEM Atlanta 2026
PGL Astana 2026
BLAST Rivals Spring 2026
TLPD

1. ByuN
2. TY
3. Dark
4. Solar
5. Stats
6. Nerchio
7. sOs
8. soO
9. INnoVation
10. Elazer
1. Rain
2. Flash
3. EffOrt
4. Last
5. Bisu
6. Soulkey
7. Mini
8. Sharp
Sidebar Settings...

Advertising | Privacy Policy | Terms Of Use | Contact Us

Original banner artwork: Jim Warren
The contents of this webpage are copyright © 2026 TLnet. All Rights Reserved.