Days LTP for Betfair - all runners UK

[fractalmodel]

The last bit of combining is the difficult bit

The VBA code doesnt lend itself to combining without VBA

[fractalmodel]

You have it all wrong. BA collates ALL the info into 1 worksheet just like the SL ABC only the BA sheet has live ish Exchange odds and not bookie odds. This is the dashboard.

Both files multiple and Betangel 1 do not store prices on one sheet

[Euler]

I collect data but just do it one race at a time as Bet Angel switches between race. I then use a command line to join them all up in a csv file. Must be a simpler solution?

[Derek27]

The last bit of combining is the difficult bit

The VBA code doesnt lend itself to combining without VBA

I use an Excel workbook that connects multiple markets to BA. The VBA code writes to a log (text) file, all markets to the same file and appends it to the same file for the whole day.

If using VBA, could you not write a CSV file containing all the necessary data? As long as each line identifies the market and the data is in the same order you can later import it into Excel, sort and reformat it.

[ShaunWhite]

Both files multiple and Betangel 1 do not store prices on one sheet

Correct.

I'd suggest using the multiple version and have a seperate sheet that references each of them. But admittedly that's not straightforward unless you know a few choice vba commands.

Do you mind me asking why you need the comparison, the Betfair price will always be better?

[ShaunWhite]

If using VBA, could you not write a CSV file containing all the necessary data? As long as each line identifies the market and the data is in the same order you can later import it into Excel, sort and reformat it.

He needs live comparisons (I think). Not a capture and export.

[fractalmodel]

I have both bet365 at intervals and skybet but the BF prices are better as thats where I trade most

Therea couple of other options.....one is other software and the other StartHereFIRST but would rather use BA

[ShaunWhite]

I have both bet365 at intervals and skybet but the BF prices are better as thats where I trade most

Therea couple of other options.....one is other software and the other StartHereFIRST but would rather use BA

It's absolutely possible with just BA. You reminded me of a spreadsheet I did a few years ago, BF prices from BA, trainers with just 1 runner etc. I've just tried to get it working again for you but I stopped using it so long ago I seem to have lost the code that sits behind it. Pity. It still had the last sessions data in it thankfully to show you, June 2018!

It could have had bookie prices inserted as extra rows or any other info BA can export such as recent form. I forget exactly what this sheet did now but I think it also highlighted changes since the last refresh so that moves up or down were shown in red or blue. Basically if you can get anything into Excel anywhere, you can do what you want with it.

Screenshot_31.jpg

.....it seems to have a different format summary sheet too, it's something I never really finished but I hope it shows it's doable.

Screenshot_32.jpg

...I wonder what happened to Hit and Run in the 14:10....D McCain, 1 runner, watch out

[Atho55]

I collect data but just do it one race at a time as Bet Angel switches between race. I then use a command line to join them all up in a csv file. Must be a simpler solution?

Not if you want the odds a few hours before the racing starts, or want to track the odds from early morning to identify runners whose odds are out of kilter with what they historically are.

[fractalmodel]

It looks a gap in BA which hopefully will get sorted

[fractalmodel]

Bet Angel Runner names Last Traded Price
Bet Angel (3) Ailes Damour 28
Bet Angel (6) An Marcach 19.5
Bet Angel (14) Annie Magic 3.55
Bet Angel (3) Another Mystery 15
Bet Angel (4) Atlantic Heart 17
Bet Angel (15) Auditoria 6.6
Bet Angel (5) Aurigny Mill 140
Bet Angel (13) Aztec Empire 2.86
Bet Angel (2) Baliyad 29
Bet Angel (6) Ben Buie 5.8
Bet Angel (7) Ben Dikduk 7.8
Bet Angel (2) Benandgone 30
Bet Angel (23) Bhubezi 27
Bet Angel (15) Bolsover Bill 2.74
Bet Angel (5) Broomfields Cave 70
Bet Angel (8) Calgary Tiger 250
Bet Angel (13) Capital Theory 4.8
Bet Angel (11) Certainly Red 5.5
Bet Angel Coast 11
Bet Angel (2) Coldens Dream 17.5
Bet Angel Corinthia Knight 24
Bet Angel (5) Daany 1000
Bet Angel (2) Dannystory 48
Bet Angel (2) Darksideoftarnside 40
Bet Angel (5) Dear Ralphy 240
Bet Angel (20) Den The Diva 160
Bet Angel (3) Dev Of Tara 34
Bet Angel (9) Doireann 5.1
Bet Angel (6) Dondiam 2.96
Bet Angel (21) Easy Equation 5.4
Bet Angel (4) Em Jay Kay 5
Bet Angel (12) Enthused 0
Bet Angel (2) Fame And Fun 4.3
Bet Angel (17) Famous Clermont 1.99
Bet Angel (5) Far Sight 60
Bet Angel (2) Ferdinand Star 38
Bet Angel (14) Fortuna Ligna 7.4
Bet Angel (24) Furnicoe 2.16
Bet Angel (15) Getabuck 12
Bet Angel Give A Little Back 7
Bet Angel (5) Gyenyame 65
Bet Angel (2) Havaila 10
Bet Angel (2) Hazy Dream 55
Bet Angel (3) Honest Oscar 50
Bet Angel Idoapologise 18.5
Bet Angel Jack Ryan 11.5
Bet Angel (12) Jaramillo 3.85
Bet Angel (7) Jer Batt 5.3
Bet Angel (2) Jet Marshall 14.5
Bet Angel (4) Kaths Toyboy 14
Bet Angel (5) Keepitfrombecky 500
Bet Angel (10) King Athelstan 16.5
Bet Angel (21) King Charles 8.4
Bet Angel (7) Lady Loveless 95
Bet Angel (14) Lime Avenue 4.5
Bet Angel (6) Line Of Descent 5.9
Bet Angel (16) Lord Cherry 4.9
Bet Angel (7) Ma Famille 26
Bet Angel Marwari 8
Bet Angel (5) Matata 3.5
Bet Angel (8) Midnight Midge 2.98
Bet Angel (20) Midsummer Lass 330
Bet Angel (5) Mister Upton 85
Bet Angel (5) Montmartin 110
Bet Angel (7) More Than A Grey 5.7
Bet Angel (16) Muatadel 21
Bet Angel (4) Mumcat 6
Bet Angel (11) Nearly Perfect 46
Bet Angel (12) Ollys Folly 44
Bet Angel (10) Owens Lad 9.2
Bet Angel (18) Pachacuti 3.4
Bet Angel (7) Passion Tango 9.4
Bet Angel Peachey Carnehan 6.8
Bet Angel (10) Persian Wolf 4.4
Bet Angel (2) Phoenix Risen 90
Bet Angel (4) Proclivity 36
Bet Angel (11) Putdecashonthedash 25
Bet Angel Ramdon Rocks 22
Bet Angel (3) Release The Kraken 19
Bet Angel (5) Rocco Royale 80
Bet Angel (8) Rock Of Star 3.9
Bet Angel (2) Sami Bear 13
Bet Angel (4) Sams Call 10.5
Bet Angel (3) Secret Trix 2.84
Bet Angel (12) Sergeant Wilson 3.05
Bet Angel (2) Sermando 18
Bet Angel (2) Seymour Promise 23
Bet Angel (17) Shantou Flyer 3.95
Bet Angel (3) Shesupincourt 4.7
Bet Angel (5) Shuil Ceoil 100
Bet Angel (3) Smart Boyo 15.5
Bet Angel (5) Spartan Army 2.52
Bet Angel St Andrews Castle 12.5
Bet Angel (27) Storm Catcher 2.06
Bet Angel (7) Sugar Hill Babe 3.7
Bet Angel (18) Supreme Yeats 16
Bet Angel (11) Tallow For Coal 13.5
Bet Angel (2) Torula 4
Bet Angel (12) Treyarnon Bay 3.25
Bet Angel (5) Tuscan Rose 440
Bet Angel (28) Well Prepared 4.1
Bet Angel Winnetka 20
Bet Angel With Respect 7.6
Bet Angel (9) Woodford Bridge 130
Bet Angel (16) Written Broadcast 3.65
Bet Angel (3) Ya Know Yaseff 6.2
Bet Angel (26) Zany Idea 150

[ShaunWhite]

Why the LTP? Wouldn't the currently available back and/or lay price be better? LTP will flash from one side of the spread to the other.

[fractalmodel]

Dont need any of that