How can i fill intermediate dates?

2 次查看(过去 30 天)
Hi
I have a matrix with dates and prices.(Nx2) I know there is a function that can create a new matrix that fills all the dates missing in the matrix using the last price available.
For example:
('05-20-2014' 800 ;'05-24-2014' 850) => ('05-20-2014' 800;'05-21-2014' 800 ;'05-22-2014' 800;'05-23-2014' 800;'05-24-2014' 850)
Best Regards

采纳的回答

Star Strider
Star Strider 2014-6-5
Use the interp1 function.
First, convert your date to date numbers with the datenum function. It gives days and decimal fractions-of-days, so you only need to specify integer date ranges for interpolation.
The interp1 function will interpolate all the columns in every row of your matrix you want to interpolate.

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Time Series Objects 的更多信息

标签

产品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by