Python Financial Data Analysis Automation

I have several streams of financial data arriving daily in CSV and Excel formats and I need a clean, repeatable way to turn those raw numbers into clear insights. The core of the job is Python programming, with the main objective being Data analysis on Financial data.

The workflow I picture looks like this:
• A Python script (Pandas, NumPy for database touch-points) ingests the files, validates them, and performs the key calculations and ratios we will define together.
• Automated hand-offs into Excel reports—either via openpyxl/xlsxwriter in Python or a light VB Script—so non-technical teammates can keep using their current spreadsheets without manual copy-paste.
• Optional push of summary metrics to our Jira Dashboards through the Jira REST API, keeping leadership updated in real time.

I will supply sample datasets, current Excel templates, and the Jira project details. What I need back is:
1. Well-commented Python code that runs end-to-end on a Windows machine.
2. Any VB Script or Excel Automation helpers bundled with clear instructions.
3. A brief README demonstrating how to schedule or trigger the job (Task Scheduler, cron, or equivalent).

The solution should handle new files dropped into a folder, flag data quality issues, and finish with refreshed Excel workbooks and, if configured, updated Jira gadgets. If this matches your skill set, let’s get started—your efficient, readable code will make a real impact on our reporting cycle.