加载中...
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.
该表提供了可转债的赎回条款详细信息,包括债券编码、赎回条款、赎回价格说明、有条件赎回价、到期赎回价、条件赎回的开始与结束日期、赎回停止交易日和转股日、发行人资金到账日、相对赎回期、每年可赎回次数以及赎回触发的最大计算时间周期等指标。
25 个字段
本表提供可转债的赎回条款,每只可转债一行,包含赎回条款原文、有条件赎回价、到期赎回价、条件赎回起止日、赎回停止交易日和转股日、赎回触发比例与触发价、赎回登记日等。
注:若起止时间为None,则表示当前没取到数据,请咨询客服
| 关键字 | 释意 |
|---|---|
| instrument | 可转债代码,格式为 代码.交易所后缀,如 110076.SH、123076.SZ。每只可转债一行 |
| date | 赎回公告日,不是交易日,也不是数据生成日期 |
cn_cbond_basic_info 中。date(赎回公告日)只有 434 行有值,其余 650 行为空。数据起始时间和结束时间只统计有值的行。redemption_clause 是条款原文,文字很长,示例数据中不展示这一列。redemption_triggercalc_mti 为 30、redemption_triggercalc_time_int 为 15、redemption_trigger_ratio 为 130,对应条款“连续 30 个交易日中至少有 15 个交易日收盘价不低于当期转股价的 130%”。| 字段 | 释意 |
|---|---|
| redemption_clause | 赎回条款原文 |
| redemption_price_explain | 赎回价格说明,如“面值加当期应计利息” |
| cndtn_redemption_price | 有条件赎回价 |
| maturity_redemption_price | 到期赎回价 |
| cndtn_redemption_sd | 条件赎回开始日 |
| cndtn_redemption_ed | 条件赎回结束日 |
| redemption_stop_redemption_date | 赎回停止交易日 |
| redemption_stop_transfer_date | 赎回停止转股日 |
| issuer_capital_to_account_date | 发行人资金到账日 |
| relative_redemption_period | 相对赎回期 |
| redemption_times_per_year | 每年可赎回次数 |
| redemption_triggercalc_mti | 赎回触发最大计算时间周期 |
| redemption_triggercalc_time_int | 赎回触发最大计算周期 |
| redemption_trigger_ratio | 赎回触发比例,单位为百分数 |
| redemption_trigger_price | 最新赎回触发价 |
| redemption_price | 赎回价 |
| redemption_audit_ad | 赎回登记日 |
| not_compulsory_redemp_indicative_date | 不强赎提示公告日 |
| not_compulsory_redemp_startdate | 不强赎提示开始日 |
| not_compulsory_redemp_enddate | 不强赎提示结束日 |
| interest_process | 利息处理,取值有应计、已含、当年 |
| is_redemption_clause_of_time | 是否有时点赎回条款 |
| time_point_redemption_num | 时点赎回数 |
| date | 赎回公告日 |
取 2025-11-04 至 2026-11-04 内赎回公告日的数据,按 date、instrument 排序,展示前 5 行和后 5 行。示例不展示 redemption_clause 列,空值显示为空单元格。
| date | instrument | redemption_price_explain | cndtn_redemption_price | maturity_redemption_price | cndtn_redemption_sd | cndtn_redemption_ed | redemption_stop_redemption_date | redemption_stop_transfer_date | issuer_capital_to_account_date | relative_redemption_period | redemption_times_per_year | redemption_triggercalc_mti | redemption_triggercalc_time_int | redemption_trigger_ratio | redemption_trigger_price | redemption_price | redemption_audit_ad | not_compulsory_redemp_indicative_date | not_compulsory_redemp_startdate | not_compulsory_redemp_enddate | interest_process | is_redemption_clause_of_time | time_point_redemption_num |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2025-11-18 00:00:00 | 123212.SZ | 面值加当期应计利息 | 100.39 | 113 | 2024-02-02 00:00:00 | 2029-07-26 00:00:00 | 2025-12-12 00:00:00 | 2025-12-17 00:00:00 | 2025-12-22 00:00:00 | 6 | 不限次数 | 30 | 15 | 130 | 24.245 | 101 | 2025-12-16 00:00:00 | 应计 | 否 | ||||
| 2025-11-18 00:00:00 | 123240.SZ | 面值加当期应计利息 | 100.45 | 110 | 2024-08-06 00:00:00 | 2030-01-30 00:00:00 | 2025-12-17 00:00:00 | 2025-12-22 00:00:00 | 2025-12-25 00:00:00 | 6 | 不限次数 | 30 | 15 | 130 | 10.4 | 100.5 | 2025-12-19 00:00:00 | 应计 | 否 | ||||
| 2025-11-29 00:00:00 | 127081.SZ | 面值加当期应计利息 | 100.805 | 111 | 2023-09-11 00:00:00 | 2029-03-02 00:00:00 | 2025-12-17 00:00:00 | 2025-12-22 00:00:00 | 2025-12-25 00:00:00 | 6 | 不限次数 | 30 | 15 | 130 | 19.188 | 101 | 2025-12-19 00:00:00 | 2025-08-08 00:00:00 | 2025-08-08 00:00:00 | 2025-11-07 00:00:00 | 应计 | 否 | |
| 2025-12-03 00:00:00 | 123185.SZ | 面值加当期应计利息 | 100.73 | 110 | 2023-10-09 00:00:00 | 2029-03-30 00:00:00 | 2025-12-19 00:00:00 | 2025-12-24 00:00:00 | 2025-12-29 00:00:00 | 6 | 不限次数 | 30 | 15 | 130 | 28.795 | 101 | 2025-12-23 00:00:00 | 应计 | 否 | ||||
| 2025-12-05 00:00:00 | 128144.SZ | 面值加当期应计利息 | 101.22 | 110 | 2021-09-06 00:00:00 | 2027-02-28 00:00:00 | 2025-12-23 00:00:00 | 2025-12-26 00:00:00 | 2025-12-31 00:00:00 | 6 | 不限次数 | 30 | 15 | 130 | 10.53 | 101.5 | 2025-12-25 00:00:00 | 2025-08-14 00:00:00 | 2025-08-14 00:00:00 | 2025-11-13 00:00:00 | 应计 | 否 | |
| 2026-08-18 00:00:00 | 113667.SH | 面值加当期应计利息 | 100.686 | 115 | 2023-09-25 00:00:00 | 2029-03-16 00:00:00 | 2026-08-26 00:00:00 | 2026-08-31 00:00:00 | 6 | 不限次数 | 30 | 15 | 130 | 12.935 | 101.5 | 2026-08-28 00:00:00 | 2026-04-18 00:00:00 | 2026-04-18 00:00:00 | 2026-07-17 00:00:00 | 应计 | 否 | ||
| 2026-08-18 00:00:00 | 127067.SZ | 面值加当期应计利息 | 100.25 | 109 | 2023-01-30 00:00:00 | 2028-07-20 00:00:00 | 2026-09-04 00:00:00 | 2026-09-09 00:00:00 | 2026-09-14 00:00:00 | 6 | 不限次数 | 30 | 15 | 130 | 13.416 | 101.8 | 2026-09-08 00:00:00 | 2026-04-28 00:00:00 | 2026-04-28 00:00:00 | 2026-07-27 00:00:00 | 应计 | 否 | |
| 2026-08-27 00:00:00 | 123112.SZ | 面值加当期应计利息 | 101.332 | 118 | 2021-10-14 00:00:00 | 2027-04-07 00:00:00 | 2026-09-14 00:00:00 | 2026-09-17 00:00:00 | 2026-09-22 00:00:00 | 6 | 不限次数 | 30 | 15 | 130 | 8.359 | 103 | 2026-09-16 00:00:00 | 应计 | 是 | 1 | |||
| 2026-09-10 00:00:00 | 123258.SZ | 面值加当期应计利息 | 100.05 | 113 | 2026-03-03 00:00:00 | 2031-08-27 00:00:00 | 2026-09-30 00:00:00 | 2026-10-12 00:00:00 | 2026-10-15 00:00:00 | 6 | 不限次数 | 30 | 15 | 130 | 70.668 | 100.4 | 2026-10-09 00:00:00 | 2026-05-19 00:00:00 | 2026-05-20 00:00:00 | 2026-08-19 00:00:00 | 应计 | 是 | 1 |
| 2026-10-09 00:00:00 | 113046.SH | 面值加当期应计利息 | 101.195 | 110 | 2021-09-27 00:00:00 | 2027-03-21 00:00:00 | 2026-10-21 00:00:00 | 2026-10-26 00:00:00 | 6 | 不限次数 | 30 | 15 | 130 | 13.234 | 102 | 2026-10-23 00:00:00 | 应计 | 是 | 1 |
import daidf = dai.query(""" SELECT date, instrument, redemption_clause, redemption_price FROM cn_cbond_redemption WHERE instrument = '128031.SZ'""",).df()import daidf = dai.query(""" SELECT instrument, redemption_trigger_price, redemption_trigger_ratio FROM cn_cbond_redemption""",).df()SELECT instrument, redemption_clause, redemption_price_explain, cndtn_redemption_price, maturity_redemption_price, cndtn_redemption_sd, cndtn_redemption_ed FROM cn_cbond_redemption WHERE date >= '2026-10-06' ORDER BY date LIMIT 100
SELECT instrument, redemption_clause, redemption_price_explain, cndtn_redemption_price, maturity_redemption_price, cndtn_redemption_sd, cndtn_redemption_ed FROM cn_cbond_redemption WHERE date >= '2026-10-06' ORDER BY date LIMIT 100