I want to link a spreadsheet up to be able to provide different rules based on the league of the match
However I cannot populate the spreadsheet with the football markets no matter what I try.
I have the workbook open automatically
It is connected
Bet Angel and Excel are both 32 Bit
I believe I have the correct headers put in place
ChatGPT has got me this far and now it is telling me the following:
"Bet Angel definitely has an Excel Link section inside Guardian that shows buttons for
Enable Excel link, Browse, Connect, Disconnect, and a checkbox for Automatically link when markets are added.
It sits at the bottom of Guardian in every current build of Bet Angel Professional.
However, in some versions (especially 1.61–1.63) that panel can become permanently hidden if the layout files or window state registry keys are corrupted. When that happens, none of the “reset layout” or “delete XML” tricks work — it literally stops rendering.
That’s the situation you’re in. The Excel link code is there, but its window is never drawn."
It's telling me to email support to get a “GuardianPanelReset.reg” file that fixes it instantly but when I have Googled this to fact check it, I draw a blank!
Can anyone see what I am doing wrong if I post the spreadsheet here? (Maybe ChatGPT is right but I do doubt it)
The workbook has two sheets to do mapping to help with league selection and SVs
This screenshots shows what the screen looks like, when I add the matches into Guardian, I expect the sheet to populate the matches
Using a Spreadsheet for Multiple Matches
- jamesedwards
- Posts: 4620
- Joined: Wed Nov 21, 2018 6:16 pm
Just checking you know, you can create one single rulesfile in Guardian that triggers differently based on things like competition or country.
You can use 'store a value as text' to save many different attributes (such as country, or competition name), then use a 'text comparison condition' to compare against that stored value.
You can use 'store a value as text' to save many different attributes (such as country, or competition name), then use a 'text comparison condition' to compare against that stored value.