MAX MIN through time

[fractalmodel]

One of the challenges I have is recording MAX and MIN for both Pre Play and Inplay for horses
I think it might need VBA as it is time dependent

Does anyone have a formula/solution or script that stores the high and low prices

[Dallas]

Its easy enough to do it with Bet Angels automation to, there's a template here you can start with if you wanted to have a play around
viewtopic.php?f=56&t=19253

[jamesg46]

I use Bet Angel history list to store volume and odds every 30 seconds, which then get exported at post time. From there I copy and paste the two into the sheet below and then on another sheet it shows the fav's volume, odds at 20 mins, lowest (=min) odds traded in that 20 mins, same for max and then the market % of the fav.

I set this sheet up with just basic formula and just delete the data out each day and hen saving it to today's date. Not sure if you're after something similar but it's never been easier to get data since Bet Angel magicians came up with history lists.

[jamesg46]

It also helps to keep an overview of price action at each meeting... if we are seeing constant steamers or whatever....