Excel VBA Expert for Data Analysis
Budget: $30 – $250 AUD
I am in need of a proficient VBA programmer with extensive experience in Excel.
The selected freelancer is expected to:
- Effectively perform data manipulation and analysis.
- Program and implement custom macros to enhance productivity.
- Integrate data sorting and filtering functionalities into the macros.
I need a macro written to take a bunch of foreign exchange buys (ordered by date) and a bunch of sells (ordered by date) and calculate profit and loss based on FIFO method. It will need to allow for future entries. It will also need to keep a running balance of which line item has been exhausted to zero and what still has a non zero balance.
For example,
1/1/23 bought 100,000 USD/GBP at 1.20
5/3/23 bought 25,000 USD/GBP at 1.22
4/9/23 sold 30,000 USD/GBP at 1.21
10/10/23 bought 15,000 USD/GBP at 1.15
10/12/23 sold 95,000 USD/GBP at 1.19
etc etc
The selected freelancer is expected to:
- Effectively perform data manipulation and analysis.
- Program and implement custom macros to enhance productivity.
- Integrate data sorting and filtering functionalities into the macros.
I need a macro written to take a bunch of foreign exchange buys (ordered by date) and a bunch of sells (ordered by date) and calculate profit and loss based on FIFO method. It will need to allow for future entries. It will also need to keep a running balance of which line item has been exhausted to zero and what still has a non zero balance.
For example,
1/1/23 bought 100,000 USD/GBP at 1.20
5/3/23 bought 25,000 USD/GBP at 1.22
4/9/23 sold 30,000 USD/GBP at 1.21
10/10/23 bought 15,000 USD/GBP at 1.15
10/12/23 sold 95,000 USD/GBP at 1.19
etc etc