data selection
Posted: Sat Apr 13, 2013 4:06 am
Hi, currently I have minute to minute stock index futuresans spot return. I want to re-arrange the data. My original data is order as the following format:
4/19/2012 02:31 0.061260
4/19/2012 02:32 0.000000
4/19/2012 02:33 -0.038283
4/19/2012 02:34 -0.030637
......
But I want to re-rerange it as following:
xxxxxxxxx 02:31 02:32 02:33 02:34 ............................
4/19/2012
4/20/2012
4/21/2012
and I have tried to use the commond "wide +/-" but it can only work out for 5 mins. I want sort all the daily data to one row.
And I attached my data in this file, and the data name in the file is called as "f" and "s".
Many Thanks
4/19/2012 02:31 0.061260
4/19/2012 02:32 0.000000
4/19/2012 02:33 -0.038283
4/19/2012 02:34 -0.030637
......
But I want to re-rerange it as following:
xxxxxxxxx 02:31 02:32 02:33 02:34 ............................
4/19/2012
4/20/2012
4/21/2012
and I have tried to use the commond "wide +/-" but it can only work out for 5 mins. I want sort all the daily data to one row.
And I attached my data in this file, and the data name in the file is called as "f" and "s".
Many Thanks