Filling in secondly intervals between 15:30:00 to 22:00:00 (require more efficient method)

Question

Mate 2u 2012-4-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/34492-filling-in-secondly-intervals-between-15-30-00-to-22-00-00-require-more-efficient-method

I have data in the form of

Hi all I have prices which change every 15 seconds throughout the whole day.

I want to make the the price secondly rather than every 15 seconds. This is so that I can compare it to another second-second data.

Here is a sample of my data:

'26/01/2012 15:29:39' 168.008200000000

'26/01/2012 15:29:54' 168.042200000000

'26/01/2012 15:30:09' 168.022300000000

'26/01/2012 15:30:24' 167.964000000000

'26/01/2012 15:30:39' 167.968800000000

'26/01/2012 15:30:54' 167.964000000000

'26/01/2012 15:31:09' 167.973700000000

'26/01/2012 15:31:24' 167.954700000000

Like I said I want the data to be second-second from 15:30:00 to 22:00:00. So for example:

From the period of 15:30:00 - 15:30:09 we would maintain a price of 168.0422

Then from the period of 15:30:09 to 15:30:24 we would maintain a price of 168.0223 secondly.

I hope I have explained this well and I look forward to all replies.

The "raw" data is calculated 15 seconds and even go beyond 22:00 and is irregular.

"" The program would need to take any data in the form of below and then just give secondly prices from 15:30:00 - 22:00:00.

Thanks

6 个评论
显示 4更早的评论隐藏 4更早的评论

Thomas 2012-4-4

Another thought: why do you just reduce the other value you are comparing this data set to, to be every 15 seconds..

Mate 2u 2012-4-4

Hi Jonathan, Yes I do understand I wont make that mistake again.

Thomas. I have two time series which have the same date formats. One is prices of a particular asset which change many times in a second. I am comparing it to another asset which is "priced" every 15 seconds. I need it every second so that I can decide "trade" decisions every second.

Thanks.

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Jan 2012-4-4

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/34492-filling-in-secondly-intervals-between-15-30-00-to-22-00-00-require-more-efficient-method#answer_43251

在 MATLAB Online 中打开

I try it again. I have no access to Matlab currently. Please test this an post, where it fails together with the error message or an explanation of the difference between your expectations and the results.

C = {'26/01/2012 15:29:39', 168.008200000000; ...
     '26/01/2012 15:29:54', 168.042200000000; ...
     '26/01/2012 15:30:09', 168.022300000000; ...
     '26/01/2012 15:30:24', 167.964000000000; ...
     '26/01/2012 15:30:39', 167.968800000000; ...
     '26/01/2012 15:30:54', 167.964000000000; ...
     '26/01/2012 15:31:09', 167.973700000000; ...
     '26/01/2012 15:31:24', 167.954700000000};
Time     = round(datenum(C(:, 1), 'dd/mm/yyyy HH:MM:SS') * 86400)
allTime  = Time(1):Time(end);
index    = cumsum(ismember(allTime, Time));
Value    = cat(1, C{:, 2});
allValue = Value(index);

3 个评论
显示 1更早的评论隐藏 1更早的评论

Mate 2u 2012-4-4

but it is fine good work I just delete the end points

Matt Tearle 2012-4-4

@Jan: beautiful!

@Mate 2u: Note that Jan just used the first and last points of Time to make the fine-grain time vector. If you want specific values (15:30:00 to 22:00:00) you could just hard-code those in. But also note that Jan's solution is using date numbers scaled up by 86400 (= the number of seconds in a day) so each integer value is a second. Hence:

startTime = datenum('26/02/2012 15:30:00' 'dd/mm/yyyy HH:MM:SS')*86400;

endTime = datenum('26/02/2012 22:00:00' 'dd/mm/yyyy HH:MM:SS')*86400;

allTime = startTime:endTime;

You could even figure out the start and end times automatically, if you had some rationale behind how you chose them.

请先登录，再进行评论。