Hi toofuzzy, the best way is for you to download it and play with it! But to answer your questions.
If you were investing monthly or even quarterly, do you ever get to invest more than 100% to use up the cash you didn't invest in the past? Or do you just use the % of the cash you have already set aside?
The answer is, yes you can invest more than the monthly installment. The percentage is applied to the total portfolio value.
So if I have $1000 and I am adding $200 this month so I have $1200. If the formula tells me to invest 50% do I invest $100 or do I invest $600?
When you set up the spreadsheet, you put your $1,000 in and at a 50% you would be directed to invest $500 in to stock. The next month you have $200 to invest, If the stock price has remained in the same price, all the $200 would go to cash. Once the price moves then the portfolio will be rebalanced to the new ratio.
I do need people to download and play with the spreadsheet and give me feedback on this feature, is it good or bad? Do you think it would be better to rebalanced even though the price did not move? I can see debating it either way.
Come see me at Systematic Investing group #board-966 lets talk formula plans.
