Practice mode and excel

We were all new to Bet Angel once. Ask any question you like here and fellow forum members promise not to laugh. Betfair trading made simple.
Post Reply
User avatar
Hepburn
Posts: 173
Joined: Sun Feb 25, 2018 11:58 pm

Hi and Happy Friday!

I was wondering if theres a way to export the list of races im trading for the day, or have traded for the day into excel?
So i dont have to manually write everything down all the time.

In practice mode though.



Tia
sa7med
Posts: 800
Joined: Thu May 18, 2017 8:01 am

Just connect it to an excel with sheets Bet Angel to Bet Angel (x) sheets

Then have another sheet and in column A for example list Bet Angel (x)'!A1

so for example

Cell A1 > Bet Angel'!A1
A2 > Bet Angel (2)'!A1
A3 > Bet Angel (3)'!A1
etc

Then you can copy and paste values in another column to get the text list

EDIT: Sorry, you want B1 ie Bet Angel'!B1
User avatar
Hepburn
Posts: 173
Joined: Sun Feb 25, 2018 11:58 pm

Ok cheers but i need some instructions that are a little clearer.
Can i use a blank spreadsheet?
Is there guidance in the manual?

tia
sa7med
Posts: 800
Joined: Thu May 18, 2017 8:01 am

You can download one of the template excel sheets from the forum, otherwise:

open a new excel > name a sheet Bet Angel > copy it however many races you want

Then create another sheet where you will have your list (call it whatever)
in Column A:
A1 > =Bet Angel'!B1
A2 > =Bet Angel (2)'!B1
.
.
Ax > =Bet Angel (x)'!B1

open guardian > load up your list of horse races > navigate to excel tab > browse for your excel sheet > open, connect it.
User avatar
Hepburn
Posts: 173
Joined: Sun Feb 25, 2018 11:58 pm

ok that fab, il give it go.

Thanks for your help and have a lovely weekend :D
User avatar
ShaunWhite
Posts: 9731
Joined: Sat Sep 03, 2016 3:42 am

There's a multimarket data capture spreadsheet template included with BA. It might be a good starting point for learning how to get info out. Have a look in the manual too, I think it's mentioned.
User avatar
Hepburn
Posts: 173
Joined: Sun Feb 25, 2018 11:58 pm

Nice one Shaun, il check that out. thank you :D
eightbo
Posts: 2154
Joined: Sun May 17, 2015 8:19 pm
Location: Malta / Australia

Hepburn wrote:
Sun Apr 29, 2018 8:53 pm
Yep i found it
The video from the help file you linked is part of a thorough YT playlist: https://www.youtube.com/playlist?list=P ... 48EDF522F6

Plenty more working examples in there once you have the basics down :D
User avatar
Hepburn
Posts: 173
Joined: Sun Feb 25, 2018 11:58 pm

Cheers eightboi. Was in Brizzle at the weekend :D
Post Reply

Return to “Bet Angel for newbies / Getting started”