I need help in reshaping my data. The desired variable are date, name, code, and return.
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input str10 name str19(AVIC PSP ZEGONA HEALTHCARE ULKER CRE) "Code" "CNE000001JY5(RI)~U$" "CH0018294154(RI)~U$" "GB00BVGBY890(RI)~U$" "US42225P5017(RI)~U$" "TREULKR00015(RI)~U$" "JP3048680007(RI)~U$" "20/04/2018" "225.17" "480.76" "131.5" "162.21" "230.28" "0.95" "23/04/2018" "213.22" "479.75" "131.45" "162.41" "228.27" "0.94" "24/04/2018" "220.69" "475.64" "131.6" "163.59" "232.75" "0.94" "25/04/2018" "216.4" "472.13" "135.19" "160.56" "228.58" "0.94" "26/04/2018" "215.8" "475.24" "140.95" "160.95" "225.26" "0.94" "27/04/2018" "209.17" "477.98" "139.58" "163.46" "231.71" "0.95" end
Comment