correlation custom report - NAs

[Tintin11]

Hi all
I am trying to create a R squared and correlation metrics report. I am putting my benchmark in the option field, but I get only NAs for all shares listed. How do I fix this? What could be the cause of this? The prices of the benchmarks are all downloaded correctly.
Thanks

[Mark]

Hi Tintin11,

The most likely cause is missing prices, or too tight of yield interpolation range settings. You need monthly returns for your comparison period. If you're missing any of these monthly prices, you will get an N/A. The way to easily find out is to use "Help / Report Calculation Log..." from within the report showing the N/A figures. It will explain why you're getting each N/A.