Power Query - Example Spreadsheets (Indexed by Sport)

Post Reply
User avatar
paspuggie48
Posts: 611
Joined: Thu Jun 20, 2013 9:22 am
Location: South-West

MemphisFlash wrote:
Fri Dec 11, 2020 11:11 am
NBA Projections - Power Query.xlsx


you mean like this one
Cracking ;)
makkad
Posts: 81
Joined: Thu Sep 22, 2016 10:38 pm

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
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

Capture.JPG
You do not have the required permissions to view the files attached to this post.
User avatar
paspuggie48
Posts: 611
Joined: Thu Jun 20, 2013 9:22 am
Location: South-West

MemphisFlash wrote:
Sun Jun 06, 2021 12:03 am
Capture.JPG
Wow...Luke Skywalker has now turned into a full-on Jedi 8-)

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.
User avatar
ShaunWhite
Posts: 9731
Joined: Sat Sep 03, 2016 3:42 am

paspuggie48 wrote:
Fri Jun 25, 2021 7:32 pm
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
You do not have the required permissions to view the files attached to this post.
User avatar
paspuggie48
Posts: 611
Joined: Thu Jun 20, 2013 9:22 am
Location: South-West

ShaunWhite wrote:
Fri Jun 25, 2021 8:42 pm
paspuggie48 wrote:
Fri Jun 25, 2021 7:32 pm
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.
User avatar
Realrocknrolla
Posts: 1903
Joined: Fri Jun 05, 2020 7:15 pm

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

Did you use another tool MF? I presume so!
User avatar
paspuggie48
Posts: 611
Joined: Thu Jun 20, 2013 9:22 am
Location: South-West

Realrocknrolla wrote:
Sat Jun 26, 2021 11:24 am
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.
User avatar
Realrocknrolla
Posts: 1903
Joined: Fri Jun 05, 2020 7:15 pm

Yes pls.
stever78
Posts: 93
Joined: Wed May 24, 2017 7:43 pm

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
You do not have the required permissions to view the files attached to this post.
Atho55
Posts: 637
Joined: Tue Oct 06, 2015 1:37 pm
Location: Home of Triumph Motorcycles

You can navigate here to find stuff https://www.racingpost.com/profile/jock ... oked-rides
stever78
Posts: 93
Joined: Wed May 24, 2017 7:43 pm

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 !!!
User avatar
paspuggie48
Posts: 611
Joined: Thu Jun 20, 2013 9:22 am
Location: South-West

stever78 wrote:
Sun Jun 27, 2021 1:48 pm
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
User avatar
paspuggie48
Posts: 611
Joined: Thu Jun 20, 2013 9:22 am
Location: South-West

stever78 wrote:
Sun Jun 27, 2021 2:33 pm
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
Posts: 93
Joined: Wed May 24, 2017 7:43 pm

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
Post Reply

Return to “Excel Power Query”