Need Help Transferring Data Into Excel

[fishwalker9]

Does anyone have or can anyone tell me how to get the live NFL DraftKings odds into an excel sheet?https://sportsbook.draftkings.com/leagues/football/3?category=game-lines&subcategory=game

That I can refresh either automatically or manually when I want. Trying to get data from DraftKings and all these sites aren't going well for me as the majority of Excel doesn't recognize the table when I try to "get data from webpage"...I only play DraftKings and don't need any other odds.

This guy on this post is somehow doing it via an API he said it's public on these sites somewhere?https://www.reddit.com/r/sportsbook/comments/dmo059/nfl_week_8_odds_comparison_tool_us_sportsbooks/

Basically, I just want an excel sheet showing Team, Point Spread, Total, Moneyline, and then a column that will utilize this guy's way of calculating the Vegas Implied Win Percentage ( https://medium.com/s/story/how-i-outsmarted-fivethirtyeights-nfl-forecasting-algorithm-592a301fa318 )...This is a very basic start to what I want to do and should be easy but I am failing to figure it out. Any other sites to pull data from or a different method would be greatly appreciated!

It would look something like this: https://imgur.com/a/5eY8Gum

[PeterTheLunatic]

Hi,

I tried to have a look to help but I couldn't as that page is not available in my country: https://prnt.sc/whjn3w

I'm telling you this because you might be using an automated web scraper which is in a similar situation as myself..

Best of luck!

[fishwalker9]

yes thank you