InvestorsHub Logo
icon url

SFSecurity

06/17/16 11:00 PM

#40786 RE: The Grabber #40779

Hi Grabber, I'm using the AimBareS.xls with a couple of additions. One addition is calculation of the % up or down for the stock. The other is to calculate the CGR - Compound Growth Rate - on the page. I'm playing with adding something like the online buy/sell calculator. I'm not happy with what I have yet as it gives slightly different results than when I simply start at the current price and enter the next penny up/down, then drag it down the column and see when it says to sell/buy next. The other thing I'm going to add is adding dividends to CASH like Lichello did but listing them in a separate column.

Lichello does mention minimum buys/sells on page 54 of the 3rd edition. He says you may ignore any "...sell or purchase under $100." I haven't seen any reference to the minimum percentage of the position that should required.

Given that the first printing of the 3rd edition was 1992 and inflation since then is ~170% he'd ignore anything below that.

However, one needs to add in the commissions before setting this parameter. It is simplest to see when doing a sell. Say you have a $10 stock and it goes up 20%, a bit more than the minimum would be for a straight AIM sale. Say it calls for you to sell $230 worth, Your cost would be $200 for the stock, $10 commission so your "profit" would be $20, a 10% return. If, however, you set the minimum dollar amount at $460 (just an easy figure to use) which would call for selling $460 and your costs would be $400 for the stock, $10 for the commission leaving $50 "profit", and your rate would be 12.5%. This is not quite accurate as the dollar move would need to be bigger with higher requirement but you get the idea.

Best,

Allen