Hey guys,
I'm trying to add a column to my trade journal (a Google Spreadsheet) that calculates my risk in pips.
Does anyone know what formula I should use?
The problem is that there are variations on price depending on the currency pair. If everything was "1.xxxx - 1.xxxx" that would be great. But there are pairs which are "123.xx - 123.xx" and "12.xxx - 12.xxx" etc.
So to clarify I want it to come out with a whole number to show how many pips I am risking. Like 30 or 25 or 42 etc.
Here is a screenshot of the spreadsheet to get an idea:
http://img.ctrlv.in/img/51539e144b6a6.png
I'm trying to add a column to my trade journal (a Google Spreadsheet) that calculates my risk in pips.
Does anyone know what formula I should use?
The problem is that there are variations on price depending on the currency pair. If everything was "1.xxxx - 1.xxxx" that would be great. But there are pairs which are "123.xx - 123.xx" and "12.xxx - 12.xxx" etc.
So to clarify I want it to come out with a whole number to show how many pips I am risking. Like 30 or 25 or 42 etc.
Here is a screenshot of the spreadsheet to get an idea:
http://img.ctrlv.in/img/51539e144b6a6.png