• 公司
  • 300個
  • 一個
• 指標
  • 27個
  • 27日
• 時間
  • 日

300 個表格代表

tables = csmar.getListTables('股票市場交易')ReportUtil(tables)fields = csmar.getListFields('TRD_Dalyr')ReportUtil(fields)data = csmar.preview('600519') ReportUtil(data)fields = csmar.getListFields('Opnprc','Hiprc') ReportUtil(fields) tables = csmar.getListTables('股票市場交易')ReportUtil(tables)fields = csmar.getListFields('TRD_Dalyr')ReportUtil(fields)

季度數據1

tables = csmar.getListTables('財務指標分析')ReportUtil(tables)fields = csmar.getListFields('FI_T3')ReportUtil(fields)data = csmar.query(['Stkcd','Accper','Typrep','F030101A','F030201A'],"Stkcd = '600519'",'FI_T3','2018-01-01','2019-12-31') ReportUtil(data)

季度數據2

tables = csmar.getListTables('財務報表')ReportUtil(tables)fields = csmar.getListFields('FS_Combas')ReportUtil(fields)# data = csmar.query(['Stkcd','Accper','Typrep','A001100000','A001212000','A001000000','A002100000','A002206000','A002000000','F030101A','F030201A'],"Stkcd = '600519'",'FS_Combas','2018-01-01','2019-12-31') data = csmar.query(['Stkcd','Trddt','Opnprc'],"Stkcd = '600519'",'TRD_Dalyr','2018-01-01','2019-12-31')ReportUtil(data)

tables = csmar.getListTables(‘財務指標分析’)

ReportUtil(tables)

fields = csmar.getListFields(‘FI_T3’)

ReportUtil(fields)

data = csmar.query([‘Stkcd’,‘Accper’,‘Typrep’,‘F030101A’,‘F030201A’],“Stkcd = ‘600809’ OR Stkcd = ‘600519’”,‘FI_T3’,‘2019-01-01’,‘2019-12-31’)

ReportUtil(data)

嘗試用拼接來跨表查詢

···
from csmarapi.CsmarService import CsmarService
from csmarapi.ReportUtil import ReportUtil
csmar = CsmarService()
tables = csmar.getListTables(‘財務指標分析’)

ReportUtil(tables)

fields = csmar.getListFields(‘FI_T3’)

ReportUtil(fields)

data = csmar.query([‘Stkcd’, ‘Accper’, ‘Typrep’, ‘F030101A’, ‘F030201A’], “Stkcd = ‘600519’”, ‘FI_T3’, ‘2018-01-01’,
‘2019-12-31’)
data1 = csmar.query([‘Stkcd’, ‘Accper’, ‘Typrep’, ‘F030101A’, ‘F030201A’], “Stkcd = ‘600809’”, ‘FI_T3’, ‘2018-01-01’,
‘2019-12-31’)
ReportUtil(data)
print(len(data))

temp = []
for i in len(data):
temp = temp.append(dict(data[i].items()+data1.items()))
print(temp)
···

與50位技術專家面對面20年技術見證，附贈技術全景圖

總結

以上是生活随笔為你收集整理的hs300 quant的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。