When running a historical sequence analysis with starting year 2001, a row of "#REF!" entries is inserted in the year where the analysis should switch over to fixed returns, since historical return data has been exhausted at that point (page 134 in the PRC2024-Gold-Users-Manual.v2.1-cd4rpo).
The "#REF!" entries are always at the end of the known historical data set (regardless if I pick 2001 or 2010 as a starting point). This is occurring in version PRC2024.2.3.3, and I have tried starting from clean copy, but the problem remains.
@johnlisa Yes, and that's because you're using PRC2024 with a model starting year of 2025. The model appears to have a bug that causes that. I'll try to get that fixed in the 2025 model which I expect to release in the next few days. I may make a fix in the 2024 model but I'm not sure at this point.
Stuart
