Export economic calendar data into a sqlite database

MQL5 Skripte SQL

Auftrag beendet

Ausführungszeit 28 Minuten
Bewertung des Kunden
Delivered earlier, very professional. Excellent!
Bewertung des Entwicklers
Appreciate your order Jordi - Client Satisfaction is Top Priority

Spezifikation

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


    Bewerbungen

    1
    Entwickler 1
    Bewertung
    (144)
    Projekte
    199
    42%
    Schlichtung
    20
    25% / 55%
    Frist nicht eingehalten
    10
    5%
    Frei
    Ähnliche Aufträge
    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

    Projektdetails

    Budget
    30+ USD
    Ausführungsfristen
    von 1 bis 3 Tag(e)