
    fi1                     ^   d Z ddlmZ ddl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dej	        fd	Zddedej	        fdZedk    rZ e
            Z ee            ed          Z ee            e            Z ee            ed
          Z ee           dS dS )ui   
Date: 2025/5/16 19:00
Desc: 债券-集思录-可转债
集思录：https://www.jisilu.cn/data/cbnew/#cb
    )StringION)demjsonreturnc                      d} t          j        |           }t          j        |j                  d         }t          j        |          }|S )u   
    首页-可转债-集思录可转债等权指数
    https://www.jisilu.cn/web/data/cb/index
    :return: 集思录可转债等权指数
    :rtype: pandas.DataFrame
    z.https://www.jisilu.cn/webapi/cb/index_history/data)requestsgetr   decodetextpd	DataFrame)urlr	data_dicttemp_dfs       D/usr/local/lib/python3.11/dist-packages/akshare/bond/bond_convert.pybond_cb_index_jslr      sB     ;CSAqv&&v.Il9%%GN    cookiec           
         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dddddddd d!}d"d#t          t          j                    d$z             i}i d%d&d'd&d(d&d)d&d*d&d+d&d,d&d-d&d.d&d/d0d1d2d1d3d1d4d1d5d6d&d7d8d9d0d&d&d:d;}t          j        ||||<          }|                                }t          j        d= |d>         D                       }|                    i d?d@dAdBdCdDdEdFdGdHdIdJdKdLdMdNdOdPdQdRdSdTd+dUdVdWd.dXdYdZd[d\d]d^d_d`dadbdcdddedfg           |g dh         }t          j        |d_         dij          j	        j
        |d_<   t          j        |dD         dij          |dD<   t          j        |dF         dij          |dF<   t          j        |dL         dij          |dL<   t          j        |dN         dij          |dN<   t          j        |dP         dij          |dP<   t          j        |dR         dij          |dR<   t          j        |dT         dij          |dT<   t          j        |dU         dij          |dU<   t          j        |dZ         dij          |dZ<   t          j        |d\         dij          |d\<   t          j        |d^         dij          |d^<   t          j        |d`         dij          |d`<   t          j        |da         dij          |da<   t          j        |db         dij          |db<   t          j        |dc         dij          |dc<   t          j        |dd         dij          |dd<   |S )ku   
    集思录可转债
    https://www.jisilu.cn/data/cbnew/#cb
    :param cookie: 输入获取到的游览器 cookie
    :type cookie: str
    :return: 集思录可转债
    :rtype: pandas.DataFrame
    z-https://www.jisilu.cn/data/cbnew/cb_list_new/accept.application/json, text/javascript, */*; q=0.01zaccept-encodinggzip, deflate, brzaccept-languagezh-CN,zh;q=0.9,en;q=0.8zcache-controlno-cachezcontent-length220zcontent-type0application/x-www-form-urlencoded; charset=UTF-8r   originhttps://www.jisilu.cnpragmareferer!https://www.jisilu.cn/data/cbnew/	sec-ch-uaz@" Not;A Brand";v="99", "Google Chrome";v="91", "Chromium";v="91"sec-ch-ua-mobile?0zsec-fetch-destemptyzsec-fetch-modecorszsec-fetch-sitesame-originz
user-agentzsMozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.164 Safari/537.36zx-requested-withXMLHttpRequest___jslzLST___t=i  fprice tpricecurr_iss_amtvolumesvolume
premium_rtytm_rtmarket	rating_cd	is_searchNzmarket_cd[]shmbshkcszmbszcybtypelistedYqflag50)sw_cdbond_idsrpparamsjsonheadersc                     g | ]
}|d          S cell .0items     r   
<listcomp>zbond_cb_jsl.<locals>.<listcomp>X       GGGTDLGGGr   rowsbond_id   代码bond_nm   转债名称price   现价increase_rt	   涨跌幅stock_id   正股代码stock_nm   正股名称sprice	   正股价sincrease_rt   正股涨跌pb   正股PBconvert_price	   转股价convert_value   转股价值   转股溢价率dblow   双低   债券评级put_convert_price   回售触发价force_redeem_price   强赎触发价convert_amt_ratio   转债占比   到期时间   剩余年限   剩余规模	   成交额	   换手率   到期税前收益)maturity_dt	year_leftr.   r/   turnover_rtr2   Tcolumnsinplace)rR   rT   rV   rX   rZ   r\   r^   r`   rb   rd   rf   rg   rj   rl   rn   rp   rq   rr   rs   rt   ru   rv   ri   coerceerrors)inttimer   postrE   r   r   renameto_datetimedtdate
to_numeric)r   r   rF   rD   payloadr   	data_jsonr   s           r   bond_cb_jslr      s    :CB. 	4 		
 	% 	J 	& 	) 	* 	6 	W 	D 	' 	& 	-  	 -!$ 	,%G* 	6St!34466F"" 	 	"	
 	2 	b 	" 	" 	R 	S 	v 	v 	v 	v 	  	#!" 	#$ )  G, 	c&wHHHAIlGGYv5FGGGHHGNN
x
~
 X
 ;	

 
 
 k
 N
 *
 [
 ^
 +
 X
 
  !2
  !"3!
"  #
$ *'*!&*/
 
 
2 5    : 	
 	
 	
G6 !nW^-DXVVVY^GNgh&7IIIGH=)=hOOOGK=)=hOOOGK mGN,CHUUUGN-
(;HMMMGJ=)=hOOOGK mGN,CHUUUGN!#w7H/IRZ![![![G!#w7H/IRZ![![![G!#w7H/IRZ![![![G mGN,CHUUUGN mGN,CHUUUGN mGN,CHUUUGN=)=hOOOGK=)=hOOOGK$&M':N2OX`$a$a$aG !Nr   c                     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dddddddd d!d"d#d$d%}d&d'i}d(d)i}t          j        | |||*          }|                                }t          j        d+ |d,         D                       }|                    i d-d.d/d0d1d2d3d4d5d6d7d8d9d8d:d;d<d=d>d?d@dAdBd8dCd8dDd8dEd8dFd8dGdHi dIdJdKd8dLd8dMd8dNd8dOd8dPdQdRdSdTdUdVdWdXdYdZd8d[d8d\d]d^d8d_d`dab           |g dc         }t          j        |d2         dde          |d2<   t          j        |d;         dde          |d;<   t          j        |d=         dde          |d=<   t          j        |d?         dde          j        j	        |d?<   t          j        |dU         dde          j        j	        |dU<   t          j        |dW         dde          j        j	        |dW<   t          j        |dA         dde          |dA<   t          j        |dH         j
                            df          dde          |dH<   t          j        |d`         dde          |d`<   t          j        |dS         dde          |dS<   t          j        |dJ         dde          |dJ<   |d]                             dgdhdai          |d]<   |dY                             djdkdldmdndo          |dY<   |S )pu   
    集思录可转债-强赎
    https://www.jisilu.cn/data/cbnew/#redeem
    :return: 集思录可转债-强赎
    :rtype: pandas.DataFrame
    z-https://www.jisilu.cn/data/cbnew/redeem_list/Acceptr   zAccept-Encodingr   zAccept-Languager   zCache-Controlr   
Connectionz
keep-alivezContent-Length5zContent-Typer   Hostzwww.jisilu.cnOriginr   PragmaRefererr"   r#   zB" Not A;Brand";v="99", "Chromium";v="101", "Google Chrome";v="101"r$   r%   zsec-ch-ua-platformz	"Windows"zSec-Fetch-Destr&   zSec-Fetch-Moder'   zSec-Fetch-Siter(   zsMozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36r)   )z
User-AgentzX-Requested-Withr*   zLST___t=1653394005966rB   r?   rC   c                     g | ]
}|d          S rH   rJ   rK   s     r   rN   z&bond_cb_redeem_jsl.<locals>.<listcomp>   rO   r   rP   rQ   rR   rS      名称rU   rV   rY   rZ   r[   r\   
margin_flg-r;   orig_iss_amt   规模r.   rs   
convert_dt   转股起始日rc   rd   next_put_dt	redeem_dtforce_redeemredeem_flagredeem_priceredeem_price_ratio   强赎触发比real_force_redeem_price	   强赎价redeem_remain_daysredeem_real_daysredeem_total_days
recount_dtredeem_count_days	redeem_tc   强赎条款r]   r^   	delist_dt   最后交易日rw   	   到期日redeem_icon   强赎状态redeem_ordersat_maturityredeem_count   强赎天计数after_next_put_dtrm   rn   Trz   )rR   r   rV   rZ   r\   r   rs   r   r   r   rd   r   rn   r^   r   r   r   r   r}   r~   %z%^.*?(\d{1,2}\/\d{1,2} \| \d{1,2}).*?$z\1)regexu   已公告强赎u   公告要强赎u   公告不强赎u   已满足强赎条件r,   )ROGBr,   )r   r   rE   r   r   r   r   r   r   r   strstripreplacemap)r   rF   rD   r   r   r   r   s          r   bond_cb_redeem_jslr      sA    :CB. 	4 		
 	l 	# 	J 	 	) 	* 	6 	Y 	D 	k 	'  	&!" 	-#$-,)  G. 	)F 	dG 	c&wHHHAIlGGYv5FGGGHHGNN"
x"
x"
 X"
 	"

 "
 #"
 S"
 H"
 N"
 +"
 ["
 3"
 "
 C"
 3"
  C!"
" !"3#"
 "
$ &{%"
& !#'"
( )"
*  +"
, #-"
.  /"
0 1"
2 k3"
4 *5"
6 ;7"
8 >9"
: S;"
< 3="
> -?"
@  A"
B !"3C"
 "
F I  % % %N 	
 	
 	
G, gh&7IIIGHgh&7IIIGH mGN,CHUUUGN!#!"8" " "  "$!"8" " "  >'+*>xPPPSXGK=)=hOOOGK!#!"&,,S11(" " "G "$w7H/IRZ![![![G=)=hOOOGK=)=hOOOGK!():!;!C!C0%t "D " "G &n599"""(	
 	
 GN Nr   128013symbolc                 T   d|  }t          j        |          }|j        }d|vrt          j                    S t          j        t          |          d          d         }d |j        D             |_        t          j        |d         d	          |d<   t          j        |d
         d	          |d
<   t          j        |d         d	          |d<   t          j	        |d         dd          j
        j        |d<   t          j	        |d         dd          j
        j        |d<   |S )u   
    集思录-可转债转股价-调整记录
    https://www.jisilu.cn/data/cbnew/#cb
    :param symbol: 可转债代码
    :type symbol: str
    :return: 转股价调整记录
    :rtype: pandas.DataFrame
    z3https://www.jisilu.cn/data/cbnew/adj_logs/?bond_id=z</table>T)parse_datesr   c                 :    g | ]}|                     d d          S ) r,   )r   rK   s     r   rN   z(bond_cb_adj_logs_jsl.<locals>.<listcomp><  s&    MMMT4<<R00MMMr   u   下修前转股价r}   r~   u   下修后转股价u   下修底价u   股东大会日z%Y-%m-%d)formatr   u   新转股价生效日期)r   r	   r   r   r   	read_htmlr   r{   r   r   r   r   )r   r   r   	data_textr   s        r   bond_cb_adj_logs_jslr   )  sU    I
H
HCSAI"" |~~,x	22EEEaHMMW_MMM(*()()
 )
 )
$% )+()()
 )
 )
$% #%-0GPX"Y"Y"Y%'^%&z(&
 &
 &

T 	!" /1n./
8/
 /
 /

T 	*+ r   __main__r,   )r   )r   )N)r   )__doc__ior   pandasr   r   r   akshare.utilsr   r   r   r   r   r   r   __name__bond_cb_index_jsl_dfprintbond_cb_jsl_dfbond_cb_redeem_jsl_dfbond_cb_adj_logs_jsl_dfrJ   r   r   <module>r      s                ! ! ! ! ! !2<    C C Cr| C C C CLABL A A A AH! ! !BL ! ! ! !H z,,..	E
 [+++N	E...00	E
   22(CCC	E
!""""" r   