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.