The Masters Live Scoring

[jlhoover3]

Hello all!

I have been importing external data to an excel sheet for years, but websites change. I am having problems pulling information from a live golf leaderboard to an excel sheet. Since most is using a java script leaderboard, my old program won't work anymore. I was wondering if anybody had ideas how to pull a live leaderboard from anywhere?

I used to use ESPN (2017 Masters Tournament Golf Leaderboard and Results- ESPN)

But willing to use anything that keeps the scores live.

Thanks so much!

 

[DRSteele]

PowerQuery works with the Golf Channel's website. This is the M-code for PQ.

let
Source = Web.Page(Web.Contents("http://www.golfchannel.com/tours/pga-tour/2017/masters-tournament/")),
Data0 = Source{0}[Data],
#"Changed Type" = Table.TransformColumnTypes(Data0,{{"", type text}, {"POS", type text}, {"MOV", type text}, {"PLAYER", type text}, {"OVERALL", type text}, {"THRU", type text}, {"RND", type text}, {"R1", type text}, {"R2", type text}, {"R3", type text}, {"R4", type text}, {"TOT", type text}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"", "MOV"}),
#"Filtered Rows" = Table.SelectRows(#"Removed Columns", each ([POS] <> "typeof(mps)=='object' && typeof(mps.getAd)=='function' && document.write(mps.getAd('midbanner1'));#(cr)#(lf)mps._execAd(""midbanner1"");" and [POS] <> "typeof(mps)=='object' && typeof(mps.getAd)=='function' && document.write(mps.getAd('midbanner2'));#(cr)#(lf)mps._execAd(""midbanner2"");")),
#"Replaced Value" = Table.ReplaceValue(#"Filtered Rows",null,"",Replacer.ReplaceValue,{"R1"}),
#"Replaced Value1" = Table.ReplaceValue(#"Replaced Value",null,"",Replacer.ReplaceValue,{"R2", "R3", "R4", "TOT"})
in
#"Replaced Value1"

 

[Chippy68]

Any chance someone can walk me through setting this up in Excel 2016. I have built a pretty comprehensive worksheet for golf pools....this would essentially automate the whole thing, but I have never used power query.

Thanks

 

[DRSteele]

Well, if you've never used PQ, you could acquire the fundamental knowledge by watching these and other videos on the excellent ExcelIsFun and MrExcel channels on youtube. Focus on the way fields (i.e., columns) are manipulated to tease out just the data you require from website sources.

I was able to load the relevant table from The Golf Channel's website and manipulate the data to make an Excel table for 2018.

https://www.youtube.com/watch?v=CsY9yb7Fm8E
https://www.youtube.com/watch?v=ohGFPF12Qwc&list=PLrRPvpgDmw0m3ohSvgwoHvd0KO8QsQdiK

 

[Chippy68]

Thanks. I've actually got it working in Google Sheets, but I would rather have it running in Excel, so I will take your advice here. Does it automatically refresh the data for you every few minutes?

 

[scpournara]

Thanks. I've actually got it working in Google Sheets, but I would rather have it running in Excel, so I will take your advice here. Does it automatically refresh the data for you every few minutes?

Were you able to complete this? I would like to do the same thing but need guidance. I am watching the videos on Youtube now. thanks.