At first I used pencil, paper and a calculator, but my latest efforts at analyzing my results have used Microsoft Access queries. Besides analyzing my opening results (inspired by Simon Webb’s “Chess for Tigers”, among other books) I’ve also attempted to analyze my performance in the middlegame and endgame. The latest version of my Games table has 41 fields:
GameID - a unique ID number for each game
TournamentID - index into a table of tournaments that I’ve played in
Round
Date
Result
Color
MyRating - my rating at the time the game was played
OppRating - opponent’s official rating at the time the game was played
OppEffRating - opponent’s effective rating, e.g. an estimated playing strength for unrated opponents
ECO - Encyclopedia of Chess Openings code for the opening
OpCategory - opening category, one of “1. e4”, “1. d4” or “Other”
Opening - opening name, e.g. “King’s Indian Defense”
Variation - opening variation, e.g. “Panno”
MyTac - my tactical mistakes (see below)
MyAtt - my attacking mistakes
MyDef - my defending mistakes
MyPos - my positional mistakes
MyOp - my opening mistakes
MyEnd - my endgame mistakes
MyTim - my time management mistakes
OppTac - opponent’s tactical mistakes
OppAtt - opponent’s attacking mistakes
OppDef - opponent’s defending mistakes
OppPos - opponent’s positional mistakes
OppOp - opponent’s opening mistakes
OppEnd - opponent’s endgame mistakes
OppTim - opponent’s time management mistakes
MySac - 1 if I sacrificed material, else 0
OppSac - 1 if opponent sacrificed material, else 0
MyIni - 1 if I had the initiative, else 0
OppIni - 1 if opponent had the initiative, else 0
MyWkP - 1 if I had pawn weaknesses, else 0
OppWkP - 1 if opponent had pawn weaknesses, else 0
MyCenP - number of center pawns I had (at the start of the middlegame)
OppCenP - number of center pawns opponent had
My4 - number of pawns I had on 4th rank and beyond
Opp4 - number of pawns opponent had on 4th rank and beyond
My5 - number of pawns I had on the 5th rank and beyond
Opp5 - number of pawns opponent had on the 5th rank and beyond
Open - 1 if there was at least one (fully) open file, else 0
HOpen - 1 if there was at least one half-open file, else 0
I created various queries to analyze the data in this table, e.g. performance rating with each opening or variation, using either official ratings or effective ratings for the opponents, rating change with each opening or variation (using an approximation with a K factor of 32), opening mistakes made by me and my opponents in each opening or variation. All of this can be broken down by time period, opponent’s playing strength, etc.
“Mistakes” are based on the concept that at any point in the game White’s and Black’s chances of winning can be expressed as a number from 0 to 10. 0 means completely winning for Black, 5 means equality, 10 means completely winning for White. I assume that White has a slight advantage at the start of the game: 6. If the opening ends in an equal position it’s now 5, so White lost 1 point and Black gained 1 point. I would record this as MyOp = 1 if I were White, OppOp = 1 if I were Black. If later on I made a blunder which gave my opponent an almost winning advantage, evaluating the position as 1 where I was White, I would record this as MyTac = 4 (tactical error resulting in a change in evaluation of 4 in my opponent’s favor). If the opponent maintained his advantage going into the endgame but I managed to draw the game I’d record it as OppEnd = 4 (opponent’s endgame mistake changing an evaluation of 1 into 5). This mistake analysis was inspired, in part, by “Catalog of Chess Mistakes” by Soltis.
My4, My5 etc. are an attempt to figure out what kinds of positions I’m good at playing. I didn’t get very far with it before I got busy with other things, like directing chess tournaments. Earlier on I used chapter and section numbers from “The Middle Game, Book One” by Euwe and Kramer.
I really went crazy with this stuff. A lot of it isn’t relevant to analyzing results with openings, but some of it could be useful:
Breaking down results by variation instead of just by opening
Looking at the evaluation of the position at the end of the opening and not just the final result
The ability to look at results over time and against various classes of opponent