Skip to content
cccskills
FreePublished on GitHub

Document Organization

Execute a single deterministic Python script to harmonize units, create/update metadata, move files to output_data/, and clean up input_data/.

The English summary is being prepared. Showing the original description.

See how to install

Files included (4)

  • SKILL.md2.7 KB
  • examples/PYPL_example.md728 B
  • scripts/__pycache__/organize.cpython-311.pyc37.5 KB
  • scripts/organize.py26.6 KB

SKILL.md (original)

Review the instructions the agent will receive before you install.

Document Organization (Phase 4)

All organization logic is consolidated into a single script that handles the complete lifecycle: classification parsing, unit harmonization, metadata management, file archival, and input cleanup.

  1. Execute the script: python skills/document_organization/scripts/organize.py {markdown_file}
  2. Verify no errors were thrown.

What the Script Does

StepActionDetails
1Read ClassificationExtracts ticker, company name, document type, dates, currency from the classification table
2Harmonize UnitsDetects prevailing unit from BS/IS, converts Shares Outstanding and Organic Growth values if they differ. Supports: ones, thousands, ten_thousands (万), millions, hundred_millions (億), billions
3Read Financial SummaryExtracts Revenue, EBITA, NOPAT, ROIC, Growth etc. for metadata
4Create/Update MetadataCreates or updates output_data/TICKER/TICKER_metadata.md with document entry + financial history row. Handles deduplication and date sorting
5Move & CleanupMoves .md and .pdf from processing_data/ → output_data/TICKER/ (removing _temp suffix). Deletes matching source PDF from input_data/
6VerifyConfirms destination files exist and source files are removed

Unit Conversion Reference

The script uses a deterministic conversion table:

UnitFactor to OnesAlias
ones1—
thousands1,000thousand
ten_thousands10,000万
millions1,000,000million
hundred_millions100,000,000億
billions1,000,000,000billion

Metadata Management

  • New ticker: Creates TICKER_metadata.md with header, processed documents table, and financial history table
  • Existing ticker: Appends new rows, sorts by period end date, deduplicates by time period (re-processing overwrites)
  • Last Updated field is always refreshed

Error Handling

  • Missing source files → warns and continues
  • Unknown units → raises ValueError with descriptive message
  • Duplicate time periods → replaces existing row (re-processing scenario)
  • Missing input_data/ files → logs info message (may have been manually cleaned)

Cross-Document Date Healing

Date healing (checking fiscal calendar consistency) is NOT automated by this script. If the agent identifies date inconsistencies after reviewing the metadata, it should flag them manually in the metadata file per the original SKILL instructions (Step 6 of the legacy spec).

Reviews

No reviews yet. Tell others what you thought.

Comments

No login needed. Share how it worked for you, ask a question, or note where it did not run.

No comments yet. Be the first to write one.

Comments are published right away. Do not include personal information such as email addresses or phone numbers. Up to 2 URLs.

0 / 1,000 characters

This form is protected by reCAPTCHA, and the Google Privacy Policy and Terms of Service apply.

More skills from this repository

Classify financial PDFs by extracting company identity, document type, and date metadata. Validates ticker via Yahoo Finance with multi-step fallback. Uses a Python orchestration script for validation, file modification, and writing markdown.

The English summary is being prepared. Showing the original description.

Ruinius/financial-analyst-skills5Updated Jun 9, 2026

Execute a single deterministic Python script to compute all derived financial metrics (EBITA, Invested Capital, Tax Rates, Summary Table) from extracted financial data.

The English summary is being prepared. Showing the original description.

Ruinius/financial-analyst-skills5Updated Jun 9, 2026

Extract balance sheet, income statement, shares outstanding, organic growth, and GAAP reconciliation data from financial PDFs. Standardize via Tiger-Transformer and append structured output to the document markdown.

The English summary is being prepared. Showing the original description.

Ruinius/financial-analyst-skills5Updated Jun 9, 2026

Execute a single deterministic Python script to compute WACC, DCF assumptions, projected free cash flows, enterprise value, and intrinsic value per share. Updates the metadata markdown.

The English summary is being prepared. Showing the original description.

Ruinius/financial-analyst-skills5Updated Jun 9, 2026

Extracts the WACC, assumptions, and DCF projections from the markdown metadata file and converts them into a clean, structured JSON file for the frontend interactive viewer.

The English summary is being prepared. Showing the original description.

Ruinius/financial-analyst-skills5Updated Jun 9, 2026

Assess a company's economic moat, EBITA margin trajectory, and organic growth trajectory from analyst reports, earnings transcripts, or long-form articles. Produces structured qualitative outlook that feeds into the Financial Modeling skill's assumption generation.

The English summary is being prepared. Showing the original description.

Ruinius/financial-analyst-skills5Updated Jun 9, 2026

See all skills by Ruinius

Report a problem with this skill