Hi Vitali, I added a column with the %/year PC increment which I enter manually, however by default the next value is copied from the previous date, so unless I change it it stays the same.
Whatever date I enter into the spreadsheet the PC is correctly incremented by that value.
If I see that the ETF is in a correction I set my subsequent PC increment to zero until it starts to pick up again. I don't want to be betting against the market. But I never decrease the PC. I bet on a rising market in the long run and decreasing the PC would risk selling at a loss. This is consistent with AIM method which does not decrease the PC,
The idea is that diversified funds follow the market which increases in the long run so I let those ETFs run up without selling up to a certain point. I find it easier and less work than doing Vealies. The Vealie concept may be better for individual stock or a very specialized ETFs, since these do not necessarily follow the market. My PC increment has done well with the recent rising market from building up excessive cash. Otherwise I would have had to do repeated Vealies.
The underlying premise in AIM is that the security either recovers or increases but never goes into a perpetual decline. If this is not met the system fails. It's like dollar cost averaging, a method not for individual stocks but for investing in funds.
Adam