CrackingMemphisFlash wrote: ↑Fri Dec 11, 2020 11:11 amNBA Projections - Power Query.xlsx
you mean like this one
Power Query - Example Spreadsheets (Indexed by Sport)
- paspuggie48
- Posts: 674
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
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
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
- Posts: 2206
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
You do not have the required permissions to view the files attached to this post.
- paspuggie48
- Posts: 674
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
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
- Posts: 9731
- Joined: Sat Sep 03, 2016 3:42 am
Have you been through these?....paspuggie48 wrote: ↑Fri Jun 25, 2021 7:32 pmI can't do it for sure, so it would be good to share the workbook when you get chance fella.
You do not have the required permissions to view the files attached to this post.
- paspuggie48
- Posts: 674
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
Thanks Shaun.ShaunWhite wrote: ↑Fri Jun 25, 2021 8:42 pmHave you been through these?....Screenshot_11.jpgpaspuggie48 wrote: ↑Fri Jun 25, 2021 7:32 pmI can't do it for sure, so it would be good to share the workbook when you get chance fella.
- 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!
Did you use another tool MF? I presume so!
- paspuggie48
- Posts: 674
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
It's an interesting challenge and I admit I cannot fathom it out. Flummoxed !!Realrocknrolla wrote: ↑Sat Jun 26, 2021 11:24 amI can’t scrape it either with PQ or P Bi.
Did you use another tool MF? I presume so!
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.
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
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.
You can navigate here to find stuff https://www.racingpost.com/profile/jock ... oked-rides
- paspuggie48
- Posts: 674
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
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.stever78 wrote: ↑Sun Jun 27, 2021 1:48 pmHello 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
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
- Posts: 674
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
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.