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