Futures Beginner Asks for Resources

September 13th, 2009, 12:36 AM

Here is a simple xcel spreedsheet that you can use to calculate your risk/reward and risk per contract. Just enter symbol, entry, stop, and target. To modify the formulas if needed the sheet password is 1234.

Some of the values look unrealistic and that's correct, just test input to make sure the math was correct, just never cleared the cells.

September 13th, 2009, 01:47 PM

This helps so much! Thank you

TraderJesse

Here is a simple xcel spreedsheet that you can use to calculate your risk/reward and risk per contract. Just enter symbol, entry, stop, and target. To modify the formulas if needed the sheet password is 1234.

Some of the values look unrealistic and that's correct, just test input to make sure the math was correct, just never cleared the cells.

September 13th, 2009, 02:12 PM

Let me see if I understand. For ES for instance
ESE-mini S&P 5000.250000$50.00$5.00

if I see .2500 as the tick size I need to devide by 1 to find out it takes 4 ticks to = one contract. and it the cost for .25 is $5. then that means for a contract to move one point for ES the cost or profit would be $5 x 4 = $20 per contract to move 1 point. Correct.

See attached speadsheet. - let me know if my added columns are correct.

TraderJesse

Here is a simple xcel spreedsheet that you can use to calculate your risk/reward and risk per contract. Just enter symbol, entry, stop, and target. To modify the formulas if needed the sheet password is 1234.

September 13th, 2009, 05:11 PM

alpine4133

Some how it looks like you got the Futures List resorted with but not all values were sorted with the symbol correctly. From the original spreedsheet.

Original

The one you uploaded

The orignal sheet shows $12.50 Tick Amount which is correct for ES.

Your modified version shows $5.00 Tick Amount which is incorrect for ES.

Example ES

Riskpoints/tick size=ticks per risk * tick amount = risk per contract

4 point risk
4/.25 = 16 * $12.50 = $200.00

1 point risk
1/.25 = 4 * $12.50 = $50.00

The risk sheet does a lookup from the list sheet keyed off the symbol, so if the list sheet is sorted incorrectly, the risk sheet will be wrong.

Risk sheet from original

Sheet with same values in your modified version

September 13th, 2009, 05:35 PM

OK, here is one sorted with the cost per 1 contract. Does it look right?

TraderJesse

alpine4133

December 15th, 2009, 08:41 PM

i am a member of a trading room and i see a lot of posts on a must read book (trading in the zone) i plan on doing an internet search of the book and you may want to also. sorry i dont have any more info than that on the author.

Futures Beginner Asks for Resources

Discussion in Traders Hideout

Futures Beginner Asks for Resources