FDibbins thank you ever so much for all your help. needless to say I couldn't have done it without you.. While I have your attention, I'd like to hear if you have any advices as for how to plot this mountain of information (see attachment for the final result, and imagine this continuing on for say, 30 days more. so about 404*30 = 12,120 rows. The immediate thought is to chart it with daily candlestick chart, yet there are some problems with that approach (if the ATM Strike (Y) changes during the day, there has to be some notification because the formulas (and the chart) are now tracking different things..

anyway I don't know if you have any advices, but I've never had to deal with such a huge amount of data and I'm fishing for clues and tips how best to go about it