Excel coding

Job ID: 35447243

Budget: $10 – $50 USD

Hi

I will have excel data that will consist of thousands of trades information (check attached file)
The data will change from time to time.
I want someone to code a presentation details so we can analysis the data in an easier way, all what I have to do is to copy and paste the new data and the presentation of the detaiels should be shown in page 2 and so on.

The info we need:
Instrument 1 number of trades
Instrument 1 success rate
Instrument 1 Net Profit
Instrument 1 max consecutive profit trades
Instrument 1 max consecutive losing trades
Instrument 1 max consecutive profit weeks
Instrument 1 max consecutive loosing weeks
Instrument 1 number of profitable weeks
Instrument 1 number of losing weeks
Instrument 1 return graph
(instrument 1 to 12)
portfolio total number of trades
portfolio success rate
portfolio Net Profit
portfolio max consecutive profit trades
portfolio max consecutive losing trades
portfolio max consecutive profit weeks
portfolio max consecutive losing weeks
portfolio number of profitable weeks
portfolio number of losing weeks
portfolio return graph

BID ONLY IF YOU UNDERSTAND THE PROJECT
BIDS ARE FINALS AND I WILL NOT ACCEPT CHANGING THEM

DONT WASTE MY TIME

thansk,
Related categories: Visual Basic Data Processing Excel Statistics Coding