VBA language Building an array of Breached Fractals prices in Excel using VBA language

I am receiving streaming data in excel from MT5 using Excel RTD Link

I would like to build a model in excel using VBA for data transformation.

All data is in the excel sheet

Specifications sheet has all the requirements

Requirements:

• All data to be transformed using VBA arrays (strictly no excel functions)

Refer to attached files for details