Hi Tom, on the Twinvestnew spreadsheet, I had evidently been tired when I uploaded it, not all values are set the same in all the sheets of the spreadsheet. Opps, sorry! when you open up the spreadsheets you need to set the initial stock price (A4) I think on all the Twinvest sheets to $4 dollars.
The prices I used are prices I made up, they start at $4 and end up at $19 ten years later and bounce around a lot!
The first sheet is plain DCA
The 2ed sheet is plain Twinvest
The 3rd sheet is Twinvest, where you add a percent of cash on hand to the new money coming in. This really comes into play after a sell I also let you determine at what percent profit you sell at. Original Twinvest was set at 100% profit, I think it should be set at around 50%.
One of the things I like about Synchrovest and Aim is they are dynamic in nature, the point where they buy and sell changes over time. To me Twinvest with a fixed code is static it will keep buying at the same price points. True the code does change when you do a sell. But I was trying for a (dynamic code).
The 4th sheet uses the 52 week Hi and Low prices to determine a dynamic code (because I am using fake prices, I had to fake the 52 week hi/low prices also), but it does produce a moving code.
The 5th sheet uses a moving average of price to calculate the code with.
The 6th sheet uses a combo of the Hi/Low price and the Moving Average to determine the code. ((Hi+Low/2)+MA)/2= number used to determine code.
I through these sheets together in a hurry in 2004, and uploaded them, to get peoples opinions on them. I got no reaction at the time.I am not saying they are better then the original Twinvest just different.
Come see me at Systematic Investing group #board-966 lets talk formula plans.
