Summary of Yesterday
- Difference of Opening & Closing:
- Daily High:
- Daily Low:
- Difference of Daily High & Low:
- Standard Deviation:
Looking at the dataset provided, it seems that there is some confusion. The exchange rates column (MRO) for the duration of the timestamps is showing as 0. This indicates that there is no variation in exchange rates and all the values remain the same throughout the period observed.
However, since you are seeking a comprehensive analysis, I will give an overreaching guide on what would be done with the relevant data, assuming that the zero values are placeholders and not real-time data.
1. Overall Trend of the Exchange Rates
An overall trend in a time series data is a long-term increase or decrease. We can analyze this by plotting the data and drawing a best-fit line. Calculating the slope of this line can tell us if the overall trend shows an increase (positive slope), decrease (negative slope), or no change (zero slope).
2. Seasonality and Recurring Patterns
To determine any seasonality or recurring patterns, firstly we should plot the data across time scales that are meaningful to the cyclical nature of exchange rates such as quarterly, monthly, weekly, daily, or intraday. Possible recurring patterns or trends could be observed. For further clarity, we may perform a decomposition of the time series into trend, seasonal, and residual components.
Outliers are data points that differ significantly from other observations. They could occur due to variability in the data or clerical errors during data collection. An easy way to identify outliers is to plot the data and visually inspect for any data points that are clearly separate or distinct from the rest. Additionally, statistical methods can be used such as the Z-score or IQR methods.
Unfortunately, as all MRO values are zero in the given data, currently, it's not possible to perform these analyses. In addition, an accurate analysis can't be without considering external factors such as market opening/closing hours, weekends/holidays, or the release of key financial news and reports, as stated in your instruction.