Work

Excel to Cloud: Migrating Legacy Trader Tools to Scalable Java & Python Applications

Year: 2025
Type: article
Abstract: Many trading desks across the financial industry still rely heavily on Excel-based tools for pricing, risk assessment, and reporting workflows. While these spreadsheets offer flexibility and familiarity, they present challenges in scalability, collaboration, version control, and integration with modern trading infrastructure. This paper presents a cloud-native migration framework that transforms trader-centric Excel tools into robust, scalable applications using Java and Python. The framework incorporates modular microservices, RESTful APIs, AWS services, and real-time data processing. It also addresses migration challenges such as formula translation, data validation, and end-user adoption. The resulting system improves performance, auditability, and maintainability while retaining the usability traders expect.
Authors: Senior Associate, Macquarie, Houston, TX, USA, Bharathvamsi Reddy Munisif
Language: English
Open Access status: bronze
OpenAlex ID: W4409599185
FWCI:
Cites:
Cited by:
Related to: 10