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'