Thanks Eric. The ratio from 1990 - 2013 is being calculated in the Show View using the first available price in VIX9D. To ignore this time period, set the Vix data to load from the same first date as VIX9D:
You can then set the Show View to start from the same date to hide the horizontal line:
My other question is if there is no numerator for the ratio before 2013 (there was no data for VX9D), how is the ratio plotted prior to that time frame? 0 divided by any n-value should still be 0.
It’s using the first available price for VIX9D ie 15.81 and backfilling to 1990.
Instead of creating the ratio in a Show View, another option would be to create a new symbol under Data > Custom Codes using the same formula, and it will only calculate it from 2013:
BUT when I close and reopen the workbook or activate other charts in the workbook and then reactivate the chart in which I have entered the start date, the date entered is replaced by the date “12/30/1899”.
It seems that the date I have entered is not “saved”!
This is an issue with the Show View having to be recalculated when the page is reopened. One solution would be to set the main price chart to start on the first bar date of the Show View by changing the Date Range property:
Alternatively, create a dataset using the ratio formula under Data > Custom Code and add that to the chart in a new window instead of the Show View.