Data-Import via Excel and/or CSV-File

Help improve Bet Angel.
Post Reply
User avatar
tlkjb
Posts: 86
Joined: Thu Aug 26, 2021 10:08 am

There are at the moment 2 options to get data into BetAngel:

1) Guardian Excel Connection.
Pro: There are a lot of things you can do in VBA, that you can't do in Bet Angel Automation and so it's a very powerful add-on.
Contra: You can't regulate the data stream from BetAngel to Excel, which you start to "feel", if you have multiple markets (specially if they are live).
Suggestion: Create a Global Command to turn on/off the updates of market prices / tennis scores / Stored Value of each connected market / Excel-Sheet. This would help with the performance and make it possible to use Excel also to just get data as Stored Values into Bet Angel.

2) Automation "Set Stored Values using a file"
Pro: Super easy to use and fast. No other program like Excel needs to be running constantly
Contra: Needs to be triggered by an Automation condition (= something "inside" BetAngel") On the other hand if you use it without Automation condition, you will either permantly overwrite Stored Values or get the constant error message in the logs "the file doesn't exist". So not really meant to be used as a constant data-import source.
Suggestion: make it possible to a) turn off the error message if the CSV file doesn't exist. b) monitor the selected CSV file on change (as a Windows FileSystem Event) and only then the trigger the "CSV-Import"-Automation Rule. c) use the market ID for the CSV filename (so if the market ID is "123456789" the rule is automatically looking in the selected folder for a CSV file with the filename "123456789.csv")
Post Reply

Return to “Suggestions”