.claude/skills/fin-guru-create-doc/SKILL.md
Create institutional-grade financial documents from templates. Handles analysis reports, buy tickets, compliance memos, Excel model specs, presentations, and onboarding reports.
npx skillsauth add aojdevstudio/finance-guru fin-guru-create-docInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
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/analysis/ using naming conventions:
{topic}-{YYYY-MM-DD}.mdbuy-ticket-{YYYY-MM-DD}-{short-descriptor}.md{strategy-name}-master-strategy.mddevelopment
Sync retirement account data from Vanguard and Fidelity CSV exports to Google Sheets DataHub. Handles multiple accounts, aggregates holdings by ticker, and updates quantities in retirement section (rows 46-62). Triggers on sync retirement, update retirement, vanguard sync, 401k update, IRA sync, or working with notebooks/retirement-accounts/ files.
devops
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.
development
Prevent accidental modification of sacred spreadsheet formulas in Google Sheets Portfolio Tracker. Blocks edits to GOOGLEFINANCE formulas, calculated columns, and total rows. Allows only IFERROR wrappers, fixing broken references, and expanding ranges. Triggers on update formula, modify column, fix errors, or any attempt to edit formula-based cells.
development
Develop comprehensive portfolio strategies from quantitative analysis. Integrates margin, dividend, and cash-flow tactics into actionable wealth-building plans.