I dont know if it is possible to do this, but I thought I would ask anyway. On the left side of my spreadsheet I enter my data, on the right side (columns QRS) I have created something of a summary of my data.
What I want to do is to make it so the summary only includes data based on certain criteria which I can choose. For example I would like to be able to calculate the number of winning, losing, break evens, Average win, and average losses for each strategy (method 1 or method 2), and be able to choose which strategy I want to see the calculations for.
Is this even possible to do, and if so, how can I go about doing it?
Excel 2007
What I want to do is to make it so the summary only includes data based on certain criteria which I can choose. For example I would like to be able to calculate the number of winning, losing, break evens, Average win, and average losses for each strategy (method 1 or method 2), and be able to choose which strategy I want to see the calculations for.
Is this even possible to do, and if so, how can I go about doing it?
| Excel Workbook | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| D | E | F | G | H | L | M | N | O | P | Q | R | S | |||
| 3 | Strategy | Pairs | Entry | L/S | Exit | W | L | BE | Pip G/L | ||||||
| 4 | Method 1 | EUR/USD | 1.0000 | Long | 1.0010 | 1 | 10.0 | ||||||||
| 5 | Method 2 | USD/JPY | 80.00 | Short | 80.10 | 1 | (10.0) | ||||||||
| 6 | Method 1 | USD/JPY | 70.50 | Short | 70.00 | 1 | 50.0 | total pips | -2963 | ||||||
| 7 | Method 2 | EUR/USD | 71.0005 | Long | 71.0005 | 1 | 0.0 | ||||||||
| 8 | Method 1 | EUR/USD | 72.0005 | Long | 72.0005 | 1 | 0.0 | total trades | 11 | ||||||
| 9 | Method 1 | USD/JPY | 73.87 | Short | 73.90 | 1 | (3.0) | Winning | 4 | 36.36% | |||||
| 10 | Method 2 | USD/JPY | 74.87 | Long | 74.99 | 1 | 12.0 | Losing | 5 | 45.45% | |||||
| 11 | Method 1 | AUD/USD | 75.5899 | Long | 75.4679 | 1 | (1220.0) | Break Even | 2 | 18.18% | |||||
| 12 | Method 2 | AUD/USD | 76.5899 | Short | 76.4679 | 1 | 1220.0 | ||||||||
| 13 | Method 2 | EUR/USD | 32.4324 | Long | 32.3425 | 1 | (899.0) | Average win | 323 | ||||||
| 14 | Method 1 | EUR/GBP | 21.3232 | Long | 21.1109 | 1 | (2123.0) | Average loss | -851 | ||||||
Sheet2 | |||||||||||||||
