A Position Sizing Table You Can Build in Ten Minutes
Calculating lot size for every trade can feel slow, and rushing leads to mistakes. A simple table prepared in advance helps you size quickly and consistently.
Here's how to build one in a spreadsheet.
Step 1: Choose your instrument. Start with your main pair.
Step 2: List your account balance or risk amount. For example, risk $20 per trade.
Step 3: List stop distances. For example, 10, 15, 20, 25, 30, 40, 50 pips.
Step 4: Calculate lot sizes. Use the formula: lot size = risk amount / (stop in pips x pip value per lot).
For a pair where one pip on a standard lot is about $10:
- 10 pips: $20 / (10 x 10) = 0.20 lots
- 20 pips: $20 / (20 x 10) = 0.10 lots
- 40 pips: $20 / (40 x 10) = 0.05 lots
Step 5: Save and print it. Keep it next to your screen.
Step 6: Update it when your account balance changes significantly or when you trade another instrument.
Benefits:
- Faster decisions in live markets
- Fewer calculation errors
- Consistent risk
Reminder: verify pip values for your broker and account currency, since they can differ.
A good tool removes friction from good behavior. Spend ten minutes now, and save yourself mistakes for months.
A Position Sizing Table You Can Build in Ten Minutes
A Position Sizing Table You Can Build in Ten Minutes
It’s Fairman 
Re: A Position Sizing Table You Can Build in Ten Minutes
Worked example of how I lay out the table. Rows are stop sizes in pips, 10, 15, 20, 25 and so on. Columns are pairs. Each cell is the lot size for 1% risk on my account. Once a month I update it for the account balance. Before every trade I just read across, no calculator in the moment.
It’s Fairman 
Re: A Position Sizing Table You Can Build in Ten Minutes
A small mistake to avoid: don't build the table on rounded pip values. On some crosses, the pip value moves with the exchange rate. A rough number is fine for EURUSD-type pairs, but update the cross pairs regularly or your 1% is quietly becoming 1.2%. On a dollar account, pairs quoted in dollars like EURUSD and GBPUSD have a fixed 10 dollars per standard lot pip. Pairs like USDJPY, USDCAD, EURGBP and GBPJPY all depend on a rate that moves. A spreadsheet that pulls live rates fixes that, for example with GOOGLEFINANCE in Google Sheets, so the table updates itself instead of relying on you remembering.
It’s Fairman 
-
Shadow Trader
- Posts: 5594
- Joined: Wed Sep 09, 2026 5:19 pm
Re: A Position Sizing Table You Can Build in Ten Minutes
Worth adding a rounding column, since most platforms only accept lots in steps of 0.01 and the formula rarely lands on a clean number. Rounding down every time keeps the risk at or under the target, which matters more than hitting it exactly.
The chart works through 20 dollars of risk on EURUSD and on USDJPY at 150.00, where one standard lot pays roughly 6.67 dollars per pip. At a 35 pip stop EURUSD comes out at 0.0571 lots, rounds down to 0.05 and actually risks 17.50.
On a 20 dollar risk that drift is tolerable. On a 5 dollar risk it is not, since the same 35 pip stop gives 0.0143 lots, which rounds down to 0.01 and risks only 3.50, so small accounts need stops where the steps land near the target.
The other column I would add is cost. If the spread plus commission is around 1 pip, a 10 pip stop behaves like 11 pips at the moment of entry, and sizing on 10 overstates the lots by roughly 10 percent.
Fairman's monthly refresh covers the balance side. For USDJPY the pip value also moves with the rate, so the same table is about 3 percent off if the pair drifts from 150 to 145.
The chart works through 20 dollars of risk on EURUSD and on USDJPY at 150.00, where one standard lot pays roughly 6.67 dollars per pip. At a 35 pip stop EURUSD comes out at 0.0571 lots, rounds down to 0.05 and actually risks 17.50.
On a 20 dollar risk that drift is tolerable. On a 5 dollar risk it is not, since the same 35 pip stop gives 0.0143 lots, which rounds down to 0.01 and risks only 3.50, so small accounts need stops where the steps land near the target.
The other column I would add is cost. If the spread plus commission is around 1 pip, a 10 pip stop behaves like 11 pips at the moment of entry, and sizing on 10 overstates the lots by roughly 10 percent.
Fairman's monthly refresh covers the balance side. For USDJPY the pip value also moves with the rate, so the same table is about 3 percent off if the pair drifts from 150 to 145.
-
FXS Prop Desk
- Posts: 1689
- Joined: Wed Oct 07, 2026 9:52 am
Re: A Position Sizing Table You Can Build in Ten Minutes
A small addition to the table is a column for the pip value of each pair in the account currency, updated weekly, since it changes with exchange rates. For a euro account, for example, the value of a pip on USD/JPY depends on both EUR/USD and USD/JPY, and using an outdated value can distort risk noticeably.
Laminating a printed copy near the screen also works for quick reference.
Laminating a printed copy near the screen also works for quick reference.
FXS Official Team | The Idea Lab & Strategy
-
Shadow Trader
- Posts: 5594
- Joined: Wed Sep 09, 2026 5:19 pm
Re: A Position Sizing Table You Can Build in Ten Minutes
FXS Prop Desk's euro account example shows how quickly a fixed table drifts, and gold is the row people get wrong most often. On XAUUSD one standard lot is usually 100 ounces, so a 1 dollar move in price is worth 100 dollars per lot.
The word pip causes trouble here because brokers define it differently for gold, some as 0.01 and some as 0.10. Writing the gold rows as stop distance in dollars of price avoids the confusion completely.
Say the risk is 20 dollars and the stop is 3 dollars below entry. That gives 20 divided by 300, or 0.0667 lots, which rounds down to 0.06 and risks 18 dollars.
A second safety feature is a maximum lot cell for each instrument, shaded red when exceeded. Typing 0.60 instead of 0.06 is an easy slip on a fast gold move, and having the ceiling printed beside the table makes the wrong number look obviously wrong before the order goes in.
Contract sizes should be checked in the platform's symbol specification rather than assumed. Some brokers use 10 ounce or 1 ounce contracts on gold, which changes every number in the row.
The word pip causes trouble here because brokers define it differently for gold, some as 0.01 and some as 0.10. Writing the gold rows as stop distance in dollars of price avoids the confusion completely.
Say the risk is 20 dollars and the stop is 3 dollars below entry. That gives 20 divided by 300, or 0.0667 lots, which rounds down to 0.06 and risks 18 dollars.
A second safety feature is a maximum lot cell for each instrument, shaded red when exceeded. Typing 0.60 instead of 0.06 is an easy slip on a fast gold move, and having the ceiling printed beside the table makes the wrong number look obviously wrong before the order goes in.
Contract sizes should be checked in the platform's symbol specification rather than assumed. Some brokers use 10 ounce or 1 ounce contracts on gold, which changes every number in the row.
-
Shadow Trader
- Posts: 5594
- Joined: Wed Sep 09, 2026 5:19 pm
Re: A Position Sizing Table You Can Build in Ten Minutes
In the minutes before a major scheduled release, ranges often narrow as participants stop trading and wait. This compression can lure scalpers into thinking conditions are calm and easy.
The compression itself does not predict direction, but it does signal that the release is likely to produce a larger move than usual, since pent-up positioning is waiting for a catalyst. Spreads may begin to widen even before the data arrives.
For scalpers, the safest approach is typically to avoid entering new positions in the final minutes before a release and to close existing ones. Those who trade the event deliberately should do so with defined risk and small size. Analyzing past events, measuring the range in the ten minutes before and after, builds a sense of typical expansion. Pairs and events differ, so keeping separate records is helpful. The key lesson is that quiet before the storm should be treated as a warning, not an invitation.
The compression itself does not predict direction, but it does signal that the release is likely to produce a larger move than usual, since pent-up positioning is waiting for a catalyst. Spreads may begin to widen even before the data arrives.
For scalpers, the safest approach is typically to avoid entering new positions in the final minutes before a release and to close existing ones. Those who trade the event deliberately should do so with defined risk and small size. Analyzing past events, measuring the range in the ten minutes before and after, builds a sense of typical expansion. Pairs and events differ, so keeping separate records is helpful. The key lesson is that quiet before the storm should be treated as a warning, not an invitation.