Excel loses all value after a period of time?

[Gareth1976]

Hi all

I am trying to track my trades using the betangel multi spreadsheet. Created a tab (sheet) at the front end and used the "=C1" to capture the race length and trades. but after a short period after the race, all the values go to 0.

Is this a formatting issue with excel? is there a way to tell excel keep the last value that changed?

thanks for any help

[CallumPerry]

Are these values changing to 0 when a market suspends or has finished? You will most likely need to use a bit of VBA to make Sheet1("A1") for example = Sheet2("C1") and Sheet3, 4, 5 etc

[sa7med]

Are you in practice mode? I think the matched bet info gets wiped after a race is finished unless you have retain matched bet info ticked on the advanced menu tab in guardian. Maybe that's it.

[Gareth1976]

brilliant, thanks lads, will give that a go.