Hello,

I am writing my dissertation thesis on the impact of Brexit negotiations on the value of the pound in 2019. To do this, I am empirically testing the change in several exchange rates as a result of news developments concerning Brexit.

I want to create a variable that measures the percentage change between the close price of each day.

My data is set up as follows:

close
1st day - 1.275429
2nd - 1.252191
3rd - 1.262881
4th - 1.273496
5th - 1.278609

I want to create a variable that performs the rate of returns formula, which in this instance would be: close - close-1 / close (e.g. with a above data: 1.252191 - 1.275429 / 1.252191)

Any advice on how to create this variable would be much appreciated.