Hi
Im looking I guess to have an excel sheet that pulls all certain market data from say Football, Match Odds and the o/u goal markets into columns, shows total matched etc and kick off time and odds, so i can then just have conditional formatting to highlight certain markets that hit my critera, Im sure in the scheme of things this is quite easy, is there a tutorial or something I can check out to build this please?
Thankyou
Excel Populated with Market Data
I believe there are quite a few tutorials and ways other users have shared about collecting data and others might have better answers....the way I have done is by connecting markets to the excel file via Guardian, and then via command line I connect to the excel file and extract data to a local Database. I am not a programmer, but managed to get it all set up interacting with AI. AI knows about Betangel and how it functions, so you should be ok.
I built a very similar scanner last year. The easiest route is definitely Guardian's Auto-bind Excel feature. One tip: keep your refresh rate sensible 5 Letter Words
“That sounds like a fairly common workflow: pull the market universe first, then apply your own eligibility rules rather than manually opening each market. The difficult part usually isn't getting the raw data into Excel — it's keeping the filtering logic consistent once you're comparing multiple markets and criteria at the same time. Out of interest, are you mainly trying to reduce the number of markets you review manually, or are you also trying to rank the ones that pass your criteria?”