//结果集将只有20161010的数据,没有假期的夜盘数据。
setsysparam("cyclefilter", 1);
setsysparam(pn_cycle(), cy_15m());
return select * from markettable datekey 20161007T to 20161010.1600T of "ag1612" end;
范例2:分离集合竞价周期线-期货
//结果将会新增20161010T08:59:00的集合竞价数据
//(期货夜盘有两个集合竞价时点,正常夜盘是20:59:00,放假无夜盘是8:59:00)
setsysparam("cyclefilter", 3);
setsysparam(pn_cycle(), cy_15m());
return select * ,datetimetostr(["date"]) as "date"
from markettable datekey 20161007T to 20161010.1600T of "ag1612" end;
返回:
范例3:分离集合竞价周期线-股票
setsysparam("cyclefilter", 3);//分离集合竞价
setsysparam(pn_cycle(), cy_1m());
return select * ,datetimetostr(["date"]) as "date"
from markettable datekey 20161007T to 20161010.1600T of "SZ000001" end;