Pricing Calculator
Project Completed
Pricing Calculator
Built an application that calculates trade prices using real-time data and user input, reducing workflow time by 50%.
THE APP
A streamlined application designed to calculate cross-currency pair trades using a combination of real-time market data and user-defined inputs.
Old process vs new solution
| Feature | Old model (manual) | New model (my app) |
|---|---|---|
| Calculates a pair trading level | ✓ | ✓ |
| Designed for non-technical users | ✕ | ✓ |
| Requires zero formula manipulation | ✕ | ✓ |
| Cross a trade in seconds | ✕ | ✓ |
Case Study
How I built it
- Created a dynamic real-time pricing spreadsheet pulling data from Bloomberg
- Built a Python calculation engine for pricing logic
- Developed a separate Python UI layer to turn the workflow into an application
- Designed the experience so end users never interact with formulas or raw data
Impact
- 50% fewer steps (12 → 6) to reach the same output
- Faster execution and reduced operational risk
- More reactive in a fast-paced market
Architecture (high level)
Bloomberg → live market data
Dynamic Spreadsheet → real-time pricing table
Python Math Engine → reference price calculations
App UI → guided inputs and validation
Output → consistent reference prices