Discussing the article: "Market Simulation (Part 20): First steps in SQL (III)"
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
Check out the new article: Market Simulation (Part 20): First steps in SQL (III).
In the previous article, « Market Modeling (Part 19): First Steps in SQL (II)», we explained how to use scripts to add, modify, and even delete records in a database. However, to truly make progress in the explanation, we will need a database that contains a minimum of elements. This will allow you to truly understand what will be explained.
Although we can work with a database containing about 10 records, it will be easier to understand when we use a file with more than 15 thousand records. That is, if we tried to create such a database manually, this task would be enormous. However, it is difficult to find such a database, even for educational purposes, that is available for download. But in reality, we don’t need to resort to that — we can use MetaTrader 5 to create a database for ourselves. Although it won't be perfect, it will at least contain a large number of records. And that is exactly what we need.
To understand how we will do this—that is, use MetaTrader 5 to create a database and study the next topic—we need to go back a little in time.
There are people and even small organizations that use Excel as a database. Many of you may not believe this or may not notice that it happens. But it's not only Excel that is used this way; there are many other programs that are also used similarly. But for now, we will limit ourselves to Excel. When we use Excel as a database program, a corresponding option appears in the Excel ribbon settings. The image below shows what is meant.
Author: Daniel Jose