I'm a foreign exchange trader/ analyst. I'd need an excel spreadsheet to perform backtesting and statistical analysis on my trading strategies. I currently have a spreadsheet where I plug in the data about each trade i.e Date, time, entry price, trading strategy type, projected profit targets and loss in pips, actual profits and loss in pips. This is all in the "backtesting" section of my current spreadsheet.
What I would need is the ability to quantify and analyze all of that data on a seperate worksheet in the excel file using pivot tables, charts, and other means to analyze the information. Examples of what I'd like to analyze include: Average profit on winning trades, average loss on losing trades, win percentage, risk to reward ratio on the trades place, average time spent in a trade before exiting, what's the performance on a particular day of the week. More details to follow.
23 freelancers are bidding on average $41 for this job
Your requirements appear to be very simple. I will be able to create a macro in Excel to get the required results. Please let me the what the additional requirements are.
Wonderful Project! We are pro in Matlab and Image Processing. We are Masters of Mathematics and Control Engineering. We will finish your project in time. Keep in touch with us. Thanks.