Export economic calendar data into a sqlite database

MQL5 Komut dosyaları SQL

İş tamamlandı

Tamamlanma süresi: 28 dakika
Müşteri tarafından geri bildirim
Delivered earlier, very professional. Excellent!
Geliştirici tarafından geri bildirim
Appreciate your order Jordi - Client Satisfaction is Top Priority

İş Gereklilikleri

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


    Yanıtlandı

    1
    Geliştirici 1
    Derecelendirme
    (144)
    Projeler
    198
    42%
    Arabuluculuk
    20
    25% / 55%
    Süresi dolmuş
    9
    5%
    Serbest
    Benzer siparişler
    see trade open on every tick seconde ok forex pair us us30 if is current running at 40170.00 so open 2 trade buy stop and sell stop both in every tick pending order of buy stop will 40171.00 and sell stop pending order will be 40169.00 buy stop will open at 40171.00 and tp will be 40173.00 and SL will be 40169.50 ok if buy stop hit sell stop order automatically will be close now if sell stop order open at 40169.00 so
    Hi Teams Looking for trading strategy or an EA, which can trigger trade, in XAUUSD, With fixed SL of 2 USD AND TP OF 3 TO 5 USD. Any strategy any time frames. Can work on lowest size
    Looking for a programmer to code EA for Buy Stop/Sell Stop HFT Trading designed for Ger40 EA must be able to trade on live account and Dll must be used for EA speed slippage control and spread filter
    i want a forex robot that will read chats and enter trades on its oown. i want it to be able to use all trading strategies and partterns. good risky manegmemt, i want it to forcuse on Gold and and all major forex pairs. i want it to use stop loses and take profits as the market might change direction anytime. i want to work on both mt5 and mt4
    Saya memerlukan Expert Advisor berdasarkan sinyal AOX. Itu harus memiliki pemeriksaan dan penanganan kesalahan operasi perdagangan. Kriteria utama pembukaan dan posisi penutupan: ■ arah rata-rata bergerak ■ harga lebih tinggi dari bar sebelumnya. Lot perdagangan adalah parameter masukan
    I need to automate the supertrend indicator on ctrader with partial tp and sl. I already have a sort of script (without tp and sl) but when I go to compile it gives me an error. would you be able to make it work by adding the partial tp and sl
    Skarito98 30 - 100 USD
    Always stay winning and survive....we all want a better life now this is a chance someone can take,to change their lives for the better.No one is supposed to suffer in this world,we create and invert new things and come up with ideas to solve situations we come across especially when it comes to finance. We all need better things in life and God want good things for us
    I believe in Robotics as a major artificial intellect to function of growth of business.Therefore if you script there is a likelihood of bringing economies of scale.The retrospective of the dynamics of indulgence of work can be economics of scale
    there I hope you're doing well I want to convert the tradingview indicator to make an indicator for mt5. And in that, I want to make an automatic robot on the base of the indicator. I have the pine script of that indicator
    Need ea according to stochastic divergence (both hidden and regular) plus candlestick flip .. need for experinced developers to complete my order with 99percent accuracy. So bet for it the budged is fixed and other plugins will be added in the v2

    Proje bilgisi

    Bütçe
    30+ USD
    Geliştirici için
    27 USD
    Son teslim tarihi
    from 1 to 3 gün