DATA Step, Macro, Functions and more

calculating returns

Reply
Contributor
Posts: 50

calculating returns

Dear everyone,

 

I have a data set containing daily stock prices and I would want to calculate the annual abnormal stock returns. To get the annual abnormal stock returns, I need to subtract the annual average stock returns from the returns of the individual stocks. My data looks like this:

GVKEY                              DATADATE                              AJEXDI                PRCCD                          TRFD

002721                               19901227                                1.0377                  0.3000                           1.2415953

 

stock return=(((((PRCCD/AJEXDI)*TRFD)/((PRCCD(PRIOR)/AJEXDI(PRIOR))*TRFD(PRIOR))) -1 )* 100).

 

I would be very grateful if someone could help me the code.

 

Thanks

Super User
Super User
Posts: 7,988

Re: calculating returns

Ask a Question
Discussion stats
  • 1 reply
  • 68 views
  • 0 likes
  • 2 in conversation