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
댓글 수: 0
채택된 답변
Star Strider
2014년 6월 5일
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
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Time Series Objects에 대해 자세히 알아보기
제품
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!