Excel - Refreshing Data in Play / Triggers

[Pug Munter]

I kind of accidently stumbled upon this software a few days ago and from a first look it seems really excellent (but am aware it's a pre release version for testing so am taking care with small stakes etc. to start with). Gary, many thanks for making this freely available.

I've used the Excel facility to set up some basic triggered bets in play and it has worked very well, and I haven't had any problem with the refresh rates.

But here is something I'd like to do :

in running, have all runners' data refreshing every second (preferably in one sheet) and record all of the last 5 seconds prices for each. So at any time, each runner would have five lines of data with the 5th line being the current price and each second the lines would all move up one and the earliest line would drop off. That way, trends in prices could be analysed and used for a trigger.

Is there any automated way to do this please, such as avoiding the need to select each runner individually from the Excel menu in BA and keeping the stored data down to the last 5 seconds per runner so as to keep the data manageable?

Any thoughts welcome.
Many thanks.

[Mitch]

You can't do that with the software alone but it's very do-able using vba in Excel.

Are you familiar with vba or just the spreadsheet formulae?

[Pug Munter]

Thanks for your reply Mitch.

I'm OK with IF statements etc but have no vba knowledge but maybe I'll have a bash and see if I can pick up some basic vba. Else, it may be worth paying someone a few bob to put something together for me!