Setup Advice

[PvtR1ZLa]

Hi,

I have some football strategies that I want to automate and thought I'd ask for some setup advice before I start. I will use an API website to pull live in-play stats into excel and then further use that data to execute trades, when triggers are met. A few questions I have;

• Would it be best to just have another sheet inside the example Bet Angel Multiple workbook with the in-play stats on, or would it be better to have a separate workbook just for the stats?

• If I'm applying the multiple workbook to multiple games, do I then need to have multiple copies of the same workbook?

• What would be the best way to match up the games I add to Guardian to the games the API site is sending to the sheet/workbook?

Any pointers on the best setup would be a big help, as I don't want to waste time putting a lot of effort into it and then having to redo it all further down the line.

Thanks,

Riz

*Edit*

• Also, I've been working to pull live in-play stats from api-football.com and have come to the issue of how to map the games I add to Bet Angel>Guardian>Excel, with the correct API data to pull. Has anybody done this already, as it will save a big amount of work?

[PvtR1ZLa]

Yep - I think I'm learning how this goes. If you're on the right path, nobody will help.
I'll stick at it and see how it goes.

Riz

[Anbell]

Hi,

I have some football strategies that I want to automate and thought I'd ask for some setup advice before I start. I will use an API website to pull live in-play stats into excel and then further use that data to execute trades, when triggers are met. A few questions I have;

• Would it be best to just have another sheet inside the example Bet Angel Multiple workbook with the in-play stats on, or would it be better to have a separate workbook just for the stats?

• If I'm applying the multiple workbook to multiple games, do I then need to have multiple copies of the same workbook?

• What would be the best way to match up the games I add to Guardian to the games the API site is sending to the sheet/workbook?

Any pointers on the best setup would be a big help, as I don't want to waste time putting a lot of effort into it and then having to redo it all further down the line.

Thanks,

Riz

*Edit*

• Also, I've been working to pull live in-play stats from api-football.com and have come to the issue of how to map the games I add to Bet Angel>Guardian>Excel, with the correct API data to pull. Has anybody done this already, as it will save a big amount of work?

Would it be best to just have another sheet inside the example Bet Angel Multiple workbook with the in-play stats on?

Yes. In my experience it is best to have just the one instance of excel.

[ODPaul82]

re the mapping, someone listed every single team name listed on betfair before. If you have a search on the forum should still be on here somewhere.

It doesn't take long to create your own one though, my tool loads in BF names & I've got a DB with a table that lists cgm name, sofascore name and BF name so I can do 3 way matching for all my data and then upload it into BA via stored value CSV every 15-20 seconds with latest stats.

[PvtR1ZLa]

Thanks for the replies! I've created the python code and it's pulling the endpoints I'm interested in and in turn it's populating a .csv that Guardian is pulling in so I see the Triggers as per the image below. The problem is, I don't see the list of Stored Values in the log. I think it's either I've formatted the csv file incorrectly or I need to do something on the Bet Angel side to get Guardian to 'see' the values?







Cheers,

Riz

[Dublin_Flyer]

Are you storing the correct values for the category of Current Selection/Nominated Selection/Market/Event/Bet Angel?

If they're in the wrong category then other markets won't read them i.e. storing a value for O/U2.5 as Market won't be readable to the Correct Score, O/U1.5 markets etc But if it's stored as Event it'll be readable to all other markets in the event/game.

Regarding matching up games/leagues, here's my list from about June 2024 to the end of that year. It's a pain in the ass trying to compile a full list and BF have weird naming numbers ways - English League 1 but Scottish League One, Japanese League 3 but Romanian Liga III.
English Women's Matches and Spanish Women's Matches but Taiwanese Ladies

BF competition names.xlsx

Hope you manage to get your setup sorted out properly, Bet Angel is a cracking piece of software so I'm sure you'll get any wrinkles ironed out eventually.

[PvtR1ZLa]

....here's my list from about June 2024 to the end of that year. It's a pain in the ass trying to compile a full list and BF have weird naming numbers ways - English League 1 but Scottish League One, Japanese League 3 but Romanian Liga III.
English Women's Matches and Spanish Women's Matches but Taiwanese Ladies
BF competition names.xlsx

Hope you manage to get your setup sorted out properly, Bet Angel is a cracking piece of software so I'm sure you'll get any wrinkles ironed out eventually.

Thanks a lot Dublin, lad, I really appreciate it!

Riz

*Edit* Does that mean if I'm trading a few games and have some logic to check if something is true, then if I set all the values to shared, then 1 games stats/logic could ring true for another, if you know what I mean?

[Dublin_Flyer]

*Edit* Does that mean if I'm trading a few games and have some logic to check if something is true, then if I set all the values to shared, then 1 games stats/logic could ring true for another, if you know what I mean?

If it's stored/shared for the event then it's specific to each market in that event

CS market.JPG

So in the example if you store values for the event that the score is not 0-0 or 0-1 0-2 0-3 1-0 then the U/O 1.5, 2.5, 3.5, Match Odds, etc for the Southampton v Fulham will all see it, other games won't.

Alternatively were you to store it for the market only, then only the Correct Score market will see it.

Alteralternatively were you to store it for Bet Angel, then every game would see that the score is not 0-0 or 0-1 0-2 0-3 1-0, and you're at risk of blowing your bank on false information.

Storing values for Bet Angel covers everything entirely, so say you were scraping sites for team news for a key player and saw Isaq wasn't starting for Newcastle and want to factor that into your trades, Southampton v Fulham will see it, 19.45 at Wolverhampton will see it, Eubank Jr v Benn tonight will see it.
It won't do any harm initially, but if you give it a generic stored value name like "Top scorer not starting" then every event will think the Top scorer isn't starting so you're lining yourself up for trouble there.

As I was typing this I checked and Isaq did actually start for Newcastle, and his goal was the difference between the game being Over 2.5 and Under 2.5