A.I.M. Users Bulletin Board

[lostcowboy]

Howdy, a long time ago the last spreadsheet I made was hilowinvestordemo.xls I don't think anyone noticed it, and I would like for people to test it and give me their opinion on it. You can find it at this folder Lostcowboy's Spreadsheets There are no Macros in it you have to put everything in by hand. but it should not be to hard to copy and past from one spreadsheet to another one.

So you start with the setup page. put in the amount of cash or bonds,and put in the amount invested in stocks and the number of shares. Then you come to the low ratio, and high ratio. I have them at 10% and 90%. That's what a young person may want to set them at.

Mrs. Tomlinson,in her book Practical Formulas for Successful Investing by Lucile Tomlinson Talked about her Tomlinson compensation plan where at the top of the market you would want to be like 30% in stocks, and at the bottom of the market you would want to be like 70% in stocks. But I think you need to set them for yourself based on your ability to handle risk.

Next you have how big a move your stock or fund needs to make before you buy or sell. Thats it for the setup page.

Then you go to the HiLow sheet, on the HiLow sheet you can only change what is in yellow. The current price is self evident, the high and low price, is what you think they could do. That is the emotional part of this spreadsheet, as the current price goes up, and gets closer to the high price, you will be selling stock, when the price reaches the High price you will be at the Low Ratio that you set on the setup sheet. If the current price drops to the low price the stock ratio will increase until you get to the High ratio, you will be buying stock. You can change the high and low price as you go down the sheet, again that is the emotional part of this. "Amount to be invested this period" is new money that you want to invest, you can put zero in there if you want to, or put it in whenever you have some. If you only have a lump some to work with, just put it in the setup sheet and the sheet will tell you how much to invest based on the current price and what you put in as high and low prices.

Well that's about it for now. Let me know what you think about it.
Clifford