Identifying price changes

[Wyndon]

I'd like to take a snapshot of prices, say 5 mins before start time, so that just before the off I can see which way prices have moved. The only way I've come up with is by placing bets and recording the prices they were matched at. I'd like to be able to do this without risking cash! Grateful for any advice/solutions.

[GaryRussell]

I've created an Excel user defined function that will return the price from a specific number of seconds ago. See viewtopic.php?f=8&t=11553

[Wyndon]

Many thanks for your prompt and helpful reply. Wished I'd asked earlier!

[Wyndon]

Sorry, I'm getting a run-time error. The following line is highlighted in the debug sheet.

Set sheetHistory = CreateObject("System.Collections.Arraylist")

I'm afraid my VB skills are practically nil.

[GaryRussell]

What is the exact error message?

[Wyndon]

Run-time error '-2146232576 (80131700)':
Automation error

[GaryRussell]

I've changed it to use native Collection instead. See viewtopic.php?f=8&t=11553&p=58079#p58079

[Wyndon]

Perfect! Thank you.

[Wyndon]

Sorry to trouble you again. I’ve set up a trigger that depends upon current odds being less than historic odds. I set up markets to be open 4 mins prior to the scheduled off and the historic odds to relate to the previous 3mins. Obviously the earliest the trigger can kick in should be after 3mins. This does in fact happen after 3 mins; but I also get several triggered bets at the instant the market is loaded. This is when the historical odds are showing zero and so should not happen. I’m assuming that at the instant the market is loaded, historic odds from the previous race briefly remain. Assuming my explanation is correct, is it possible to ensure historic odds from the previous race are cleared immediately after the race? Hope this makes some sort of sense. Thanks.

[GaryRussell]

I've updated it to check the market name in the recorded prices matches the current market to prevent this happening. See viewtopic.php?f=8&t=11553&p=58089#p58089

[Wyndon]

That's fixed it.