My (different) data didn't start/end at the same date.
Hi, I work on many different stock data. And it not start/end at the same date. When I add all of stock data it'll show only overlap date. how to deal with it ?
With no code, no output, no chart ... the question would be what's the actual meaning of show in:
When I add all of stock data it'll show only overlap date
Oh, I'm so sorry.
Here is my code. I just add 2 data (Companies enter the market at 2009-09-02 for AAV symbol and 2012-05-31 for ADVANC symbol) into cerebro and try to run example strategy to print out the data(Close). I noticed that Backtest is start at 2012-05-31. So I can't access data before 2012-05-31. The question is how to add all the data without cut any row off.
import backtrader as bt import os import sys import datetime import pandas as pd # Create a Stratey class TestStrategy(bt.Strategy): def log(self, txt, dt=None): ''' Logging function fot this strategy''' dt = dt or self.datas.datetime.date(0) print('%s, %s' % (dt.isoformat(), txt)) def __init__(self): # Keep a reference to the "close" line in the data dataseries self.dataclose = self.datas.close def next(self): # Simply log the closing price of the series from the reference self.log('Close, %.2f' % self.dataclose) if __name__ == '__main__': cerebro = bt.Cerebro() # Add a strategy cerebro.addstrategy(TestStrategy) # Datas are in a subfolder of the samples. Need to find where the script is # because it could have been called from anywhere ATSET100UNIV = [ 'AAV', # It start at 2012-05-31 'ADVANC', # It start at 2009-09-02 ] datapath = '/Users/tempurak/Work/ls-eq/data/' symbols = os.listdir(datapath) symbols.remove('.DS_Store') for file in symbols: # Create a Data Feed if file[:-4] in ATSET100UNIV: data = bt.feeds.GenericCSVData( dataname = datapath + file, fromdate=datetime.datetime(2000, 1, 1), todate=datetime.datetime(2017, 2, 20), nullvalue = 0.0, dtformat = ('%Y-%m-%d'), datetime = 0, open = 1, high = 2, low = 3, close = 4, volume = 5, openinterest = -1) cerebro.adddata(data) # Set our desired cash start cerebro.broker.setcash(100000.0) cerebro.addanalyzer(bt.analyzers.PyFolio, _name='pyfolio') print('Starting Portfolio Value: %.2f' % cerebro.broker.getvalue()) cerebro.run() print('Final Portfolio Value: %.2f' % cerebro.broker.getvalue())
Starting Portfolio Value: 100000.00 2012-05-31, Close, 3.70 2012-06-01, Close, 3.28 2012-06-05, Close, 3.12 2012-06-06, Close, 3.30
This is by design. Each object has a minimum period and while that minimum period is not met, the objects dependent on those cannot go into
nextand remain in
next. For data feeds the minimum period is simply1`, i.e.: they have started delivering data.
Being the reason as simple as:
def next(self): ... print(self.data0.close) # ok ... starts earlier as self.data1 and has delivered print(self.data1.close) # NOK ... kaboom ... exception raised if data1 hadn't started to deliver but it has ... ...
The idea is that code NEVER breaks inside
next. There is no code guard around
self.data1checking if it has already delivered, because it has. It is guaranteed in
nextthat all objects already deliver.
You can always forward each call to
next, but you will have to manually check the length of
data1(and associated indicators) to make sure the code doesn't break.
def next(self): ... print(self.data0.close) # ok ... starts earlier as self.data1 and has delivered if len(self.data1): print(self.data1.close) # guard placed because it may not have delivered ... ...