The other day Marcos asked where he could find a position sizing spreadsheet. I just uploaded mine in case anybody else wanted a copy. It’s nothing fancy at all and it’s based on the percent risk position sizing model. Just enter your account equity and the amount you want to risk per trade (expressed as a percentage, so 1% would be entered as 0.01) on row 2.

The way I use it is I enter the tickers and stop loss amounts (in cents) in columns A and B. The number of shares to trade will appear in column C (rounded off to the nearest 25 shares). Another way, which is probably better would be to have ‘enter’ and ‘exit’ columns which would then compute the stop thus eliminating any human error in figuring out the stop (which I do once in a while).

Alternatively, you could just use the spreadsheet as a simple table, listing various stop amounts and the corresponding number of shares.

There are links to other, online, position sizing calculators in my position sizing post.