Hey Guys,
I was wondering if it was possible to form a formula based on my following requirements:
Currently, I have two spreadsheets, one is a statistical spreadsheet and one is a pip count sheet.
On the pip count sheet i type in the pair i use, the system i use and the pip count for that trade.
In the Statiscal Spreadsheet, i have all the stats, such as % of winning trades. etc
I organised my stats spreadsheet so that it is arranged by pair as well as system.
I want to be able to type one thing into my pip count spreadsheet and have it replicated in my stats spreadsheet without me entering it in twice.
So for example, I want to be able to place a "EURUSD" trade under the "POURI" System, and the amount of pips earned from that trade in my pip count sheet. And i want this information to be sorted and filled under the POURI - EURUSD system section, in the stats spreadsheet - showing the amount of pips gained and how many trades have been done for that particular trade.
Also, I would like it to identify whether the trade has been negative or positive and arrange it in the "Winning pips" and "losing pips" section of my stats spreadsheet.
Ive done all the formulas for the stats spreadsheet, and the pip count spreadsheet - the only thing i am having trouble on is producing something that can identify the above and place it in its appropriate cells in the following sheet
Cheers
Rusty
I was wondering if it was possible to form a formula based on my following requirements:
Currently, I have two spreadsheets, one is a statistical spreadsheet and one is a pip count sheet.
On the pip count sheet i type in the pair i use, the system i use and the pip count for that trade.
In the Statiscal Spreadsheet, i have all the stats, such as % of winning trades. etc
I organised my stats spreadsheet so that it is arranged by pair as well as system.
I want to be able to type one thing into my pip count spreadsheet and have it replicated in my stats spreadsheet without me entering it in twice.
So for example, I want to be able to place a "EURUSD" trade under the "POURI" System, and the amount of pips earned from that trade in my pip count sheet. And i want this information to be sorted and filled under the POURI - EURUSD system section, in the stats spreadsheet - showing the amount of pips gained and how many trades have been done for that particular trade.
Also, I would like it to identify whether the trade has been negative or positive and arrange it in the "Winning pips" and "losing pips" section of my stats spreadsheet.
Ive done all the formulas for the stats spreadsheet, and the pip count spreadsheet - the only thing i am having trouble on is producing something that can identify the above and place it in its appropriate cells in the following sheet
Cheers
Rusty