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
(879)
Projects
1392
67%
Arbitration
117
32% / 42%
Overdue
215
15%
Free
3
Developer 3
Rating
(356)
Projects
632
26%
Arbitration
89
73% / 13%
Overdue
12
2%
Free
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
6
Developer 6
Rating
(8)
Projects
17
41%
Arbitration
1
100% / 0%
Overdue
2
12%
Working
Similar orders
i get paid in 12 hour too send agreement Once the Tp or stop loss or trailing sl is hit a new order is placed in the direction of where the Tp and sl or tsl is hit immediately So trail profits until close and open new trade in reverse direction immediately and trail until close again points for trailing sl, tp and sl I want the trailing stop too have two different functions one is that it’s trails from the entry
// @version= 5 strategy ( "EMA Crossover Strategy with 1:1.6 Risk-Reward" , overlay = true ) // Define the EMAs shortEma = ta.ema ( close , 10 ) longEma = ta.ema ( close , 20 ) // Plot the EMAs on the chart plot ( shortEma , color = color.blue , title = "10 EMA" ) plot ( longEma , color = color.red , title = "20 EMA" ) // Calculate the crossover conditions longCondition = ta.crossover ( shortEma , longEma )
I need a chart to replicate/track my equity + Balance Curve into my mt4. Also this chart i need to be able to add Stochastic / Bollingerband / Moving average on the equity/balance curve. Besides the equity curve i would like the indicator to show the Line-chart of my win + 1 and my loss -1 which results in a win-loss curve. ( i will discuss this with the choosen developer in depth. ) More information on what i want
I want to export the live feed from my market watch to my technical analysis software. They have provided me an api also. Is there a way that their api can be integrated and take rates from my mt5 client terminal
Starting from scratch, I need a solution to develop my own crypto trading and exchange platform. This platform should compare prices across various exchanges like Coinbase, Binance, KuCoin, and Unocoin, as well as different cryptocurrencies. The solution must identify opportunities to buy on one platform and sell on another for a profit, transferring funds to my personal wallet instantly for security. The bot should
I need a AI signal generating and executing bot for forex trading. The bot should operate such that when i put it in a chart it will analyze the market, after several minutes it will display whether the trade is buying or selling and then execute a trade. It should display the one minute, five minute,15minute, 30 minute, one hour, 4 hours and daily time frame whether they are buying or selling. If it is buying the
looking for help to get my ibkr automated, i have strategies already built in composer and have JSON for them, i really just need to he setup and explanation on how to maintain it and add new strategies
I need a AI signal generating bot for forex trading. 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 whether they are buying or selling. If it is buying the arrow should be green and if it is
Using Bollinger Band only. When price closes above upper BB, open Buy. If the length of the candle body that closed above the upper BB is more than Y pips, then do not Buy and remove the EA. Otherwise, continue to open Buy if crosses and close above upper BB and the number of positions is not more than Max No of Positions. The user will choose either Buy or Sell only. When price closes below the lower BB, close all
The expert Advisor will place trades during high-impact news releases. it will then close trades by trailing stop methods after reaching the breakeven points. It should be built in such a way that it will allow adjustments of parameters like opening distance points, initial stop loss, breakeven points etc

Project information

Budget
100 - 250 USD
For the developer
90 - 225 USD
Deadline
from 1 to 3 day(s)