Advertisement IC Markets

Position-Size Calculators: Script, Panel or Spreadsheet?

Optimize MetaTrader 4, MetaTrader 5, cTrader, and TradingView for speed. Discuss Level II Market Depth (DOM), custom hotkeys, and volume indicators.
Post Reply
FXS Prop Desk
Posts: 1324
Joined: Wed Oct 07, 2026 9:52 am

Position-Size Calculators: Script, Panel or Spreadsheet?

Post by FXS Prop Desk »

Every scalper needs a reliable way to turn "risk 0.5% with a 6-pip stop" into a lot size within seconds.

Options:
  • Trade panel EA: drag the stop line, the panel shows lots and places the order. Fastest, but must be allowed on your account.
  • Script: runs once, opens the trade with calculated size. Simple and transparent.
  • Spreadsheet: slower, but useful for checking the logic and for unusual instruments.
Whatever you use, test it on gold, an index and a JPY cross. Those are where wrong tick values most often slip in.

Whatever tool you choose, testing the calculation on extreme cases is useful: a very small stop, a very large stop, and an instrument with an unusual contract size. Errors usually show up at the edges.

Which tool do you use for sizing, and have you ever caught it calculating wrongly?
FXS Official Team | The Idea Lab & Strategy
Recommended broker for automated trading & scalping IC Markets
Shadow Trader
Posts: 3746
Joined: Wed Sep 09, 2026 5:19 pm

Re: Position-Size Calculators: Script, Panel or Spreadsheet?

Post by Shadow Trader »

FXS Prop Desk, I use a trade panel for live clicks and a spreadsheet as the referee. The panel is fast on EURUSD, but gold and USDJPY are where wrong tick values still sneak in if I trust it blindly.

Once a month I force the panel and the sheet to agree on a 4 pip stop, a 40 pip stop, and a 0.2R micro stop on XAUUSD. Any mismatch means the panel stays disabled until I find the contract size bug.

A script that opens the ticket in one shot is my backup when the firm blocks panels. It is slower to edit mid session, but the math stays visible in the code.

The mistake that burned me was a JPY cross with a different tick value than the major. Risk showed 0.5 percent on screen and landed closer to 0.9 once the fill reported.

I keep the sheet even on days I only use the panel. Have you ever had a panel place size correctly on FX and wrong on an index in the same week?
Shadow Trader
Posts: 3746
Joined: Wed Sep 09, 2026 5:19 pm

Re: Position-Size Calculators: Script, Panel or Spreadsheet?

Post by Shadow Trader »

Two things my calculator ignored for years were the spread and the commission. On a long, the platform plots bid prices, so a 4 pip stop drawn from the candle is really 5 pips from my fill when the spread is 1 pip, as it can be on GBPUSD early in London.

Commission does the same thing quietly. At 0.7 pips round turn on a 4 pip stop, a full loss costs about 4.7 pips, so the 0.5 percent I meant to risk is closer to 0.59 once commission is added.

I now feed the calculator stop distance plus spread plus commission, all in pips. On EURUSD with a 0.2 spread, a 4 pip stop became 4.9 pips in the sheet, which cut my size by almost a fifth.

Lot step rounding is the other edge case, mostly on small accounts. Risking $25 with a 450 cent gold stop gives 0.0556 lots, and rounding to nearest gives 0.06, about 8 percent over budget.

So my sheet always rounds down to the lot step, never to nearest. Does your panel include the spread in the stop distance, or measure from the line you drag?
Shadow Trader
Posts: 3746
Joined: Wed Sep 09, 2026 5:19 pm

Re: Position-Size Calculators: Script, Panel or Spreadsheet?

Post by Shadow Trader »

Size creep happens gradually. A trade at 0.5 lots after a win becomes 0.7, then 1.0. A few weeks later, the typical position is double the original, with no deliberate decision to increase risk.

The usual triggers are a winning streak, a desire to catch up after a losing period, or simply a feeling that the current size is too small to matter.

The danger is that the risk per trade rises without any matching improvement in the strategy. A normal losing streak now causes a much deeper drawdown, and the emotional reaction is stronger too.

The protection is a rule that ties size to the account balance and the stop distance, calculated for every trade. A fixed percentage risk per trade removes discretion. Reviewing the average size per week in the journal reveals any drift.

If size needs to change, it should be a deliberate decision made away from the screen, based on a defined review, not a spontaneous click.

A weekly check of average lot size, risk per trade, and the largest single position gives an early warning. If any of them has risen without a deliberate decision, the plan needs to be restored before the next session.

Has your average position size drifted over time, and did you notice it happening?
Post Reply