Sunday, December 6, 2020

How to transform the Datastream Format to Panel Data? Could you help me please?

I hope I could transform my data to the format below. There should be four columns and for different Tickers.
Array


But the DataStream gave me the data like below.

Array

I have attached the two files(one with my target format, one with the DataStream format) for your convenience. For the target format, I only list two stocks but actually it should has more. Just use it as an example.

Could you help me? Thanks very much!!!!!!!

Sofia

No comments:

Post a Comment