Answers.Body: <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.sstatic.net/PWRHZ.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/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.sstatic.net/syFW8.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/syFW8.png" alt="Screenshot of Opening Report" /></a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-06-14T10:59:13.740Z
Answers.Text: Nice. I've used Scid for awhile time and never thought of using it like that.
Answers.UserDisplayName: hangejj
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-07-14T04:46:19.037Z
Answers.Text: More fast is the "Opening Report". It informs some charasteristics that are of importance for the ending, like opposite castling.
Answers.UserDisplayName: djnavas
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-07-14T09:10:29.457Z
Answers.Text: @djnavas The opening report does have some interesting stats, and is a quick way to filter based on position, but the "themes" are only counted in those stats if they happen in the first 20 moves, which seemed overly restricted.
Answers.UserDisplayName: D M
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-07-15T10:54:26.593Z
Answers.Text: @D_M Let me copy about finales, what an opening report informs:
  
  **4.4 Finales**
  
  `Tipos de finales según la última posición de las partidas:`  
  
  `P     BN      R   R,BN      Q   Q,BN    Q,R Q,R,BN`  
  
  `Informe de partidas     1%     8%     6%    21%     1%     4%     2%    56%`  
  
  `Todas las partidas      1%     7%     7%    26%     1%     3%     4%    51%`
Answers.UserDisplayName: djnavas
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-03-05T00:15:27.400Z
Answers.Text: @djnavas You are correct. I'll edit this to add that it can be done with the Opening Report.
Answers.UserDisplayName: D M
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-06-13T23:46:29.147Z
Answers.LastActivityDate: 2021-03-05T00:36:47.607Z
Answers.LastEditDate: 2021-03-05T00:36:47.607Z
Answers.UserDisplayName: D M
Answers.Body: <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>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-06-14T03:12:17.290Z
Answers.Text: I second this.  Great chess database language and developers are very helpful.
Answers.UserDisplayName: hangejj
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-06-14T03:28:29.437Z
Answers.Text: It may be worth mentioning that CQL stands for Chess Query Language; it's chess-specific and not just some random programming language.
Answers.UserDisplayName: D M
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-06-14T02:01:18.857Z
Answers.LastActivityDate: 2020-06-14T02:01:18.857Z
Answers.UserDisplayName: Meshka7
Body: <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>
  
Tags: <opening><endgame>
Title: How can I find the endgame probability based on the opening?
ThreadText: # How can I find the endgame probability based on the opening?
  
  (Asked by: username_0 on 2020-06-13)
  
  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](http://help.chessbase.com/CBase/15/Eng/index.html?endgame_probabilities.htm) 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](https://en.wikipedia.org/wiki/French_Defence#Exchange_Variation:_3.exd5_exd5), a tool might output the following:
  
  **Endgame probabilities based on the Exchange Variation**
  
  1. `N vs N` = 66 percent
  2. `Pawn Ending` = 13 percent
  3. `Q vs Q` = 8 percent
  4. `R+P vs R` = 5 percent
  5. `R vs R` = 4 percent
  6. `R vs N` = 3 percent
  7. `RN vs RB` = 1 percent
  
  **Tags:** opening, endgame
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_4 on 2020-06-14. Score: 6 | Accepted answer
  
  Learn CQL (<http://www.gadycosteff.com/cql/>), then write a program to automate the process
  
  > **Comments:**
  > **username_2**: I second this.  Great chess database language and developers are very helpful.  
  > **username_1**: It may be worth mentioning that CQL stands for Chess Query Language; it's chess-specific and not just some random programming language.  
  
  ---
  
  ### Answer by username_1 on 2020-06-13. Score: 10
  
  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.
  
  [![Screenshot of filter](https://i.sstatic.net/PWRHZ.png)](https://i.sstatic.net/PWRHZ.png)
  
  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.
  
  [![Screenshot of Opening Report](https://i.sstatic.net/syFW8.png)](https://i.sstatic.net/syFW8.png)
  
  > **Comments:**
  > **username_2**: Nice. I've used Scid for awhile time and never thought of using it like that.  
  > **username_3**: More fast is the "Opening Report". It informs some charasteristics that are of importance for the ending, like opposite castling.  
  > **username_1**: @username_3 The opening report does have some interesting stats, and is a quick way to filter based on position, but the "themes" are only counted in those stats if they happen in the first 20 moves, which seemed overly restricted.  
  > **username_3**: @D_M Let me copy about finales, what an opening report informs:  **4.4 Finales**  `Tipos de finales según la última posición de las partidas:`    `P     BN      R   R,BN      Q   Q,BN    Q,R Q,R,BN`    `Informe de partidas     1%     8%     6%    21%     1%     4%     2%    56%`    `Todas las partidas      1%     7%     7%    26%     1%     3%     4%    51%`  
  > **username_1**: @username_3 You are correct. I'll edit this to add that it can be done with the Opening Report.  
  
  ---
  
  