Where exactly do I enter my selections in Excel?

[kenco]

Hi all,

I’m trying to automate bets using Guardian and Excel, and I just need to understand something basic.

I’ll have multiple selections during the day, and I’ll already have markets loaded into Guardian before I start updating Excel.

So:

Which workbook should I use?

Which sheet should I be writing into?

Which row and column does the first selection go into?

Where do the second, third, fourth selections go?

Also, where exactly do I put the following for each selection?

Horse name

Meeting name

Race time

Stake

Bet type (Back or Lay)

Offset (with greening)

Stop loss

Exit timing (e.g. 60 seconds before the off)

Do I also need to include column headers in the sheet (e.g. “Selection 1”, “Odds”, “Stake”, etc.), or should I leave those out?

I’m trying to keep this simple and reliable — just need a clear idea of how to structure the spreadsheet properly so Guardian picks everything up.

Thanks

[ODPaul82]

There is an excel template saved down in the betangel folder
C:\Program Files (x86)\Bet Angel Limited\Bet Angel - Professional\templates\

The Excel integration section of the user guide answers the vast majority of your questions
https://www.betangel.com/user-guide/mic ... ation.html

You will need to use some VBA to clear the status cells once a bet is triggered if you intend to use the same worksheet.
There are examples on the forum for performing this if you search for something like "Clear cells Excel"

[kenco]

Thanks