Loop between dates using the value for that date

Hi:

I want to create a loop but not depending on the position of the value in an array, I want to create it dependent on a certain time:

I manage to create a timetable with the data I want :

Im starting with Matlab and therefore I dont know if it is the best way or not to do this.

My aim is to do a loop in the following way. For example:

if true
  for i= {2015-12-31 10:00}:{2015-12-31}
Pup=UP/1000
Pdown=DOWN/1000
Pelspot=ELSPOT/100
%Im not just dividing in the the code, i will get an output that I will store, but I want the ouput for that certain time)
end

My problem is that I dont know how to tell MATLAB, use the data for this certain date ( now is easy but after I will use a table with 52 000 values were dates are repeated and I want to be sure MATLAB links the DATE with the data in this loop).

Thanks in advance

Answer 1

[Peter Perkins]

Probably a loop is not what you want. It's possible that you want to do something like this:

i = isbetween(datime.Time,'31-Dec-2015 10:00:00','1-Jan-2016 00:00:00'}
Pup=datime.UP(i)/1000
Pdown=datime.DOWN(i)/1000
Pelspot=datime.ELSPOT(i)/100

Hard to say without more to go on. You could also use timerange:

tr = timerange('31-Dec-2015 10:00:00','1-Jan-2016 00:00:00')
Pup=datime.UP(tr)/1000
Pdown=datime.DOWN(tr)/1000
Pelspot=datime.ELSPOT(tr)/100

Answer 2

[Mikhail Skalyga]

Oh, man, I am taking the same course at DTU right now. Have you found out how to loop over date eventually?