Excel loses all value after a period of time?

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
Gareth1976
Posts: 24
Joined: Tue Aug 20, 2019 6:39 pm

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
Posts: 575
Joined: Wed Apr 19, 2017 5:12 pm

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
Posts: 800
Joined: Thu May 18, 2017 8:01 am

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
Posts: 24
Joined: Tue Aug 20, 2019 6:39 pm

brilliant, thanks lads, will give that a go.
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”