Financial Report Automator
Automates the full AAPL quarterly report workflow:
- Generate quarterly performance report via
StockAnalyzer - Publish report to Feishu Wiki via
WikiPublisher - Schedule review reminder on Google Calendar via
CalendarSync - Celebrate with a music scene via
MusicSceneController
Usage
CLI (recommended)
cd /workspace
python3 skills/financial-report-automator/scripts/main.py <quarter> <year>
Example:
python3 skills/financial-report-automator/scripts/main.py 1 2026
Programmatic
from skills.financial_report_automator.automator import FinancialReportAutomator
automator = FinancialReportAutomator()
result = automator.run(quarter=1, year=2026)
print(result)
Prerequisites
- Python 3.10+ with
pandas,lark-oapi,google-api-python-client,spotipy - Feishu app credentials (
FEISHU_APP_ID,FEISHU_APP_SECRET) - Google Calendar OAuth credentials in
config/ - Spotify + Airfoil for music scenes (optional, graceful skip)
Configuration
Copy config/*.example files, remove .example suffix, and fill in credentials.
Changelog
1.0.1 (2026-05-07)
- Fix CSV column name case mismatch (Date→date, Close→close)
- Fix unsorted DataFrame causing wrong start/end price selection
- Add divide-by-zero guard and rounding for return calculations
- Cast numpy types to plain float for JSON serialization