Mariner Backtesting - TA-LIB Commodity Channel Index

CCI

CCI

 real = CCI(high, low, close, timeperiod=14)

Plot

Commodity Channel Index

Working Example

from cloudquant.interfaces import Strategy
from collections import OrderedDict
import ktgfunc
import talib

class WE_CCI(Strategy):

    def on_start(self, md, order, service, account):
        # symbol and timestamp
        print(self.symbol + ":  " + service.time_to_string(service.system_time))
        daily_bars = md.bar.daily(start=-100)
        close = daily_bars.close
        high = daily_bars.high
        low = daily_bars.low
        real = talib.CCI(high, low, close, timeperiod=14)

        # get the date values
        dates = service._context.market._storage.market_hours.keys()
        dateList = []
        for date in dates:
           dateList.append(str(date.strftime('%Y-%m-%d')))
        dates = sorted(dateList, reverse=True)[1:101]
        dates.sort()

        dict = OrderedDict()
        dict['date'] = dates
        dict['high'] = high
        dict['low'] = low
        dict['close'] = close
        dict['real'] = real
        symbol = 'CCI: ' + self.symbol
        print ktgfunc.talib_table(symbol, 1, dict)

Console

MSFT:  2017-02-09 09:30:00.000000
CCI: MSFT
Input Output
date high low close real
2016-09-16 57.24 56.37 56.87 nan
2016-09-19 57.36 56.47 56.55 nan
2016-09-20 56.97 56.37 56.43 nan
2016-09-21 57.46 56.70 57.37 nan
2016-09-22 57.61 57.24 57.43 nan
2016-09-23 57.52 56.99 57.04 nan
2016-09-26 56.76 56.45 56.52 nan
2016-09-27 57.67 56.30 57.56 nan
2016-09-28 57.67 57.28 57.64 nan
2016-09-29 57.78 56.83 57.01 nan
2016-09-30 57.38 56.96 57.21 nan
2016-10-03 57.16 56.68 57.03 nan
2016-10-04 57.21 56.59 56.86 nan
2016-10-05 57.57 56.88 57.25 49.48
2016-10-06 57.47 56.90 57.35 45.29
2016-10-07 57.59 57.03 57.41 70.19
2016-10-10 58.00 57.48 57.65 185.47
2016-10-11 57.63 56.51 56.81 -70.29
2016-10-12 56.89 56.02 56.73 -160.93
2016-10-13 56.92 55.94 56.54 -139.87
2016-10-14 57.35 56.74 57.03 -17.39
2016-10-17 57.07 56.49 56.84 -69.36
2016-10-18 57.56 57.02 57.27 58.69
2016-10-19 57.45 57.01 57.14 36.94
2016-10-20 57.13 56.28 56.87 -69.32
2016-10-21 60.04 59.09 59.26 349.03
2016-10-24 60.59 59.53 60.59 257.02
2016-10-25 60.96 60.39 60.58 189.14
2016-10-26 60.79 60.06 60.22 126.14
2016-10-27 60.42 59.69 59.70 84.47
2016-10-28 60.11 59.18 59.47 58.35
2016-10-31 60.01 59.52 59.52 53.68
2016-11-01 59.62 58.85 59.40 30.41
2016-11-02 59.53 58.90 59.03 17.46
2016-11-03 59.24 58.71 58.81 -1.76
2016-11-04 58.88 58.13 58.32 -43.45
2016-11-07 60.11 59.38 60.01 47.26
2016-11-08 60.37 59.75 60.06 60.04
2016-11-09 60.18 58.80 59.77 -10.75
2016-11-10 60.08 57.24 58.31 -135.10
2016-11-11 58.72 57.62 58.62 -130.44
2016-11-14 58.68 56.90 57.73 -159.01
2016-11-15 59.49 58.31 58.87 -29.67
2016-11-16 59.66 54.27 59.65 -125.58
2016-11-17 60.95 59.97 60.64 144.93
2016-11-18 61.14 60.30 60.35 133.25
2016-11-21 60.97 60.42 60.86 118.99
2016-11-22 61.26 60.81 61.12 115.72
2016-11-23 61.10 60.25 60.40 72.11
2016-11-25 60.53 60.13 60.53 52.92
2016-11-28 61.02 60.21 60.61 61.00
2016-11-29 61.41 60.52 61.09 77.91
2016-11-30 61.18 60.22 60.26 44.36
2016-12-01 60.15 58.94 59.20 -29.66
2016-12-02 59.47 58.80 59.25 -54.49
2016-12-05 60.58 59.56 60.22 0.98
2016-12-06 60.46 59.80 59.95 -13.51
2016-12-07 61.38 59.80 61.37 72.17
2016-12-08 61.58 60.84 61.01 104.66
2016-12-09 61.99 61.12 61.97 156.48
2016-12-12 62.30 61.72 62.17 165.00
2016-12-13 63.42 62.24 62.98 194.19
2016-12-14 63.45 62.53 62.68 149.11
2016-12-15 63.15 62.30 62.58 108.68
2016-12-16 62.95 62.12 62.30 78.54
2016-12-19 63.77 62.42 63.62 106.55
2016-12-20 63.80 63.03 63.54 100.22
2016-12-21 63.70 63.12 63.54 90.35
2016-12-22 64.10 63.40 63.55 96.46
2016-12-23 63.54 62.80 63.24 58.36
2016-12-27 64.07 63.21 63.28 78.94
2016-12-28 63.40 62.83 62.99 29.39
2016-12-29 63.20 62.73 62.90 -0.49
2016-12-30 62.99 62.03 62.14 -106.14
2017-01-03 62.84 62.12 62.58 -97.64
2017-01-04 62.75 62.12 62.30 -104.34
2017-01-05 62.66 62.03 62.30 -97.76
2017-01-06 63.15 62.04 62.84 -43.37
2017-01-09 63.08 62.54 62.64 -36.53
2017-01-10 63.07 62.28 62.62 -45.57
2017-01-11 63.23 62.43 63.19 10.09
2017-01-12 63.40 61.95 62.61 -36.76
2017-01-13 62.87 62.35 62.70 -31.15
2017-01-17 62.70 62.03 62.53 -78.87
2017-01-18 62.70 62.12 62.50 -68.31
2017-01-19 62.98 62.19 62.30 -39.50
2017-01-20 62.82 62.37 62.74 35.42
2017-01-23 63.12 62.57 62.96 126.37
2017-01-24 63.74 62.94 63.52 256.88
2017-01-25 64.10 63.45 63.68 237.98
2017-01-26 64.54 63.55 64.27 216.37
2017-01-27 65.91 64.89 65.78 257.38
2017-01-30 65.79 64.80 65.13 162.04
2017-01-31 65.15 64.26 64.65 95.11
2017-02-01 64.62 63.47 63.58 30.08
2017-02-02 63.41 62.75 63.17 -31.05
2017-02-03 63.70 63.07 63.68 -7.58
2017-02-06 63.65 63.14 63.64 -15.48
2017-02-07 63.78 63.23 63.43 -23.73
2017-02-08 63.81 63.22 63.34 -35.24