Mariner Backtesting - TA-LIB Williams' %R

WILLR

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

Plot

Williams' \%R

Working Example

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

class WE_WILLR(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.WILLR(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 = 'WILLR: ' + self.symbol
        print ktgfunc.talib_table(symbol, 1, dict)

Console

MSFT:  2017-02-09 09:30:00.000000
WILLR: 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 -35.51
2016-10-06 57.47 56.90 57.35 -28.78
2016-10-07 57.59 57.03 57.41 -24.74
2016-10-10 58.00 57.48 57.65 -20.48
2016-10-11 57.63 56.51 56.81 -70.22
2016-10-12 56.89 56.02 56.73 -64.32
2016-10-13 56.92 55.94 56.54 -70.85
2016-10-14 57.35 56.74 57.03 -46.75
2016-10-17 57.07 56.49 56.84 -56.39
2016-10-18 57.56 57.02 57.27 -35.18
2016-10-19 57.45 57.01 57.14 -41.44
2016-10-20 57.13 56.28 56.87 -54.94
2016-10-21 60.04 59.09 59.26 -19.10
2016-10-24 60.59 59.53 60.59 -0.00
2016-10-25 60.96 60.39 60.58 -7.52
2016-10-26 60.79 60.06 60.22 -14.64
2016-10-27 60.42 59.69 59.70 -25.12
2016-10-28 60.11 59.18 59.47 -29.67
2016-10-31 60.01 59.52 59.52 -28.68
2016-11-01 59.62 58.85 59.40 -31.06
2016-11-02 59.53 58.90 59.03 -41.19
2016-11-03 59.24 58.71 58.81 -45.86
2016-11-04 58.88 58.13 58.32 -56.48
2016-11-07 60.11 59.38 60.01 -20.17
2016-11-08 60.37 59.75 60.06 -19.11
2016-11-09 60.18 58.80 59.77 -42.10
2016-11-10 60.08 57.24 58.31 -71.39
2016-11-11 58.72 57.62 58.62 -62.84
2016-11-14 58.68 56.90 57.73 -78.57
2016-11-15 59.49 58.31 58.87 -44.01
2016-11-16 59.66 54.27 59.65 -11.84
2016-11-17 60.95 59.97 60.64 -4.64
2016-11-18 61.14 60.30 60.35 -11.50
2016-11-21 60.97 60.42 60.86 -4.08
2016-11-22 61.26 60.81 61.12 -2.00
2016-11-23 61.10 60.25 60.40 -12.30
2016-11-25 60.53 60.13 60.53 -10.44
2016-11-28 61.02 60.21 60.61 -9.30
2016-11-29 61.41 60.52 61.09 -4.48
2016-11-30 61.18 60.22 60.26 -16.11
2016-12-01 60.15 58.94 59.20 -30.95
2016-12-02 59.47 58.80 59.25 -30.25
2016-12-05 60.58 59.56 60.22 -16.67
2016-12-06 60.46 59.80 59.95 -20.45
2016-12-07 61.38 59.80 61.37 -1.53
2016-12-08 61.58 60.84 61.01 -20.50
2016-12-09 61.99 61.12 61.97 -0.63
2016-12-12 62.30 61.72 62.17 -3.71
2016-12-13 63.42 62.24 62.98 -9.52
2016-12-14 63.45 62.53 62.68 -16.56
2016-12-15 63.15 62.30 62.58 -18.71
2016-12-16 62.95 62.12 62.30 -24.73
2016-12-19 63.77 62.42 63.62 -3.02
2016-12-20 63.80 63.03 63.54 -5.20
2016-12-21 63.70 63.12 63.54 -5.20
2016-12-22 64.10 63.40 63.55 -12.11
2016-12-23 63.54 62.80 63.24 -20.00
2016-12-27 64.07 63.21 63.28 -19.07
2016-12-28 63.40 62.83 62.99 -34.05
2016-12-29 63.20 62.73 62.90 -40.34
2016-12-30 62.99 62.03 62.14 -82.35
2017-01-03 62.84 62.12 62.58 -73.43
2017-01-04 62.75 62.12 62.30 -86.96
2017-01-05 62.66 62.03 62.30 -86.96
2017-01-06 63.15 62.04 62.84 -60.87
2017-01-09 63.08 62.54 62.64 -70.53
2017-01-10 63.07 62.28 62.62 -71.50
2017-01-11 63.23 62.43 63.19 -43.96
2017-01-12 63.40 61.95 62.61 -69.30
2017-01-13 62.87 62.35 62.70 -64.62
2017-01-17 62.70 62.03 62.53 -72.64
2017-01-18 62.70 62.12 62.50 -62.07
2017-01-19 62.98 62.19 62.30 -75.86
2017-01-20 62.82 62.37 62.74 -45.52
2017-01-23 63.12 62.57 62.96 -30.34
2017-01-24 63.74 62.94 63.52 -12.04
2017-01-25 64.10 63.45 63.68 -19.53
2017-01-26 64.54 63.55 64.27 -10.25
2017-01-27 65.91 64.89 65.78 -3.28
2017-01-30 65.79 64.80 65.13 -19.70
2017-01-31 65.15 64.26 64.65 -31.82
2017-02-01 64.62 63.47 63.58 -58.84
2017-02-02 63.41 62.75 63.17 -70.62
2017-02-03 63.70 63.07 63.68 -57.47
2017-02-06 63.65 63.14 63.64 -59.89
2017-02-07 63.78 63.23 63.43 -66.76
2017-02-08 63.81 63.22 63.34 -72.60