Business Case:
I developed this project to automate tracking the USD to EGP exchange rate without needing manual checks. By periodically updating the exchange rate in a PostgreSQL database, this solution provides quick, reliable access to the latest rate for financial calculations and planning purposes.
Technical Solution:
Using Python and Selenium, I created a bot that opens Google, searches for "1 USD to EGP," and scrapes the latest exchange rate from the search result. The retrieved rate is then stored in a PostgreSQL database, where it updates the same record each time, ensuring that the database always reflects the latest conversion rate.