I am looking for someone able to extract the past odds from the Pinnacle bookmaker for the Asian Handicap and Over / Under markets on football (soccer) matches and import it into Excel.
No need to create a program to automatically retrieve future odds.
I only need past data, from August 1, 2016 to today (end of September 2021 for example) for all football matches in all competitions offered by Pinnacle during this period.
In detail, I would need all the lines and odds of the Asian Handicap and Over / Under markets at different times:
- Opening (first odds set by the bookmaker)
- In closing (last odds just before the start of the match)
- 10 minutes after the start of the match (or between 5 and 10 minutes if it is not available for the 10th minute, the chosen minute must be specified in a dedicated column)
- At half time (you can choose the odds at the start or at the end of the half, but try to keep the same process all the time)
There are a maximum of 9 different lines to extract for the biggest championships. For smaller championships which only have 1, 3, 5 or 7 lines, unspecified lines will be left empty.
For the Asian Handicap market, the line chosen will be the line of the home team
The odds will be in European format (1.90 / 1.90 for example)
There are several websites that allow you to retrieve opening and closing odds like oddsportal.com. You can use whatever website you prefer. The important thing is that the data is reliable. Maybe [login to view URL] has an API that does this, but I'm not sure.
To be honest I don't know where it is possible to extract the past odds live on Pinnacle, maybe thanks to their API but I don't know either.
So please specify in your post if you are sure you know how to collect past Pinnacle live odds. If no one knows, I will post a new ad amending this point.
In addition, it will be necessary to specify on the excel file for each match:
- The date of the match (Paris time GMT + 1) the date format is preferably: day / month / year
- The start time of the match (Paris time GMT + 1)
- The league / competition
- The home team
- The away team
- The score after 10 minutes of play (or at the minute chosen to take the odds if it was not available in the 10th minute)
- The score at half-time
- The final score
Attached is a sample presentation of the file. This is just an example, you can complete the file as you wish, one sheet per year, one sheet per type of bet, all the information on one sheet ... whatever.
The most important thing is that the file is understandable and that all the information is present and usable.
Note that I only specified lines 1 and 9 in the file, but the dotted lines between the columns clearly indicate that lines 2 to 8 will also need to be inserted if they are available.
Last point but which is optional because I do not know if it is feasible. Team names sometimes vary from website to website, so it would be necessary to change the team names to be the same as the [login to view URL] website.
For example, the team called "Vysehrad" on [login to view URL] is called "Slavoj Vysehrad" on [login to view URL], so the team should be called like on [login to view URL] "Slavoj Vysehrad" on the excel file if possible. If this is not possible, it does not matter, the most important are the previous points. But try to tell me in your post if you can get this last point as well.