how to match daily returns ?
조회 수: 1 (최근 30일)
이전 댓글 표시
hello everyone, i have the dependent variable with daily returns y (1 column ), in the other hand daily returns for the independant variable x (1 column of daily returns). How to pick daily returns from x corresponding to y ( so must have same date) because daily returns could be missing some days in x and assign nan for the missing days in such way to make linear regression!
댓글 수: 2
답변 (1개)
Rik
2017년 2월 9일
So you have two datasets that are sampled over time that you need to resample over a common/matched timeframe? Am I understanding you correctly?
I had something that sounded similar, but my data had different millisecond timestamps. I used interp1 to interpolate to a timestampvector, which would look something like this:
t=unique([y(1,:) x(1,:)]);
y2=interp1(y(1,:),y(2,:),t);
x2=interp1(x(1,:),x(2,:),t);
plot(x2,y2)
And then you can do all the fancy fitting you wish. You need to convert those dates into something that increments normally. I bet 2 second of google will result in a FEX submission that does that for you.
댓글 수: 0
참고 항목
카테고리
Help Center 및 File Exchange에서 Get Started with MATLAB에 대해 자세히 알아보기
제품
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!