Export economic calendar data into a sqlite database

MQL5 Скрипты SQL

Работа завершена

Время выполнения 28 минут
Отзыв от заказчика
Delivered earlier, very professional. Excellent!
Отзыв от исполнителя
Appreciate your order Jordi - Client Satisfaction is Top Priority

Техническое задание

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).


    Откликнулись

    1
    Разработчик 1
    Оценка
    (144)
    Проекты
    199
    42%
    Арбитраж
    20
    25% / 55%
    Просрочено
    10
    5%
    Свободен
    Похожие заказы
    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

    Информация о проекте

    Бюджет
    30+ USD
    Сроки выполнения
    от 1 до 3 дн.