Simple software for Journalling/backtesting of Forex trading

Need a simple software for Journalling/backtesting of Forex trading. Journal can be done on excel or exported to excel.

The software should be able to deduce which outcome occurs first from the data keyed in.

Requirements are as below:

My Trading has 3 outcomes. The software NEEDS TO DECIDE WHICH OUTCOME OCCURS FIRST.

1. profit - when "profit target" is hit b4 "stop loss" or "break even" are hit.

2. loss - when "stop loss" is hit b4 "profit target" or "break even" are hit.

3. break even (when the market moves in the direction that i want for a specific amount, i will shift my stop loss to entry level. However if the market moves back to hit the entry level before hitting my profit level my trade will be breakeven)

The information to key in are as follows:

1. Direction - Buy/Sell

2. Entry price + date + time

3. Largest move against desired direction(in terms of price) + date + time

4. Largest move in desired direction (in terms of price) b4 returning to entry price + date + time

5. Highest/Lowest Price reached in desired direction + date + time

6. Remarks (any remarks of the trade tat i may want to add)

The software need to calculate which outcome is hit first.

Variables are values i can change to get different reports from the information keyed in above.

The variables are as follows:

1. Spread - in terms of pips

2. Profit target - in terms of pips

3. Stop loss - in terms of pips

4. Pips moved in desired direction b4 moving stop loss to "Break Even" level.

The information tat need to be reported by the software are as follows:

1. Number of Trades - able to define period by date, for eg. between 1st July to 31st July

2. Number of profitable trades/break even trades and losing trades - able to define period

3. Percentage of profitable trades/break even trades and losing trades - able to define period

4. Profit /Loss - able to define period.

5. Largest number of consecutive wins, consecutive losses and consecutive break evens - able to define period.

6. The largest draw down in pips. Draw down = largest number of pips the account decreased by b4 returning to it's original level.

The report needs to be able to exported to a spreadsheet like excel.

Example

I "BUY" GBP/USD at entry price 1.63 with a profit target of 200 pips, a stop loss of 100 pips and set that when the market moves 100 pips in my desired direction i will shift my stop loss to break even level.

This means that my profit targe is 1.65 in terms of price and my stop loss level is 1.62. (0.01 in terms of price translates to 100 pips)

The spread of GBP/USD is 3pips. Which means that although I enter the trade when the price was 1.63, I will need the market to hit 1.6503 in order to take profit. On the other hand the market needs only hit 1.6203 for my stop loss to be triggered.

The software need to assess which outcome is hit first. 1 (entry + exit) is treated as 1 trade.

Programování v C Excel

Identifikační číslo projektu: #1188894

O projektu