
    fiUK                        d Z ddlZddlZddlmZ dej        fdZddedej        fdZ	e
d	k    r e            Z ee            e	d
          Z ee            e	d
          Z ee            e	d
          Z ee            e	d
          Z ee            e	d
          Z ee            e	d
          Z ee           dS dS )u2  
Date: 2024/2/1 16:20
Desc: 东方财富网-数据中心-新股数据-打新收益率
东方财富网-数据中心-新股申购-打新收益率
https://data.eastmoney.com/xg/xg/dxsyl.html
东方财富网-数据中心-新股数据-新股申购与中签查询
https://data.eastmoney.com/xg/xg/default_2.html
    N)get_tqdmreturnc                  r   d} dddddddd	d
d
dd}t          j        | |          }|                                }|d         d         }t          j                    }t                      } |t          d|dz             d          D ]{}|                    d|i           t          j        | |          }|                                }t          j        |d         d                   }t          j        ||gd          }||	                    d           |j
        dz   |d<   |                    i ddddddddd d!d"d#d$d%d&d'd(d)d*d+d,d-d.d/d0d1d2d3d4d5d6d7d8d9d:           |g d;         }t          j        |d         d<=          |d<   t          j        |d!         d<=          |d!<   t          j        |d#         d<=          |d#<   t          j        |d%         d<=          |d%<   t          j        |d'         d<=          |d'<   t          j        |d)         d<=          |d)<   t          j        |d+         d<=          |d+<   t          j        |d-         d<=          |d-<   t          j        |d/         d<=          |d/<   t          j        |d1         d<=          |d1<   t          j        |d3         d<=          |d3<   t          j        |d5         d<=          |d5<   t          j        |d7         d<=          |d7<   t          j        |d9         d<=          j        j        |d9<   |S )>u   
    东方财富网-数据中心-新股申购-打新收益率
    https://data.eastmoney.com/xg/xg/dxsyl.html
    :return: 打新收益率数据
    :rtype: pandas.DataFrame
    z4https://datacenter-web.eastmoney.com/api/data/v1/getzLISTING_DATE,SECURITY_CODE-1,-150001RPTA_APP_IPOAPPLYz(f2~01~SECURITY_CODE,f14~01~SECURITY_CODE0ALLWEBz((APPLY_DATE>'2010-01-01')(|@APPLY_DATE="NULL"))((LISTING_DATE>'2010-01-01')(|@LISTING_DATE="NULL"))(TRADE_MARKET_CODE!="069001017"))sortColumns	sortTypespageSize
pageNumber
reportNamequoteColumns	quoteTypecolumnssourceclientfilterparamsresultpages   Fleaver   dataTignore_index)inplaceindex   序号SECURITY_CODE   股票代码f14   股票简称ISSUE_PRICE	   发行价LATELY_PRICE	   最新价ONLINE_ISSUE_LWR   网上-发行中签率ONLINE_VA_SHARES   网上-有效申购股数ONLINE_VA_NUM   网上-有效申购户数ONLINE_ES_MULTIPLE   网上-超额认购倍数OFFLINE_VAP_RATIO   网下-配售中签率OFFLINE_VATS   网下-有效申购股数OFFLINE_VAP_OBJECT   网下-有效申购户数OFFLINE_VAS_MULTIPLE   网下-配售认购倍数	ISSUE_NUM   总发行数量LD_OPEN_PREMIUM   开盘溢价LD_CLOSE_CHANGE   首日涨幅LISTING_DATE   上市日期r   r"   )r$   r&   r(   r*   r,   r.   r0   r2   r4   r6   r8   r:   r<   r>   r@   rB   rD   coerceerrors)requestsgetjsonpd	DataFramer   rangeupdateconcatreset_indexr#   rename
to_numericto_datetimedtdate)	urlr   r	data_json
total_pagebig_dftqdmpagetemp_dfs	            O/usr/local/lib/python3.11/dist-packages/akshare/stock_feature/stock_dxsyl_em.pystock_dxsyl_emr`      s^    AC3)B ] F 	S(((AI8$W-J\^^F::DU1j1n--U;;; A A|T*+++LV,,,FFHH	,y26:;;FG,4@@@
t$$$lQ&F7O
MM
X
^
 >
 ;	

 K
  8
  ;
 8
 !"=
  !9
 7
 !"=
 #$?
 *
 ~
  ~!
" N#
& )    , 	
 	
 	
F* -{(;HMMMF;-{(;HMMMF;')}'(( ( (F#$ +--*+H+ + +F&' +--*+H+ + +F&' +--*+H+ + +F&' (*}'(( ( (F#$ +--*+H+ + +F&' +--*+H+ + +F&' +--*+H+ + +F&' !#f5F.GPX Y Y YF]6.+A(SSSF>]6.+A(SSSF>^F>,B8TTTW\F>M       全部股票symbolc                    dddddd}d}| dk    rd	d
dddddddd	}t          j        ||          }|                                }|d         d         }t          j                    }t                      } |t          ddt          |          z             d          D ]{}	|                    d|	i           t          j        ||          }|                                }t          j        |d         d                   }
t          j	        ||
gd          }||
                    i dddd d!d"d#d$d%d&d'd(d)d*d+d,d-d.d	d/d0d1d2d3d4d5d6d7d8d9d:d;d<d=i d>dd?d@dAdBdCdDdEddFdGdHdIdJdKdLdMdNddOdPdQdRdSdTdUdVdWdXdYdZd[d\d]d^dd_d`           |dD         |dB         z  |da<   |g db         }t          j        |d(         dcd          |d(<   t          j        |d5         dcd          |d5<   t          j        |d9         dcd          |d9<   t          j        |d7         dcd          |d7<   t          j        |d,         dcd          |d,<   t          j        |d@         dcd          |d@<   t          j        |dT         dcd          |dT<   t          j        |dB         dcd          |dB<   t          j        |da         dcd          |da<   t          j        |d\         dcd          |d\<   t          j        |dI         dcd          |dI<   t          j        |dG         dcd          |dG<   t          j        |dX         dcd          |dX<   t          j        |d.         dcd          |d.<   t          j        |dR         dcd          |dR<   t          j        |d^         dcd          |d^<   t          j        |d]         dcd          |d]<   t          j        |d/         dcd          j        j        |d/<   t          j        |d3         dcd          j        j        |d3<   |S dedfdgddhdi||          dddj	}t          j        ||          }|                                }|d         d         }t          j                    }t                      } |t          d|dz             d          D ]{}	|                    d|	i           t          j        ||          }|                                }t          j        |d         d                   }
t          j	        ||
gdk          }||
                    i ddldmdndodd%d&dpdqdrdsdtddud(d4dvdwdxdydzd{dxd|d}d~dxd+d,dddCdDi d	ddddddddd.d?d@dEdddRddddddddddxd>dxddxddxdHdxdxdxdxdxdxdxdxdxdxdxdxdxdxdxdd`           |g d         }t          j        |d         dcd          j        j        |d<   t          j        |d                   j        j        |d<   t          j        |d                   j        j        |d<   t          j        |d(         dcd          |d(<   t          j        |dv         dcd          |dv<   t          j        |dz         dcd          |dz<   t          j        |d}         dcd          |d}<   t          j        |d,         dcd          |d,<   t          j        |d         dcd          |d<   t          j        |dD         dcd          |dD<   t          j        |d.         dcd          |d.<   t          j        |dR         dcd          |dR<   t          j        |d@         dcd          |d@<   t          j        |d         dcd          |d<   t          j        |d         dcd          |d<   t          j        |d         dcd          |d<   t          j        |d         dcd          |d<   |S )u*  
    新股申购与中签查询
    https://data.eastmoney.com/xg/xg/default_2.html
    :param symbol: choice of {"全部股票", "沪市主板", "科创板", "深市主板", "创业板", "北交所"}
    :type symbol: str
    :return: 新股申购与中签数据
    :rtype: pandas.DataFrame
    z(APPLY_DATE>'2010-01-01')z(APPLY_DATE>'2010-01-01')(SECURITY_TYPE_CODE in ("058001001","058001008"))(TRADE_MARKET_CODE in ("069001001001","069001001003","069001001006"))zl(APPLY_DATE>'2010-01-01')(SECURITY_TYPE_CODE in ("058001001","058001008"))(TRADE_MARKET_CODE="069001001006")z(APPLY_DATE>'2010-01-01')(SECURITY_TYPE_CODE="058001001")(TRADE_MARKET_CODE in ("069001002001","069001002002","069001002003","069001002005"))z[(APPLY_DATE>'2010-01-01')(SECURITY_TYPE_CODE="058001001")(TRADE_MARKET_CODE="069001002002"))rb      沪市主板	   科创板   深市主板	   创业板z3http://datacenter-web.eastmoney.com/api/data/v1/get	   北交所
APPLY_DATEz-1500r   r   RPT_NEEQ_ISSUEINFO_LISTz'f14~01~SECURITY_CODE~SECURITY_NAME_ABBR
NEEQSELECTr   )	r   r   r   r   r   r   r   r   r   r   r   r   r   Fr   r   r   Tr    ORG_CODE-r%      代码SECUCODEu   带市场标识股票代码SECURITY_NAME_ABBR   简称
APPLY_CODE   申购代码EXPECT_ISSUE_NUM   发行总数	PRICE_WAYu   定价方式r)      发行价格ISSUE_PE_RATIO   发行市盈率	   申购日RESULT_NOTICE_DATEu   发行结果公告日期SELECT_LISTING_DATE   上市首日-上市日ONLINE_ISSUE_NUM   网上-发行数量APPLY_AMT_UPPER   网上-顶格所需资金APPLY_NUM_UPPER   网上-申购上限ONLINE_PAY_DATEu   网上申购缴款日期ONLINE_REFUND_DATEu   网上申购资金退款日	INFO_CODEr-   	   中签率NEWEST_PRICE   最新价格-价格CLOSE_PRICE   首日收盘价INITIAL_MULTIPLEPER_SHARES_INCOME   上市首日-每百股获利rA      上市首日-涨幅TURNOVERRATEu   首日换手率	AMPLITUDEu   首日振幅ONLINE_APPLY_LOWERMAIN_BUSINESSu   主营业务INDUSTRY_PE_RATIO   行业市盈率APPLY_AMT_100   稳获百股需配资金TAKE_UP_TIMEu   资金占用时间CAPTURE_PROFIT   上市首日-约合年化收益APPLY_SHARE_100u   每获配百股需配股数AVERAGE_PRICE   上市首日-均价   参与申购人数   参与申购资金)ORG_VANVA_AMTISSUE_PRICE_ADJFACTORrE      最新价格-累计涨幅)rp   rs   ru   rw   r   r   r   ry   r|   r   r   r   r   r   r   r   r   r   r{   r   r   r   rF   rG   zAPPLY_DATE,SECURITY_CODEr   r   r	   a  SECURITY_CODE,SECURITY_NAME,TRADE_MARKET_CODE,APPLY_CODE,TRADE_MARKET,MARKET_TYPE,ORG_TYPE,ISSUE_NUM,ONLINE_ISSUE_NUM,OFFLINE_PLACING_NUM,TOP_APPLY_MARKETCAP,PREDICT_ONFUND_UPPER,ONLINE_APPLY_UPPER,PREDICT_ONAPPLY_UPPER,ISSUE_PRICE,LATELY_PRICE,CLOSE_PRICE,APPLY_DATE,BALLOT_NUM_DATE,BALLOT_PAY_DATE,LISTING_DATE,AFTER_ISSUE_PE,ONLINE_ISSUE_LWR,INITIAL_MULTIPLE,INDUSTRY_PE_NEW,OFFLINE_EP_OBJECT,CONTINUOUS_1WORD_NUM,TOTAL_CHANGE,PROFIT,LIMIT_UP_PRICE,INFO_CODE,OPEN_PRICE,LD_OPEN_PREMIUM,LD_CLOSE_CHANGE,TURNOVERRATE,LD_HIGH_CHANG,LD_AVERAGE_PRICE,OPEN_DATE,OPEN_AVERAGE_PRICE,PREDICT_PE,PREDICT_ISSUE_PRICE2,PREDICT_ISSUE_PRICE,PREDICT_ISSUE_PRICE1,PREDICT_ISSUE_PE,PREDICT_PE_THREE,ONLINE_APPLY_PRICE,MAIN_BUSINESS)	r   r   r   r   r   r   r   r   r   )objsr!   r&   SECURITY_NAMEr(   TRADE_MARKET_CODETRADE_MARKET	   交易所MARKET_TYPE   板块ORG_TYPEr=      网上发行OFFLINE_PLACING_NUM_TOP_APPLY_MARKETCAP   顶格申购需配市值PREDICT_ONFUND_UPPERONLINE_APPLY_UPPER   申购上限PREDICT_ONAPPLY_UPPERr+   r,      申购日期BALLOT_NUM_DATE   中签号公布日BALLOT_PAY_DATE   中签缴款日期rC   rD   AFTER_ISSUE_PE   询价累计报价倍数INDUSTRY_PE_NEWOFFLINE_EP_OBJECT   配售对象报价家数CONTINUOUS_1WORD_NUM   连续一字板数量TOTAL_CHANGE   涨幅PROFIT   每中一签获利LIMIT_UP_PRICE
OPEN_PRICEr?   )r   LD_HIGH_CHANGLD_AVERAGE_PRICE	OPEN_DATEOPEN_AVERAGE_PRICE
PREDICT_PEPREDICT_ISSUE_PRICE2PREDICT_ISSUE_PRICEPREDICT_ISSUE_PRICE1PREDICT_ISSUE_PEPREDICT_PE_THREEONLINE_APPLY_PRICEr   IS_REGISTRATION)r&   r(   ru   r   r   rw   r   r   r   ry   r,   r   r   r   r   rD   r{   r   r   r   r   r   r   r   )rI   rJ   rK   rL   rM   r   rN   intrO   rP   rR   rS   rT   rU   rV   )rc   
market_maprW   r   rX   rY   rZ   r[   r\   r]   r^   s              r_   stock_xgsglb_emr      s    8 n H lv J @C'3E"

 

 LV,,,FFHH	x(1
zzDq!c*oo"566eDDD 	E 	EDMM<.///S000AIl9X#6v#>??GY0tDDDFF&C&& 9& %h	&
 n& #N& ^& ~& !"3& k& %&@& &'?& #$9& "#>& "#8&  "#=!&" %&C#& &$ S%&& #K'&(  5)&* 0+&, #C-&. $%C/&0 "#81&2  13&4 ^5&6 %c7&8  9&: $%6;&<  !;=&>  4?&@ !"CA&B "#@C&D  !6E& &F 0.),K& & &N Q 	 )	
 )	
 )	
T /55F.G&QfJg.g*+  
4 "$vn/Eh!W!W!W~(*()()
 )
 )
$% )+()()
 )
 )
$% /1m.//
 /
 /
*+ "$vn/Eh!W!W!W~ mF;,?QQQ{-/]-.x.
 .
 .
)* )+()()
 )
 )
$% /1m.//
 /
 /
*+ )+()()
 )
 )
$% )+()()
 )
 )
$% 241282
 2
 2
-. 57M45h5
 5
 5
01 %'M&9J2KT\$]$]$] !$&M&9J2KT\$]$]$] !')}V<P5QZb'c'c'c#$')}V<P5QZb'c'c'c#$ nVK-@RRRUZ{+->+,X,
 ,
 ,

T 	'(  6 - g (

 

 LV,,,FFHH	x(1
zzDq*q.11??? 	J 	JDMM<.///S000AIl9X#6v#>??GYVW$5DIIIFF111 $S1 n	1
 1 x1 C1 ^1 #N1 &s1 &'A1 '1 %n1 (1 ~1  !1" 0#1 1$ n%1& "#7'1( "#7)1* +1, !"3-1. #K/10 #$>112 "#4314 $%?516 '(?718 91: .;1< !#=1> S?1@ cA1B "3C1D "3E1 1F !$!$$' &)!(+'*(+$'$'&)!$#&a1 1 1d g 	 4	
 4	
 4	
j   
: "$~0Fx!X!X!X![!`~')~f=Q6R'S'S'V'[#$')~f=Q6R'S'S'V'[#$!#vn/Eh!W!W!W~!#vn/Eh!W!W!W~-/]-.x.
 .
 .
)* "$vn/Eh!W!W!W~!#vn/Eh!W!W!W~ mF;,?QQQ{$&M&9J2KT\$]$]$] !$&M&9J2KT\$]$]$] !$&M&9J2KT\$]$]$] ! mF;,?QQQ{-/]-.x.
 .
 .
)* .0]-.x.
 .
 .
)* =)9(KKKx')}V<P5QZb'c'c'c#$Mra   __main__)rc   re   rf   rg   rh   ri   )rb   )__doc__pandasrL   rI   akshare.utils.tqdmr   rM   r`   strr   __name__stock_dxsyl_em_dfprintstock_xgsglb_em_df ra   r_   <module>r      s         ' ' ' ' ' 'k k k k k\Y YC YR\ Y Y Y Yx z&((	E
(???	E
(???	E
(<<<	E
(???	E
(<<<	E
(<<<	E
) ra   