Hello everyone,

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 would like to create a variable using the current exchange rate data I have to calculate and illustrate the daily change in the exchange rate on days affected by Brexit and contrast these with dates not affected by Brexit.

My data has the 'open price' and 'close price' of certain exchange rates per day as two separate variables (see below) alongside the date as a float variable.

open
1st day - 1.275234
2nd - 1.251878
3rd - 1.262897
4th - 1.273285
5th - 1.278691

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

I essentially would like to create a variable which performs the basic percentage change formula (Close - Open / Open (x100) ) for each day of my data.

Any guidance on how to create such a variable would be much appreciated.