Capturing change in excel

[globi166]

Hi
Anyone could help? I would like to keep last traded price record. Not sure if there is such a command. Hope that makes sense. Many thanks.

[Dallas]

There are several data capture spreadsheets in the Betfair data section which capture the LTP plus more, which you could either copy the part you need or strip out the bits you don't require
viewforum.php?f=54

[globi166]

Ok cool. So I guess there isn't a simple formula that I can use to store data as it changes from one value to another? Most of those spreadsheets are very complicated.

[globi166]

I found this spreadsheet viewtopic.php?f=54&t=11521 Looks like what I was looking for however Is there any chance to set it up for auto-reset after x amount of times the market changed? Max 10 changes for example.

[Dallas]

I found this spreadsheet viewtopic.php?f=54&t=11521 Looks like what I was looking for however Is there any chance to set it up for auto-reset after x amount of times the market changed? Max 10 changes for example.

Best posting the question to the thread itself, NigelK isn't around now but you got a better chance of someone else who's using it and can help seeing the question there