Export economic calendar data into a sqlite database

MQL5 Scripts SQL

Job finished

Execution time 28 minutes
Feedback from customer
Delivered earlier, very professional. Excellent!
Feedback from employee
Appreciate your order Jordi - Client Satisfaction is Top Priority

Specification

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


    Responded

    1
    Developer 1
    Rating
    (144)
    Projects
    198
    42%
    Arbitration
    20
    25% / 55%
    Overdue
    9
    5%
    Free
    Similar orders
    I need a AI signal generating bot for forex trading. The bot should operate such that when i put it in a chart it will analyse the market, after several minutes it will display whether the trade is buying or selling. It should display the one minute, five minute,15minute, 30 minute, one hour, 4 hours and daily time frame whether they are buying or selling. If it is buying the arrow should be green and if it is
    Using Bollinger Band only. When price closes above upper BB, open Buy. If the length of the candle body that closed above the upper BB is more than Y pips, then do not Buy and remove the EA. Otherwise, continue to open Buy if crosses and close above upper BB and the number of positions is not more than Max No of Positions. The user will choose either Buy or Sell only. When price closes below the lower BB, close all
    Hello freelancers here, I need an expert to help me with coding my script which is already working in pinescript, Moreover, i want a system whereby i can sell my trading bot and can give access with a license, I need an expert that can help me with this
    Hello freelancers here, I need an expert to help me with coding my script which is already working in pinescript, Moreover, i want a system whereby i can sell my trading bot and can give access with a license, I need an expert that can help me with this, and my budget is $20, Thank you
    Hello freelancers here, I need an expert freelancer to help me convert an expert advisor from MT4 to MT5. I have the MT4 source code, As for now i only got $15 for this project i don't have much on me at the moment, So i need someone who can work long terms cause i still have other projects i need him to work on for me
    An EA based on Fibonacci 100 - 750 USD
    I am in need of 3 EA based on Fibonacci re-tracement after a high or low is made,each EA will have a hedge trade on it.the hedge trade will be at the 50 percent of the Fibonacci..this will be present on all 3 EA, all three EA will have different levels of re-tracement, while the hedge trade will be a continuation (buy/sell stop), while the re-tracement trades will be (buy/sell limit)This EA must work on timeframe
    Need a good synthetic EA 50 - 1000 USD
    I don't have specifications. If you're good at building an EA with good coding, accuracy, 85% money management, good trading decision. Please apply let's discuss Bussiness. Price below is not specific we can discuss new price depending on your professionalism
    I don't see signals on the chart .... On mt4 it's perfect...but when I converted it to Tradingview by a guy on this platform it doesn't show any signals, kindly bid on it and let me know if you can do it, And also check it thoroughly that you can do it okay
    I don't see signals on the chart .... On mt4 it's perfect...but when I converted it to Tradingview by a guy on here it doesn't show any signals, I need an expert that can help me to work on it, that can also work on more projects, Thanks, I have $20 for this project now, If you think is too small and you want to charge $30, i can pay you the rest later on
    can anyone here help me with develop a Pine script on TradingView's Pine Editor for a trading strategy based on certain variations of the Morning Star candlestick pattern which I have been noticing from last 2 years

    Project information

    Budget
    30+ USD
    For the developer
    27 USD
    Deadline
    from 1 to 3 day(s)