Improve an excel spreadsheet for Forex investment strategy backtesting.

This project was awarded to meeshusoft1 for $25 USD.

Get free quotes for a project like this
Project Budget
$10 - $30 USD
Total Bids
Project 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.

Awarded to:

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online