Excel errors (#VALU...
 
Notifications
Clear all

Excel errors (#VALUE!) on Monte Carlo report graph when returns are bad

2 Posts
2 Users
0 Likes
95 Views
(@wmchbaker)
Active Member Customer
Joined: 10 months ago
Posts: 6
Topic starter  

They're in the column labeled success rate in the screenshot


   
ReplyQuote
Topic Tags
(@smatthews51)
Member Admin
Joined: 4 years ago
Posts: 729
 

@wmchbaker This is the result of a test scenario never envisioned in the PRC design and which is not handled gracefully by the code: your modeling period is only four(4) years in duration and the column where you're seeing the errors presents the success rate for the last 10 years of the modeling period. The six years where you're seeing the #VALUE errors are the six years prior to the modeling period. This "error" will likely never be fixed.

Stuart


   
ReplyQuote
Share: