MT4 to Google SpreadSheet (live with DLL using Google Dev API)

Tarea técnica

I am looking for metatrader interation with cloud based software platform (something easy to use & easy access like Google SpreadSheet). Preferebly using DLL so that we dont have to key in the url to the webrequest.

The end goal is to use and save data on live. 


When the program saving the file to the excel or google sheet, it should save two main element Account detail (1st part) & Trade result (2nd part). This non-tradable EA will only trigger once there are any closing trade

  1. Account name
  2. Acc ID
  3. Balance
  4. Equity
  5. (Balance - Equity) / Balance * 100% = (AKA drawdown %) - Check if the balance is empty or not
  6. Current Symbol
  7. Current Timeframe
  8. Broker time
  9. Local time
  10. Broker name
  11. EA magic number (if dont have then 0)
  12. EA / Script / indicator name (for testing, make it available as a string input)
  13. Blank column - To sepererate session (if cant blank then just put a place holder like "-")
  14. OrderTicket
  15. OrderOpenTime
  16. OrderCloseTime
  17. OrderProfit (in Dollar)
  18. MAEinDollars
  19. MFEinDollars
  20. Holding duration (Close - Open time in minute)
  21. Holding duration (Close - Open time in hour)
  22. OrderProfit (in Point)
  23. MAEinPoints
  24. MFEinPoints
  25. TimeOfMAE
  26. TimeOfMFE
  27. Blank column - To sepererate session (if cant blank then just put a place holder like "-")
  28. Parameter list (Source: https://www.mql5.com/en/forum/191721#comment_5693578) - Optional


Input: Download data after Deinit = True;

By default, When the program deinit, it will download the google sheet to local in CSV format. And Print in the expert tab, where is the file location.


Make the program into function that called inside the start(). Soemthing like

int start(){

        if(trade has been closed) GoogleSheeet( some parameters );
}

void GoogleSheet( some parameters ){
	Do something...
}

There are the GoogleSheet program is transferable.


Code for Trade result (2nd) part will share privately.


Source code is needed.

Open to any suggestion!

Note: Thep past developer that wroking with me suggested Gogle Dev API (it is not nessary to use it, incase you have better suggestion).




Han respondido

1
Desarrollador 1
Evaluación
(206)
Proyectos
333
35%
Arbitraje
66
12% / 58%
Caducado
87
26%
Libre
Solicitudes similares
Modification of Trade_Panel_7 7.05 Objective . I have this utility “Trade_Panel_7 7.05” with which I open and close positions. Please refer to attached “Trade Panel Modification.jpg”. It shows an input parameter “Volume Step”. This parameter has the initial value of 0.02 as shown. This feature needs to be amended. Present Status . Value of lot size is increased by this “Volume Step”. I have built a whole series of
Indicador Maximas e Minimas + Super Trend O Indicador MAX/MIN é um indicador de análise técnica para o MetaTrader 5 , desenvolvido para ajudar você a identificar regiões importantes de preço e possíveis oportunidades de compra e venda. O que ele faz MAX/MIN: identifica máximas e mínimas relevantes do mercado e mostra os preços no gráfico. HH / HL / LH / LL: ajuda a visualizar a estrutura do mercado, mostrando quando
please share: Strategy description — entry/exit rules, indicators used, timeframe(s), and instrument(s) (a written explanation, screenshots, or an existing indicator/EA to reference all work) Risk management rules — position sizing method (fixed lot / % risk), stop loss / take profit logic, max drawdown or daily loss limits, and whether martingale/grid/hedging is involved Broker & account details — broker name
I need a unique grid trading system for XAUUSD that combines entry, controlled two-sided grid expansion, DCA (Dollar Cost Averaging) basket profit control, hedging. Unlike traditional grid EAs that only trade against price, this unique grid system should dynamically build positions in both directions based on market movement, allowing flexible adaptation to changing conditions ie the grid needs to dynamically move
I need an experienced MQL5 developer to create a fully automated MT5 Expert Advisor called Ayoub Gold EA , focused exclusively on XAUUSD (Gold) . Main requirements: Platform: MT5 / MQL5. Fully automated BUY and SELL trading on XAUUSD. Must support broker suffixes such as XAUUSD, XAUUSD.f and XAUUSDm. Trading strategy based mainly on Range Breakout with trend confirmation. EMA, ADX and ATR filters. London/New York
Looking for an experienced Sierra Chart ACSIL/C++ developer to customize an existing footprint chart. I need 3 things: 7-Day ATR – calculate and display a configurable 7-day ATR. Custom Footprint – modify my existing footprint chart to match my preferred layout/data display. Automatic LVN – detect and plot Low Volume Nodes automatically based on volume distribution. I already have a working footprint chart, so no
//———————————————————————————————————————————————————————————————————— struct S_MCAV { double matureSum; double totalSum; double value; void Init () { matureSum = 0.0; totalSum = 0.0; value = 0.5; } void AddContext (int ctx) { totalSum += 1.0; if (ctx == 1) matureSum += 1.0; } void ApplyDecay (double rate) { matureSum *= rate; totalSum *= rate; } void Update () {
1. Title Development of a Custom MQL5 Expert Advisor for XAUUSD (MetaTrader 5) 2. Requirements Specification Overview: I am looking for an experienced MQL5 developer to build a robust, fully custom Expert Advisor (EA) for MetaTrader 5 tailored for trading Gold (XAUUSD). Core Specifications & Features: Asset & Timeframe: Designed specifically for XAUUSD. Timeframe should be selectable directly from the EA inputs
SPECIFICA TECNICA: Cerco uno sviluppatore MQL5 esperto per sviluppare da zero un Expert Advisor completamente nuovo per XAUUSD su MT5. Non desidero un semplice Expert Advisor basato su indicatori fissi. Desidero un sistema di trading dinamico e adattivo , in grado di adattare il comportamento proprio alle diverse condizioni di mercato di XAUUSD. Lo sviluppatore può utilizzare tecniche appropriate quali trend
I am looking for a Senior MQL5 Developer to create a new MetaTrader 5 Expert Advisor from scratch. I will provide a complete Requirements Specification containing objective entry, exit and risk-management rules. This is not a request to copy or decompile an existing product. Project requirements: Clean and modular MQL5 source code. Exact implementation of the supplied strategy. One signal evaluation per configured

Información sobre el proyecto

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