AI Agent Skill-HK IPO Data Updater

HK IPO Data Updater

AI Agent Skill for Automated Investment Tracking

Automatically fetch Hong Kong IPO first-day market data and update your investment spreadsheet — no manual research required.

Overview

Managing a Hong Kong IPO subscription portfolio involves tedious data entry: IPO prices, listing dates, first-day open/close prices, and return calculations. This AI Agent Skill automates the entire pipeline — from fetching real-time stock data via akshare (Sina source) to filling in your Excel spreadsheet with proper formatting, fonts, and colors. Simply tell the AI which stock to update, and it handles the rest.

Features

First-Day K-line Data: Retrieves opening and closing prices for any HK-listed stock on its IPO debut day via akshare.

Auto Return Calculation: Computes open and close percentage changes against IPO price.

Excel Integration: Writes data directly into your spreadsheet with proper formatting (Song Ti 11pt, centered, thin borders, red for positive returns).

Format Cloning: Copies cell formatting from existing rows to maintain spreadsheet consistency.

IPO Price Lookup: Guides you through finding IPO subscription prices via web search when needed.

What's Included

SKILL.md — AI Agent skill definition with step-by-step SOP and Excel column mappings.

fetch_hk_ipo.py — Python script that fetches K-line data, calculates returns, and writes to Excel.

data-sources.md — Reference guide for reliable and unreliable data sources.

formatting-guide.md — Excel formatting specifications (fonts, borders, alignment, colors).

Requirements

• Python 3.7+ with akshare and openpyxl packages

• VS Code with GitHub Copilot Chat

• Microsoft Excel for the target spreadsheet