Setting SV values from Excel to Guardian

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
sniffer66
Posts: 1679
Joined: Thu May 02, 2019 8:37 am

Hopefully this is a quick answer from someone....

My firs venture into using using Excel so struggling a little - my Excel skills are rubbish. I'm pulling down a number of in play stats via JSON and want to pass those values as different SV's in Guardian. Just testing with a single SV at the moment, though I know I can do multiples in the same cell.

So, I'm editing L9 with: SET_SV FOR:SELECTION NAME:Test VALUE:50, which creates a corresponding log entry in Guardian:

25/11/2020 10:13:37: [Excel] : Command for Juan Manuel Cerundolo = 'SET_SV FOR:SELECTION NAME:Test VALUE:50'

I'm pulling down the stats every x seconds and want to re-update the SV by updating L9 again. i.e SET_SV FOR:SELECTION NAME:Test VALUE:55

If I edit the existing text to VALUE:55 I dont get a new entry in the Guardian log. Do I need to clear the cell and re-enter (which I've tried) or some other process ? The new value may be being applied but the log just isnt re-updating maybe ?
sniffer66
Posts: 1679
Joined: Thu May 02, 2019 8:37 am

Think I answered it myself, needed to clear the "OK" in Column O first :)
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”