Power Query - Example Spreadsheets (Indexed by Sport)

[paspuggie48]

NBA Projections - Power Query.xlsx


you mean like this one

Cracking

[makkad]

https://www.eloratings.net/fixtures

I've tried to get some some data from this site using power query - but it may be more advanced than my skill level

Any ideas?

Cheers

[MemphisFlash]

Capture.JPG

[paspuggie48]

Capture.JPG

Wow...Luke Skywalker has now turned into a full-on Jedi

Not sure how you did it but well done Tom.

I can't do it for sure, so it would be good to share the workbook when you get chance fella.

[ShaunWhite]

I can't do it for sure, so it would be good to share the workbook when you get chance fella.

Have you been through these?....

Screenshot_11.jpg

[paspuggie48]

I can't do it for sure, so it would be good to share the workbook when you get chance fella.

Have you been through these?....Screenshot_11.jpg

Thanks Shaun.

[Realrocknrolla]

I can’t scrape it either with PQ or P Bi.

Did you use another tool MF? I presume so!

[paspuggie48]

I can’t scrape it either with PQ or P Bi.

Did you use another tool MF? I presume so!

It's an interesting challenge and I admit I cannot fathom it out. Flummoxed !!

So, I'd like to have the spreadsheet too and I'm sure Makkad and RRR would like it also so they can play with the data...as it looks like it may have some scope that website.

[Realrocknrolla]

Yes pls.

[stever78]

Hello Pugspar, rocknroller, and all.
thanks for your help yesterday

can i ask you , and anyone who knows, for your thoughts on how possible this is, and if so approx how would i go about doint it.

i have extracted the ATR SMART STATS into excel. ( i enclose pic of cartmels stats )

i can see that the trainer gary hanmer has a strike rate of 41%.

if i wanted to automate the process of taking ALL trainers with say over 30% strike rate AND then see the runners for those trainers.

Would i need to import a file of all runners + trainers for the day and then MATCH the two up.

and in terms of automating that, would i use a macro?.

do you think that would be the BEST way to go about it??

thanks for your help, much appreciated

steve

[Atho55]

You can navigate here to find stuff https://www.racingpost.com/profile/jock ... oked-rides

[stever78]

thanks for reply,

i wanted to automate the whole process.

so , run the " get data"
and
MACRO
to show me the runners for the HIGH TRAINERS for the day.

im thinking its a bit more complex than i first thought though !!!

[paspuggie48]

Hello Pugspar, rocknroller, and all.
thanks for your help yesterday

can i ask you , and anyone who knows, for your thoughts on how possible this is, and if so approx how would i go about doint it.

i have extracted the ATR SMART STATS into excel. ( i enclose pic of cartmels stats )

i can see that the trainer gary hanmer has a strike rate of 41%.

if i wanted to automate the process of taking ALL trainers with say over 30% strike rate AND then see the runners for those trainers.

Would i need to import a file of all runners + trainers for the day and then MATCH the two up.

and in terms of automating that, would i use a macro?.

do you think that would be the BEST way to go about it??

thanks for your help, much appreciated

steve

On the PQ thread you will see a document that gets the runners for the day. Then it's a case of merging both your document and the information from that document. Or you could dive into the PQ Editor to see how it is done etc.

To 'merge' tables/documents requires a bit of homework for you. I would go view YT channels like ExcelIsfun, Goodly, Access Analytic and many others...or just do a search how to do a PQ merge.

None of which will require any 'coding', unlike macros.

Peefa

[paspuggie48]

thanks for reply,

i wanted to automate the whole process.

so , run the " get data"
and
MACRO
to show me the runners for the HIGH TRAINERS for the day.

im thinking its a bit more complex than i first thought though !!!

It's not.

Imagine Workbook 1 is your Trainers data and Workbook 2 is your daily runners.

You merge the two (like vlookup) and using PQ to do that is much easier (with no formulas) and it is automated.

[stever78]

thanks very much for the replies

i think i need to read up on PQ. just need to take a breather after loading and looking into numerous MACROS ( some of which may now be redundant !!!!)

should of spent the time on PQ i think !!

thanks all