difference between 1m and realtick real spread on nzdchf BJT-JRXBS-117

SQX 130
Hello,
Tomas Matejka asked me to open a ticket here.


I’ve just encountered a strange difference between 1m test precision and real tick-real spread.
Despite the fact that i’ve used quite a strict spread setting for 1m test it is still even not close to real tick real spread result.
Please have a look,
I’ve attached everything here.


Probably it isn't a bug, but Tomas agreed that it looks odd.


Thank you in advance

Attachments
nzdchf1m25.cfx
(3.81 KiB)
Strategy 14575tick.sqx
(31.32 KiB)
Strategy 14575_1m25.sqx
(45.49 KiB)
nzdchfrealtick.cfx
(3.81 KiB)
  • Votes 0
  • Project StrategyQuant X
  • Type Bug
  • Status Fixed
  • Priority High

History

VO
#1

GRoundofInferno

23.03.2021 13:34

Task created

MF
#2

Mark Fric

26.03.2021 11:34

Priority changed from Normal to High

TB
#3

Tomas Brynda

29.03.2021 17:27

Status changed from New to Fixed

I backtested the strategy and to me it looks like the strategy is very sensitive to spread settings.

If I compare backtests using minute data and real ticks with custom spread, the results are much more similar.


Looking at the tick data of NZDCHF I think the applied spread 1.9 pips is quite low, I can see 4 or 5 pips in the data itself.

VO
#4

GRoundofInferno

29.03.2021 17:55

Attachment to Tomasnzdchfspread.zip added

to Tomasnzdchfspread.zip
(370.47 KiB)
Hello, Tomas.

 thank your for your investigation. 

I found spread settings here. https://www.dukascopy.com/swiss/english/marketwatch/average-spreads/

It is stated that nzd chf pair has spread 1.9-2.1 more than 96% of time. So I've used 1.9 as a reliable one.

Also I've made a quick backtest for you and there is a still a problem.

I am attaching those strategies here. 



TB
#5

Tomas Brynda

30.03.2021 20:31

Attachment strategies.zip added

strategies.zip
(472.67 KiB)

Hi Valery,

I have investigated this a little deeper and performed Monte Carlo tests with randomized spread.

From monte carlo equity curves it is clear that first four strategies are sensitive to spread - the number of trades varies a lot depending on the spread used.

These four strategies also use a very similar entry price levels.


The last one - 4.12.429 is different, the number of trades is almost constant accross all spread settings and higher spreads only cause lower overall profit.

I attach the backtested strategies, you can take a look.


Best regards,

Tomas


Votes: 0

Drop files to upload

or

choose files

Max size: 5MB

Not allowed: exe, msi, application, reg, php, js, htaccess, htpasswd, gitignore

...
Wait please