- Money Management
- How to Build A Forex Trading Journal Using Excel Spreadsheet
- Money Management
- 1. Risk Per Trade
- Risk Controls You Shouldn’t Ignore
- Fractional money management
- My Trading Journal (Excel Spreadsheet)
- Advantages of smaller lot sizes
- Traders Day Trading
- Beware of correlations
- Forex Money Management Tactics to Protect and Grow Your Account
- 2. Risk Reward
- Search This Blog
- Fichier Excel pour Money Management
- Trading Journal Spreadsheet Download
- Strike a balance between your risk/reward
- Forex trading money management excel
- Ebook Pack
- 3x Popular eBooks
What sets successful traders apart from those who fail over the long term is their money management skills. Money management can be thought of as the administrative side of trading.
How to Build A Forex Trading Journal Using Excel Spreadsheet
The basic aim is to manage risk by limiting market exposure, at any given time, to acceptable levels.
the trader's budget © forexop
This is achieved by managing factors such as the amount of capital risked per trade and the total number of open positions. This ultimately ensures a trader can withstand losses within his or her trading system without “running down” the account.
Forex trading makes this task particularly challenging.
Firstly, many forex traders use high leverage. This means if a trader’s money management isn’t sound, small movements in the market can have dramatic effects on the floating P&L.
If a trader’s money management isn’t sound, small movements in the market can have dramatic effects on the floating P&L.
Secondly, the forex market uses fixed-sized trading contracts known as lots.
With a smaller account, this makes the choice of trade size even more critical since each unit can represent a relatively large proportion of the account capital.
1. Risk Per Trade
The first principle of money management involves deciding how much of your total capital to expose at any given time. All things being equal, the more of your capital you expose (trade with), the more risk you are taking.
Your market exposure is a combination of:
a) The amount of capital allocated per trade
b) The number of open positions you are holding
More capital exposed = higher risk, potentially higher profit
Less capital exposed = lower risk, potentially lower profit
If you choose too small a value, your account will be underutilized.
Too large a value and you risk a margin call.
Risk Controls You Shouldn’t Ignore
So what’s the best way to go?
Fractional money management
Many traders use formulaic approaches based on ideas such as “fixed ratio” or “fixed fractional” money management.
The advantage of using a formulaic approach is that it will tell you precisely how many lots to trade at any given point. In doing so it takes into consideration the account balance, lot size and the maximum loss allowed per trade.
As your balance changes through profits or losses, your exposure is increased or reduced in the same proportion.
See Figure 1.
Figure 1: Account balance verses lots traded on a nano account. © forexop
So let’s say you have a nano account size of $1,000.
If your stop loss is 100 pips, and you want to risk no more than 1% per trade that would mean you can trade 10 lots each. And your maximum exposure per trade is $10. If you use 10 lots per trade, that’s 1% of your capital at risk on each open position.
My Trading Journal (Excel Spreadsheet)
See the table below.
|Lot size (in standard lots)||0.001|
|Max stop loss (pips)||100.00|
|Max risk per trade||1.00%|
|Max risk on account||15.00%|
|Max permitted loss per trade||$10.0|
|Max account loss||$150.0|
|Max lots per trade||10.00|
|Max open lots||150.00|
Copyright © 2020 forexop.com
The Excel spreadsheet that can be downloaded below will calculate the sizes and maximum lots using fractional money management.
We also have a Metatrader money management indicator that will do the calculations for you “on the fly”.
One thing the above doesn’t do is factor for correlation between positions being held.
For that you will need to calculate the VAR – or value at risk.
Advantages of smaller lot sizes
When it comes to money management, flexibility is the key. Having an account that’s able to trade in smaller lots has several major advantages.
Firstly, you can split trades into smaller sized units and this allows you to manage risk more effectively.
It also gives you more leeway to adjust trade sizes in line with accumulated profit/loss as the account balance changes.
Secondly it allows you to stagger your entry and exit points.
This means you reduce the risk of being taken out in one sweep by a sudden increase in spreads or volatility.
Traders Day Trading
Several trading strategies such as Martingale and grid trading use this approach.
You can see by checking the spreadsheet that with a balance of $1,000 you shouldn’t risk more than 1 micro lot per trade. If you have a balance of $100 then you’d really need to use a nano account in order to keep within advisable risk limits.
Beware of correlations
Once you’ve decided how much to risk per trade, the next question is “how many open lots (positions) to allow at any given time?”.
Currency pairs tend to move in unison with one another more than other asset types such as stocks.
That is, they’re strongly correlated either directly or indirectly. If you’re trading the majors, all of your positions are likely to be correlated with one another – at least to some extent.
It’s important to check both the historical and current correlations between the pairs you are trading.
Forex Money Management Tactics to Protect and Grow Your Account
If you use Metatrader you can use our free hedging indicator to do this for you.
This correlation needs to be factored in when deciding your overall account exposure. If you allow too many open lots on correlated pairs, you can find your account balance is adversely affected by the movements of just one or two of them.
Just because a system has a higher payoff verses loss, doesn’t necessarily make it a good system.
The second aspect of money management is the concept of risk vs.
reward. On an individual trade, the risk is the potential loss in the transaction. The reward is the potential gain.
However, this is only part of the story. The other side of this is the outcome – that is the odds of winning verses losing.
For example, a trader may be willing to risk a greater loss, if the probability of that loss occurring is small.
Likewise, a trader may be willing to accept a smaller reward, if the odds of winning are in his favor.
In spite of what many people think, having a reward value that’s less than the risk is not necessarily a bad strategy.
Search This Blog
Likewise, just because a system has a higher payoff verses loss, doesn’t necessarily make it a good system. If it were so simple to load the odds in your favor by adjusting risk:reward then wouldn’t trading be a simple task? Unfortunately things are never that easy.
There are several factors that need to be considered.
Firstly, suppose you have a much lower risk verses reward.
That is you set your trades with a stop loss that’s much smaller than your take profit amount.
Fichier Excel pour Money Management
Suppose you use a 10 pip stop verses a 100 pip take profit.
If you believe the markets are efficient, then this implies that all information is reflected in the existing price.
We shouldn’t be able to beat the market consistently. The outcome of any trade would then be at best 50:50. this ignore any carry opportunity and trading costs.
p(win) x win + p(loss) x loss = 0
P(win):p(loss) = -loss: win
In other words, the risk-reward ratio is exactly the inverse of the odds of winning verses losing.
For example, if your risk-reward is 3:1, then your odds of winning must be 1:3.
That is with a 3:1 risk-reward, you risk 300 pips to gain 100 pips. Then, if the market is efficient your odds of success must be exactly 3 times your odds of losing. (read more here)
EMH just talks above averages.
This doesn’t mean the outcome of every trade is zero, and it doesn’t mean there aren’t long term winning and losing runs in the markets. Statistical outliers do exist; ask Warren Buffet or George Soros.
On the other side of EMH there's the Fractal Markets Hypothesis.
In this case, statistically speaking fewer of your trades will end in profit. This will give you a lower overall trade win ratio.
Trading Journal Spreadsheet Download
However, when you win, the payoff will be significant compared to the smaller losses.
Now on the other hand, suppose you do it the other way around. You set wide stop losses at 100 pips, and a small take profit of just 10 pips. In this case, you’d expect to have a much higher win ratio.
When you use this type of setup, while the losses may be fewer, any individual loss may be unmanageable within the account.
Strike a balance between your risk/reward
In a nutshell, there is no right “risk-reward” ratio.
The level you use will depend on your strategy and your trading objectives.
Keep in mind that high risk strategies demand constantly high trade win-ratios.
Forex trading money management excel
And that is difficult to guarantee in the long run. If your loss per trade is too high, you may discover that a relatively short sequence of losing trades is enough to create a margin call.
In forex, “unlikely events” tend to happen much more often than people realize. Traders who follow good money management are wise to this and are prepared; those who don’t rarely last very long.
Most of these risks and reasons for failure can be avoided by sticking to some tried and tested rules.
eBook value set for the classic trading strategies: Grid trading, scalping and carry trading.
All ebooks contain worked examples with clear explanations. Learn to avoid the pitfalls that most new traders fall into.
Want to stay up to date?
Just add your email address below and get updates to your inbox.