Gamestudio Links
Zorro Links
Newest Posts
optimize global parameters SOLVED
by dBc. 09/27/25 17:07
ZorroGPT
by TipmyPip. 09/27/25 10:05
Release 2.68 replacement of the .par format
by Martin_HH. 09/23/25 20:48
assetHistory one candle shift
by jcl. 09/21/25 11:36
Plugins update
by Grant. 09/17/25 16:28
AUM Magazine
Latest Screens
Rocker`s Revenge
Stug 3 Stormartillery
Iljuschin 2
Galactic Strike X
Who's Online Now
0 registered members (), 18,175 guests, and 5 spiders.
Key: Admin, Global Mod, Mod
Newest Members
krishna, DrissB, James168, Ed_Love, xtns
19168 Registered Users
Previous Thread
Next Thread
Print Thread
Rate Thread
Best Practice to deal with missing trade data/no trades made? #476851
04/12/19 23:16
04/12/19 23:16
Joined: Dec 2016
Posts: 12
K
kreko Offline OP
Newbie
kreko  Offline OP
Newbie
K

Joined: Dec 2016
Posts: 12
Hi, I got almost 8 years of BTC/USD data with 1 min resolution. The problem is there are plenty of instances where there are no trades made in any given minute. Especially in the beginning, which in my case is the year 2011.
I took this data set through Python's pandas library and forward filled the missing entries, ie filled all missing minutes with the data from the last minute where data was available. (See screenshots)

Is it a correct approach or I should have kept the missing entries empty as the reality of that moment? What is the correct way of dealing with these cases re backtesting?

Thanks

Attached Files forward_fill.PNG
Re: Best Practice to deal with missing trade data/no trades made? [Re: kreko] #476855
04/13/19 07:36
04/13/19 07:36
Joined: Jul 2000
Posts: 28,022
Frankfurt
jcl Offline

Chief Engineer
jcl  Offline

Chief Engineer

Joined: Jul 2000
Posts: 28,022
Frankfurt
Better remove all NaN quotes out of the history. Very old BTC data is anyway not well suited for backtests due to the low volume. Only after 2016 BTC backtests became meaningful.

Re: Best Practice to deal with missing trade data/no trades made? [Re: jcl] #476861
04/13/19 16:21
04/13/19 16:21
Joined: Dec 2016
Posts: 12
K
kreko Offline OP
Newbie
kreko  Offline OP
Newbie
K

Joined: Dec 2016
Posts: 12
Originally Posted By: jcl
Better remove all NaN quotes out of the history. Very old BTC data is anyway not well suited for backtests due to the low volume. Only after 2016 BTC backtests became meaningful.


Got it, thanks


Moderated by  Petra 

Powered by UBB.threads™ PHP Forum Software 7.7.1