strategy

Technical Analysis using atr, lwma

Predicting stocks using technical indicators (atr, lwma)

You can clone and edit this example there (tab Examples).


This template shows you the basic steps for taking part to the NASDAQ-100 Stock Long-Short contest.

In [1]:
import xarray as xr

import qnt.ta as qnta
import qnt.data as qndata
import qnt.output as qnout
import qnt.stats as qns
import xarray as xr

import qnt.ta as qnta
import qnt.backtester as qnbt
import qnt.data as qndata


def strategy2(data, wma, limit):
    vol = data.sel(field="vol")
    liq = data.sel(field="is_liquid")
    close = data.sel(field="close")
    high = data.sel(field="high")
    low = data.sel(field="low")

    atr = qnta.atr(high=high, low=low, close=close, ma=14)
    ratio = atr / close
    weights = xr.where(ratio > limit, 0, 1)

    money_vol = vol * liq * close
    total_money_vol = money_vol.sum(dim='asset')
    money_vol_share = money_vol / total_money_vol

    return qnta.lwma(money_vol_share, wma) * weights


data = qndata.stocks.load_ndx_data(min_date="2005-01-01")
weights_1 = strategy2(data, wma=135, limit=0.0205)
100% (367973 of 367973) |################| Elapsed Time: 0:00:00 Time:  0:00:00
100% (39443 of 39443) |##################| Elapsed Time: 0:00:00 Time:  0:00:00
100% (14717216 of 14717216) |############| Elapsed Time: 0:00:00 Time:  0:00:00
fetched chunk 1/6 1s
100% (14720244 of 14720244) |############| Elapsed Time: 0:00:00 Time:  0:00:00
fetched chunk 2/6 2s
100% (14717184 of 14717184) |############| Elapsed Time: 0:00:00 Time:  0:00:00
fetched chunk 3/6 3s
100% (14717100 of 14717100) |############| Elapsed Time: 0:00:00 Time:  0:00:00
fetched chunk 4/6 4s
100% (14717100 of 14717100) |############| Elapsed Time: 0:00:00 Time:  0:00:00
fetched chunk 5/6 6s
100% (13667388 of 13667388) |############| Elapsed Time: 0:00:00 Time:  0:00:00
fetched chunk 6/6 7s
Data loaded 7s
In [2]:
def get_enough_bid_for(weights_):
    time_traded = weights_.time[abs(weights_).fillna(0).sum('asset') > 0]
    is_strategy_traded = len(time_traded)
    if is_strategy_traded:
        return xr.where(weights_.time < time_traded.min(), data.sel(field="is_liquid"), weights_)
    return weights_

weights_new = get_enough_bid_for(weights_1)
weights_new = weights_new.sel(time=slice("2006-01-01", None))

weights = qnout.clean(output=weights_new, data=data, kind="stocks_nasdaq100")
Output cleaning...
fix uniq
ffill if the current price is None...
Check liquidity...
WARNING! Strategy trades non-liquid assets.
Fix liquidity...
Ok.
Check missed dates...
Ok.
Normalization...
Output cleaning is complete.
In [3]:
def print_statistic(data, weights_all):
    import qnt.stats as qnstats

    stats = qnstats.calc_stat(data, weights_all)
    display(stats.to_pandas().tail(5))
    # graph
    performance = stats.to_pandas()["equity"]
    import qnt.graph as qngraph

    qngraph.make_plot_filled(performance.index, performance, name="PnL (Equity)", type="log")

print_statistic(data, weights)
field equity relative_return volatility underwater max_drawdown sharpe_ratio mean_return bias instruments avg_turnover avg_holding_time
time
2024-04-18 2.505899 -0.001599 0.049208 -0.014134 -0.102797 1.047715 0.051556 1.0 183.0 0.026700 22.273710
2024-04-19 2.502194 -0.001479 0.049205 -0.015592 -0.102797 1.045832 0.051460 1.0 183.0 0.026714 22.275284
2024-04-22 2.505274 0.001231 0.049200 -0.014380 -0.102797 1.047138 0.051519 1.0 183.0 0.026718 22.258929
2024-04-23 2.508717 0.001374 0.049195 -0.013025 -0.102797 1.048608 0.051587 1.0 183.0 0.026713 22.258652
2024-04-24 2.512924 0.001677 0.049191 -0.011370 -0.102797 1.050421 0.051671 1.0 183.0 0.026718 22.417670
In [4]:
qnout.check(weights, data, "stocks_nasdaq100")
qnout.write(weights)  # to participate in the competition
Check liquidity...
Ok.
Check missed dates...
Ok.
Check the sharpe ratio...
Period: 2006-01-01 - 2024-04-24
Sharpe Ratio = 1.050421152820803
Ok.
Check correlation.
WARNING! Can't calculate correlation.
Correlation check failed.
Write output: /root/fractions.nc.gz
In [5]:
weights
Out[5]:
<xarray.DataArray (time: 4609, asset: 249)>
array([[0.        , 0.        , 0.        , ..., 0.        , 0.        ,
        0.        ],
       [0.        , 0.        , 0.        , ..., 0.        , 0.        ,
        0.        ],
       [0.        , 0.        , 0.        , ..., 0.        , 0.        ,
        0.        ],
       ...,
       [0.        , 0.06403569, 0.        , ..., 0.        , 0.        ,
        0.        ],
       [0.        , 0.06389316, 0.        , ..., 0.        , 0.        ,
        0.        ],
       [0.        , 0.06359773, 0.        , ..., 0.        , 0.        ,
        0.        ]])
Coordinates:
  * time     (time) datetime64[ns] 2006-01-03 2006-01-04 ... 2024-04-24
  * asset    (asset) <U10 'NAS:AAL' 'NAS:AAPL' ... 'NYS:RHT' 'NYS:TEVA'
In [6]:
data
Out[6]:
<xarray.DataArray 'stocks_nasdaq100' (field: 9, time: 4861, asset: 249)>
array([[[     nan,   1.1568,      nan, ...,  12.08  ,  13.41  ,
          29.81  ],
        [     nan,   1.1393,      nan, ...,  12.49  ,  13.05  ,
          29.2   ],
        [     nan,   1.1511,      nan, ...,  12.11  ,  12.6   ,
          27.97  ],
        ...,
        [ 14.28  , 165.515 , 156.19  , ...,  40.98  ,      nan,
          12.94  ],
        [ 13.962 , 165.35  , 157.24  , ...,  41.28  ,      nan,
          12.94  ],
        [ 14.22  , 166.54  , 164.475 , ...,  41.72  ,      nan,
          12.98  ]],

       [[     nan,   1.1179,      nan, ...,  11.9   ,  13.03  ,
          29.06  ],
        [     nan,   1.1245,      nan, ...,  11.97  ,  12.54  ,
          28.02  ],
        [     nan,   1.1438,      nan, ...,  11.97  ,  12.25  ,
          27.31  ],
...
        [  1.    ,   1.    ,   1.    , ...,   1.    ,      nan,
           1.    ],
        [  1.    ,   1.    ,   1.    , ...,   1.    ,      nan,
           1.    ],
        [  1.    ,   1.    ,   1.    , ...,   1.    ,      nan,
           1.    ]],

       [[     nan,   1.    ,      nan, ...,   0.    ,   0.    ,
           1.    ],
        [     nan,   1.    ,      nan, ...,   0.    ,   0.    ,
           1.    ],
        [     nan,   1.    ,      nan, ...,   0.    ,   0.    ,
           1.    ],
        ...,
        [  0.    ,   1.    ,   1.    , ...,   0.    ,      nan,
           0.    ],
        [  0.    ,   1.    ,   1.    , ...,   0.    ,      nan,
           0.    ],
        [  0.    ,   1.    ,   1.    , ...,   0.    ,      nan,
           0.    ]]])
Coordinates:
  * time     (time) datetime64[ns] 2005-01-03 2005-01-04 ... 2024-04-24
  * asset    (asset) <U10 'NAS:AAL' 'NAS:AAPL' ... 'NYS:RHT' 'NYS:TEVA'
  * field    (field) object 'open' 'low' 'high' ... 'split_cumprod' 'is_liquid'