user13177: I want to find the endgame probabilities based on the openings I play.
This would be a game changer when it comes to prioritizing what endgames to study.
I know Chessbase provides a tool for this, but I don't have Windows or the money to shell out on Chessbase. Is there a free online alternative or an easy way to find the endgame probability of an opening via searching through an online database (e.g. chessgames.com)?
For example, if I want to find the endgame probabilities based on the French Defence, Exchange Variation, a tool might output the following:
Endgame probabilities based on the Exchange Variation

N vs N = 66 percent
Pawn Ending = 13 percent
Q vs Q = 8 percent
R+P vs R = 5 percent
R vs R = 4 percent
R vs N = 3 percent
RN vs RB = 1 percent


user17626: Learn CQL (http://www.gadycosteff.com/cql/), then write a program to automate the process

user12629: You can do something like this in SCID, which is a free program. It takes a little effort, but it's not too bad.
First, load the desired database. Then use a filter to select only games from the opening of your choice. You can filter either by a position, or by ECO code, to get the desired opening. Note how many games meet the filter criteria.
Next, use the "Search for material or board patterns" filter feature. You can use the "Common Endgames" button on that screen, or you can select your own criteria. Make sure to select the "AND (Restrict filter)" option. Hit the Search button, and the filter will be restricted to only games which meet your selected criteria. Note how many there are, and with some basic math you can calculate what percentage this is.
Repeat this for all desired endgames.

You can also use the Opening Report feature to get some quick endgame probabilities. Put the desired position on the chessboard, and then run the Opening Report from the Tools menu. This does, however, include all games in the database with that opening, regardless of whether they really have an "endgame" or not. It will count a Scholar's Mate as a "Q, R, BN" endgame since those pieces are all on the board.


13177: <p>I want to find the endgame probabilities based on the openings I play.</p>

<p>This would be a game changer when it comes to prioritizing what endgames to study.</p>

<p>I know Chessbase provides a <a href="http://help.chessbase.com/CBase/15/Eng/index.html?endgame_probabilities.htm" rel="nofollow noreferrer">tool</a> for this, but I don't have Windows or the money to shell out on Chessbase. Is there a free online alternative or an easy way to find the endgame probability of an opening via searching through an online database (e.g. chessgames.com)?</p>

<p>For example, if I want to find the endgame probabilities based on the <a href="https://en.wikipedia.org/wiki/French_Defence#Exchange_Variation:_3.exd5_exd5" rel="nofollow noreferrer">French Defence, Exchange Variation</a>, a tool might output the following:</p>

<p><strong>Endgame probabilities based on the Exchange Variation</strong></p>

<ol>
<li><code>N vs N</code> = 66 percent</li>
<li><code>Pawn Ending</code> = 13 percent</li>
<li><code>Q vs Q</code> = 8 percent</li>
<li><code>R+P vs R</code> = 5 percent</li>
<li><code>R vs R</code> = 4 percent</li>
<li><code>R vs N</code> = 3 percent</li>
<li><code>RN vs RB</code> = 1 percent</li>
</ol>
 17626: <p>Learn CQL (<a href="http://www.gadycosteff.com/cql/" rel="noreferrer">http://www.gadycosteff.com/cql/</a>), then write a program to automate the process</p>
 12629: <p>You can do something like this in SCID, which is a free program. It takes a little effort, but it's not too bad.</p>
<p>First, load the desired database. Then use a filter to select only games from the opening of your choice. You can filter either by a position, or by ECO code, to get the desired opening. Note how many games meet the filter criteria.</p>
<p>Next, use the &quot;Search for material or board patterns&quot; filter feature. You can use the &quot;Common Endgames&quot; button on that screen, or you can select your own criteria. Make sure to select the &quot;AND (Restrict filter)&quot; option. Hit the Search button, and the filter will be restricted to only games which meet your selected criteria. Note how many there are, and with some basic math you can calculate what percentage this is.</p>
<p>Repeat this for all desired endgames.</p>
<p><a href="https://i.stack.imgur.com/PWRHZ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/PWRHZ.png" alt="Screenshot of filter" /></a></p>
<p>You can also use the Opening Report feature to get some quick endgame probabilities. Put the desired position on the chessboard, and then run the Opening Report from the Tools menu. This does, however, include <em>all</em> games in the database with that opening, regardless of whether they really have an &quot;endgame&quot; or not. It will count a Scholar's Mate as a &quot;Q, R, BN&quot; endgame since those pieces are all on the board.</p>
<p><a href="https://i.stack.imgur.com/syFW8.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/syFW8.png" alt="Screenshot of Opening Report" /></a></p>
