stock-data-expert

Normalize securities data and reconcile regulatory metadata for JPX/EDINET integration.

Updated Aug 27, 2026
One-click install
npx skills add https://github.com/Yoshi-Dai-1/ARIA --skill stock-data-expert
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: stock-data-expert
Source: https://github.com/Yoshi-Dai-1/ARIA/tree/main/.agent/skills/stock-data-expert
Command: npx skills add https://github.com/Yoshi-Dai-1/ARIA --skill stock-data-expert

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, and includes scripts (resource) and references (resource) components.

What problem does it solve?

このスキルは ARIA データの正規化と整合性管理を実現します。具体的には、5桁コードへの統一、SICC ルールに基づく親子紐付け、JPX/EDINET 間の属性解決、履歴の自己修復、異常検知のガードを提供します。

Core Features & Use Cases

  • 5 桁正規化とルール適用: Excel由来の表記ゆれを統一し、4桁コードは末尾に 0 を付けて 5 桁化します。
  • 属性解決とリコンシリエーション: JPX Master を最優先とし、EDINET/Catalog、過去データをフォールバックとして活用します。
  • 登録ガードと履歴自己修復: IPO 発見、登録保留、LISTING/DELISTING のイベント生成、データの整合性を保ちます。
  • 異常検知の閾値: 指数構成の件数やコード割り当ての検証を行い、問題時には通知・停止を発生させます。

Quick Start

5桁正規化とリコンシリエーションを有効化して、JPX/EDINET のマスタデータを統合します。

Frequently Asked Questions about stock-data-expert

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I normalize 4-digit stock codes to 5-digit codes for JPX and EDINET data integration?

To normalize securities data, 4-digit codes are converted to 5-digit by appending a trailing zero, resolving Excel formatting variations and enforcing strict code normalization for JPX and EDINET integration.

What is the best way to reconcile securities metadata between JPX Master and EDINET?

Securities metadata reconciliation uses a precedence-based approach where JPX Master is prioritized first, falling back to EDINET, Catalog, and historical data to resolve attributes and ensure data integrity.

Can I use pandas to repair missing stock listing history and detect anomalies?

Yes, using pandas, you can apply history self-healing to repair missing records and configure threshold-based anomaly detection to validate index constituent counts and code assignments.

How does SICC rule-based linkage work for parent-subsidiary stock alignment?

SICC rule-based linkage connects parent and subsidiary entities during master stock alignment, applying strict precedence rules to resolve corporate relationships and ensure accurate regulatory metadata reconciliation.

Why does my IPO discovery workflow require registration guards and event generation?

IPO discovery requires registration guards to manage pending listings and generate LISTING or DELISTING events, preventing incomplete records and maintaining historical data integrity during securities reconciliation.

What are the limitations of anomaly guarding when validating securities code assignments?

Anomaly guarding validates index constituent counts and code assignments against configured thresholds, but when validation fails, it triggers notifications or halts processing to prevent data corruption.