加载中...
AI 原生量化投研平台AI-native quantitative research platform
正在加载…Loading…
页面仍在加载,可以继续等待,或重新加载。The page is still loading. You can keep waiting or reload.
部分页面资源未能加载,请重新加载。Some page resources could not load. Please reload.
设备当前处于离线状态,恢复连接后可以继续等待或重新加载。Your device is offline. Once connected, you can keep waiting or reload.
该表提供了全面的可转债投资指标,包括债券的基本信息(如债券编码、已计息天数、应计利息、下一个付息时间)、债券的期限信息(如剩余期限天数、加权剩余期限按本息)、转股信息(如累计转股比例、转股价、转股比例等)、纯债信息(如纯债价值、纯债溢价率、纯债到期收益率)、正股信息(如正股市盈率、正股市净率)、以及其他重要的财务指标(如隐含波动率、剩额、回售触发价、赎回触发价等)。
34 个字段
本表提供可转债的每日投资分析指标,每个交易日、每只可转债一行,包含应计利息、剩余期限、纯债价值与溢价、转股价与转股价值、转股溢价、正股估值、隐含波动率、回售与赎回触发价、剩余规模等指标。
注:若起止时间为None,则表示当前没取到数据,请咨询客服
| 关键字 | 释意 |
|---|---|
| date | 交易日 |
| instrument | 可转债代码,格式为 代码.交易所后缀,如 110076.SH、123076.SZ |
pure_bond_ytm 为空、implied_volatility 全为 0,这两个字段在之后会被补齐,当天读到的是未补齐的值。2026-10-19 至 2026-10-22 的 pure_bond_ytm 没有空值。implied_volatility 为 0 的标的每天都有一部分(2026-10-22 为 41 只),0 的含义未核实。bond_balance 的单位是亿元,un_conversion_balance 的单位是元,两者相差 1e8 倍(bond_balance × 1e8 = un_conversion_balance)。conversion_price 与 conversion_clause_price、conversion_ratio 与 transfer_ratio 两组字段取值相同(2026-10-22 全部 309 只核对一致)。date 范围要带上时分秒,上限写到当天 23:59:59。只写日期会被解析为当天 00:00:00,取不到当天的数据。| 字段 | 释意 |
|---|---|
| days_accrued_interest | 已计息天数 |
| accrued_interest | 应计利息 |
| next_interest_date | 下一个付息时间 |
| last_td_date_convertible | 最后交易日,仅少数标的有值(2026-10-22 为 6 只),具体口径未核实 |
| remaining_days | 剩余期限(天) |
| remaining_life_year | 剩余期限(年),等于 remaining_days ÷ 365 |
| wgt_surplus_years | 加权剩余期限,按本息 |
| accum_conversion_ratio | 累计转股比例 |
| current_yield | 当期收益率 |
| pure_debt_value | 纯债价值 |
| pure_debt_premium | 纯债溢价,等于当日收盘价(cn_cbond_bar1d)减 pure_debt_value |
| pure_bond_premium_rate | 纯债溢价率,单位为百分数,等于 pure_debt_premium ÷ pure_debt_value × 100 |
| pure_bond_ytm | 纯债到期收益率 |
| conversion_price | 转股价 |
| conversion_ratio | 转股比例,等于 100 ÷ 转股价 |
| transfer_value | 转股价值,等于 conversion_ratio × 正股未复权收盘价 |
| conversion_premium | 转股溢价,等于当日收盘价(cn_cbond_bar1d)减 transfer_value |
| conversion_premium_rate | 转股溢价率,单位为百分数,等于(收盘价 ÷ transfer_value - 1)× 100 |
| conver_pe | 转股市盈率 |
| conver_pb | 转股市净率 |
| stock_pe | 正股市盈率 |
| stock_pb | 正股市净率 |
| conversion_dlt_ratio | 转股稀释率,单位为百分数 |
| float_shares_dlt_rate | 对流通股稀释率,单位为百分数 |
| implied_volatility | 隐含波动率 |
| bond_balance | 剩额,剩余规模,单位为亿元 |
| resale_trigger_price | 回售触发价 |
| redemption_trigger_price | 赎回触发价 |
| conversion_clause_price | 转股价格,与 conversion_price 取值相同 |
| transfer_ratio | 转股比例,与 conversion_ratio 取值相同 |
| un_conversion_balance | 未转股余额,单位为元 |
| un_conversion_ratio | 未转股比例,单位为百分数,范围 0 到 100 |
取 2026-10-28 至 2026-11-04 的数据,按 date、instrument 排序,展示前 5 行和后 5 行。空值显示为空单元格。
| date | instrument | days_accrued_interest | accrued_interest | next_interest_date | last_td_date_convertible | remaining_days | remaining_life_year | wgt_surplus_years | accum_conversion_ratio | current_yield | pure_debt_value | pure_debt_premium | pure_bond_premium_rate | pure_bond_ytm | conversion_price | conversion_ratio | transfer_value | conversion_premium | conversion_premium_rate | conver_pe | conver_pb | stock_pe | stock_pb | conversion_dlt_ratio | float_shares_dlt_rate | implied_volatility | bond_balance | resale_trigger_price | redemption_trigger_price | conversion_clause_price | transfer_ratio | un_conversion_balance | un_conversion_ratio |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2026-10-28 00:00:00 | 110077.SH | 343 | 1.87945 | 2026-11-20 00:00:00 | 2026-11-16 00:00:00 | 23 | 0.0630137 | 0.0630137 | 83.9729 | 1.01544 | 109.903 | 87.0558 | 79.2114 | -700.654 | 4.41 | 22.6757 | 196.372 | 0.587118 | 0.298983 | 9.97798 | 1.13448 | 9.88631 | 1.1311 | 4.58228 | 4.58228 | 0.0001 | 2.88487 | 3.087 | 5.733 | 4.41 | 22.6757 | 2.88487e+08 | 16.0271 |
| 2026-10-28 00:00:00 | 110081.SH | 93 | 0.509589 | 2027-07-28 00:00:00 | 273 | 0.747945 | 0.747945 | 16.8568 | 2.19657 | 106.827 | -15.7762 | -14.768 | 24.888 | 18.36 | 5.44662 | 56.7538 | 34.2972 | 60.4315 | -26.5875 | 0.933462 | -1.57312 | 0.581844 | 22.7738 | 22.7738 | 0 | 71.5028 | 12.852 | 23.868 | 18.36 | 5.44662 | 7.15028e+09 | 83.1428 | |
| 2026-10-28 00:00:00 | 110084.SH | 306 | 1.50904 | 2026-12-27 00:00:00 | 425 | 1.16438 | 1.14828 | 18.4347 | 1.46113 | 109.882 | 13.3095 | 12.1125 | -8.0987 | 6.41 | 15.6006 | 95.6318 | 27.5602 | 28.819 | 1719.99 | 2.98506 | 151.404 | 2.31725 | 9.85456 | 9.85456 | 0.3557 | 8.15649 | 4.487 | 8.333 | 6.41 | 15.6006 | 8.15649e+08 | 81.5649 | |
| 2026-10-28 00:00:00 | 110085.SH | 247 | 1.21808 | 2027-02-24 00:00:00 | 484 | 1.32603 | 1.30978 | 0.140933 | 1.62431 | 108.714 | 2.1022 | 1.93371 | -0.011 | 34.6 | 2.89017 | 32.8035 | 78.0125 | 237.818 | -16.8594 | 5.34846 | -5.34862 | 1.58324 | 7.14333 | 7.14333 | 0.739 | 119.831 | 24.22 | 44.98 | 34.6 | 2.89017 | 1.19831e+10 | 99.859 | |
| 2026-10-28 00:00:00 | 110086.SH | 190 | 0.936986 | 2027-04-22 00:00:00 | 542 | 1.48219 | 1.46907 | 0.0043 | 1.51235 | 111.275 | 7.74528 | 6.9605 | -3.0117 | 4.57 | 21.8818 | 68.709 | 50.311 | 73.2234 | 17.0111 | 1.1733 | 10.3296 | 0.677336 | 18.0257 | 18.0257 | 0.4796 | 19.9991 | 3.199 | 5.941 | 4.57 | 21.8818 | 1.99991e+09 | 99.9957 | |
| 2026-11-04 00:00:00 | 127116.SZ | 49 | 0.0134247 | 2027-09-17 00:00:00 | 2144 | 5.86849 | 5.8111 | 0.0735343 | 98.8686 | 37.1224 | 37.5472 | 29.18 | 3.427 | 84.5785 | 51.4125 | 60.7868 | 18.0245 | 3.04752 | 13.1847 | 1.89538 | 10.0972 | 10.0972 | 0 | 6.86 | 20.426 | 37.934 | 29.18 | 3.427 | 6.86e+08 | 100 | |||
| 2026-11-04 00:00:00 | 127117.SZ | 43 | 0.0117808 | 2027-09-23 00:00:00 | 2150 | 5.88493 | 5.82865 | 0.0657895 | 100.605 | 51.3952 | 51.0862 | 83.96 | 1.19104 | 68.2468 | 83.7532 | 122.721 | 66.8498 | 8.70089 | 59.0592 | 3.90663 | 3.61721 | 3.7531 | 0 | 10 | 58.772 | 109.148 | 83.96 | 1.19104 | 1e+09 | 100 | |||
| 2026-11-04 00:00:00 | 127118.SZ | 21 | 0.00575342 | 2027-10-15 00:00:00 | 2172 | 5.94521 | 5.8984 | 0.0732601 | 99.9233 | 36.5767 | 36.6048 | 18.48 | 5.41126 | 77.3268 | 59.1732 | 76.5234 | 31.3325 | 3.31838 | 14.0703 | 1.87985 | 10.3039 | 11.7927 | 0 | 5.75 | 12.936 | 24.024 | 18.48 | 5.41126 | 5.75e+08 | 100 | |||
| 2026-11-04 00:00:00 | 128138.SZ | 353 | 2.90137 | 2026-11-17 00:00:00 | 2026-11-11 00:00:00 | 13 | 0.0356164 | 0.0356164 | 0.034381 | 2.31248 | 129.796 | -0.0653555 | -0.0503523 | 10.6 | 9.43396 | 89.2453 | 40.4857 | 45.3645 | 53.2685 | 2.17755 | 21.017 | 1.49799 | 8.83588 | 11.0873 | 0 | 4.19856 | 7.42 | 13.78 | 10.6 | 9.43396 | 4.19856e+08 | 99.9656 | |
| 2026-11-04 00:00:00 | 128142.SZ | 322 | 1.76438 | 2026-12-18 00:00:00 | 44 | 0.120548 | 0.120548 | 0.0384401 | 1.8134 | 109.804 | 0.486194 | 0.442784 | 17.5 | 5.71429 | 96.5714 | 13.7186 | 14.2056 | 17.6661 | 4.08784 | 19.8942 | 3.57937 | 4.5484 | 4.59925 | 0 | 7.17724 | 12.25 | 22.75 | 17.5 | 5.71429 | 7.17724e+08 | 99.9616 |
import daidf = dai.query(""" SELECT date, instrument, stock_pe, stock_pb, conversion_price, current_yield, FROM cn_cbond_analyze_metric WHERE instrument = '110043.SH' ORDER BY date""", filters={"date": ["2023-01-01", "2024-01-31"]}).df()import daidf = dai.query(""" SELECT date, instrument, conversion_premium_rate, pure_bond_premium_rate FROM cn_cbond_analyze_metric ORDER BY date""", filters={"date": ["2023-10-19"]}).df()SELECT instrument, days_accrued_interest, accrued_interest, next_interest_date, last_td_date_convertible, remaining_days, remaining_life_year FROM cn_cbond_analyze_metric WHERE date >= '2026-10-06' ORDER BY date LIMIT 100
SELECT instrument, days_accrued_interest, accrued_interest, next_interest_date, last_td_date_convertible, remaining_days, remaining_life_year FROM cn_cbond_analyze_metric WHERE date >= '2026-10-06' ORDER BY date LIMIT 100