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

MQL5 Lo demás Minería de datos

Trabajo finalizado

Plazo de ejecución 23 horas
Comentario del Cliente
Order was completed very fast and efficiently, I highly recommend this developer.
Comentario del Ejecutor
Thank you for your order! Was glad to help!

Tarea técnica

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 !


Han respondido

1
Desarrollador 1
Evaluación
Proyectos
0
0%
Arbitraje
1
0% / 100%
Caducado
0
Libre
2
Desarrollador 2
Evaluación
(885)
Proyectos
1410
67%
Arbitraje
123
32% / 41%
Caducado
218
15%
Libre
Ha publicado: 1 ejemplo
3
Desarrollador 3
Evaluación
(361)
Proyectos
644
26%
Arbitraje
92
72% / 14%
Caducado
12
2%
Trabaja
Ha publicado: 1 ejemplo
4
Desarrollador 4
Evaluación
(23)
Proyectos
25
12%
Arbitraje
1
0% / 100%
Caducado
8
32%
Libre
5
Desarrollador 5
Evaluación
(94)
Proyectos
148
59%
Arbitraje
16
38% / 13%
Caducado
25
17%
Libre
Ha publicado: 1 ejemplo
6
Desarrollador 6
Evaluación
(8)
Proyectos
17
41%
Arbitraje
1
100% / 0%
Caducado
2
12%
Trabaja
Solicitudes similares
You can control via Telegram: /start - enable bot, begin trading, /stop - end trading, disable bot /status - trade status Bot requirements: • Automated trading throughout the day until 00:00 UTC (Moscow time) (I do not want to trade or turn the bot on 100 times a day). • Auto shutdown of the bot in Telegram at 00:00 UTC (Moscow time) and manual restart when convenient. • Market analysis 24/5 using 20 EMA, RSI, and
Early Killer EA 30+ USD
It must have automated stop loss. Something that can end poverty and kill the market early.It must take the trades for me whenever I start it it must work on tradeport ea
The scanner will scan all currency base on MACD Diverdgent, my strength indicator and my better volume indicator. All this would be across all time frame and all currency pairs
Ninjatrdaer Script 500 - 1000 USD
I am looking to purchase a ninjatrader script, if there is any for sale, i mean a ready made ninjatrdaer script that trade futures, i need the seller to show me a backtest of the system, you know send some results, I would like to see a 1 year and YTD backtest
Mk 30+ USD
I need a fully automated trading robot designed to generate consistent profits while strictly controlling risk and minimizing losses. The robot should use a combination of strategies, including trend-following, scalping, and price action, and must be able to adapt to different market conditions such as trending and ranging markets. It should analyze the market using indicators like Moving Averages, RSI, MACD, and
1. IF price forms: - Higher highs + higher lows → TREND = BUY - Lower highs + lower lows → TREND = SELL ELSE → NO TRADE 2. IF: - Trend = BUY - Price retraces to support zone - Bullish engulfing candle forms - TDI green crosses above red (optional) THEN: - Execute BUY 3. IF: - Trend = SELL - Price retraces to resistance - Bearish engulfing forms - TDI confirms THEN: - Execute SELL 4. Risk per trade = 1% of account Lot

Información sobre el proyecto

Presupuesto
100 - 250 USD
Plazo límite de ejecución
de 1 a 3 día(s)