Excel Data Transfer with Custom Formulas

I need help transferring live option data from a .xls file provided by my broker into another Excel sheet. I also need to apply some custom financial formulas on the copied data.

Requirements:
- Copy all columns of data from the .xls file
- Paste into a new Excel sheet
- Ability to apply custom financial formulas as per my requirements

Ideal Skills:
- Proficiency in Excel
- Experience with .xls files
- Knowledge of financial formulas