Thanks Steve
I changed $ Available to $100,000 because $10,000 with Min Buy of $1000 caused the Min Buy $ to over-ride the calculated number of shares to be bought (which made it difficult to understand how it all works.
However, keeping $ Available at $10,000 and changing Min Buy to $800 allows the spreadsheet to show how it all works out in theory - to me anyway. (In practice, with commission charges, Min Buy of $1000 is probably advisable).
The emphasis in discussions on this seems to be on running out of stocks to sell rather than about not having enough cash reserve if the market drops - for me, with the current state of the market, and using sector ETFs it seems most unlikely that prices will go straight up more than 50% from here and therefore allowing for 3 sells looks OK (from the work tables 3 sells allows for 54.3% price appreciation). I'm more concerned about prices dropping 30 to 40% and, with Min Buy $ of $800, allowing for 5 buys requires a cash reserve of about $4,500 (from the work tables 5 buys allows for a 30% price drop). The $2,700 of $ Saved over Classic AIM I'd probably put aside until the markets revert to more normal valuations (if they ever do).
I'm still thinking about this - I like working with a mechanical method such as AIM but with current valuations I'm uncomfortable with the buy&hold part of Classic AIM - using LD AIM and keeping the $ Saved for investing later when the markets are more normal means that I could use AIM and feel happier about it.
ken
AI
Market Data 
Markets 
