Martingale worksheet: calculations and precautions

Martingale worksheet: calculations and precautions
Martingale worksheet: calculations and precautions

The original worksheet is in Portuguese. This article provides a localised guide to its use.

Martingale Spreadsheet

Martingale Spreadsheet we can optimize your operations, Fill in the operating capital, payout and initial value fields and you will be able to have values ​​before entering the market

You will fill in the operating capital field

The payout (which varies from 70% to 95%) depends on what the broker is paying at that time, and, finally, the initial value. In other words, this field corresponds to the value with which you want to start the first order…

On the field in red

You will see the total amount of your operating capital you are using, both in absolute values ​​and as a percentage. This way, it is easier to monitor the impact of each operation on your total operating capital.

Let’s assume that

You enter with 200 dollars on an 80% payout. In this case, note that this value modifies the entire spreadsheet, automatically adjusting the calculations and subsequent operations according to the new initial investment.

When starting

For example, with 10 dollars, realize that, on the second entry, the profit will be equivalent to the first. In other words, the profit from the second entry will be the sum of the initial 10 dollars plus the profit obtained in the first operation.

In the notes field

You can add texts or even a formula, depending on your need to customize the spreadsheet. This way, it becomes easier to organize your information and keep control of each operation.

Do you know the Strategy that I made available to you for free?Conhecer o treinamento Doubling Capital

Have you seen the trading robot? João said this here click

 

CLICK ON THE ICON TO DOWNLOAD YOUR MARTINGALE METHOD WORKSHEET

Download the worksheet

 

Original worksheet examples, readable without images

These HTML tables reproduce the legible figures in the original screenshots. They are theoretical examples, not suggested settings or expected returns. Rounding is preserved; no probabilities or trading costs are shown in the original.

The original screenshots show the same worksheet with different cells highlighted. The table below combines those views without repeating heavy images.

Martingale increases stakes after losses; exposure can exceed the starting balance. A later win is not assured.

Example 1: 85%

Starting balance
$100.00
Payout on a winning trade
85%
Initial stake
$1.00
Cumulative exposure
EntryStakeCumulative exposureShare of starting balance
1$1.00$1.001.00%
2$2.18$3.183.18%
3$4.74$7.917.91%
4$10.31$18.2218.22%
5$22.44$40.6640.66%
6$48.84$89.5089.50%
7$106.30$195.80195.80%
8$231.35$427.15427.15%
9$503.35$930.67930.67%
10$1095.91$2026.592026.59%

Example 2: 80% / $1

Starting balance
$200.00
Payout on a winning trade
80%
Initial stake
$1.00
Cumulative exposure
EntryStakeCumulative exposureShare of starting balance
1$1.00$1.000.50%
2$2.25$3.251.63%
3$5.06$8.314.16%
4$11.39$19.709.85%
5$25.63$45.3322.67%
6$57.67$103.0051.50%
7$129.75$232.74116.37%
8$291.93$524.67262.34%
9$656.84$1181.51590.76%
10$1477.89$2659.411329.71%

Example 3: 80% / $10

Starting balance
$200.00
Payout on a winning trade
80%
Initial stake
$10.00
Cumulative exposure
EntryStakeCumulative exposureShare of starting balance
1$10.00$10.005.00%
2$22.50$32.5016.25%
3$50.63$83.1341.56%
4$113.91$197.0398.51%
5$256.29$453.32226.66%
6$576.65$1029.97514.98%
7$1297.46$2327.441163.72%
8$2919.29$5246.732623.36%
9$6568.41$11815.145907.57%
10$14778.92$26594.0513297.02%

Notes

Record the date, instrument, entry rule, outcome and reason for stopping. The original blank notes area can be reproduced in your own journal.

This content is also available in:German Portuguese (Brazil) Spanish