I'd like some help with extracting tick data from a time series ....

MQL5 Other Data mining

Job finished

Execution time 23 hours
Feedback from customer
Order was completed very fast and efficiently, I highly recommend this developer.
Feedback from employee
Thank you for your order! Was glad to help!

Specification

I have S&P500 Index tick daily data on one minute intervals for the last 12 years. The file is an CSV file.

I'd like to extract the following fields :

Date, Opening price, Price 1 hour after the open, price 1.5 hours after the open, price 2 hours after the open, Closing Price.


Here is a sample of 4 of the minutes from 2007, time 5pm, 5:01pm, 5:02 pm, 5:03pm. I just need the next field with the index level.


01/04/2007;17:00:00;1431.75;1432;1431.25;1431.75;393
01/04/2007;17:01:00;1431.75;1431.75;1431.25;1431.5;461
01/04/2007;17:02:00;1431.5;1431.5;1431.5;1431.5;64
01/04/2007;17:03:00;1431.25;1431.5;1431.25;1431.25;145


I'm not sure if the Time Stamp is local time (Chicago or New York) so that will need to be cross-referenced. Also not sure if daylight-saving time is incorporated into the time stamp.

Thanks !


Responded

1
Developer 1
Rating
Projects
0
0%
Arbitration
1
0% / 100%
Overdue
0
Free
2
Developer 2
Rating
(885)
Projects
1410
67%
Arbitration
123
32% / 41%
Overdue
218
15%
Free
Published: 1 code
3
Developer 3
Rating
(361)
Projects
644
26%
Arbitration
92
72% / 14%
Overdue
12
2%
Working
Published: 1 code
4
Developer 4
Rating
(23)
Projects
25
12%
Arbitration
1
0% / 100%
Overdue
8
32%
Free
5
Developer 5
Rating
(94)
Projects
148
59%
Arbitration
16
38% / 13%
Overdue
25
17%
Free
Published: 1 code
6
Developer 6
Rating
(8)
Projects
17
41%
Arbitration
1
100% / 0%
Overdue
2
12%
Working
Similar orders
I need an Ai trading bot for Binance and BTC on MT5 that also uses order flow data. It should also make use of TSI- Temporal indicator sampling and also it should make use of fundamental analysis in the process of signal generation
I am looking for an experienced MQL4/MQL5 developer to build a custom MT4 indicator from scratch or cracking my ex4 file that i provide to you. I already have an existing indicator (EX4) which produces highly accurate buy/sell signals. I want a similar indicator developed based on its observable behavior and signal structure. my existing indicator is pc id protected so you have to do PC ID security bypass and source

Project information

Budget
100 - 250 USD
Deadline
from 1 to 3 day(s)