Calculating Prices Between Two Time Periods

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Steve, EViews Moderator, EViews Jason

JaChel
Posts: 1
Joined: Wed Oct 08, 2014 2:40 am

Calculating Prices Between Two Time Periods

Postby JaChel » Wed Oct 08, 2014 2:47 am

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? :))

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13603
Joined: Tue Sep 16, 2008 5:38 pm

Re: Calculating Prices Between Two Time Periods

Postby EViews Gareth » Wed Oct 08, 2014 8:15 am

Did you use the log function in Excel or the ln function?


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests