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.
Related Posts with Percentage change of daily exchange rate data
Pvar errorDear Statalisters, I have an unbalanced panel dataset and I'd like to conduct a Granger Causality t…
ARIMA forecasting - non-normal residualsHi everybody, I am trying to do an ARIMA forecast of hospital examinations with daily time-series d…
Linearity panel dataHi everyone. I am working on a regression on the overestimation of companies, and I'm working with p…
Fixed Effects EstimationI am trying to run a fixed effects regression but unfortunately having some issues. I hope someone c…
operators and how my data is arrangedHello, I use panel data that I have set via Code: mi xtset id survey With id being the identifi…
Subscribe to:
Post Comments (Atom)
0 Response to Percentage change of daily exchange rate data
Post a Comment