My Excel O365 package updated and Power Query has an upgrade web scraper, so thought I'd give it a go. Not much noticeable but loading multiple Tables seemed easier and more efficient.
Another example of PQ getting some pointer stats for the day.
To refresh each day, select Data Tab > Refresh All
Power Query - Pointers
-
paspuggie48
- Posts: 659
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
You do not have the required permissions to view the files attached to this post.
-
MemphisFlash
- Posts: 2184
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
Love it.
You do not have the required permissions to view the files attached to this post.
-
paspuggie48
- Posts: 659
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
You do not have the required permissions to view the files attached to this post.
-
MemphisFlash
- Posts: 2184
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
Thank you for teaching me the basics of Power Query.
Since those initial sessions i have learnt so much more.
Since those initial sessions i have learnt so much more.
-
Realrocknrolla
- Posts: 1903
- Joined: Fri Jun 05, 2020 7:15 pm
+1MemphisFlash wrote: ↑Fri Nov 03, 2023 12:50 pmThank you for teaching me the basics of Power Query.
Since those initial sessions i have learnt so much more.
Hope your well Paul
-
paspuggie48
- Posts: 659
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
All good Mike, hope the job is treating you wellRealrocknrolla wrote: ↑Fri Nov 03, 2023 1:22 pm+1MemphisFlash wrote: ↑Fri Nov 03, 2023 12:50 pmThank you for teaching me the basics of Power Query.
Since those initial sessions i have learnt so much more.
Hope your well Paul
-
ShaunWhite
- Posts: 9731
- Joined: Sat Sep 03, 2016 3:42 am
Power Query is good at pulling together a set of data and then creating subsets from it, but what tools are people using to analyse it apart from eyeballs? Memphis probably doesn't need any cos he's been betting dogs since the 1950s but other will.
For me....because our data is small (gigabytes not terabytes) you can use a lot things out there for free. If you're familiar with the Microsoft family of products rather than python/Linux then it's well worth looking at https://azure.microsoft.com/en-gb/produ ... tomatedml/ . You can even use Power Query to feed it data. i know a few traders who are starting to use it or the AWS equivilent. It's not simple but simple doesn't do the job these days, but with AI to assist it's more accessible than ever.
For me....because our data is small (gigabytes not terabytes) you can use a lot things out there for free. If you're familiar with the Microsoft family of products rather than python/Linux then it's well worth looking at https://azure.microsoft.com/en-gb/produ ... tomatedml/ . You can even use Power Query to feed it data. i know a few traders who are starting to use it or the AWS equivilent. It's not simple but simple doesn't do the job these days, but with AI to assist it's more accessible than ever.