메뉴
Create institutional-grade financial documents from templates. Handles analysis reports, buy tickets, compliance memos, Excel model specs, presentations, and onboarding reports.
Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.
SOC 직업 분류 기준
Sync dividend data from Fidelity CSV to Dividends sheet. Reads dividend.csv from notebooks/updates/, calculates actual dividends received (shares × amount per share), writes to input area (rows 2-46), then clicks Add Dividend button to process. Triggers on sync dividends, update dividends, dividend tracker, layer 2 income, or monthly dividend analysis.
Import and manage Fidelity transaction history CSVs. Two workflows - IngestTransactions (local rolling archive from Downloads) and SyncTransactions (Google Sheets push). USE WHEN user mentions "sync transactions", "import transactions", "ingest transactions", "transaction history", OR wants to import Fidelity History CSV.
Privacy and security compliance scanner for the Finance Guru repo. Catches API tokens, account numbers, dispatcher URLs, owner-name leaks, untracked sensitive files, and gitignore gaps before they reach GitHub. Use this skill whenever the user says "compliance scan", "is this safe to push", "scan for PII", "secrets check", "pre-commit security", "pre-push security", "check for leaks", "PRIVACY.md compliance", "audit privacy", "any leaks", "check before push", or wants a sanity check before `git push`. Also run it proactively after editing PRIVACY.md, after creating any new file under `.claude/skills/`, `notebooks/`, `fin-guru-private/`, or `scripts/qa/`, and any time the user adds a new credential, deploy URL, or webhook. Privacy and security are non-negotiable in this repo — when in doubt, run it.
Finance Guru™ Core Context Loader Auto-loads essential Finance Guru system configuration and user profile at session start. Ensures complete context availability for all financial operations.
Update Margin Dashboard with Fidelity balance data and calculate margin-living strategy metrics. Monitors margin balance, interest costs, coverage ratios, and scaling thresholds. Triggers safety alerts for large draws and provides time-based scaling recommendations. Use when updating margin, balances, coverage ratio, or margin strategy analysis.
Import and sync broker CSV portfolio data to Google Sheets DataHub. Supports Fidelity (automated) with multi-broker planned. USE WHEN user mentions import broker data OR sync portfolio OR update positions OR CSV import OR portfolio-sync OR ingest positions OR bring in positions OR downloaded from Fidelity OR working with Portfolio_Positions CSVs. Handles file ingestion from Downloads, position updates, SPAXX/margin validation, safety checks, and formula protection.
| name | fin-guru-create-doc |
| description | Create institutional-grade financial documents from templates. Handles analysis reports, buy tickets, compliance memos, Excel model specs, presentations, and onboarding reports. |
Create professional financial documents using Finance Guru templates.
| Template | Path | Purpose |
|---|---|---|
| Analysis Report | {project-root}/fin-guru/templates/analysis-report.md | Research and analysis reports |
| Buy Ticket | {project-root}/fin-guru/templates/buy-ticket-template.md | Capital deployment authorization |
| Compliance Memo | {project-root}/fin-guru/templates/compliance-memo.md | Regulatory compliance documentation |
| Excel Model Spec | {project-root}/fin-guru/templates/excel-model-spec.md | Financial model specifications |
| Presentation | {project-root}/fin-guru/templates/presentation-format.md | Stakeholder presentations |
| Onboarding Report | {project-root}/fin-guru/templates/onboarding-report.md | Client onboarding summaries |
{project-root}/fin-guru/templates/fin-guru-private/fin-guru/ using naming conventions:
analysis/{topic}-{YYYY-MM-DD}.mdtickets/buy-ticket-{YYYY-MM-DD}-{short-descriptor}.mdanalysis/{strategy-name}-master-strategy.mdBuy tickets use the canonical buy-ticket-template.md contract:
## Execution Summary sectionfin-guru-private/fin-guru/tickets/