💎一站式轻松地调用各大LLM模型接口,支持GPT4、智谱、星火、月之暗面及文生图 广告
# 按照封单跟流通股本比例排序,剔除6月上市新股,前50 > 来源:https://uqer.io/community/share/559e5315f9f06c6dd1e17ed6 ```py import pandas as pd today = Date.todaysDate() cal = Calendar('China.SSE') yesterday = cal.advanceDate(today, '-1B', BizDayConvention.Following).strftime('%Y%m%d') allSecList = DataAPI.EquGet(equTypeCD = 'A', field = ['secID'])['secID'].tolist() precls = {} uplimit, dnlimit = [], [] for i in range(0, len(allSecList), 200): sub = allSecList[i:min(len(allSecList), i+200)] df_precls = DataAPI.MktEqudGet(secID = sub, beginDate = yesterday, endDate = yesterday, field = 'secID,closePrice') df_lasprx = DataAPI.MktTickRTSnapshotGet(securityID = sub, field = 'shortNM,lastPrice,bidBook,askBook') for j in range(len(df_precls)): precls[df_precls.at[j,'secID']] = df_precls.at[j,'closePrice'] for j in range(len(df_lasprx)): if df_lasprx.at[j,'lastPrice'] > 0: sec = df_lasprx.at[j,'ticker']+'.'+df_lasprx.at[j,'exchangeCD'] if df_lasprx.at[j,'bidBook_volume1'] == 0 and df_lasprx.at[j,'askBook_volume1'] > 0: bang = df_lasprx.at[j,'askBook_volume1'] * df_lasprx.at[j,'askBook_price1'] dnlimit.append([df_lasprx.at[j,'shortNM'], sec, precls[sec], df_lasprx.at[j,'lastPrice'],df_lasprx.at[j,'askBook_volume1'], bang/10000]) if df_lasprx.at[j,'askBook_volume1'] == 0 and df_lasprx.at[j,'bidBook_volume1'] > 0: bang = df_lasprx.at[j,'bidBook_volume1'] * df_lasprx.at[j,'bidBook_price1'] uplimit.append([df_lasprx.at[j,'shortNM'], sec, precls[sec], df_lasprx.at[j,'lastPrice'],df_lasprx.at[j,'bidBook_volume1'], bang/10000]) ``` ```py name, sec, precls, latprx, bangvol, bang = zip(*uplimit) df_uplimit = pd.DataFrame({'简称': name, '代码': sec, '前收': precls, '最新价': latprx,'封单量': bangvol, '封单金额(万)': bang}).sort(columns='封单金额(万)').reset_index() df_uplimit = df_uplimit.loc[:, ['简称', '代码','前收','最新价','封单量','封单金额(万)']] print '涨停股票数量:', len(uplimit) , '个, 收盘封单总金额:', df_uplimit.sum()['封单金额(万)']/10000 , '亿' df_uplimit 涨停股票数量: 1280 个, 收盘封单总金额: 644.57280353 亿 ``` | | 简称 | 代码 | 前收 | 最新价 | 封单量 | 封单金额(万) | | --- | --- | | 0 | 科达股份 | 600986.XSHG | 24.86 | 27.35 | 8095 | 22.139825 | | 1 | *ST夏利 | 000927.XSHE | 7.11 | 7.47 | 61912 | 46.248264 | | 2 | 宝诚股份 | 600892.XSHG | 35.60 | 39.16 | 14200 | 55.607200 | | 3 | *ST古汉 | 000590.XSHE | 17.97 | 18.87 | 35228 | 66.475236 | | 4 | 永艺股份 | 603600.XSHG | 96.55 | 106.21 | 7500 | 79.657500 | | 5 | 法拉电子 | 600563.XSHG | 27.52 | 30.27 | 27485 | 83.197095 | | 6 | 天润乳业 | 600419.XSHG | 37.46 | 41.21 | 30361 | 125.117681 | | 7 | 光大证券 | 601788.XSHG | 20.09 | 22.09 | 65049 | 143.758290 | | 8 | S佳通 | 600182.XSHG | 19.59 | 20.57 | 80503 | 165.594671 | | 9 | *ST华锦 | 000059.XSHE | 7.57 | 7.95 | 220596 | 175.373820 | | 10 | 鄂尔多斯 | 600295.XSHG | 8.40 | 9.24 | 248700 | 229.798800 | | 11 | 富煌钢构 | 002743.XSHE | 24.32 | 26.75 | 91387 | 244.460225 | | 12 | 良信电器 | 002706.XSHE | 52.81 | 58.09 | 47519 | 276.037871 | | 13 | 洋河股份 | 002304.XSHE | 64.26 | 70.69 | 41128 | 290.733832 | | 14 | *ST水井 | 600779.XSHG | 9.76 | 10.25 | 284700 | 291.817500 | | 15 | 滨海能源 | 000695.XSHE | 14.06 | 15.47 | 189000 | 292.383000 | | 16 | 中钢国际 | 000928.XSHE | 18.03 | 19.83 | 167224 | 331.605192 | | 17 | 金地集团 | 600383.XSHG | 12.64 | 13.90 | 273600 | 380.304000 | | 18 | 百花村 | 600721.XSHG | 10.21 | 11.23 | 361831 | 406.336213 | | 19 | XD吉林森 | 600189.XSHG | 9.85 | 10.73 | 392689 | 421.355297 | | 20 | 兖州煤业 | 600188.XSHG | 9.74 | 10.71 | 422093 | 452.061603 | | 21 | 时代万恒 | 600241.XSHG | 11.14 | 12.25 | 381174 | 466.938150 | | 22 | 银座股份 | 600858.XSHG | 9.19 | 10.11 | 480700 | 485.987700 | | 23 | 金山开发 | 600679.XSHG | 11.39 | 12.53 | 393526 | 493.088078 | | 24 | 远程电缆 | 002692.XSHE | 16.67 | 18.34 | 271064 | 497.131376 | | 25 | 苏 泊 尔 | 002032.XSHE | 21.88 | 24.07 | 206600 | 497.286200 | | 26 | 万向德农 | 600371.XSHG | 15.93 | 17.52 | 292926 | 513.206352 | | 27 | 洛阳玻璃 | 600876.XSHG | 10.60 | 11.66 | 448678 | 523.158548 | | 28 | 东方证券 | 600958.XSHG | 23.18 | 25.50 | 205700 | 524.535000 | | 29 | 东兴证券 | 601198.XSHG | 20.52 | 22.57 | 236032 | 532.724224 | | ... | ... | ... | ... | ... | ... | ... | | 1250 | 金龙汽车 | 600686.XSHG | 14.42 | 15.86 | 15154357 | 24034.810202 | | 1251 | 浩物股份 | 000757.XSHE | 7.43 | 8.17 | 30249462 | 24713.810454 | | 1252 | 湖北能源 | 000883.XSHE | 5.03 | 5.53 | 45428493 | 25121.956629 | | 1253 | 上海莱士 | 002252.XSHE | 70.82 | 77.90 | 3266870 | 25448.917300 | | 1254 | 保利地产 | 600048.XSHG | 9.38 | 10.32 | 24812739 | 25606.746648 | | 1255 | 贵州百灵 | 002424.XSHE | 46.51 | 51.16 | 5007138 | 25616.518008 | | 1256 | 掌趣科技 | 300315.XSHE | 9.70 | 10.67 | 25399058 | 27100.794886 | | 1257 | 万向钱潮 | 000559.XSHE | 11.65 | 12.82 | 21612652 | 27707.419864 | | 1258 | 东软集团 | 600718.XSHG | 12.09 | 13.30 | 21087016 | 28045.731280 | | 1259 | 时代新材 | 600458.XSHG | 16.97 | 18.67 | 15189697 | 28359.164299 | | 1260 | 东方财富 | 300059.XSHE | 45.99 | 50.59 | 5819640 | 29441.558760 | | 1261 | 紫光股份 | 000938.XSHE | 56.69 | 62.25 | 4756189 | 29607.276525 | | 1262 | 泛海控股 | 000046.XSHE | 11.00 | 12.10 | 24553068 | 29709.212280 | | 1263 | 隆平高科 | 000998.XSHE | 18.15 | 19.97 | 15137564 | 30229.715308 | | 1264 | 五 粮 液 | 000858.XSHE | 21.92 | 24.11 | 12672663 | 30553.790493 | | 1265 | 洛阳钼业 | 603993.XSHG | 10.21 | 11.23 | 28763738 | 32301.677774 | | 1266 | 川投能源 | 600674.XSHG | 8.91 | 9.80 | 34759105 | 34063.922900 | | 1267 | 大族激光 | 002008.XSHE | 20.09 | 22.10 | 16645752 | 36787.111920 | | 1268 | 机器人 | 300024.XSHE | 78.20 | 86.02 | 4285905 | 36867.354810 | | 1269 | 上海电气 | 601727.XSHG | 10.34 | 11.37 | 33204217 | 37753.194729 | | 1270 | 大唐电信 | 600198.XSHG | 19.88 | 21.87 | 17856149 | 39051.397863 | | 1271 | 招商证券 | 600999.XSHG | 22.07 | 24.28 | 17547853 | 42606.187084 | | 1272 | 新 大 陆 | 000997.XSHE | 17.52 | 19.27 | 22280471 | 42934.467617 | | 1273 | 同方股份 | 600100.XSHG | 11.48 | 12.63 | 37915652 | 47887.468476 | | 1274 | 中航动力 | 600893.XSHG | 28.34 | 31.17 | 17871582 | 55705.721094 | | 1275 | 国泰君安 | 601211.XSHG | 25.88 | 28.47 | 19942615 | 56776.624905 | | 1276 | 中国重工 | 601989.XSHG | 8.53 | 9.38 | 67338975 | 63163.958550 | | 1277 | 格力电器 | 000651.XSHE | 19.64 | 21.60 | 30817884 | 66566.629440 | | 1278 | 中国核电 | 601985.XSHG | 8.20 | 9.02 | 76664230 | 69151.135460 | | 1279 | 兴业银行 | 601166.XSHG | 15.53 | 17.08 | 45921158 | 78433.337864 | ``` 1280 rows × 6 columns ``` ```py nfList = DataAPI.EquGet(equTypeCD = 'A', field = ['secID','nonrestfloatA','listDate']) nf = {} nl = {} for j in range(len(nfList)): nf[nfList.at[j,'secID']] = nfList.at[j,'nonrestfloatA'] nl[nfList.at[j,'secID']] = nfList.at[j,'listDate'] ``` ```py name, sec, precls, latprx, bangvol, bang = zip(*uplimit) nflist = [] nllist = [] nfrate = [] for j in range(len(sec)): nflist.append(nf[sec[j]]) nllist.append(nl[sec[j]]) if nf[sec[j]] > 0: nfrate.append(bangvol[j]*1000/nf[sec[j]]) else: nfrate.append(0) print "按照封单跟流通股本比例排序,剔除6月上市新股,前50" df_uplimit1 = pd.DataFrame({'简称': name, '代码': sec, '前收': precls, '最新价': latprx,'封单量': bangvol, '封单金额(万)': bang, '总流通股本': tuple(nflist), '封单总股本比(‰)': tuple(nfrate),'listDate': tuple(nllist)}).sort(columns='封单总股本比(‰)',ascending=False).reset_index() df_uplimit1 = df_uplimit1.loc[:, ['简称', '代码','前收','最新价','封单量','封单金额(万)','总流通股本','封单总股本比(‰)','listDate']] df_uplimit1[df_uplimit1.listDate < '2015-06'][:50] 按照封单跟流通股本比例排序,剔除6月上市新股,前50 ``` | | 简称 | 代码 | 前收 | 最新价 | 封单量 | 封单金额(万) | 总流通股本 | 封单总股本比(‰) | listDate | | --- | --- | | 4 | 山河药辅 | 300452.XSHE | 46.62 | 51.28 | 1231062 | 6312.885936 | 11600000 | 106 | 2015-05-15 | | 5 | 浩物股份 | 000757.XSHE | 7.43 | 8.17 | 30249462 | 24713.810454 | 312802683 | 96 | 1997-06-27 | | 7 | 康斯特 | 300445.XSHE | 58.53 | 64.38 | 899439 | 5790.588282 | 10200000 | 88 | 2015-04-24 | | 14 | 三变科技 | 002112.XSHE | 9.63 | 10.59 | 13039855 | 13809.206445 | 180956458 | 72 | 2007-02-08 | | 17 | 石大胜华 | 603026.XSHG | 15.09 | 16.60 | 3422222 | 5680.888520 | 50680000 | 67 | 2015-05-29 | | 18 | 三毛派神 | 000779.XSHE | 9.93 | 10.92 | 12593170 | 13751.741640 | 186441020 | 67 | 1997-05-28 | | 22 | 威帝股份 | 603023.XSHG | 31.06 | 34.17 | 1292499 | 4416.469083 | 20000000 | 64 | 2015-05-27 | | 23 | 普丽盛 | 300442.XSHE | 40.09 | 44.10 | 1587575 | 7001.205750 | 25000000 | 63 | 2015-04-24 | | 27 | 立霸股份 | 603519.XSHG | 45.17 | 49.69 | 1217375 | 6049.136375 | 20000000 | 60 | 2015-03-19 | | 33 | 道氏技术 | 300409.XSHE | 39.34 | 43.27 | 1348689 | 5835.777303 | 24375000 | 55 | 2014-12-03 | | 35 | 金石东方 | 300434.XSHE | 35.04 | 38.54 | 913700 | 3521.399800 | 17000000 | 53 | 2015-04-24 | | 37 | 苏试试验 | 300416.XSHE | 45.27 | 49.80 | 831929 | 4143.006420 | 15700000 | 52 | 2015-01-22 | | 38 | 南华仪器 | 300417.XSHE | 48.16 | 52.98 | 531826 | 2817.614148 | 10200000 | 52 | 2015-01-23 | | 39 | 美尔雅 | 600107.XSHG | 7.82 | 8.60 | 18644466 | 16034.240760 | 360000000 | 51 | 1997-11-06 | | 40 | 海联讯 | 300277.XSHE | 15.25 | 16.78 | 2678747 | 4494.937466 | 52903291 | 50 | 2011-11-23 | | 41 | 华铁科技 | 603300.XSHG | 16.81 | 18.49 | 2535770 | 4688.638730 | 50670000 | 50 | 2015-05-29 | | 42 | 先导股份 | 300450.XSHE | 84.45 | 92.90 | 835200 | 7759.008000 | 17000000 | 49 | 2015-05-18 | | 45 | 亚星客车 | 600213.XSHG | 7.13 | 7.84 | 10399809 | 8153.450256 | 220000000 | 47 | 1999-08-31 | | 47 | 鲍斯股份 | 300441.XSHE | 31.55 | 34.71 | 972250 | 3374.679750 | 21120000 | 46 | 2015-04-23 | | 49 | 盛洋科技 | 603703.XSHG | 30.03 | 33.03 | 1037229 | 3425.967387 | 23000000 | 45 | 2015-04-23 | | 50 | 中光防雷 | 300414.XSHE | 50.46 | 55.51 | 910413 | 5053.702563 | 21070000 | 43 | 2015-05-13 | | 51 | 清水源 | 300437.XSHE | 47.30 | 52.03 | 727611 | 3785.760033 | 16700000 | 43 | 2015-04-23 | | 52 | 博通股份 | 600455.XSHG | 26.21 | 28.83 | 2131135 | 6144.062205 | 49717768 | 42 | 2004-03-29 | | 53 | 川仪股份 | 603100.XSHG | 13.04 | 14.34 | 4233692 | 6071.114328 | 100000000 | 42 | 2014-08-05 | | 54 | 永东股份 | 002753.XSHE | 26.64 | 29.30 | 1018901 | 2985.379930 | 24700000 | 41 | 2015-05-19 | | 55 | 华天酒店 | 000428.XSHE | 5.95 | 6.55 | 29409137 | 19262.984735 | 718762425 | 40 | 1996-08-08 | | 60 | 惠天热电 | 000692.XSHE | 5.23 | 5.75 | 20215598 | 11623.968850 | 532788880 | 37 | 1997-02-27 | | 61 | 全信股份 | 300447.XSHE | 50.22 | 55.24 | 767600 | 4240.222400 | 20250000 | 37 | 2015-04-22 | | 62 | 康跃科技 | 300391.XSHE | 14.69 | 16.16 | 1497500 | 2419.960000 | 41675000 | 35 | 2014-08-01 | | 63 | 莫高股份 | 600543.XSHG | 8.19 | 9.01 | 11235969 | 10123.608069 | 321120000 | 34 | 2004-03-24 | | 64 | 宝色股份 | 300402.XSHE | 12.61 | 13.87 | 1762286 | 2444.290682 | 51000000 | 34 | 2014-10-10 | | 65 | 金龙汽车 | 600686.XSHG | 14.42 | 15.86 | 15154357 | 24034.810202 | 442597097 | 34 | 1993-11-08 | | 66 | 大唐电信 | 600198.XSHG | 19.88 | 21.87 | 17856149 | 39051.397863 | 532989392 | 33 | 1998-10-21 | | 67 | 山东华鹏 | 603021.XSHG | 26.64 | 29.30 | 882565 | 2585.915450 | 26400000 | 33 | 2015-04-23 | | 68 | 高能环境 | 603588.XSHG | 42.31 | 46.54 | 1296851 | 6035.544554 | 40400000 | 32 | 2014-12-29 | | 69 | 三鑫医疗 | 300453.XSHE | 35.23 | 38.75 | 649389 | 2516.382375 | 19860000 | 32 | 2015-05-15 | | 70 | 中来股份 | 300393.XSHE | 40.45 | 44.50 | 759245 | 3378.640250 | 23490000 | 32 | 2014-09-12 | | 71 | 仙坛股份 | 002746.XSHE | 15.21 | 16.73 | 1310986 | 2193.279578 | 39850000 | 32 | 2015-02-16 | | 73 | 济民制药 | 603222.XSHG | 17.89 | 19.68 | 1302174 | 2562.678432 | 40000000 | 32 | 2015-02-17 | | 74 | 兰州黄河 | 000929.XSHE | 14.69 | 16.16 | 6088560 | 9839.112960 | 185588036 | 32 | 1999-06-23 | | 75 | 迅游科技 | 300467.XSHE | 176.12 | 193.73 | 328574 | 6365.464102 | 10000000 | 32 | 2015-05-27 | | 76 | 北京城乡 | 600861.XSHG | 10.22 | 11.24 | 10072835 | 11321.866540 | 316804949 | 31 | 1994-05-20 | | 77 | 中泰股份 | 300435.XSHE | 34.94 | 38.43 | 621982 | 2390.276826 | 20000000 | 31 | 2015-03-26 | | 78 | 轴研科技 | 002046.XSHE | 7.85 | 8.64 | 10496924 | 9069.342336 | 340565970 | 30 | 2005-05-26 | | 79 | 四通新材 | 300428.XSHE | 34.41 | 37.85 | 609600 | 2307.336000 | 20200000 | 30 | 2015-03-19 | | 80 | 田中精机 | 300461.XSHE | 29.96 | 32.96 | 510040 | 1681.091840 | 16680000 | 30 | 2015-05-19 | | 81 | 运达科技 | 300440.XSHE | 42.54 | 46.79 | 847050 | 3963.346950 | 28000000 | 30 | 2015-04-23 | | 83 | 迈克生物 | 300463.XSHE | 57.51 | 63.26 | 1140788 | 7216.624888 | 37500000 | 30 | 2015-05-28 | | 84 | 华通医药 | 002758.XSHE | 38.64 | 42.50 | 429400 | 1824.950000 | 14000000 | 30 | 2015-05-27 | | 86 | 鼎泰新材 | 002352.XSHE | 27.66 | 30.43 | 1520600 | 4627.185800 | 49194459 | 30 | 2010-02-05 |