This is a quick guide on how to use one of the many data-capture worksheets available to download from this section of the forum, the same principle is applied to any worksheet you wish to use with Bet Angel.
There are two ways to use any Excel sheet with Bet Angel, first is on the main screen and would be used for single markets, the second and one you’ll likely be using if capturing data from multiple each day is through Guardian.
Main Interface
To capture data (or use any workbook on a single market) select the ‘Excel’ tab, then click browse and locate the file on your PC, if you have just downloaded it will likely be in your download folder, when you get to that folder if you can’t see it you may have to select ‘All Files’ as shown in the image below
Once selected, click ‘Open’ then as soon as it's opened the ‘Connect’ button will become active, click this and your data-capture sheet will be connected to whatever market you have on your ladder/one-click screen.
Guardian
As I said earlier the most likely way you will use a data capture sheet is via Guardian and applying the data-capture sheet to multiple markets.
To do this first make sure you have your markets loaded into Guardian then click the ‘Excel’ tab across the top and it’s the same process as before, Browse for your workbook, click ‘Open’ then click ‘Connect’
If the data-capture sheet (or whatever workbook your going to be using) has multiple worksheets within it (ie, Bet Angel, Bet Angel 2, Bet Angel 3 etc) then you can tick the ‘Auto-bind Bet Angel Sheets’ box located just to the right of the connect button and each market will be binded (connected) to its own individual sheet automatically for you.
If your data-capture sheet will be capturing all the data to one worksheet (has only one worksheet named Bet Angel) then after connecting the sheet click on the ‘Excel’ cell for the first market and select the worksheet named ‘Bet Angel’ as sown in the image below
You will then need to repeat that for the remaining markets – unless you use the keyboard shortcut editor and create a short cut key to clone excel binding, see image below for the options required in the keyboard short cut editor.
If you have an assigned short cut key then with the first market in Guardian highlighted press your 'Shift + End' keys to select all markets or use 'Shift + Dwn Arrow' key to select a few, once the ones your interested in are all highlighted press your shortcut key to bind this same Bet Angel sheet to those markets in one go.
Finally, ensure you have your Guardian refresh rates and any restrict refresh settings you maybe using correctly set to enable you to capture the data you require
How to use and Connect a Data Capture Spreadsheet to Bet Angel
Locked
1 post
• Page 1 of 1
Locked
1 post
• Page 1 of 1
Jump to
- Bet Angel Professional - Betfair trading software
- ↳ Bet Angel - Release & version history
- ↳ Announcements
- ↳ Bet Angel - FAQ's
- ↳ Bet Angel for newbies / Getting started
- ↳ Bet Angel - Tips and tricks
- ↳ Bet Angel - Spreadsheet / Excel chat
- ↳ Bet Angel - Example spreadsheets
- ↳ Horse racing
- ↳ Trade analysis & record keeping
- ↳ Tips and tricks
- ↳ Excel Power Query
- ↳ Bet Angel - Automation
- ↳ Bet Angel - Total Performance Data - FAQ's
- ↳ Bet Angel Automation - Shared files
- ↳ Bet Angel Automation - Football
- ↳ Bet Angel Automation - Tennis
- ↳ Bet Angel Automation - Horse racing - In-running
- ↳ Bet Angel Automation - Horse racing - Pre off
- ↳ Bet Angel Automation - General
- ↳ Bet Angel - API
- ↳ Bet Angel Automation - Betfair trading alerts
- ↳ Tennis trading alerts
- ↳ Bet Angel - Servants
- ↳ Bet Angel - Servants - Shared files
- ↳ Bet Angel - Customisation, settings, filters and coupons.
- ↳ Market selection filters
- ↳ Market coupons
- ↳ One Click trading interface
- ↳ Ladder trading interface
- ↳ Advanced charting
- ↳ In-play trader tool
- ↳ Guardian market list layouts
- ↳ TPD / Total Performance Data
- ↳ Suggestions
- ↳ Betfair trading videos - For current videos visit www.betangel.tv
- ↳ Support
- Betfair trading & Sports Betting strategies
- ↳ General discussion
- ↳ Australian
- ↳ Deutsche
- ↳ Español
- ↳ Italiano
- ↳ русский
- ↳ Trading Horse racing
- ↳ Football trading
- ↳ Trading Financial markets
- ↳ Cryptocurrency
- ↳ Tennis Trading
- ↳ Trading Psychology
- ↳ Other Betfair Sports Trading markets
- ↳ Trading Golf
- ↳ Rugby
- ↳ Boxing
- ↳ Non Sports trading Markets
- ↳ Political betting & arguing
- ↳ Technology
- ↳ Betfair Cricket trading
- ↳ Betfair trading strategies
- ↳ Sports betting strategies
- ↳ Loss recovery systems and methods
- ↳ Trading Greyhound racing
- Betting exchange & Bookmakers reviews and advice
- ↳ Chill Out Area
- ↳ Betfair exchange
- ↳ Betfair Data
- ↳ Betfair Exchange API
- ↳ Betdaq exchange
- ↳ Alternative betting exchanges, Smarkets, Matchbook etc.
- ↳ Bookmaker & Sportsbooks
-
- Bet Angel Quicklinks