Create an Excel VBA Function that Calculates Real Time Data

I Need an Excel VBA function/Add-in that Calculates Real Time Data in a range over a minute and displays the Calculated Results (three result as an array) in three column ( UDF ( Range as range ( Ex. A4:G1000, D5:J400", etc. ) ,TimeInterval as integer (1,2, etc.))) on each minute Down that cells (adding new minutes data). I will Show any details you need to know Via Teamviewer, if i think you are fit to reach the goal. Details are in attached files.