Huge stakes on lay side of 1.01 odds every time

[jamesedwards]

You did well to get that close to the front of the queue, there's usually a lot of people all competing to be first with a lot larger sums

Fastest finger first!

[globi166]

To put it into context with earlier years


1.01 and Lose.jpg





1.01 and Lose a.jpg

God Im so jealous about your spreadsheet!! I was trying to get all data about min in play price. So you can select past race and see min price of a horse being match in play. So looked at a historical betfair prices but have no clue how to connect all those spreadsheets from betfair from few years and make it easy to read and usable.

[firlandsfarm]

To put it into context with earlier years


1.01 and Lose.jpg





1.01 and Lose a.jpg

Love the crosstab Atho, I'm going to replicate it but with Race Type as a filter … figures may look better with last fence fallers!

[Atho55]

Globi

I can walk you through it.

If you have downloaded all the sheets you want then the next step is this

Combine Sheets.jpg

New Excel Workbook
Data, New Query, From Folder

Navigate to the folder containing the source files. If you have used the tool generously created by NigelK it should be like this. If not locate where you have placed it and select it.

Folder Path.jpg

Press OK

You should then be presented with this view

Combine & Load.jpg

I select Combine and Load if I remember correctly

This should load all the sheets from that folder into a single workbook tab.

Good luck

[globi166]

Globi

I can walk you through it.

If you have downloaded all the sheets you want then the next step is this

Combine Sheets.jpg


New Excel Workbook
Data, New Query, From Folder

Navigate to the folder containing the source files. If you have used the tool generously created by NigelK it should be like this. If not locate where you have placed it and select it.

Folder Path.jpg


Press OK

You should then be presented with this view

Combine & Load.jpg


I select Combine and Load if I remember correctly

This should load all the sheets from that folder into a single workbook tab.

Good luck

thanks so much but all my files are from betfair in some strange format bz2 all packed win winrar. So does not look like it will work ours seems to be csv.

[firlandsfarm]

thanks so much but all my files are from betfair in some strange format bz2 all packed win winrar. So does not look like it will work ours seems to be csv.

Ahhh, that means you have a Betfair historical Data download and not the BSP files … yeah, I know, complicated. I have never had any luck with the bz2 files, I've searched for and been given advice but it never seems to work for me so gave up! By all means have a go there is advice in the forum, search for "GitHub" and you should find posts referring to how to handle these files … good luck, and if it works remember me!

For the BSP files downloaded by Nigel's spreadsheet start here and follow the links. Nigel's spreadsheet on this forum is highly recommended, use it to download the BSP files on mass. But ...

I select Combine and Load if I remember correctly

This should load all the sheets from that folder into a single workbook tab.

Good luck

… and there's always a 'but' … be careful with the combining of the data. The Combine action joins all the files into one file on one worksheet, great. But the 'but' is it does it column by column and not by data definition. Therefore if the column order is not identical in every file (and they are not!) the data becomes jumbled. When I discovered this after noticing some weird analysis returns I search for obvious inaccuracies such as an XXXMIN value that's higher than an XXXMAX and found many of them! So it does need tidying, don't take any data from Betfair as gospel. They say data out is only as good as the data in but what they forget to warn you of is that it's also only as good as the person getting it out!

[Anbell]

I use a neat little program called TXTcollector which combines all the files into one.

[spreadbetting]

You did well to get that close to the front of the queue, there's usually a lot of people all competing to be first with a lot larger sums

Fastest finger first!

How did you manage that? Back in the day I used have a script running to check for new eventIds and fire into the market when new markets were put up. Don't remember ever getting to the front of the queue

[Derek27]

You did well to get that close to the front of the queue, there's usually a lot of people all competing to be first with a lot larger sums

Fastest finger first!

How did you manage that? Back in the day I used have a script running to check for new eventIds and fire into the market when new markets were put up. Don't remember ever getting to the front of the queue

Ten years ago I was often the first to fire bets (manually) into horse racing markets as soon as they opened. I haven't even looked at a horse racing market the night before lately so don't know what they're like now.

[firlandsfarm]

I use a neat little program called TXTcollector which combines all the files into one.

But does it combine them by column order or column header? I was simply joining them with DOS Copy which just appends each column in column order and disregards the column headers. It was when I noticed IPMIN's of 1,000 and IPMAX's of 1.

[Atho55]

One of the advantages of only saving what you need rather than all. You minimise the afterwork due to BF errors

[Anbell]

I use a neat little program called TXTcollector which combines all the files into one.

But does it combine them by column order or column header? I was simply joining them with DOS Copy which just appends each column in column order and disregards the column headers. It was when I noticed IPMIN's of 1,000 and IPMAX's of 1.

yes, it just combines the csvs that you can then use in excel with text-to-columns etc

[firlandsfarm]

I use a neat little program called TXTcollector which combines all the files into one.

But does it combine them by column order or column header? I was simply joining them with DOS Copy which just appends each column in column order and disregards the column headers. It was when I noticed IPMIN's of 1,000 and IPMAX's of 1.

yes, it just combines the csvs that you can then use in excel with text-to-columns etc

OK, I use DOS "copy *.csv AllFiles.csv" but if your app just does the same you then need to rearrange for the columns being in different order! It's just something people should be aware of when using the BSP files … it took me a while before I uncovered it!

[jamesedwards]

You did well to get that close to the front of the queue, there's usually a lot of people all competing to be first with a lot larger sums

Fastest finger first!

How did you manage that? Back in the day I used have a script running to check for new eventIds and fire into the market when new markets were put up. Don't remember ever getting to the front of the queue

A very healthy amount of luck I guess.