Power Query - Steamers & Drifters

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

I've used Power Query to grab the data from the At The Races website for both Steamers & Drifters. It also grabs the Top 10 for each too.

Screenshot 2020-12-01 112210.png

If you use this, it may be beneficial to refresh the data at a particular time of day or 10mins before the off, as the figures change considerably during the day.
You do not have the required permissions to view the files attached to this post.
User avatar
Realrocknrolla
Posts: 1903
Joined: Fri Jun 05, 2020 7:15 pm

paspuggie48 wrote:
Tue Dec 01, 2020 11:28 am
I've used Power Query to grab the data from the At The Races website for both Steamers & Drifters. It also grabs the Top 10 for each too.


Screenshot 2020-12-01 112210.png


If you use this, it may be beneficial to refresh the data at a particular time of day or 10mins before the off, as the figures change considerably during the day.


ATR Steamers & Drifters.xlsx
Extraordinary!
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

you missed a trick by not hyperlinking the At the races website to the logo?
And so the apprentice becomes the master. lol
User avatar
Realrocknrolla
Posts: 1903
Joined: Fri Jun 05, 2020 7:15 pm

MemphisFlash wrote:
Tue Dec 01, 2020 11:56 am
you missed a trick by not hyperlinking the At the races website to the logo?
And so the apprentice becomes the master. lol
HAHA!!!!
User avatar
paspuggie48
Posts: 611
Joined: Thu Jun 20, 2013 9:22 am
Location: South-West

MemphisFlash wrote:
Tue Dec 01, 2020 11:56 am
you missed a trick by not hyperlinking the At the races website to the logo?
And so the apprentice becomes the master. lol
I get that a lot from my students lol. The whole point is I'm a busy man so I don't have to navigate to the website :) ;)
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

Capture.JPG

i changed your colour scheme as well
You do not have the required permissions to view the files attached to this post.
User avatar
murdok
Posts: 151
Joined: Sun Apr 02, 2017 7:10 pm

this is very good, it's just a pity the odds are not decimal ;)
User avatar
paspuggie48
Posts: 611
Joined: Thu Jun 20, 2013 9:22 am
Location: South-West

murdok wrote:
Tue Dec 01, 2020 2:15 pm
this is very good, it's just a pity the odds are not decimal ;)
Try the attached now Murdok. Does this work?

ATR Steamers & Drifters.xlsx

As Memphis shows, one can change colours etc to suit their particular style. Select "Design"

Screenshot 2020-12-01 165102.png
You do not have the required permissions to view the files attached to this post.
User avatar
murdok
Posts: 151
Joined: Sun Apr 02, 2017 7:10 pm

its good thx ;)
User avatar
paspuggie48
Posts: 611
Joined: Thu Jun 20, 2013 9:22 am
Location: South-West

Power Query – Steamers & Drifters

Market indicators showing Steamers & Drifters

Steamers & Drifters.xlsx

To update the data each day select: Data Tab > Refresh All
You do not have the required permissions to view the files attached to this post.
pyfprofessionals
Posts: 7
Joined: Wed Nov 10, 2021 7:07 pm

Thank you for sharing your work :D
Post Reply

Return to “Excel Power Query”