Hey Guys
Here is a spreadsheet i made up to calculate Pip P/L, Slippage, and some basic trade stats from Dukascopy's Position Report. To use it, export your position report from their website. Open the "report.csv" that is downloaded, and sort it ascendingly through Position ID. Then copy and paste this into Position Report Tab of this workbook starting in cell A3.
There is also a second sheet that calculates the slippage on pending orders. To do this you have to open up your trade log, and from the "State" drop down menu select "Filled". Copy and paste the webpage entries to a new spread sheet, starting in cell A1. Highlight column G, and press F5, and select "special", then select "blanks" and hit ok. Then right click on the highlighted cells and select "delete..." and select "entire row". Paste the remaining values into the slippage spread sheet.
Here is a spreadsheet i made up to calculate Pip P/L, Slippage, and some basic trade stats from Dukascopy's Position Report. To use it, export your position report from their website. Open the "report.csv" that is downloaded, and sort it ascendingly through Position ID. Then copy and paste this into Position Report Tab of this workbook starting in cell A3.
There is also a second sheet that calculates the slippage on pending orders. To do this you have to open up your trade log, and from the "State" drop down menu select "Filled". Copy and paste the webpage entries to a new spread sheet, starting in cell A1. Highlight column G, and press F5, and select "special", then select "blanks" and hit ok. Then right click on the highlighted cells and select "delete..." and select "entire row". Paste the remaining values into the slippage spread sheet.
Attached File(s)
Dukascopy Position Report Stats.xlsx.zip
84 KB
|
575 downloads