Export economic calendar data into a sqlite database

MQL5 Sripts SQL

Trabajo finalizado

Plazo de ejecución 28 minutos
Comentario del Cliente
Delivered earlier, very professional. Excellent!
Comentario del Ejecutor
Appreciate your order Jordi - Client Satisfaction is Top Priority

Tarea técnica

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


    Han respondido

    1
    Desarrollador 1
    Evaluación
    (144)
    Proyectos
    199
    42%
    Arbitraje
    20
    25% / 55%
    Caducado
    10
    5%
    Libre
    Solicitudes similares
    1.Sinyal Perdagangan : Sinyal beli: garis MACD utama memotong garis sinyal ke atas (macd_current>signal_current && macd_previous<signal_previous). Sinyal jual: garis MACD utama memotong garis sinyal ke bawah (macd_current<signal_current && macd_previous>signal_previous). Gambar di bawah menunjukkan kasus beli dan jual. 2. Posisi ditutup pada sinyal yang berlawanan: Posisi beli ditutup pada sinyal jual, dan posisi
    can anyone help me with building a complete automated pine code strategy and indicator that work for both FXs & CFDs and have a high winning rate proved through back testing. I have a very complex current code that developed mostly using AI but lots of gaps are there although it translate exactly what I have in my mind. So, you are free to decide whether wo build a complete new code or fix my current working code ( i
    I want to buy the EA today, Provide me with demo ex5, proof of profitability and Proof that the EA is profitable in your application. *NO Martingale* or Avaraging down
    Pazuzu 30+ USD
    generate or create me a python coded file that has mql5 language requirements for a trading bot under the following instructions. the bot must execute trades if necessary the bot must trade 24/7 the bot must trade gold and currency the bot must make unlimited profit hourly the bot must enter market with caution after market analysis of 98 percent of clear trade

    Información sobre el proyecto

    Presupuesto
    30+ USD
    Plazo límite de ejecución
    de 1 a 3 día(s)