Using a Spreadsheet for Multiple Matches

Advanced automation available in Guardian - Chat with others and share files here.
Post Reply
smgreyuk
Posts: 123
Joined: Tue Jul 30, 2024 4:20 pm

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
Guardian_League_AutoTag.xlsx
This screenshots shows what the screen looks like, when I add the matches into Guardian, I expect the sheet to populate the matches
Screenshot 2025-10-17 230518.png
You do not have the required permissions to view the files attached to this post.
tumby
Posts: 39
Joined: Wed Mar 13, 2019 6:49 pm

Did you take one of the Bet Angel example sheets and modify that or are you using a blank excel sheet that you have added some headings to?

If you start with the Bet Angle example sheets and modify from there it should be fine.
User avatar
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.
Post Reply

Return to “Bet Angel - Automation”