请问这个资金流水数据用VB脚本如何抓取数据?
repJsonUrl="http://push2his.eastmoney.com/api/qt/stock/fflow/daykline/get?lmt=0&klt=101&secid=0.000802" &
"&fields1=f1,f2,f3,f7&fields2=f51,f52,f53,f54,f55,f56,f57,f58,f59,f60,f61,f62,f63,f64,f65&ut=b2884a393a59ad64002292a3e90d46a5&cb=jQuery183006116367860942051_1588986389914&_=1588986390300",
Source = Json.Document("["&Text.BetweenDelimiters(Text.FromBinary(Web.Contents(repJsonUrl)),"(",")")&"]"),
Result = Table.FromRows(List.Transform(Source{0}[data][klines],each Text.Split(_,",")))
in
|