Treasury Trading Performance Reporting

Customer: AI | Published: 10.03.2026
Бюджет: 30 $

I need to turn raw treasury-trading deal data into clear, decision-ready performance reports. The core of the job is to build a repeatable process that reads my daily deal files, analyses them, and produces a set of Performance Reports covering three key metrics: • Return on Investment • Trading Volume • Profit & Loss Statement . RATES AND MORE The source files arrive in CSV/Excel straight from our treasury platform. I am comfortable sharing a sample dataset so you can map the fields, clean anomalies, and transform the numbers. Ideally the workflow is automated—SQL or Python for the heavy lifting and Excel, Power BI or Tableau for the final dashboards and printable summaries—but I am open to whichever stack you can justify as robust and maintainable. Acceptance criteria • A scripted ETL routine that I can run on new deal files without rewriting code. • Interactive dashboards plus a one-page PDF summary highlighting ROI, volume trends, and daily P&L. • Brief hand-off notes so my team can adjust data paths or field names in future. If you have questions about the data structure or need a quick walkthrough of the treasury trading workflow, let me know and I’ll set up a call.