Click on the image to make it larger.
This is an excel workbook I have set up which shows the performance of a number of signal providers which I am following or watching. The workbook takes the historic trading data and using an if function to calculate the stop loss at increments of 10 pips from 10 (min) to 200 (max). From this I calculate an optimum stop loss (low, medium and high). The far columns show the most recent 20 trades to give an indication of the current performance vs. historic performance of each signal provider. I am updating this spreadsheet weekly and will be adding signal providers to the listing if it appears they are trading profitably.
Ideally I am looking at using a stop loss of no greater than 100 pips. The below image is sorted by average pips per trade using an optimum stop loss of 100 pips or less. It would seem logical to just take say the top 5 signal providers from this list, however when we look at the most recent 20 trades it is clear that some of these signal providers are not performing well in the current volatile trading environment. I am looking to add signal providers who average greater than 10 pips per trade at a stop loss of 100 pips and who have traded profitably over the most recent 20 trades. The below image shows those providers which fit this criteria. The excel query is +10 pips per trade and trading profitably over most recent 20 trades.
No comments:
Post a Comment