<p>You are never going to be able to fill in the gaps exactly, so the best approach may depend on what you want to use the data for.  </p>

<p>One reasonable approach might be to use an average offset from the 10-year rate, e.g. adding about $0.3$ to it.  If you did that, then you would get the red data on the chart below, which compares reasonably well with the actual blue data for the 15-year rate, though not perfectly.  So you might use the red line as a proxy for the earlier missing blue data.  This might not be such a good idea if the purpose of your analysis was precisely considering the changing gap between the 10-year and 15-year rates</p>

<p><a href="https://i.sstatic.net/BMHzF.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/BMHzF.png" alt="enter image description here"></a>  </p>

CC BY-SA 3.0
2017-03-29T00:27:06.357Z
2017-03-29T00:27:06.357Z
Henry
<p>I have <strong>bond yields</strong> for Indian G-Sec. For short term yields the proxy are (15-91 days) , (92-182 days) , (183-364 days). For long term yields the proxy are 5,10 &amp; 15 years. Data ranges from 1996 - 2016.
But the yield values for 15 years bonds are unavailable from 1996 to 1999. So in order to have a complete data-set, i need to compute the 15 year bonds yield those 3 years on monthly basis.</p>

<p>Please check the below link for data file.
<strong><a href="https://spaces.hightail.com/space/9wrYy" rel="nofollow noreferrer">https://spaces.hightail.com/space/9wrYy</a></strong></p>

<econometrics><data-request><statistics>
How to extrapolate the data?
SOUMYAJIT RAY
# How to extrapolate the data?

(Asked by: username_0 on 2017-03-28)

I have **bond yields** for Indian G-Sec. For short term yields the proxy are (15-91 days) , (92-182 days) , (183-364 days). For long term yields the proxy are 5,10 & 15 years. Data ranges from 1996 - 2016.
But the yield values for 15 years bonds are unavailable from 1996 to 1999. So in order to have a complete data-set, i need to compute the 15 year bonds yield those 3 years on monthly basis.

Please check the below link for data file.
**<https://spaces.hightail.com/space/9wrYy>**

**Tags:** econometrics, data-request, statistics

---

## 1 answers

### Answer by username_1 on 2017-03-29. Score: 1

You are never going to be able to fill in the gaps exactly, so the best approach may depend on what you want to use the data for.

One reasonable approach might be to use an average offset from the 10-year rate, e.g. adding about $0.3$ to it. If you did that, then you would get the red data on the chart below, which compares reasonably well with the actual blue data for the 15-year rate, though not perfectly. So you might use the red line as a proxy for the earlier missing blue data. This might not be such a good idea if the purpose of your analysis was precisely considering the changing gap between the 10-year and 15-year rates

[![enter image description here](https://i.sstatic.net/BMHzF.png)](https://i.sstatic.net/BMHzF.png)


---

