i'm fiddling with matlab (no toolboxes added) and am trying to understand how to create x-minute bars from a trade database.
accessing the data from SQL server, i get a cell array, Buy_Data:
Attributes: []
Data: {619134x2 cell}
DatabaseObject: [1x1 database]
RowLimit: 0
SQLQuery: [1x210 char]
Message: []
Type: 'Database Cursor Object'
ResultSet: [1x1 com.microsoft.sqlserver.jdbc.SQLServerResultSet]
Cursor: [1x1 com.mathworks.toolbox.database.sqlExec]
Statement: [1x1 com.microsoft.sqlserver.jdbc.SQLServerStatement]
Fetch: [1x1 com.mathworks.toolbox.database.fetchTheData]
now, the content looks something like:
'2012-08-28 16:48:56.0' [24800]
'2012-08-28 16:48:56.0' [24800]
'2012-08-28 16:49:14.0' [24800]
'2012-08-28 16:49:14.0' [24800]
'2012-08-28 16:49:21.0' [24799]
'2012-08-28 16:49:51.0' [24800]
'2012-08-28 16:49:51.0' [24800]
'2012-08-28 16:49:55.0' [24800]
'2012-08-28 16:49:55.0' [24800]
'2012-08-28 16:49:56.0' [24800]
'2012-08-28 16:49:56.0' [24800]
'2012-08-28 16:49:56.0' [24800]
'2012-08-28 16:49:56.0' [24800]
'2012-08-28 16:49:56.0' [24800]
'2012-08-28 17:00:12.0' [24839]
how do i go about combining 2 of these cell-arrays into a x-minute time series?