Spécifications
Hi everyone,
I need an expert to write a script in MQL5 that will fetch and store OHLC price data for a specified time period for a range of specified symbols. The data will be saved in 4 separate Excel CSV format files, one file for Open price data, one file for High price data, one file for Low price data and one file for Close price data. In each CSV file, the dates will be listed vertically in column A, and the range of symbols horizontally starting from row 2 column B. Each file will contain all the specified dates and all the specified symbols.
In the beginning, I will run the script to capture OHLC price data for the past 100 days (as an example) and then I will be running the script once every day to capture the previous day's OHLC price data for all the specified symbols.
| Date | EURUSD | GBPUSD | XAUUSD | NASDAQ |
|---|---|---|---|---|
| 2024.04.01 | 1.09212 | 1.24605 | 2334.015 | 18167.15 |
| 2024.04.02 | 1.09452 | 1.24988 | 2342.518 | 18097.35 |
| 2024.04.03 | 1.09433 | 1.25124 | 2345.007 | 18011.23 |
| 2024.04.04 | 1.09658 | 1.24784 | 2325.987 | 18159.67 |
The above table shows how data will be displayed in Excel CSV file for one data point, say Open price.
Hope it is clear enough. At your disposal for further clarification.
Regards,
Petros