In Progress

Improve an excel spreadsheet for Forex investment strategy backtesting.

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

About the Employer:
( 0 reviews ) United States

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

22 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
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
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
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
$47 USD in 2 days
(16 Reviews)
3.8
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
$50 USD in 2 days
(14 Reviews)
4.0
ksinghrajeev

Hello There, Here are some of my work examples. Project Report Automation - [url removed, login to view] Log Report Automation - [url removed, login to view] More

$100 USD in 5 days
(5 Reviews)
3.6
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
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
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
$50 USD in 1 day
(5 Reviews)
2.7
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
$20 USD in 1 day
(0 Reviews)
0.0
afsarbasha000786

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

$15 USD in 1 day
(0 Reviews)
0.0
$25 USD in 1 day
(0 Reviews)
0.0
miltonbiswasjohn

Sir... I am really interested to work on your project. I've done that's type job on up-work . And would be glad to talk about this project with [url removed, login to view] you want then mail me at this address:: miltonbiswasjohn At GmA More

$15 USD in 1 day
(0 Reviews)
0.0
$23 USD in 6 days
(0 Reviews)
0.0
$25 USD in 2 days
(0 Reviews)
0.0