Discussion of article "How to Access the MySQL Database from MQL5 (MQL4)" - page 8
![MQL5 - Language of trade strategies built-in the MetaTrader 5 client terminal](https://c.mql5.com/i/registerlandings/logo-2.png)
You are missing trading opportunities:
- Free trading apps
- Over 8,000 signals for copying
- Economic news for exploring financial markets
Registration
Log in
You agree to website policy and terms of use
If you do not have an account, please register
New article How to Access the MySQL Database from MQL5 (MQL4) has been published:
Author: Eugeniy Lugovoy
Hi Eugeniy Lugovoy,
Firstly, thank you for taking the time to make this project.
I've been looking for weeks on how to import/update all the open/closed trades from a trading account into a MySQL table, if possible realtime. is there a way to do this using your library?
Many thanks in advance.
Dragos
Thank the author, I modified this project locally, so that I can use non-English words store in MySQL DB code page UTF8.
Hi Amy. It's great, I had no time to do it by myself. So, if that's alright by you, can you share sources with community?
Hello to everyone!
Unfortunately, I have no time to support this project and to spend time in community, so All My Dears forgive me unanswered questions and my silence.
But I see some experienced people here which can help to others and it's really great.
Thank you all for using my library, extending its functionality and getting your own experience.
Good luck to all with your projects!
Kindest regards,
Eugene
Hi Eugeniy Lugovoy,
Firstly, thank you for taking the time to make this project.
I've been looking for weeks on how to import/update all the open/closed trades from a trading account into a MySQL table, if possible realtime. is there a way to do this using your library?
Many thanks in advance.
Dragos
Hi Dragos!
Sure, you can build EA using this library to insert data into your Mysql database and keep them up to date (close to realtime update).
Pay attention, that closed orders in MT4/5 available programmatically only when they listed in History tab. So, if you set the filter in History 3 recent days - you can access only trades processed in that period.
It's not depended on this library, it's just MQL-MT4 infrastructure.
Regards,
Eugene
Eugene,
Awesome work again as this was very simple to get working.
Curious, have you or anyone else here tried to get this working on the Strategy Tester? I've evolved the script onto an indie in the live environment and all is OK, but no luck integrating in a backtesting envionment.
br George
Hi Amy. It's great, I had no time to do it by myself. So, if that's alright by you, can you share sources with community?
Hi Eugeniy,
Sorry for late response. Here is what i did with your code. I just modified one function cMySqlGetRowField to use MultiByteToWideChar. The original code is commented for compare.
Hi Eugeniy,
Sorry for late response. Here is what i did with your code. I just modified one function cMySqlGetRowField to use MultiByteToWideChar. The original code is commented for compare.
Thanks your guys are great. I tried your code .Don't forget includ widechar head, or it'll not work.
#include <wchar.h>
Hi I have loaded dll in Libraries folder but it report an error " "Cnnot call 'cMySqlVersion', '....\Libraries\MQLMySQL.dll' is not loaded
How is it possible?
Hi I have loaded dll in Libraries folder but it report an error " "Cnnot call 'cMySqlVersion', '....\Libraries\MQLMySQL.dll' is not loaded
How is it possible?
I have the same issue than you.
Using MT5 with Windows 10 - 64bits.