Improve an excel spreadsheet for Forex investment strategy backtesting.

sedang Berlangsung

Deskripsi

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.

Keahlian Entri Data, Excel, Analisa Keuangan, Microsoft Office

Lihat lebih lanjut: 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

ID Proyek: #12194488

Diberikan kepada:

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 Lagi

$25 USD dalam 1 hari
(1 Ulasan)
1.1

23 freelancer menawar pada rata-rata $41 untuk pekerjaan ini

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 Lagi

$150 USD dalam 3 hari
(169 Ulasan)
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 dalam 2 hari
(120 Ulasan)
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 Lagi

$30 USD dalam 1 hari
(33 Ulasan)
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 dalam 1 hari
(56 Ulasan)
5.1
$47 USD dalam 2 hari
(16 Ulasan)
3.8
$50 USD dalam 2 hari
(14 Ulasan)
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 dalam 1 hari
(16 Ulasan)
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/ Lagi

$100 USD dalam 5 hari
(5 Ulasan)
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 Lagi

$25 USD dalam 1 hari
(8 Ulasan)
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 Lagi

$40 USD dalam 5 hari
(11 Ulasan)
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 Lagi

$25 USD dalam 1 hari
(4 Ulasan)
2.8
$50 USD dalam 1 hari
(5 Ulasan)
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 dalam 1 hari
(2 Ulasan)
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 Lagi

$20 USD dalam 0 hari
(2 Ulasan)
1.7
$25 USD dalam 2 hari
(0 Ulasan)
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 Lagi

$60 USD dalam 3 hari
(0 Ulasan)
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 Lagi

$15 USD dalam 1 hari
(0 Ulasan)
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 Lagi

$25 USD dalam 1 hari
(0 Ulasan)
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 dalam 1 hari
(0 Ulasan)
0.0
$20 USD dalam 1 hari
(0 Ulasan)
0.0