A comparison page prices a customer. A spreadsheet prices you. The gap between the two is usually a few hundred pounds a year, and it is entirely arithmetic. 

What is a pattern, once you take the words out of it? 

Ask someone what they intend to trade and you get a sentence. A spreadsheet wants six quantities: which instruments, how much exposure per position, how many round trips a year, how many nights those positions are carried, how much annual turnover is priced outside sterling, and how often money moves in or out. Every charge a platform can levy attaches to one of the six. 

The test is whether each can be written as a number with a unit beside it. Ninety six round trips. Two hundred and twenty position nights. Most people give the first two confidently and shrug at the other four, which is unfortunate, because the shrugged ones hold most of the money. 

A pattern not written in units is an intention, and intentions do not multiply. 

Which rows carry the weight? 

Frequency and nights, comfortably. They are the multipliers, and a multiplier turns a trivial per-unit difference into the largest line on the page. Sixty pence extra on a round trip is not worth arguing about until you write it out ninety six times and it becomes fifty eight pounds. A third of a percentage point on conversion meets forty thousand pounds of turnover and becomes a hundred and forty. 

Neither is visible per trade, which is the unit in which both look harmless. So round the quantities against yourself. If your honest answer sits between sixty and a hundred round trips, put a hundred in the cell. An estimate biased low is worse than none, since it carries the authority of arithmetic while understating what you built it to find. 

The spread column stacks four different units 

Notice first that the spread column on a comparison page stacks four different units. Pips on a currency pair, points on an index, pence on a UK share, a percentage on the conversion. None is money, and turning them into money runs through position size, which the page does not know. A headline spread also describes the calmest hour on whichever instrument the firm quotes best, so if row one points somewhere else it is a number you will never be charged. 

A rate belongs to you only once the instrument is named 

Price each line against the instruments you named, at the hours you expect to be awake, and where a range is quoted put both ends in the cell. Watch the shape of the pricing rather than its labels. One account type folds the dealing cost into the quote, another splits it into a tighter quote plus commission. A commission line looks like a penalty next to a zero until you total the column above it. 

Where do rate numbers come from before you have an account? 

This is the circular bit. The amounts you want are visible only from inside a funded account, and the account is what you are deciding about. Two sources fill the gap. The provider’s schedule, accurate about what it describes and silent about the rest. And somebody who has already paid the bills. A UK investing research site that opens and funds live accounts with its own money to test trading platforms, rather than compiling rankings from providers’ published fee schedules, The Investors Centre puts the FCA-regulated options against each other on the charges that decide the bill. 

Whatever you copy, copy the date with it. Put the source and the month beside every rate, because a rate without a date cannot be rechecked. 

Two rate cards gathered eight months apart compare a platform with a calendar, and the sheet quietly prefers whichever one you researched more recently. 

What does it look like once the multiplication is done? 

Take a worked pattern: ninety six round trips a year, five thousand pounds of exposure per position, two hundred and twenty position nights, forty thousand pounds of turnover priced outside sterling, four withdrawals. Hold those quantities identical across both columns. Price platform A on the pattern you intend and platform B on the one you have, and the totals stop meaning anything. 

Two columns is the ceiling too. Rate cards gathered in the same month stay comparable and eight of them will not, and the shortlist that gets you to two is made on authorisation and on whether row one is offered at all, which is not arithmetic the sheet can do. 

A worked illustration. The rates in the two right hand columns are placeholders chosen to show the arithmetic, not quotes from any named provider. 

Read the gap rather than the totals 

Three hundred and thirty seven pounds separates them, and the dealing lines every comparison page leads with explain two hundred and forty. The rest is conversion, financing, a monthly fee and a charge for taking your own money out. Platform B loses the headline comparison and wins the year. 

The sheet audits the rates and takes your word for the quantities 

Here is the weakness in the exercise, and it is not in the pricing. Row one holds the pattern you intend, and stated intentions have a poor record here. A 2021 study of retail CFD clients found that 10.5% of them held no positions overnight at all. 

Note what that does and does not say: the denominator is every retail CFD client in the sample, not the subset who describe themselves as day traders, so it cannot tell