Easy task to pull data into Excel

2019.11.09 Experts Scripts

Specification

EA or Script to integrate with .XLSM for live pull of data from pair or multiple pairs into different sheets of the workbook.

Data required is HIGH and LOW of specified timeframe.

BUT, the order is important. If the HIGH occurs BEFORE the LOW, then the  HIGH should come first, if the LOW comes before the HIGH, then the LOW should come first, as follows for the daily (requires use of lower timeframes to work out which came first in time, the low or the high:

09/11/2019 - 1.2650 [Low came first]

09/11/2019 - 1.2660 [High came second]

10/11/2019 - 1.2690 [High came first]

10/11/2019 - 1.2640 [Low came second]

11/11/2019 - 1.2650 [High came first]

11/11/2019 - 1.2610 [Low came second]

And so on...

So for each candle on the timeframe, there is a row for the high, and a row for the low, but the order high then low, or low then high depends on which price was hit first.

Should be an easy one for the right coder.

Ideally can pull multiple instruments and timeframes data into the same workbook, on separate sheets. If it requires separate sheet, that's okay. Needs to update in real time. It may be necessary to use a lower timeframe to establish which came first (high or low) or you might have your own solution.


Files:

ZIP
hilo.zip
8.9 Kb

Responded

1
Developer 1
2019.11.09
Rating
4.91
(148)
Projects
247
27%
Arbitration
31
48% / 19%
Overdue
14
6%
Busy
2
Developer 2
2019.11.10
Rating
5
(1)
Projects
1
0%
Arbitration
0
Overdue
0
Free
3
Developer 3
2019.11.10
Rating
5
(1)
Projects
4
0%
Arbitration
2
50% / 0%
Overdue
2
50%
Working

Project information

Budget
30 - 35 USD
VAT (20%): 6 - 7 USD
Total: 36 - 42 USD
For the developer
27 - 31.5 USD
Deadlines
to 3 day(s)

Customer

Placed orders7
Arbitrage count0