Drexel dragonThe Math ForumDonate to the Math Forum



Search All of the Math Forum:

Views expressed in these public forums are not endorsed by Drexel University or The Math Forum.


Math Forum » Discussions » Software » comp.soft-sys.matlab

Topic: How to fill missing data in excel time series - Matlab
Replies: 0  

Advanced Search

Back to Topic List Back to Topic List  
Giorgio Monti

Posts: 2
Registered: 10/25/12
How to fill missing data in excel time series - Matlab
Posted: Jan 29, 2013 12:18 PM
  Click to see the message monospaced in plain text Plain Text   Click to reply to this topic Reply

Hi,

I need a hand on this problem: In an Excel workbook I reported 10 time series (with monthly frequency) of 10 titles that should cover the past 15 years. Unfortunately, not all titles can cover the 15-year time series. For example, a title only goes up to 2003; So in the column of that title, I have the first 5 years with a "Not Available" instead of a value. Once I?have imported the data into Matlab, obviously, in the column of the title with the shorter series appears NaN where there are no values.

Prices xlsread = ('PrezziTitoli.xls')

whos

% Name Size Bytes Class Attributes % Prices 182x10% 6360 double

My goal is to estimate the variance-covariance matrix, however, because of the lack of data, the calculation is not possible for me. I thought to an interpolation, before the calculation of the variance-covariance matrix, to cover the values that in Matlab return NaN, for example with a "fillts", but have difficulties in its use.

There is some code that can be useful to me? Can you help me?

Thanks!



Point your RSS reader here for a feed of the latest messages in this topic.

[Privacy Policy] [Terms of Use]

© Drexel University 1994-2014. All Rights Reserved.
The Math Forum is a research and educational enterprise of the Drexel University School of Education.