Discussion of article "Applying OLAP in trading (part 3): Analyzing quotes for the development of trading strategies"
Developing a seasonal theme via olap, nice. You can also use the inbuilt light skl, I guess.
Maxim Dmitrievsky:
Developing a seasonal theme via olap, nice. You can also use the inbuilt light skl, I guess.
Developing a seasonal theme via olap, nice. You can also use the inbuilt light skl, I guess.
I guess you could, but when I started OLAP in 2016, SQL wasn't in MT yet.
I attach source codes of this article, adapted quickly for MT4. They should compile normally, but the full functionality has not been fully tested. Some things are missing in MQL4 and cannot be adequately emulated, in particular, the ArrayPrint function with support for multidimensional arrays and arrays of structures - it is implemented as a simple stub without a nice output with alignment in log lines. Those who wish can improve it. Also here, as well as in the article, the graphical interface was not considered or ported to MT4.
Files:
MQL4OLAP.zip
48 kb
Thanks for the article! Is it correct that OLAP is now fully overlapping in meaning with SQLite capabilities?
fxsaber:
Thanks for the article! Is it correct that OLAP is now fully overlapping with SQLite capabilities?
Thanks for the article! Is it correct that OLAP is now fully overlapping with SQLite capabilities?
Not completely overlap, rather complement each other. OLAP is usually an add-on on top of the database and other data sources. Writing queries in SQL is a chore. The goal of OLAP is to provide a more human interface.

You are missing trading opportunities:
- Free trading apps
- Over 8,000 signals for copying
- Economic news for exploring financial markets
Registration
Log in
You agree to website policy and terms of use
If you do not have an account, please register
New article Applying OLAP in trading (part 3): Analyzing quotes for the development of trading strategies has been published:
In this article we will continue dealing with the OLAP technology applied to trading. We will expand the functionality presented in the first two articles. This time we will consider the operational analysis of quotes. We will put forward and test the hypotheses on trading strategies based on aggregated historical data. The article presents Expert Advisors for studying bar patterns and adaptive trading.
Here is a brief summary of what was implemented in previous articles (if you haven't read them, it is strongly recommended that you start with the first two articles). The core was in the OLAPcube.mqh file which contained:
Specific HTML report related fields were implemented in the HTMLcube.mqh files, in which classes of trades from the HTML report HTMLTradeRecord and the adapter that generates them HTMLReportAdapter are defined.
Similarly, CSVTradeRecord classes of trades from CSV reports and an adapter for them CSVReportAdapter were implemented separately in the CSVcube.mqh file.
Finally, to simplify OLAP integration with MQL5 programs, the OLAPcore.mqh file was written. It contained the OLAPWrapper wrapper class for the entire OLAP functionality used in demonstration projects.
Since the new OLAP processing task addresses a new area, we will need to perform refactoring of the existing code and select the parts of it which are common not only for the trading history but also for quotes or for any data sources.
Author: Stanislav Korotky