I have an Excel file that imports data from Bet Angel. The data is manipulated in Excel to give a stake amount for each selection in the market. Is there some way I can import these stake amounts back into a column in Bet Angel's One-Click screen? I would then just click in the column for a chosen selection and a bet would be made using the staked amount.
I'm thinking I would need to use Stored Values somehow. I've found the blog post below, but I don't really understand how it works.
https://www.betfairtradingblog.com/impo ... bet-angel/
Hope someone can point me in the right direction or link to a Bet Angel video (I've looked previously but not found one) that shows the process.
Cheers.
Import stake data from Excel to Bet Angel
So looking into this a bit more, I have been trying to use the CSV file method to see how it works, but I can't quite get it. I've posted some screen shots below on what I have tried.
Using one of the template examples that Bet Angel have provided. The first picture below is my CSV file:
Then into Guardian to create a new rules file called Maiden. The general tab (I set it to Always armed):
The Parameters tab. Browsed to the CSV file and checked file for errors - all good:
Using one of the template examples that Bet Angel have provided. The first picture below is my CSV file:
Then into Guardian to create a new rules file called Maiden. The general tab (I set it to Always armed):
The Parameters tab. Browsed to the CSV file and checked file for errors - all good:
You do not have the required permissions to view the files attached to this post.
Then into the One-click screen which has the first race of this afternoon which is a Mdn. Opened the Custom Columns editor and populated the General section:
Added the Maiden column to the One-click screen:
I was expecting 1.2 to be in the Maiden column but it was blank. Am I missing something or doing something wrong?
Thanks for any comments.
Added the Maiden column to the One-click screen:
I was expecting 1.2 to be in the Maiden column but it was blank. Am I missing something or doing something wrong?
Thanks for any comments.
You do not have the required permissions to view the files attached to this post.
I forgot to add the Maiden rule to Guardian which has now fixed the issue of the column being blank on the one-click screen.
So now I've got that cracked onto the next issue. For the 'Value Itself' column in the CSV file I have copied data from an XLS file that imports from Bet Angel. This data is constantly changing, and although the CSV data updates, the One-Click screen doesn't unless the CSV file is constantly saved. Not sure if I can get the data to auto update in the One-click screen.
Then my next challenge is to convert the data in the One-click screen to be a lay liability bet.
So now I've got that cracked onto the next issue. For the 'Value Itself' column in the CSV file I have copied data from an XLS file that imports from Bet Angel. This data is constantly changing, and although the CSV data updates, the One-Click screen doesn't unless the CSV file is constantly saved. Not sure if I can get the data to auto update in the One-click screen.
Then my next challenge is to convert the data in the One-click screen to be a lay liability bet.