C. Commodity Options Trading Excel Forms

This commodity options trading Excel forms appendix contains a brief description of all the "Trading Forms" that are included with your Commodity OPTIONS Trading Course^TM and how they are used. A full description is provide in the Appendix of the complete Commodity OPTIONS Trading Course^TM.

The purpose of these forms is to help you quickly identify and select commodities which have near-term potential for high profit. You would then use the process described in the Commodity OPTIONS Trading Course^TM to identify when to enter and exit the market.

Purchasers of the complete Commodity OPTIONS Trading Course^TM receive fully-functional Excel "Trading Forms". Visitors only have access to the "formula-stripped" (non-calculating) FREE versions of these forms to evaluate the usefulness of these resources.

Download each file into a previously-created options directory/folder on your computer. You do this by moving your mouse pointer to each chapter file link so the mouse icon changes from an arrow to a pointing hand. Click the Right mouse button (a menu of choices is displayed). Move the mouse pointer to the Save Links As..." option and select it with the Left mouse button. This will display a "Save As..." dialog box where you can specify the options directory/folder as the download location for the selected file. Repeat this procedure for each file.

Note 1: To accommodate differing verisons of Excel, all ".xls" files are saved in Excel 97 & 5.0/95 workbook format. This means that they can be read by higher versions of Excel if your copy of Excel was installed with the required file conversion program. If you encounter an error message that states; "file format is not valid" -or- "cannot be accessed, the file may be read only or you may be trying to access a read only location or the server the document is stored in may not be responding", this means the necessary Excel file conversion program was not installed. You will either need to install the Excel file conversion program(s) on your computer (using your Excel installation disk), or load the files into Excel on another computer and save them in the format recognized by your Version of Excel.

Note 2: These trading forms are for the Microsoft Excel program only. They will not load in Microsoft Works spreadsheet program.

Note 3: All trading forms are "locked" to avoid accidental erasure of important formulas in the forms. There are times when you will need to unlock a form to change the numeric format of certain cells so they will display the commodity's data values correctly. It is assumed that you are familiar with Excel to perform these tasks. Cells where data entry is permitted have a light blue background.

Note 4: All trading form Excel files have been provided to you as a convenient way to monitor and track your trading activities. I do not provide support for any of these files. If you want them changed, you must either do it yourself or find someone who can make the changes. You should make copies of your original forms and use the copies. Because your trades may exceed the timeframe available on the trading forms, you should make copies using filenames in sequence (i.e., filename1.xls, filename2.xls, etc.) transferring applicable data to the subsequent form.

1. Option Information Form^TM (substituted filename used: o3.xls)

   This form contains information about option specifications which you must know. Each row identifies the commodity (in Investor's Business Daily Option Page sequence), how the price for the option is quoted, the multiplier (this value is entered into the Option Premium Tracking Form), the premium quote value (as quoted in Investor's Business Daily Option Page, and how to enter this premium into the Option Premium Tracking Form (some values require a decimal adjustment to display the correct price). This form does not perform any calculations. Print and refer to this form when using the Option Premium Tracking Form.

2. Option Premium Tracking Form^TM (substituted filename used: o4.xls)

   This form helps you to track up to four option premiums to determine when they are at bargain prices. To use this form, first make a copy of the file. Open the copy of the file and enter the date (in mm/dd format) into cell B14 (must be a Monday date). The rest of the dates will automatically be filled in by the form.

   Up to four option premiums can be tracked (Commod1: through Commod4:). Enter the name of the commodity into the cell to the right of "Commod1:" for reference. Enter the "Future Mo.:" in the corresponding cell for reference. Enter whether you are tracking a Put or Call into the appropriate cell next to "Put/Call:" for reference. Enter the "Strike:" (option strike value) of the option for reference. Enter the "Multiplier:" for the commodity (from the Option Information Form) into the appropriate cell to be used in calculations elsewhere. Enter the "Exp. Date:" of the option for the underlying futures contract month (in mm/dd format) in the appropriate cell for reference. Enter the "# Options:" in the position. Enter the commission per option in the "Unit Comm:" cell (this should initially be a zero, with the actual commission per option in the next lower cell for reference).

   Enter "Premium-1" data in the correct number form (see Option Information Form for information). The form calculates the dollar price for the option and displays it in the appropriate Price-1 cell. Also displayed is the number of days remaining until the option expires. Repeat as needed for "Commod2:" through "Commod4:". When the position is closed, enter the commission per commodity in the "Unit Comm:" field. Your actual net is calculated for you.

3. Daily P&L Summary Form (substituted filename used: 6.xls)

   This form displays a summary of all your active positions on a daily basis as a total for up to four weeks. This form is distributed as a "locked" file. To use this form, first make a copy of the file. Open the copy and enter the following data in the upper lefthand box:

   Enter the "Date" (in mm/dd format) into cell A6 (a Monday). The rest of the dates will automatically be filled in by the form. Enter the "Month" (use "Jan" - "Dec" format), "Commodity", and "Type" (Put or Call) for each of up to four items. These items will autofill the rest of the boxes on this form.

   Enter the "Net P&L" each day for every active position. The form will calculate and display the Daily P&L (Profit & Loss) of all your active (up to three) positions. As each position is closed out, transfer the final result to the Trading History Form.

4. Trading History Form^TM (substituted filename used: 7.xls)

   This form is manually completed when each position is closed, and presents you with a history of your Net P/L (profit & loss) for your positions during a specific time period. You use this form document the history of your trades. To use this form, first make a copy of the file. Open the copy and enter the number of trades in the "quan" cell. Enter the "Month" and "Commodity", followed by "Order Date", "Entry Date". Enter the data into the "Options" area, indicating if the trade is a put or call in the "Put Call" column, the date the option expires in the Opt. Exp." column, the "Strike" price, the "Entry Price" and the "Target" (normally a daily 50% target).

   When the trade is complete, enter the "Exit Date", the "Exit Price", and the "Net P/L for trade". The form only performs one calculation at cell T4 to display the "Net P/L for all trades". When all trades have been closed, print and file this completed page because it is an historic record of your trading activity. Review these records occasionally as you may gain insight into ways you can improve your trading activities.

5. 21-Day Put/Call Volume Ratio Moving Average Calculation Form^TM (substituted filename used: o1.xls)

   This form will calculate the 21-day moving average of the put/call ratio on a daily basis. This form calculates the average of the 21 days of data which is present in columns D - through - X, with the headings. It is distributed as a "locked" file. To use this form, first make a copy of the file. Open the copy and enter the most recent 21 days of option put/call ratio data, changing the date heading to reflect the data of the reported data (remember that data reported in Investor's Business Daily is the previous day's data). Enter the data for the selected commodity option using the following format "=put volume/call volume" (e.g., =521/1108).

   Each new data value is obtained by clicking column D and select Insert, Columns to create another column. When you insert a new column, any data in column B is blanked out. Enter the date in the heading, then enter the data into the selected commodity in the "=put/call" format from Investor's Business Daily Option Page. The revised 21-day moving average appears in column B. Monday's data in column B can be copied to the Put/Call Ratio Summary Form.

   Also remember that the data in Investor's Business Daily Option Page contains values from the previous day.

6. Put/Call Ratio Summary Form^TM (substituted filename used: o2.xls)

   This form is used to record the Put/Call average (obtained from the 21-Day Put/Call Volume Ratio Moving Average Calculating Form) for each Monday. Transfer the Monday values from put-call.xls to this form, inserting a new row and moving all previous rows rightward. See Chapter 3-F for instructions to use this data for further analysis.

More Commodity Trading Products For YOU:

Commodity FUTURES Trading Course

Commodity OPTIONS Trading Course

Commodity PYRAMID Trading Course

Affordable Workshops Just For You

This Newsletter Gives You The Best Trades

Futures & Options Price Quotes