The Challenge The client required a robust, fully automated system to track daily stock performance and volumes across multiple international markets (US, UK, Europe). Manually updating stock prices in Google Sheets was time-consuming and prone to human error, especially regarding currency conversions (e.g. USD/GBP to EUR) and formatting consistency.