New article Exploring Seasonal Patterns of Financial Time Series with Boxplot has been
In this article we will view seasonal characteristics of financial time series using Boxplot diagrams. Each separate boxplot (or
box-and-whiskey diagram) provides a good visualization of how values are distributed along the dataset. Boxplots should not be
confused with the candlestick charts, although they can be visually similar.
Prices have a shift in the average value over time and form trends, therefore the statistical analysis is not applicable to such raw series.
Percentage price changes (price increments) are usually used in econometrics to ensure they all lie in the same value range. The
percentage changes can be received using the pd.DataFrame(rates['close'].pct_change(1))
We need average monthly price ranges. Let us arrange the table so as to receive the average values of monthly increments by years and
display them on the boxplot diagram.
Fig. 1. Average price increment ranges by month, over 10 years.
Author: Maxim Dmitrievsky
Hi, I think some changes in MT5 python api, so need to change code. Later Ill fix it.
I run code:
rates = pd.DataFrame(mt5.copy_rates_range("EURUSD", mt5.TIMEFRAME_D1, datetime(2010, 1, 1), datetime(2020, 1, 1)),
columns=['time', 'open', 'low', 'high', 'close', 'tick_volume', 'spread', 'real_volume'])
and the time I get is sth like '1262563200' which does not make sense, How can this be fixed plz?
Hi, try this
Please enable the necessary setting in your browser, otherwise you will not be able to log in.