Can this be done? Guardian market loading and Export reports trick

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
User avatar
1clutch1
Posts: 12
Joined: Sun Feb 12, 2017 2:35 am

Hi there,

First time poster here and still getting used to the automation with excel feature.
I've been doing a bit of exploration in practice mode and I've a few things I'm trying to figure out.

1. Is it possible to load markets from an excel file into Guardian so I can put on the relevant templates?
Let me go into detail here if It doesn't it doesn't make sense.

What I'd like to do is copy all the tennis matches that will be played, (upcoming matches) from the website.
Even use a script to scrape match up names. I can do this quite easily with imacros and save them to csv.

I'd like to then push this to Guardian so I can populate the markets and set the excel sheet templates.
Has anyone got a suggestion or a good trick for loading a list of markets in without having to select them 1 by 1?

2. I'd like to automate the reports after markets settle. I guardian I have selected export reports on market closure. A day by day file is generated and in the folder is three sub folders Logs, matchedBets, ProfitAndLoss

Is there a way of automating these files so they go into a master file or does anyone have a custom set up they'd like to share?

Thanks for reading.
User avatar
Euler
Posts: 26446
Joined: Wed Nov 10, 2010 1:39 pm

Guardian can't read from a spreadsheet, but the spreadsheet can read from a list of Guardian markets so maybe that's the way you can look to implement it?
User avatar
1clutch1
Posts: 12
Joined: Sun Feb 12, 2017 2:35 am

Thanks for your answer. I'll make do with loading them in the morning through guardian
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”