Discussing the article: "How to create a trading journal with MetaTrader and Google Sheets" - page 2

New comment
 
Sara Sabaghi #:

The codes of Google Sheet and the program that are in Metatrader are sensitive to the smallest change. All uppercase and lowercase letters must be respected.

In the previous comment, the code related to Apps Script is placed. Use it carefully.

This code:  https://github.com/jamiewilson/form-to-google-sheets

Do the steps "Create a new Google Sheet" to "How to post (write) data to google Spreadsheets" again. If you are not successful in these steps, you cannot go to the next steps.

All the code and MY JOURAN are a sample. you must do the steps by yourself.

Hello Sara, 

I finally had time to look into this. 

For multiple times I've tried to make it work, following the instructions very carefully, but I still get no trades logging on the Google sheet from MT5 data.

The App Scritp works when I enter the data manually thought the html. The Mt5 code (that I've downloaded from here) gives me no errors nor warnings - I carefully inserted my web app URL to it. 

Chatgpt suggested to add my App Script URL in the the Expert Advisor  "Allow WebRequest for listed URL." But that did not help. 


I noticed that the issue is that when I apply the EA to the chart, it looks active on the top right corner, but if I look into Expert in the bottom window, it does NOT say "Expert Advisor Initialized" (as it usually does with other EAs)


Is there anything else I could try? I'd really like to use this. 

Thanks a lot

 

EDIT: 

After a lot of tweaking with AI also to add other parameters, I managed to make it work! YES! I love it. Thank you. 

 
heremita #:

EDIT: 

After a lot of tweaking with AI also to add other parameters, I managed to make it work! YES! I love it. Thank you. 

I am happy and pleased that this article was useful to you.

Your efforts are commendable. Because there were really many details and nuances in this work.

Good luck.

 
Awesome work, much appreciate the time and effort to share this tutorial. Thank you.
 

Got a compile error for this line, pointing to an undefined variable  'str'

res=WebRequest("POST", url, NULL, 0, data, result, str);

Error Description:

lvalue expected AutoJournal.mq5 49 55

could be one of 2 function(s) AutoJournal.mq5 49 8

   built-in: int WebRequest(const string,const string,const string,const string,int,const uchar&[],int,uchar&[],string&) AutoJournal.mq5 49 8

   built-in: int WebRequest(const string,const string,const string,int,const uchar&[],uchar&[],string&) AutoJournal.mq5 49 8


 
Caijac #:
Amazing work, I really appreciate the time and effort to share this tutorial. Thank you very much.
I'm honoured to have been able to help.
 
T3adr #:

I got a compilation error for this line, pointing to an undefined variable 'str'

Error description:

lvalue expected AutoJournal.mq5 49 55

could be one of 2 functions AutoJournal.mq5 49 8

built-in: int WebRequest(const string,const string,const string,const string,int,const uchar&[],int,uchar&[],string&) AutoJournal.mq5 49 8

built-in: int WebRequest(const string,const string,const string,int,const uchar&[],uchar&[],string&) AutoJournal.mq5 49 8


The problem is most likely with your version of MetaTrader. Please update it.
 
Sara Sabaghi #:
It is very likely that the problem is with your MetaTrader version. Please update it.

It's already using latest build 5572 when I got the error.

Version: 5.00 build 5572

30 Jan 2026

 
T3adr #:

It's already using latest build 5572 when I got the error.

Version: 5.00 build 5572

30 Jan 2026

We have provided the code snippet in the article section for training and explanation. You compile it. This is wrong. Use the complete and ready-made code at the end of the article and using the hole of article to learn how it works and how you need to implemented it.
12
New comment