https://communities.sas.com/t5/SAS-Programming/calculating-returns/m-p/405225#M98555 <P>Is this not covered in one of the 600 posts returned by a search:</P> <P><A href="https://communities.sas.com/t5/forums/searchpage/tab/message?advanced=false&amp;allow_punctuation=false&amp;q=calculating+returns" target="_blank">https://communities.sas.com/t5/forums/searchpage/tab/message?advanced=false&amp;allow_punctuation=false&amp;q=calculating+returns</A></P> Wed, 18 Oct 2017 14:23:55 GMT RW9 2017-10-18T14:23:55Z https://communities.sas.com/t5/SAS-Programming/calculating-returns/m-p/405198#M98543 <P>Dear everyone,</P><P>&nbsp;</P><P>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:</P><P>GVKEY&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DATADATE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AJEXDI&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; PRCCD&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TRFD</P><P>002721&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;19901227&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;1.0377&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;0.3000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1.2415953</P><P>&nbsp;</P><P>stock return=<SPAN>(((((PRCCD/AJEXDI)*TRFD)/((PRCCD(PRIOR)/AJEXDI(PRIOR))*TRFD(PRIOR))) -1 )* 100).</SPAN></P><P>&nbsp;</P><P><SPAN>I would be very grateful if someone could help me the code.</SPAN></P><P>&nbsp;</P><P><SPAN>Thanks</SPAN></P> Wed, 18 Oct 2017 13:27:03 GMT https://communities.sas.com/t5/SAS-Programming/calculating-returns/m-p/405198#M98543 Theo_Gh 2017-10-18T13:27:03Z https://communities.sas.com/t5/SAS-Programming/calculating-returns/m-p/405225#M98555 <P>Is this not covered in one of the 600 posts returned by a search:</P> <P><A href="https://communities.sas.com/t5/forums/searchpage/tab/message?advanced=false&amp;allow_punctuation=false&amp;q=calculating+returns" target="_blank">https://communities.sas.com/t5/forums/searchpage/tab/message?advanced=false&amp;allow_punctuation=false&amp;q=calculating+returns</A></P> Wed, 18 Oct 2017 14:23:55 GMT https://communities.sas.com/t5/SAS-Programming/calculating-returns/m-p/405225#M98555 RW9 2017-10-18T14:23:55Z