Page 1 of 1

Calculating Prices Between Two Time Periods

Posted: Wed Oct 08, 2014 2:47 am
by JaChel
Hi guys, I am trying to calculate an equation Rt=log Pt- logPt-1. After importing the data, I generated a new series by adding the equation returnaxp=log(axp)-log(axp(-1)). However, the values I obtain are different when I use Excel and I trust my excel more than EViews, as it is my first time using it. Can someone tell me what went wrong please? :))

Re: Calculating Prices Between Two Time Periods

Posted: Wed Oct 08, 2014 8:15 am
by EViews Gareth
Did you use the log function in Excel or the ln function?