Export economic calendar data into a sqlite database

MQL5 Scripts SQL

Tâche terminée

Temps d'exécution 28 minutes
Commentaires du client
Delivered earlier, very professional. Excellent!
Commentaires de l'employé
Appreciate your order Jordi - Client Satisfaction is Top Priority

Spécifications

Description:

The purpose of this MQL5 script is to export all the economic calendar data from MQL5 into a SQLite database, using MQL5 Economic Calendar API: https://www.mql5.com/en/docs/calendar

    Requirements:

    1. Launching the script will ask for 3 parameters:
      1. database name, default to "economic.db",
      2. initial date, default to "Jan 1st 2010", and
      3. final date, default to 0.
    2. Create a sqlite database with the name specified as script parameter.
    3. Create tables: MqlCalendarCountryMqlCalendarEvent and MqlCalendarValue tables with the exact data structures https://www.mql5.com/en/docs/constants/structures/mqlcalendar (Note: ENUM types can be strings representing its value).
    4. Iterate over CalendarCountries function results and UPSERT values in the corresponding table
    5. For each Country in CalendarCountries, Iterate over CalendarEventByCountry function results and UPSERT values in the corresponding table
    6. For each Event in CalendarEventByCountry, iterate over CalendarValueHistoryByEvent function results and UPSERT values in the corresponding table. Due to the amount of results on this call, if during the development process you get memory errors, consider slicing the date range and iterate smaller ranges.

    Technical details:

    Acceptance criteria:

    • Running the script will create a new database and the tables (Steps 1 and 2)
    • The table MqlCalendarCountry will contain the data from CalendarCountries (Step 3)
    • The table MqlCalendarEvent will contain the events from the countries listed (Step 4)
    • The table MQLCalendarValue will contain the values from events listed (Step 5).


    Répondu

    1
    Développeur 1
    Évaluation
    (144)
    Projets
    199
    42%
    Arbitrage
    20
    25% / 55%
    En retard
    10
    5%
    Gratuit
    Commandes similaires
    I’m building a trading signal platform called Tradexa focused only on US30 and Nasdaq. I need you for Phase 1: to build the signal engine/logic side. The system must use strict top-down analysis (H4 → H1 → M15) and generate M15 trade signals only when all conditions are met, including liquidity sweep, structure shift, retest, SL and multiple TPs. I already have a detailed rule sheet for the strategy and signal
    Title Professional AI Automation Trading Bot for Forex & Crypto Solution Language Python (preferred) or MQL5 depending on integration requirements. Categories Expert Advisor (EA) for MetaTrader 5 Automated trading strategies AI/ML-based signal generation Risk management automation Required Skills Strong knowledge of MQL5/Python Experience with MetaTrader API integration Machine learning model deployment

    Informations sur le projet

    Budget
    30+ USD
    Délais
    de 1 à 3 jour(s)