The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
We want to provide raw trading data to an excel spreadsheet.
Macro code you write will sum the data and extract relevant detail to present the data into a template that you develop.
This tempate will then act as the basis of an HTML e-mail senty through outlook.
You will develop the code that takes the excel content and creates the outlook e-mail.
Attahced is a data sheet with sample trading data mentioned above. Below is a detaile dlist fo tasks relating to that data.
Extract unique constituents of column E – defined as Venues
Extract B/S (replace with Buy/Sell) from column B – defined as Buy/Sell
Extract most recent date from Column F - defined as Trade Date
Extract most recent date time from Column F – defined as First Execution
Extract oldest date time from Column F – defined as Last Execution
Calculate Sub Total column C data by unique constituents of column E – defined as Volume Traded
Calculate % of Total Vo...
Sign in or Register to see more