Help Pulling Odds to Google Sheets - Source

Question

Hi-

I am looking to pull BOL odds daily to a google sheet. Is there anyway to do this?

If not, where can I pull First 5 Over/Under & side odds from?

Willing to watch a tutorial or something to learn. I know google sheets & excel well and currently have an automatic updating template for stats. Trying to buildout for odds.

BarackPajamas · Answer

Hi-

I am looking to pull BOL odds daily to a google sheet. Is there anyway to do this?

If not, where can I pull First 5 Over/Under & side odds from?

Willing to watch a tutorial or something to learn. I know google sheets & excel well and currently have an automatic updating template for stats. Trying to buildout for odds.

bigvern1013 · Answer

Good question. I have no idea, but hope someone here can help.

thorpe · Answer

Pinnacle has an API. Used to be open to everyone but now it may just be for members.

https://www.pinnacle.com/en/api

Here is one way to get data from the internet to Excel.

Start recording Macro

Get External Data - website

put in URL

check what you want to import, click import

Stop Macro

Edit Macro if needed.

BarackPajamas · Answer

@Thorpe -Thank you.  So, Pinnacle I cannot use bc I need to be a member and do not live in LV.I never thought of making a macro to pull from the site. Can that be done in google sheets? I do not think you can pull from a site like BOL with excel because of the format.

thorpe · Answer

Excel only on the Macro and you are probably right on BOL being the wrong format...

Help Pulling Odds to Google Sheets - Source

Hot Forum Topics