A macro to Download form data from webpage (Just learning about Excel at 61)

[HectorIN2Excell]

I am trying to download webpage data from the link below and can do it to a certain standard but the data gets jumbled at times and isn't consistent
using procedures within excel.
Greyhound Bet | Greyhound Betting Web App from the Racing Post

So I would like to have my own macro that collects data from each race for 6 greyhounds.
with the data from each heading below in a table.

Date	Track	Dis	Trp	Split	Bends	Fin	By	Win/Sec	Remarks	WnTm	Gng	Wght	SP	Grade	CalTm

The end product I would appreciate is to have the : The greyhound name, The data under each heading, Each race downloaded onto separate sheets, Race 1 on sheet1 upto last Race 12 on sheet 12. This is repeated for which ever greyhound track meeting I run at it on. (Tracks are like Romford, Crayford, Towcester, etc)
I am a oldie whois a newbie at this so I would really appreciate some of your wisdom and knowhow on this matter.

Thanks in advance

 

[Dan_W]

You can use Power Query in Excel to get data from this url: https://greyhoundbet.racingpost.com/meeting/blocks.sd?r_date=2023-05-10&view=meetings&blocks=header,list

Nicely done identifying the JSON source!

 

[nguyendang]

Nicely done identifying the JSON source!

Well, it's a little trick here. From any Chromium-based web browser, you can press F12 to open Developer Tools, then click the Network tab to figure out what API endpoint is providing data feed to the website you're visiting.

 

[Dan_W]

Well, it's a little trick here. From any Chromium-based web browser, you can press F12 to open Developer Tools, then click the Network tab to figure out what API endpoint is providing data feed to the website you're visiting.
View attachment 91834

I'm familiar with it, but it's not a little trick - it's one I wish more people knew, and so am grateful to you for explaining it here on the forum!

 

[SQUIDD]

Hi Hector

Did you get this worked out from the help?

If not, i have some code for you.

Dave

 

[HectorIN2Excell]

Hi Hector

Did you get this worked out from the help?

If not, i have some code for you.

Dave

I'm sorry but talking JSON and all is above my scope. I am manually doing at the moment......so any code would be appreciated. I think you guys are all amazing but you have to be aware that some of us are really starting to learn this from scratch...Real Dummies do exist to .....to start with.

 

[Dan_W]

I'm sorry but talking JSON and all is above my scope. I am manually doing at the moment......so any code would be appreciated. I think you guys are all amazing but you have to be aware that some of us are really starting to learn this from scratch...Real Dummies do exist to .....to start with.

I don't understand. What are you talking about? @nguyendang already wrote the whole thing for you: A macro to Download form data from webpage (Just learning about Excel at 61)

 

[SQUIDD]

Dan

i think the issue is its not setting out the data as per the original post.

Hector

Can i just confirm what you want.

1 - We would add a drop down(data validation) list say into cell a1. This would be all the track names from todays racing
2 - You could then use this to select the track you want to download.
3 - after selection of your track, we would work out how many races are at that track. Then create sheets to this amount, 14 races would be sheets 1-14 created.
4 - then on sheets 1-14, starting at sheet1 we would download the 1st race, all the information from all 6 greyhounds as per the header catagories you requested in your original post.

is that something like correct.
I would imagine you want to run some sort of data analasis on this data.
could i ask why you would not review 1 race at a time, so the dropdown would be everyrace from today, and on selextion 1 comple race would be downloaded?

Dave

 

[SQUIDD]

hector

i have just sent you a privat message

 

[HectorIN2Excell]

Dave I need to give you a standing Ovation......You gave me the perfect solution. All I can say is thank you!!

 

[SQUIDD]

Dave I need to give you a standing Ovation......You gave me the perfect solution. All I can say is thank you!!

Thanks for the feedback hector.

thanks need to also go out to @nguyendang for suggesting and writing the part to get the json, as i have never seen this before.

good job

dave