Improve an excel spreadsheet for Forex investment strategy backtesting.

In Progress

Description

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.

Skills: Data Entry, Excel, Financial Analysis, Microsoft Office

See more: investment strategy backtesting excel, simple forex excel spreadsheet, backtesting investment strategies excel, excel spreadsheet forex, market entry strategy excel spreadsheet, excel spreadsheet examples ruby rails, excel spreadsheet examples, backtesting trading systems excel forex, backtesting forex excel, investment opportunities schedule excel spreadsheet, examples job description excel spreadsheet, forex excel spreadsheet, examples excel spreadsheet small business includes salary, creative excel spreadsheet examples, forex calculator excel spreadsheet

Project ID: #12194488

Awarded to:

meeshusoft1

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

$25 USD in 1 day
(1 Review)
1.1

23 freelancers are bidding on average $41 for this job

Webxpert4u

Hello, I am ready to start work with you. Please provide me detail of your task. LET'S DISCUSS before starting the task. I would love to work on this task. I can easily do any task in excel for example, creat More

$150 USD in 3 days
(169 Reviews)
6.9
P0L

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.

$100 USD in 2 days
(120 Reviews)
6.3
MohsanEijaz

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

$30 USD in 1 day
(33 Reviews)
4.7
teeares

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.

$25 USD in 1 day
(56 Reviews)
5.1
$47 USD in 2 days
(16 Reviews)
3.8
$50 USD in 2 days
(14 Reviews)
4.0
chintu83

Lest's start work with great accuracy and with in time deadlines .My aim is to satisfy my client by my WORK.Thanks.

$25 USD in 1 day
(16 Reviews)
3.8
ksinghrajeev

Hello There, Here are some of my work examples. Project Report Automation - https://www.dropbox.com/s/tt0q9qhfq3s4izm/eBird%20FEP%20Plan%2012_Feb_15.xlsm?dl=0 Log Report Automation - https://www.dropbox.com/s/ More

$100 USD in 5 days
(5 Reviews)
3.6
jssinfosys

Hi, I am an expert in MS Excel, MS Access, SQL database production and management. I have over 7 years of experience in working with all of the databases and analytics. I am a financial engineering graduate and have e More

$25 USD in 1 day
(8 Reviews)
3.6
bhaveshghodasara

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

$40 USD in 5 days
(11 Reviews)
3.0
goyalfreelancer

Hi, I'm Sahil I have 2 years working experience on data entry and web search. I already done some work like bank statements, student record and customer information on excel. I will be provide you 100% accurate data w More

$25 USD in 1 day
(4 Reviews)
2.8
$50 USD in 1 day
(5 Reviews)
2.7
kstudio1

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.

$25 USD in 1 day
(2 Reviews)
2.5
mianimranamjad

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

$20 USD in 0 days
(2 Reviews)
1.7
$25 USD in 2 days
(0 Reviews)
0.0
insidenetsoft

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

$60 USD in 3 days
(0 Reviews)
0.0
pulenthira

Hello, I found your job post and I'm very interested in your Project.I think you'll find I possess the capabilities you're looking for. Please take a look at my portfolio to get an idea of the kind of skills I have More

$15 USD in 1 day
(0 Reviews)
0.0
Ranajoyfreelance

Dear Hiring Manager, I have read your JOB post and I got it what you want to develop.WE HAVE GOOD EXPERIENCE TO WORKING WITH FOLLOWING SKILLS like php, html, SEO, mysql, MVC,SQL server,JQUERY,API More

$25 USD in 1 day
(0 Reviews)
0.0
amirhamza2

Hey there, I looked up your project & very interested to work with you. You can hire me. I can give you the best & quality work at low budget.

$15 USD in 1 day
(0 Reviews)
0.0
$20 USD in 1 day
(0 Reviews)
0.0