by NorthView » Fri Dec 11, 2020 12:46 am
I'm a recently retired developer who's done a lot of work over the past 10 years or so in Excel with Betfair data, in Gruss and also separate to Gruss (mainly Excel).
One of the things I did was using VBA to record horse prices in Gruss from 11 am to the end of the day in csv files which I loaded into SQL Server for analysis (too many rows for Excel to handle).
From the description of the requirement it might be possible to do it with formulae - if not then certainly with VBA.