copperwasher
Board Regular
- Joined
- Mar 1, 2016
- Messages
- 84
- Office Version
- 365
- Platform
- Windows
Hi there Excel Guru's,
Do excuse the title of this one...
Below is a table of data.
What I need to do is gather the data from respective cells and collate this data into a simple format to ascertain the best values
For example
Gather all the setting no.s (ranked biggest to smallest)
The pair is related to the setting number
Account balance next in relation to the setting number
The total trades - again in relation to the setting number
Etc...
Drafted example (Possible layout)
There are 28 pairs (columns) of data.
The idea is to understand the setting no. and which setting (group of numbers) produces the best return.
I hope this makes sense.
I have enclosed a copy, but its values only - so no formulas
The reason why some of the columns show #DIV/0! is the data produced at setting one = zero. I.E The report displayed no values for this setting.
I know how to set the cell to blank or 0
If you require further info, please just message me.
My thanks and appreciation
Copperwasher
Do excuse the title of this one...
Below is a table of data.
What I need to do is gather the data from respective cells and collate this data into a simple format to ascertain the best values
For example
Gather all the setting no.s (ranked biggest to smallest)
The pair is related to the setting number
Account balance next in relation to the setting number
The total trades - again in relation to the setting number
Etc...
Drafted example (Possible layout)
account balance | £88126 | £64287 | £57001 | £51085 |
setting no. (in order biggest > smallest) | 76 | 57 | 28 | 21 |
total trades | 38 | 60 | 101 | 96 |
pair | AUDJPY | AUDCAD | AUDCHF | AUDNZD |
I may require more data gathering in this row | ||||
|
There are 28 pairs (columns) of data.
The idea is to understand the setting no. and which setting (group of numbers) produces the best return.
I hope this makes sense.
I have enclosed a copy, but its values only - so no formulas
The reason why some of the columns show #DIV/0! is the data produced at setting one = zero. I.E The report displayed no values for this setting.
I know how to set the cell to blank or 0
If you require further info, please just message me.
My thanks and appreciation
Copperwasher