All about F: using a spreadsheet to maximize gain. (finding the optimal f using Microsoft Excel 3.0) (Trading Techniques)

Futures (Cedar Falls, Iowa),  September, 1992  by Bergerson, Karl; Burke, Gibbons

Tags: Microsoft Corp., Microsoft Excel, spreadsheet, technique

• E-mail
• Print
• Link

What is the optimal number of contracts to trade for a given equity level? We illustrate the answer using a popular spreadsheet program.

"Don't overtrade," the trading wizards warn us. "Keep your wager small," they say, usually just after they have told you to "Follow the trend" and "Hang on to your winners." This is faultless advice to be sure, but how does a trader know when he is overtrading?

Put on too big a position and a series of losses will wipe out the account. If you are not aggressive enough, your winners will have no ...

Read the rest of this article with a Free Trial at HighBeam Research.