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

MQL5 其它 数据探索

工作已完成

执行时间23 小时
客户反馈
Order was completed very fast and efficiently, I highly recommend this developer.
员工反馈
Thank you for your order! Was glad to help!

指定

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 !


反馈

1
开发者 1
等级
项目
0
0%
仲裁
1
0% / 100%
逾期
0
空闲
2
开发者 2
等级
(885)
项目
1410
67%
仲裁
123
32% / 41%
逾期
218
15%
空闲
发布者: 1 代码
3
开发者 3
等级
(361)
项目
644
26%
仲裁
92
72% / 14%
逾期
12
2%
工作中
发布者: 1 代码
4
开发者 4
等级
(23)
项目
25
12%
仲裁
1
0% / 100%
逾期
8
32%
空闲
5
开发者 5
等级
(94)
项目
148
59%
仲裁
16
38% / 13%
逾期
25
17%
空闲
发布者: 1 代码
6
开发者 6
等级
(8)
项目
17
41%
仲裁
1
100% / 0%
逾期
2
12%
工作中
相似订单
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

项目信息

预算
100 - 250 USD
截止日期
 1  3 天