[R-sig-Finance] Data management question

Carlos J. Gil Bellosta cgb at datanalytics.com
Tue Jul 4 16:27:41 CEST 2006


Try ?reshape

Carlos J. Gil Bellosta
http://www.datanalytics.com


Quoting "Daye, Wilfred" <wilfred.daye at dbzco.com>:

> I have a text file data that looks like this
>
> Date	ticker	price
> 06/1/06	A	x1
> 06/2/06	A	x2
> ;;	;;	;;
> 06/1/06	B	y1
> 06/2/06	B	y2
> ;;	;;	;;
> 06/1/06	C	z1
> 06/2/06	C	z2
> ;;	;;	;;
>
> So on
>
> I want to arrange tickers as column fields and match the time series
> price by date.
> To be
>
> Date	A	B	C
> 06/1/06	x1	y1	z1
>
>
> The time series per ticker does not necessarily equal to those of others
>
> Thx in advance



More information about the R-SIG-Finance mailing list