Spreadsheet Name: AIMBAREBONESV1.00 Spreadsheet File Name: AIMBARES.XLS Instruction Text File Name (this document): AIMBARET.TXT The allied spreadsheet implements the algorithm proposed by Lichello in his book, "How to Make $1,000,000 in the Stock Market Automatically," Third Revised Edition, published by Signet. The following notes explain how to work with this spreadsheet. Spreadsheet and these notes by GW Riedeman. Prodigy: PXKF83A AOL: GBillR Internet: gwbill@televar.com Neither spreadsheet nor notes are protected by copyright and may be used at will by any and all at no charge. August 3, 1996 Notes on AIM Spreadsheet: Most of the elements should be self explanatory; however, here are the basics of how to use it. The usual warning: The calculations have not been extensively checked, and the user assumes all responsibility for any events which may transpire consequent to using this spreadsheet. If you find any errors, let me know and I'll correct them posthaste and send you corrected copies. Notes: 1. The fundamental AIM algorithm implemented is: * Portfolio Control is initially set at initial stock value. * Safe values calculated as percentage of stock value. * Buy recommendation shown when Portfolio Control exceeds stock value by more than minimum trade limit AND the number of shares to be traded at current price exceeds minimum trade limit. * Sell recommendation shown when stock value exceeds Portfolio Control by more than minimum trade limit AND the number of shares to be traded at current price exceeds minimum trade limit. * Actual buys and sells are entered by the user and may or may not be exactly as AIM recommended. Frequently, the actual buys and sells are rounded to even multiples of 100 shares. The AIM algorithm uses the actual values, not the recommendations, for follow on calculations. * The Portfolio Control is incremented only and only on an actual buy by one half the dollar amount of the actual buy. 2. Dates mean nothing on this chart. They are only entered for the user's convenience. 3. You will find three worksheets, a Master, a Working, and one labeled CAER. The latter, CAER, is provided as an illustration of what it will look like and how it works. I recommend you never enter any data on the Master worksheet; you should retain this sheet to be used as an original for the one(s) you actually use. Copy the original to another worksheet or workbook and make new entries on the new copy. The Working worksheet is a blank for just such a new entry, or for playing with, as you prefer. 4. I have protected the non-entry areas of this spreadsheet. It is easy to override this protection in the Tools top menu - simply bring the menu down and select protection. Here you can turn it on or off. There is no password required. Also, when copying, I don't think the protection is carried into the copy. If you want to make sure you don't inadvertently overwrite or erase any of the calculated cells, you might want to reinstate protection for the copy. 5. The Initial Data Box is self explanatory. The initial investment is the total cash commitment you want to make to the account. The program will divide this amount into stock and cash sub accounts depending upon the percent split you enter. 6. The first data line is shaded as there should be no user input to this line. It is automatically filled. 7. The user enters data only into the yellow shaded areas. Remember, the date column is for info only and plays no part in the calculations. 8. The only REQUIRED entry is the second column, Price Close $. All others are elective. You can enter price data either as a history file all at once by pasting the data from another list or periodically in real time to track an ongoing investment. Of course, you can enter historical data manually if you must do so. As you enter data, the calculations will automatically open up in the remainder of the spreadsheet. I have blanked the cells to unclutter the unused portion of the sheet. 9. If you wish to change Buy Safe, Sell Safe, Minimum Trade Shares or Dollars, enter new values in the shaded area at the point where you want them to become effective. The new value will remain until changed again. 10. If you want to remove an entry, click the right mouse button on the cell to be cleared and then select CLEAR CONTENTS only (that should be the only choice you will have). Never DELETE data in any spreadsheet - it will screw your spreadsheet up royally! Preventing deletions is one important safety feature provided by protection. 11. The spreadsheet will indicate AIM's recommended action. If you choose to make a trade, based upon AIM's recommendations or not, enter the trade in the appropriate place. 12. Remember, all values not shaded are calculated, and should not be changed by the user, particularly if the user is not pretty familiar with spreadsheets and their programming. I haven't entered any trickery in here, but the blanking logic can be confusing to an inexperienced user. 13. The last three columns, New Parameters, are only bookkeeping and can be ignored for all practical purposes. The data shows on the next line waiting for the next entry. When printing, there is no need to print these last three columns. 14. You will also note that when you enter a new price, not only will that line's values calculate and display, but three new values will show up in the following line. These values merely lend some visibility to the status quo awaiting the next entry, which may be of interest. Eventually, they are used in the calculation for that line when a price is entered. Remember, a price entered into the price column is the primary trigger for that row's calculations and display. 15. You can change any entry at any time, make corrections, etc., without any detriment to the spreadsheet, as long as you keep these changes in the shaded areas. Change outside of these areas, and you will be in deep yogurt. Use the protection feature if you can, particularly if you are not pretty familiar with spreadsheet operation. 16. There is room for 100 entries. That should be enough for most purposes. If you want a larger spreadsheet, one with more rows, you can extend this one. To do so, you should know something about creating and deleting borders and shading - done in the formatting cells selection which comes up when clicking the right button over any cell or block. You should not copy the bottom row for extension, copy the row above. Then paste as many new lines as you want, starting at the first vacant row. Now, you will be missing a bottom border and will have the original bottom border remaining. The easiest way to finish is to cut (not copy) the original bottom row, containing the old bottom border, and paste it at the very bottom. Then copy the line above the "hole" and paste it in the hole. 17. When printing, you can hide columns if you want, but sometimes the spreadsheet looks a little funny. It may take a little experimentation. But you should never include the right three columns in your printout. They just scrunch up your printout and add nothing.