Populate guardian from Excel?

Example spreadsheets and comments on example spreadsheets.
Post Reply
TJSN1
Posts: 25
Joined: Wed Jun 01, 2022 11:22 am

I want to achieve the following, but I'm not sure if it's possible and haven't found anything on this forum that might help so any advice would be appreciated.

Automatically populate Guardian using a pre-populated Excel sheet that contains market information as displayed in Betfair. Then apply a rule to those markets.

From my understanding, Guardian populates Excel, not the other way around, but I wondered if I'd missed how to do the above?

Thanks
User avatar
Euler
Posts: 24561
Joined: Wed Nov 10, 2010 1:39 pm
Location: Bet Angel HQ

You can populate Guardian from a CSV file: -

https://www.betfairtradingblog.com/impo ... bet-angel/
jordonary
Posts: 6
Joined: Wed Aug 30, 2023 2:10 pm

anyone have an example of Automation_SetStoredValues_Example since that file isnt intuative.
User avatar
ODPaul82
Posts: 678
Joined: Sun May 08, 2011 6:32 am
Location: Digswell Herts

jordonary wrote:
Wed Aug 30, 2023 3:08 pm
anyone have an example of Automation_SetStoredValues_Example since that file isnt intuative.
I can't attach csvs, these are the first few rows from one

1
1.214872131,16:18,*,1,SS,GHValueLay,1
1.214872131,16:18,*,5,SS,GHValueLay,1
1.214872131,16:18,*,6,SS,GHValueLay,1
1.214872133,16:38,*,1,SS,GHValueLay,1
1.214872133,16:38,*,2,SS,GHValueLay,1
1.214872133,16:38,*,4,SS,GHValueLay,1
1.214872133,16:38,*,6,SS,GHValueLay,1
1.214872137,17:18,*,1,SS,GHValueLay,1
1.214872137,17:18,*,2,SS,GHValueLay,1
1.214872137,17:18,*,3,SS,GHValueLay,1
1.214872115,13:49,*,1,SS,GHValueLay,1
1.214872115,13:49,*,2,SS,GHValueLay,1
1.214872115,13:49,*,4,SS,GHValueLay,1
1.214872125,15:18,*,3,SS,GHValueLay,1
User avatar
ShaunWhite
Posts: 9731
Joined: Sat Sep 03, 2016 3:42 am

I'd assume they all need the same number of commas (data items). Your first like only has 1.

Just a guess.
User avatar
ODPaul82
Posts: 678
Joined: Sun May 08, 2011 6:32 am
Location: Digswell Herts

ShaunWhite wrote:
Wed Aug 30, 2023 5:56 pm
I'd assume they all need the same number of commas (data items). Your first like only has 1.

Just a guess.
Supplying one that works as a sample to OP :)
The first row is always a 1 and nothing else (well not always but there isn't any new functionality where 2,3,n is used)
After that as per sample file

# Column1: Market Name. The text in this column will be matched against the name of the market to decide whether this row applies or not. * can be used to wildcard the match. E.g. Exact_Match / Starts_With* / *Ends_With / *Contains* . Note: When using an exact match, the Market Name can be substituted with the betfair Market Id. To ignore this filter use a single * character
# Column2: Market Time. The text in this column should be in the format hh:mm (24hr clock) and will be matched against the expected start time of the market to decide whether this row applies or not. If you don't want to filter by time use a single * character
# Column3: Selection Name. The text in this column will be matched against the name of the selection to decide whether this row applies or not. * can be used to wildcard the match. E.g. Exact_Match / Starts_With* / *Ends_With / *Contains* . Note: When using an exact match, the Selection Name can be substituted with the betfair Selection Id. To ignore this filter use a single * character
# Column4: Selection Row Number. The number in this column will be matched against the row (in betfair order) of the selection in the market to decide whether this row applies to the selection or not. Enter a number >= 1 or use a single * character to ignore the filter
# Column5: The Stored Value Type. Use S to set the Stored Value on the Selection (local to this Automation instance). Use SS to set a Shared Stored Value on the Selection. Use M to set the Stored Value on the Market (local to this Automation instance). Use SM to set a Shared Stored Value on the Market. Use E to set a Shared Stored Value at the Event level. Use B to set a Shared Stored Value at the Bet Angel level
# Column6: The Stored Value Name.
# Column7: The value itself.
# Columns 8 to 10 are a repeat of columns 5 to 7 to set another stored value with the same market/selection criteria. These columns can be repeated as many times are required.
mcgeadyspin
Posts: 1
Joined: Tue Jan 24, 2023 7:21 pm

How would I use the Automation_SetStoredValues.csv file to just populate the markets in guardian if it's even possible to do so or is there some other way to add in the markets via a spreadsheet?

For example, I have 50 - 60 different football matches across the top 9 leagues running over the weekend and ideally I'd be able to populate Guardian with the match odd market for each match using a CSV/XLSX file instead of having to manually add each match manually, the matches change each week so currently I'm manually adding them in which can be quite time consuming?
Post Reply

Return to “Bet Angel - Example spreadsheets”