Exchange Rate Report Automation

Project Overview:
This project focuses on automating the calculations and analysis of Excel reports. Specifically, it automates the process of downloading exchange rate information between the Colombian peso and the dollar, generating a report with historical data analysis, and sending it via email.

​

What Was Done:
1. Automated the downloading of exchange rate information.
2. Processed and formatted the data into an Excel report.
3. Automatically sent the report via email.

​

How It Was Done:
1. Data Collection:
   - Used Yahoo Finance to automatically download exchange rate information.
2. Data Processing:
   - Processed the downloaded data into a data frame using Python.
   - Created an Excel file with the processed data, ensuring the data and its format were properly fixed for presentation.
3. Report Automation:
   - Scheduled the automatic sending of the Excel file through email using Python and Windows Task Scheduler. This included selecting the time and frequency for sending the email.

​

Achievements:
- Successfully automated the generation and distribution of daily exchange rate reports.
- Saved time and reduced human errors by automating data collection, processing, and report generation.
- Demonstrated a replicable and modifiable process for automating similar reports for different requirements.