How to export daily results from Guardian to excel

[kahuao]

Hi

I have watched Peter Webb's video and read the threads in Bet Angel - Spreadsheet/Excel chat on this subject but have had no joy

I am wanting to export my daily football results from Guardian automation to an excel spreadsheet so I can analyse my results

Can anyone help please

I will continue to go through the thread to hopefully find the solution

Thanks in advance

[Dallas]

On the 'Advanced' tab in Guardian tick the 'Export Reports on Market Closure' box

[kahuao]

Thank you very much

[petergray]

To export daily football results from Guardian to Excel, follow my below mentioned step:

1- Set up Guardian automation in Bet Angel to collect the desired data.
2- Export the data from Guardian to a text or CSV file.
3- Save the file on your computer.
4- Open Excel and create a new workbook.
5- Go to the "Data" tab and select "Get External Data" or "From Text."
6- Locate the exported file and open it.
7- Follow the Text Import Wizard to specify the delimiter and format the data columns.
8- Finish the import process, and Excel will populate the data into a worksheet.
9- Analyze and manipulate the data in Excel as needed.

Hop it helped. Do lemme know if you know any further assistance.

[truemank]

Hi , does anyone know how to extract 1 report which contains everything from the guardian screen at the end of the day??

i store all my values into the gaurdian screen and have tried exporting stored values and tried the method above but it seems like it gives me a new file per race etc

[jamesedwards]

Hi , does anyone know how to extract 1 report which contains everything from the guardian screen at the end of the day??

i store all my values into the gaurdian screen and have tried exporting stored values and tried the method above but it seems like it gives me a new file per race etc

Right click on any market. 'Export the contents of this market list'

[NodwellBainbridge]

Hi , does anyone know how to extract 1 report which contains everything from the guardian screen at the end of the day??

i store all my values into the gaurdian screen and have tried exporting stored values and tried the method above but it seems like it gives me a new file per race etc

Right click on any market. 'Export the contents of this market list'

You sir , are a Legend .... thank you ...

[odefeyerabend]

Hi Bet Angel team,

I am running Practice Mode automation tests and want to export the results into my own audit workbook.

Can Bet Angel export practice-mode bet results with Betfair Market ID and Selection ID included?

Ideally I need one CSV row per matched bet with:

- Market ID
- Selection ID
- Market name
- Selection name
- Time bet placed/matched
- Back/Lay
- Matched odds
- Stake
- Bet reference
- Automation rule name
- Practice/live flag
- P/L

If these are not available in the standard MatchedBetsReport or ProfitLossReport files, is there another export/logging method I should use?

Thanks.

[surman]

To export daily football results from Guardian to Excel, follow my below mentioned step:

1- Set up Guardian automation in Bet Angel to collect the desired data.
2- Export the data from Guardian to a text or CSV file.
3- Save the file on your computer.
4- Open Excel and create a new workbook.
5- Go to the "Data" tab and select "Get External Data" or "From Text."
6- Locate the exported file and open it.
7- Follow the Text Import Wizard to specify the delimiter and format the data columns.
8- Finish the import process, and Excel will populate the data into a worksheet.
9- Analyze and manipulate the data in Excel as needed.

Hop it helped. Do lemme know if you know any further assistance.

Thanks for laying it out step by step. One additional tip: when importing the CSV into Excel, it's worth checking that dates and decimal values are recognized correctly, especially if your regional settings use different separators. Converting the imported data into an Excel Table also makes filtering, sorting, and creating PivotTables much easier later on.