Improve an excel spreadsheet for Forex investment strategy backtesting.
$10-30 USD
Paid on delivery
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.
Project ID: #12194488
About the project
Awarded to:
Please share your actual data so that I can add all analyzing tools required by you. Average profit on winning trades, average loss on losing trades, win percentage etc. are easy to monitor. However, risk to reward rat More
21 freelancers are bidding on average $42 for this job
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
I have experience in MS Office, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfect for y More
I have done programme with help of pivot table previously.. As this is statistical data it need to be calculated very accurately. And i do have sound knowledge of stock market also so it will be plus point if you all More
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.
Hello, SOLUTION: Since you already have the database sheet, the solution that I propose is to add 2 more sheets: "Param" and "Dashboard Overview". In the Param tab we will setup all the parameters needed for the for More
Lest's start work with great accuracy and with in time deadlines .My aim is to satisfy my client by my WORK.Thanks.
Hello I’m very interested in your job post involving these skills. I have good experience in data entry and excel. I believe my skills would be ideal for your project. I can complete this job within the required time More
Having qualified in higher typing test and got a certificate and worked in a BPO for 2 years in non voice process and having ten years of experience in dealing with computers can do your work accurately and within a sh More
