[R-SIG-Finance] Transforming Price Timeseries

Johannes Lips johannes.lips at googlemail.com
Thu Apr 21 21:55:55 CEST 2011


Hello,

I have a little problem for which I don't have a solution. I have 
electricity prices for each hour of the day, since that's the normal 
form of contracts traded at energy exchanges.

The current format looks like this:
         Date EEXHR01 EEXHR02 EEXHR03 ... EEXHR22 EEXHR23 EEXHR24
1 2000-06-16   12.43   12.40   12.40 ... 15.45   14.57   14.57
2 2000-06-17   10.06   10.04   10.04 ... 12.82   12.83   12.82
3 2000-06-18   10.08   10.08    9.00 ... 11.78   11.80   11.78
4 2000-06-19   12.05   12.05   10.05 ...  16.42   14.95   14.95

I now would to transform this daily data into hourly data and make a 
'continous' time series. Something like:
Date			EEXPrice
2000-06-16-01:00	12.43
2000-06-16-02:00	12.40
.			.
.			.
.			.
2000-06-16-24:00	14.57

Is this possible with R or should I use something different?
If you need more information, just ask, pleas.

Thanks in advance!

Best Regards,

Johannes



More information about the R-SIG-Finance mailing list