The original worksheet is in Portuguese. This article provides a localised guide to its use.
Fantastic Soros Spreadsheet
With the Fantástica Spreadsheet Soros, you will be able to manage operating capital with this spreadsheet that is widely used by traders.
In the highlighted field in the image below, you will find a space for filling in the amount of operating capital you have. This value, therefore, represents the initial amount that you are willing to invest in your operations. By entering this value correctly, you will be able to have better control over your investment and, therefore, be able to adjust your strategies according to the amount available. Furthermore, remember that this is a fundamental step to ensure that your investment decisions are always aligned with your financial reality, avoiding unnecessary risks and, consequently, protecting your operating capital.
In the highlighted field The payout of 70 to 95%
In the highlighted field, you will find the payout, which can vary from 70% to 95%. This value represents the return you can obtain on the amount invested in a successful operation. Therefore, when selecting the payout, it is important to understand that the higher the payout, the higher the potential return, but there may also be different levels of risk involved. Furthermore, it is essential to consider this aspect within your investment strategy, as it will directly influence your results. If you choose a payout of 70%, for example, your return will be lower compared to a payout of 95%, but the risk may be different. Therefore, when defining this percentage, you must balance your risk appetite with the expected reward, ensuring a more assertive approach to your operations.
The start field to be the first entry
The start field will be used to define your first entry. By filling it out, you will be taking the first step towards operating in the market. This field is crucial as the first entry is usually the foundation of your trading strategy. Therefore, when starting the operation, it is important to accurately determine the value of the entry, taking into account your risk profile and the established objectives. Furthermore, it is essential that you pay attention to the exact moment you make this entry, as it can directly influence the following stages of your operation. Finally, when adjusting the starting field, remember that this decision will define the approach to your trade, and is therefore fundamental to the success of the strategy as a whole.
As the trader makes the gain
He must reinvest not only the profit, but also the value of the first entry into the second entry, and so on. This practice is known as ‘Soros’, where the trader uses accumulated profits to progressively increase the value of entries in subsequent operations. By doing this, it enhances the chances of return, since the amount invested grows according to the success of the negotiations. However, it is important to remember that this strategy requires discipline and control, as, when reinvesting, the trader also assumes greater risks. Therefore, it is essential to have well-structured risk management and define clear limits to ensure that gains are not consumed by losses. This way, the trader can maximize his profits while maintaining control over risks throughout the process.
In the field in green
You will see two distinct fields. In the first green field, there will be the profit obtained with the initial amount invested. In the second green field, you will only find the profit, that is, the value that was generated from the operation after the return on the initial investment. This separation is important as it allows you to have a clear view of the net profit, without including the value of the initial entry. With this organization, it is easier to monitor the performance of operations and make more informed decisions about how to proceed with reinvestment or withdrawal of profits. This way, you can maintain more efficient control over your operating capital and subsequent operations….
On the yellow field
You will see the initial investment value, which is directly related to your operating capital. For example, if your operating capital is $100, each initial investment of $1 will correspond to 1% of the total operating capital value. This value is crucial, as it determines the size of your input into operations and, consequently, your risk management. Therefore, by using this strategy, you can better control the amount invested in each operation, keeping it within a safe percentage of your operating capital. This type of organization is essential to ensure that, even in times of loss, the impact on your capital is minimized and you are able to continue operating in a sustainable manner….
In the notes field
You will have the flexibility to fill in both numeric values and texts. This allows you to record important information about each trade, such as the amount invested, the results of previous entries or even personal notes about the strategy used. Plus, by doing so, you’ll be able to track your performance over time, helping you identify patterns or areas that need adjustment. Therefore, by keeping this record, it becomes easier to analyze your trading history and make more informed decisions on upcoming trades.
Download the worksheet
Read also: How João Transformed his financial life in OB How João Transformed His Financial Life in OB
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.
- Starting balance
- $100.00
- Payout on a winning trade
- 70%
- Initial stake
- $1.00
Soros reinvests proceeds after wins. The figures assume consecutive winning trades; a losing trade interrupts the sequence and can erase reinvested gains.
| Entry | Total | Total less initial stake |
|---|---|---|
| 2 | $2.89 | $1.89 |
| 3 | $4.91 | $3.91 |
| 4 | $8.35 | $7.35 |
| 5 | $14.20 | $13.20 |
| 6 | $24.14 | $23.14 |
| 7 | $41.03 | $40.03 |
| 8 | $69.76 | $68.76 |
| 9 | $118.59 | $117.59 |
| 10 | $201.60 | $200.60 |
Profit: $2.89 − $1.00 = $1.89.
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:
