NSE File Automation and Transformation

I need a freelancer to automate the downloading of the F&O-Bhavcopy File (DAT) from the NSE website at a specific time daily. After downloading, the file needs to have certain transformation logic applied, which I'll provide.

https://www.nseindia.com/all-reports-derivatives


Requirements:
- Automation to download file at a specific time daily
- Apply data aggregation and summarization transformations
- Save transformed file in Excel format

Ideal Skills:
- Experience with web automation tools
- Proficient in data manipulation and transformation
- Familiarity with Excel and automation scripts

Please provide examples of similar work done.