# example for Y intercept to zero?

I am comparing the performance of 2 investment portfolios.

To simplify the numbers:

After day 1, portfolio A is up 1.5% and portfolio B is up 1.7%.

After day 2, A is up a total of 2% over the 2-day period, and B is up 2.4%.

After day 3, A is up a total of 2.2% over the 3-day period, and portfolio B is up 2.7%.

And so on.

Now I calculate the percentage-point difference in their returns. So after day 1 it is 1.7 - 1.5 = 0.2. After day 2 it is 2.4 - 2.0 = 0.4. After day 3, 2.7 - 2.2 = 0.5.

Then I chart that %-point difference on an Excel scatter chart. After over a year of this, there is a clear trend. So I use Excel to add a trendline.

The chart’s X axis is a simple series of integers representing each day that an entry is added. I update the chart 5 days a week. So the data are complete (not a sample).

The Y axis is the thing I am interested in: the %-point difference in performance of the 2 portfolios over time.

The first entry for the chart is (1,0.0). (The 0.0 is the first number in the table column, and represents the initial zero difference in performance between each portfolio.) The most recent entry is (426,9.9). The Y column has gone up more or less steadily from 0.0 to 9.9.

Is this one of those rare (I think) cases where I should force the trendline's y intercept to 0? If I do that the line would be somewhat different than it is currently.