how to get the favourite to go to the top on betangel?

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
calais250
Posts: 14
Joined: Fri Jul 15, 2011 3:49 pm

Hi, everyone
Im trying to trade on the Australian horse market, but it's not like the UK market, The favorite horse goes on top of screen because of the low prices. how do i make the Australian market to do this? it would make it easier to use with excel and maybe lay just the favourite.
Thanks for any help
calais250
Posts: 14
Joined: Fri Jul 15, 2011 3:49 pm

sorry i forgot im using bet angel and on the one click screen, if any one knows any setting i can use, would be so much help.
User avatar
TheTub
Posts: 267
Joined: Thu Mar 26, 2009 7:53 pm

Sort by price by clicking on the column header.

See here page 56:

http://www.betangel.com/user-guide/bap.php
calais250
Posts: 14
Joined: Fri Jul 15, 2011 3:49 pm

Thanks Tub
clicking on the price tab did the trick and i saved my setting. :D
calais250
Posts: 14
Joined: Fri Jul 15, 2011 3:49 pm

now to get excel to do the same, any help any one?
thank you
User avatar
Euler
Posts: 26434
Joined: Wed Nov 10, 2010 1:39 pm

You can immediate swap rows on the spreadsheet or else the market could end up mis-aligned to the bet rules you are trying to fire against. All you need to do is set up another sheet with selections ordered how you want. Just create a header sheet to the underlying data.
calais250
Posts: 14
Joined: Fri Jul 15, 2011 3:49 pm

sorry i don't understand you, i'm using the guardian
auto select market for me every 5 minutes, but what your saying is i should manually place the favourite to the top? but it works great for UK market, if you can help and send me a template you might have.
THank you
User avatar
Euler
Posts: 26434
Joined: Wed Nov 10, 2010 1:39 pm

Have a look at this video: -

http://www.betangel.tv/video/using-bet- ... osing-data

It should point you in the right direction.
calais250
Posts: 14
Joined: Fri Jul 15, 2011 3:49 pm

thanks Uler
so we need to do this for every race? :( . I use guardian with excel and it does it with ease for the UK market,always has the favorite on the B9 cell with the lowest price, but why not for The Australian Market?
thanks everyone
User avatar
Euler
Posts: 26434
Joined: Wed Nov 10, 2010 1:39 pm

No, once you have set up the template it will do it for each race because you will define what information is displays and how. In the UK racing Betfair sort by order of favourtism but they don't do this in AUS for some reason.
calais250
Posts: 14
Joined: Fri Jul 15, 2011 3:49 pm

can you please show me a template, i'm using standard bet angel template, maybe you can write or show me one. I tried to copy and paste one for you.
Thank Uler
User avatar
Euler
Posts: 26434
Joined: Wed Nov 10, 2010 1:39 pm

No I can't, the idea of all this flexability is that it allows you to do what you want. So you should experiment with ideas based around exactly what you want to do. If you are trying to back or identify the favourite that's easy to do in Excel.
User avatar
Euler
Posts: 26434
Joined: Wed Nov 10, 2010 1:39 pm

If you look in the Excel section of the forum is seems several people have worked on ranking runners.

viewtopic.php?f=19&t=4539
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”