dividend-premium-tracker

# Dividend Premium Tracker

Track the dividend premium (dividend yield minus 10-year bond yield) for CSI Dividend Low Volatility Index.

## Description

This skill tracks the dividend premium for the CSI Dividend Low Volatility Index (H30269), which is crucial for investment decisions in China's dividend-focused market. The dividend premium represents the excess return of dividend-paying stocks over risk-free bonds.

## What It Tracks

- **CSI Dividend Low Volatility Index Dividend Yield** - From China Securities Index
- **10-Year China Government Bond Yield** - From Ministry of Finance
- **Dividend Premium** = Dividend Yield - Bond Yield

## Features

- 📊 Auto-download and track dividend and bond yield data
- 📈 Generate Excel reports with clean charts
- 🔔 Alert when bond yield rises for 3 consecutive days
- 🔔 Alert when premium drops below 1%
- 📅 Support for historical data backfill

## Commands

### Update Today's Data
```bash
python3 scripts/update_dividend_premium.py --update
```

### Check Monitoring Alerts
```bash
python3 scripts/monitor_dividend_premium.py --check
```

### Backfill Historical Data
```bash
python3 scripts/update_dividend_premium.py --backfill 2026-01-01 2026-01-31
```

## Files

```
dividend-premium-tracker/
├── SKILL.md              # This file
├── scripts/
│   ├── update_dividend_premium.py   # Main update script
│   └── monitor_dividend_premium.py  # Monitoring script
├── references/           # Documentation (optional)
└── assets/              # Output files (optional)
```

## Setup

### Telegram Alerts (Optional)

Set Telegram Bot Token for alerts:
```bash
export TELEGRAM_BOT_TOKEN="your_bot_token_here"
```

### Cron Job (Daily Update)

```bash
crontab -e
# Add line:
0 17 * * * cd /path/to/skill && python3 scripts/update_dividend_premium.py --update
```

## Data Sources

| Data | Source | URL |
|------|--------|-----|
| Dividend Yield | China Securities Index | [H30269 Indicator XLS](https://oss-ch.csindex.com.cn/static/html/csindex/...