//获取20260610陆股通(北向)融资融券余额行业占比
endt:=20260610T;
//指定日沪股通与深股通的股票
stocks:=sselect thisrow
from GetBksByDate(array("HG000002","HG000004"),endt)
where StockType(thisrow)<3 end;
setsysparam(pn_date(),endt);
t:=select thisrow as "StockID",
spec(StockSWIndustryName1(),thisrow) as "行业",
spec(StockMarginTradingBalance(),thisrow) as "融资融券余额"
from stocks end;
sumv:=sum(t[:,"融资融券余额"]);
rt:=select ["行业"] ,
hys:=sumof(["融资融券余额"]) as "行业两融余额",
FloatN(hys/sumv*100,2) as "两融余额行业占比(%)"
from t group by ["行业"] end;
SortTableByField(rt,"两融余额行业占比(%)",0);
return rt;