How can i fill intermediate dates?
2 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Fernando Galdames Paredes
am 5 Jun. 2014
Kommentiert: Star Strider
am 5 Jun. 2014
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
0 Kommentare
Akzeptierte Antwort
Star Strider
am 5 Jun. 2014
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.
2 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Time Series Objects finden Sie in Help Center und File Exchange
Produkte
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!