Bet Angel and Excel

[CPerry]

You're bang on SamT! So as you said, I'll cut to what I want it to do:

I want data to flood into my worksheet as quickly as possible in the yellow area so that I can calculate OHLC (Open - the first value every 200m/s, High - the largest number in the table, Low - the smallest number in the table and Close - the last number in the yellow section). This OHLC data will go down my sheet along with other indicators I need to programme to trigger events - so you are correct, no brain all computer power here. Let me give you an example with a MACD indicator (OHLC and MACD are financial tools, these formulas are the foundation of my system).

MACD = a 'previous 12 readings' moving average and a 'previous 26 readings' moving average along with a 'previous 9 readings' average as a signal line. As a very simple example, if both the 12 average and 24 average crossed the signal line i.e. the numbers in cells AU3 and AV3 were both greater than the number in cell AW3, a trigger cell would show the number 1. If E3 = 1 then BetAngel will place an order in the market for me (via the green section starting at M45 down). OHLC will be used for other indicators similar to this one to define a market's current position.
There is a very similar spreadsheet (but only ticking in whole seconds) if you follow this link here... excelbettingbots (.com)

I was planning on using an index function or something to continually identify the lowest 12 numbers and calculate a mean average (every 200m/s, live as the data pours in). Now once I have data flowing that is when I will trial and examine different indicators so if you could kindly show me how you would code a simple formula like the following into a vba code, that would help tremendously...

=AVERAGE(AU3:AU11)

The problem I'm going to face with it constantly ticking down is the next line formula for the next 9 point average would have to be =AVERAGE(AU4:AU12), I need a ticking range also. Any ideas how to get around this?

With regard to having the data come through on a separate sheet, this is fine as long as the triggers don't get confused which sheet they are reading from and the scrolling of data uses the HOME sheet start times and countdown to start times in cells G39 and G40 respectively. That way I don't have 40 or so sheets trying to trigger their VBA code at the same time and shutting down the entire internet! You're talking about 3,000 lines of 200m/s before the race goes in-play which means 30,000 loops in the original yellow section at 10x that speed. That's disregarding letting my spreadsheet going in-play which I will test to see if it can do both.

So to summarise...
1) Data comes in very quickly,
2) Data gets crunched in 200m/s segments (first number, last, highest, lowest and several indicators - each requiring approx 2/3 cells each thus me leaving 12 cells across in the blue section),
3) These indictors every so often produce a 1 or some other 'GO' command to trigger a back/lay bet which then goes through the green striped section into BetAngel and places real money in the live market (That is already programmed to happen, trust me. I just need to put something like =IF(E5=1,"BACK","").

Again, there's a lot there so thank you so much for taking the time to look over this!
CPerry.