MT4 indicator data into MS Access real time
Dear Community,
is it possible to feed data from MT4 indicators into Access tables real time?
As far as I could find out, it can be done with server-generated data like Time, Open, Close etc. But what I (additionally need is locally generated data), what should be easier theoretically, but who knows.
I'ld like to know before starting the project, as without the indicator data, the whole thing would be rather useless. For I shy away from transferring the indicator programs into Access language.
Thank you so much in advance and a short answer would be fine. I don't want to waste your time. More specific questions may follow 😊 when I went through research and more specific learning and testing.
Sylvia
I don't know about MT4 with MS Access, but MT4 with MS Excel has been a thing for many years. I'm pretty sure that you can import CSV files into Access too.
Forum on trading, automated trading systems and testing trading strategies
Sergey Golubev, 2021.05.13 17:26
Excel
Systems and tools
- Working with Excel (tools, indicators, conversion ...) - the thread
- Forex data converters thread
- MULTI FIBO CALCULATOR with DDE off course - the thread
- FX risk calculator with DDE - the thread
- Excel Spreadsheet to simulate cost averaging strategies objectively - the thread
Articles
- MQL5 Cookbook: Writing the History of Deals to a File and Creating Balance Charts for Each Symbol in Excel - the article
- How to Prepare MetaTrader 5 Quotes for Other Applications - the article
- Using spreadsheets to build trading strategies - the article
CodeBase
- Export Indicator's Values - MT5 tool
- Export Positions History V1 - script for MetaTrader 5
- Export Deals History V1 - script for MetaTrader 5
- Live positions to csv - script for MetaTrader 5
- Export Calculated Prices & Indicator Buffers - script for MetaTrader 5
- Symbols to Excel - script for MetaTrader 5
- Export Summary Grouped by Symbols - script for MetaTrader 5
- Export Summary Grouped by Trading Days - script for MetaTrader 5
- VR Orders History MT5 Lite - script for MetaTrader 5
- DDE - Server - MT5 tool
- History Dump CSV with heat map for Excel analysis - MT4 tool
- MS Excel: Data Exchange and Management - MT4 tool
- Export to Excel in Real Time - MT4 tool
- MetaCOT 2 CFTC ToolBox (Set of Indicators) MT4 - COT in Excel
- Export Trades to excel - MT4 script
- Converting hst-files into csv files - MT4 tool
I don't know about MT4 with MS Access, but MT4 with MS Excel has been a thing for many years. I'm pretty sure that you can import CSV files into Access too.
Dear Ryan,
a huge thank you for this elaborated answer and your time to help.
Yes, most articles on similar questions I found, were about Excel. What made me optimistic that it would work with Access too. Already found a DDE for it last week.
CSV-Files into Access definitely is no problem. I did it some years ago and still have the scripts for it. But I never thought about the possibility to continually produce CSV-Files and have them imported into Access as soon as they show up. Thank you for this idea, I'm gonna test whether and how this may be worked out.
All the fine sources you added I will read and search through for solutions next weekend. Looking forward to it. I really, really love programming and this new challenge is really exciting.
Kind regards
Sylvia
- Free trading apps
- Over 8,000 signals for copying
- Economic news for exploring financial markets
You agree to website policy and terms of use
Dear Community,
is it possible to feed data from MT4 indicators into Access tables real time?
As far as I could find out, it can be done with server-generated data like Time, Open, Close etc. But what I (additionally need is locally generated data), what should be easier theoretically, but who knows.
I'ld like to know before starting the project, as without the indicator data, the whole thing would be rather useless. For I shy away from transferring the indicator programs into Access language.
Thank you so much in advance and a short answer would be fine. I don't want to waste your time. More specific questions may follow 😊 when I went through research and more specific learning and testing.
Sylvia