[kenazen]

Attached is a OpenOffice spreadsheet used for determing how many units to purchase based on the need for a 50-pip-SL and a willingness to lose 2% of your equity.

For a USD Major pair with a USD qoute, you use a USDRATE of 1, like EUR/USD.

For a USD Major pair with a USD base, you use a USDRATE equal to the currency rate, for example 1.3151 for USD/CHF.

For a non-Major pair ("Minor"), you use a USDRATE that is either USD Conversion rate, for example on CHF/JPY @ 89.15, you would use USD/JPY @ 116.55. I'm not sure why this works in all cases, perhaps it doesn't. The forumla is supposed to be different when it's the qoute or base price that is being converted to USD, but it seems to work.

The PipValue always has the same number of decimals as the USDRATE. SO it is 0.0001 on most pairs, and 0.01 on JPY-based pairs.

If anyone has any suggestions, or would like to double-check my math, that would be helpful.

The goal of the calculations is for me to be able to take multiple bets where each one is risking 2% of my money with a 50-pip Stop Loss.