Macro Excel

I have a workbook that receives data from Esignal through the Esignal Qlink. Live data ( in my case the data will be a price) is streamed to a field, and the price(data) is changing throughout the day thousands of times. I need to fire that price (data) to other cells and aggregate all the different changes in price (data) . From that price (data) aggregation I want to find the MAX. and [login to view URL] display, and keep the MAX and the MIN current. Each day I will update the macro for different fields, so I will be deleting and updating alot of the data. I anticipate that this macro can be applied on an average day to 50 different fields (data points) so I am unsure of how much data can be stored on excel, I might also try to figure out a condition to eliminate redundant data(price) ?