复制链接
克隆策略

    {"description":"实验创建于2017/8/26","graph":{"edges":[{"to_node_id":"-76:instruments","from_node_id":"-68:data"}],"nodes":[{"node_id":"-68","module_id":"BigQuantSpace.instruments.instruments-v2","parameters":[{"name":"start_date","value":"2021-01-01","type":"Literal","bound_global_parameter":null},{"name":"end_date","value":"2021-12-08","type":"Literal","bound_global_parameter":null},{"name":"market","value":"CN_STOCK_A","type":"Literal","bound_global_parameter":null},{"name":"instrument_list","value":"","type":"Literal","bound_global_parameter":null},{"name":"max_count","value":0,"type":"Literal","bound_global_parameter":null}],"input_ports":[{"name":"rolling_conf","node_id":"-68"}],"output_ports":[{"name":"data","node_id":"-68"}],"cacheable":true,"seq_num":1,"comment":"","comment_collapsed":true},{"node_id":"-76","module_id":"BigQuantSpace.advanced_auto_labeler.advanced_auto_labeler-v2","parameters":[{"name":"label_expr","value":"# #号开始的表示注释\n# 0. 每行一个,顺序执行,从第二个开始,可以使用label字段\n# 1. 可用数据字段见 https://bigquant.com/docs/develop/datasource/deprecated/history_data.html\n# 添加benchmark_前缀,可使用对应的benchmark数据\n# 2. 可用操作符和函数见 `表达式引擎 <https://bigquant.com/docs/develop/bigexpr/usage.html>`_\n\n# 计算收益:5日收盘价(作为卖出价格)除以明日开盘价(作为买入价格)\nshift(close, -5) / shift(open, -1)\n\n# 极值处理:用1%和99%分位的值做clip\nclip(label, all_quantile(label, 0.01), all_quantile(label, 0.99))\n\n# 将分数映射到分类,这里使用20个分类\nall_wbins(label, 20)\n\n# 过滤掉一字涨停的情况 (设置label为NaN,在后续处理和训练中会忽略NaN的label)\nwhere(shift(high, -1) == shift(low, -1), NaN, label)\n","type":"Literal","bound_global_parameter":null},{"name":"start_date","value":"","type":"Literal","bound_global_parameter":null},{"name":"end_date","value":"","type":"Literal","bound_global_parameter":null},{"name":"benchmark","value":"000300.SHA","type":"Literal","bound_global_parameter":null},{"name":"drop_na_label","value":"True","type":"Literal","bound_global_parameter":null},{"name":"cast_label_int","value":"True","type":"Literal","bound_global_parameter":null},{"name":"user_functions","value":"{}","type":"Literal","bound_global_parameter":null}],"input_ports":[{"name":"instruments","node_id":"-76"}],"output_ports":[{"name":"data","node_id":"-76"}],"cacheable":true,"seq_num":2,"comment":"","comment_collapsed":true}],"node_layout":"<node_postions><node_position Node='-68' Position='-85.5556755065918,-416.4991760253906,200,200'/><node_position Node='-76' Position='-14.85906982421875,-285.2054748535156,200,200'/></node_postions>"},"nodes_readonly":false,"studio_version":"v2"}
    In [1]:
    # 本代码由可视化策略环境自动生成 2021年12月10日 17:44
    # 本代码单元只能在可视化模式下编辑。您也可以拷贝代码,粘贴到新建的代码单元或者策略,然后修改。
    
    
    m1 = M.instruments.v2(
        start_date='2021-01-01',
        end_date='2021-12-08',
        market='CN_STOCK_A',
        instrument_list='',
        max_count=0
    )
    
    m2 = M.advanced_auto_labeler.v2(
        instruments=m1.data,
        label_expr="""# #号开始的表示注释
    # 0. 每行一个,顺序执行,从第二个开始,可以使用label字段
    # 1. 可用数据字段见 https://bigquant.com/docs/develop/datasource/deprecated/history_data.html
    #   添加benchmark_前缀,可使用对应的benchmark数据
    # 2. 可用操作符和函数见 `表达式引擎 <https://bigquant.com/docs/develop/bigexpr/usage.html>`_
    
    # 计算收益:5日收盘价(作为卖出价格)除以明日开盘价(作为买入价格)
    shift(close, -5) / shift(open, -1)
    
    # 极值处理:用1%和99%分位的值做clip
    clip(label, all_quantile(label, 0.01), all_quantile(label, 0.99))
    
    # 将分数映射到分类,这里使用20个分类
    all_wbins(label, 20)
    
    # 过滤掉一字涨停的情况 (设置label为NaN,在后续处理和训练中会忽略NaN的label)
    where(shift(high, -1) == shift(low, -1), NaN, label)
    """,
        start_date='',
        end_date='',
        benchmark='000300.SHA',
        drop_na_label=True,
        cast_label_int=True,
        user_functions={}
    )
    
    In [3]:
    m2.data.read()
    
    Out[3]:
    date m:open m:close m:low m:amount instrument m:high label
    0 2021-01-04 2121.030518 2065.506104 2047.738281 2.891682e+09 000001.SZA 2121.030518 13
    1 2021-01-04 4370.779297 4275.360840 4235.346680 4.079417e+09 000002.SZA 4370.779297 11
    2 2021-01-04 84.081306 85.422379 83.390450 5.726255e+07 000004.SZA 86.113235 1
    3 2021-01-04 23.447035 23.354359 23.261684 1.231635e+07 000005.SZA 23.447035 3
    4 2021-01-04 205.898087 201.517273 200.787140 4.502973e+07 000006.SZA 205.898087 4
    ... ... ... ... ... ... ... ... ...
    956482 2021-12-01 20.926224 20.878265 20.542549 5.755690e+05 871396.BJA 21.022142 6
    956483 2021-12-01 6.059739 6.113176 5.963552 1.624003e+06 871553.BJA 6.155925 3
    956484 2021-12-01 16.530001 16.820000 16.530001 3.564486e+06 871642.BJA 16.980000 5
    956485 2021-12-01 51.389999 50.000000 49.889999 3.647058e+07 871981.BJA 51.599998 4
    956486 2021-12-01 23.658594 23.628197 23.303968 3.213995e+06 872925.BJA 23.901766 4

    956487 rows × 8 columns