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
643
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
Looking for an experienced MQL5 developer to design and develop a custom Expert Advisor (EA) for MetaTrader 5. The purpose of this EA is not just automated trading, but also to help me better structure, test, and refine my personal trading strategy
Phahla fx boto 30+ USD
99.99% signal accuracy 10-15 trades distribution all currency trade and meta AI assistance on loss[advice] stop and start robot cyber security firewall protection activation code: 20060605TLP20 Please create a trading bot with any logo with the name elevation
I would like to create a robot with the smart money concepts, that integrates order block,FVG,supply & demand ,read the market structure,liquidity and also trade with the session and also after a liquidity sweep a market structure is needed to verify the reversal and a retracement to the order block and sometimes fair value Gap
Ai robot 30 - 50 USD
1️⃣ System Architecture An AI robot typically consists of the following subsystems: 🔹 1. Perception Layer Collects environmental data using: RGB / Depth cameras LiDAR Ultrasonic sensors IMUs (Inertial Measurement Units) Microphones Data is processed using: Computer Vision (e.g., object detection, SLAM) Signal processing Sensor fusion algorithms 🔹 2. Cognition / Intelligence Layer Implements AI models such as
Data Integrity 500 - 1000 USD
The trading bot is an automated software system designed to monitor financial markets, execute trades, and manage risk based on predefined strategies. The bot aims to maximize profits while minimizing human intervention and emotional decision-making. Scope: Supports automated trading on selected exchanges (e.g., Binance, Bitget, Coinbase). Executes trades based on technical indicators, signals, or AI models. Provides
I need a AI signal generating bot for forex trading that use the latest ai technology to track real time forex market, analyse and give signals. The bot should operate such that when i put it in a chart it will analyse the market, after several minutes it will display whether the trade is buying or selling. It should display the one minute, five minute,15minute, 30 minute, one hour, 4 hours and daily time frame
Hello, I have a High Frequency Trading EA for MT4 that performs consistently profitable in demo accounts , but when I switch to a real account (IC Markets Raw) , it starts to generate losses under the same conditions . Everything — settings, VPS, broker, and market hours — is exactly the same. This indicates the issue is likely related to execution speed, slippage handling, or real tick behavior . I am looking for an

Project information

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