I love the CSV race card - This could make things much easier.
I have been using a freelancer (from Odesk) to manually download historic race cards into Excel. The process was rather complicated, but I have been able to look at tipsters predictions for the last couple of months & the results - identifying whether I could make money backing or laying their tips.
Has anyone managed to download historic race cards into CSV? Historic race cards are available on AtTheRaces, but the process to extract the data seems quite tricky.
Downloading racecards in CSV
-
- Posts: 3
- Joined: Mon Apr 01, 2013 11:45 am
I use Web Content Extractor. I download all the days racing and export it from WCE as a CSV file and then import it into a MYSQL database.
Very helpful after sales. Think the program cost £50 when I bought it about 3 years ago and you can get a free trial to prove it works.
I have no connection to this company other than being a user of their software
Very helpful after sales. Think the program cost £50 when I bought it about 3 years ago and you can get a free trial to prove it works.
I have no connection to this company other than being a user of their software
This is not working anymore. Is there a chance you could update it so it can be used again?
Thanks in advance!
You can do it already, we updated a few versions back: -
https://youtu.be/q2rxyyDjRY0
Load into Guardian, right click, export.
https://youtu.be/q2rxyyDjRY0
Load into Guardian, right click, export.
- paspuggie48
- Posts: 665
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
To jump on the back of Peter's post, I do exactly this. Export the CSV file then use Power Query to format a basic meeting/race/horse table of contents.
This is based on my Guardian List (of those same Header Names)
If one wanted a more detailed set of data e.g. Form, Jockey & Trainer then alter your Guardian List and export. It will require a bit more work in PQ but it would be automated per se.
Maybe in time I can develop a 'dynamic' PQ for anyone to use...will have a think !
Caveat being Guardian is limited to 100 columns if I am correct, so always bear in mind the max of up to 40 runners, so if you wanted Form, Jockey & Trainer for those possible 40 runners as well then you already are maxing out the Columns permitted.
This is based on my Guardian List (of those same Header Names)
If one wanted a more detailed set of data e.g. Form, Jockey & Trainer then alter your Guardian List and export. It will require a bit more work in PQ but it would be automated per se.
Maybe in time I can develop a 'dynamic' PQ for anyone to use...will have a think !
Caveat being Guardian is limited to 100 columns if I am correct, so always bear in mind the max of up to 40 runners, so if you wanted Form, Jockey & Trainer for those possible 40 runners as well then you already are maxing out the Columns permitted.
You do not have the required permissions to view the files attached to this post.
Hi PeterEuler wrote: ↑Fri Feb 25, 2022 6:41 pmYou can do it already, we updated a few versions back: -
https://youtu.be/q2rxyyDjRY0
Load into Guardian, right click, export.
Golly gosh!
That's a great video. I don't know how I missed the racecards info option.
Many thanks.
Cheers
Mike
Have you got a template copy of that spreasheet with the Power Queries. I have no idea how to write a power query. I would like to have the columns for the distance and race type hcp etcpaspuggie48 wrote: ↑Sat Feb 26, 2022 8:55 amTo jump on the back of Peter's post, I do exactly this. Export the CSV file then use Power Query to format a basic meeting/race/horse table of contents.
Screenshot 2022-02-26 084521.png
This is based on my Guardian List (of those same Header Names)
If one wanted a more detailed set of data e.g. Form, Jockey & Trainer then alter your Guardian List and export. It will require a bit more work in PQ but it would be automated per se.
Maybe in time I can develop a 'dynamic' PQ for anyone to use...will have a think !
Caveat being Guardian is limited to 100 columns if I am correct, so always bear in mind the max of up to 40 runners, so if you wanted Form, Jockey & Trainer for those possible 40 runners as well then you already are maxing out the Columns permitted.
- Realrocknrolla
- Posts: 1903
- Joined: Fri Jun 05, 2020 7:15 pm
Hello mate, hope this post helps.gstar1975 wrote: ↑Wed Jul 20, 2022 1:24 pmHave you got a template copy of that spreasheet with the Power Queries. I have no idea how to write a power query. I would like to have the columns for the distance and race type hcp etcpaspuggie48 wrote: ↑Sat Feb 26, 2022 8:55 amTo jump on the back of Peter's post, I do exactly this. Export the CSV file then use Power Query to format a basic meeting/race/horse table of contents.
Screenshot 2022-02-26 084521.png
This is based on my Guardian List (of those same Header Names)
If one wanted a more detailed set of data e.g. Form, Jockey & Trainer then alter your Guardian List and export. It will require a bit more work in PQ but it would be automated per se.
Maybe in time I can develop a 'dynamic' PQ for anyone to use...will have a think !
Caveat being Guardian is limited to 100 columns if I am correct, so always bear in mind the max of up to 40 runners, so if you wanted Form, Jockey & Trainer for those possible 40 runners as well then you already are maxing out the Columns permitted.
viewtopic.php?f=5&t=25987
- Realrocknrolla
- Posts: 1903
- Joined: Fri Jun 05, 2020 7:15 pm
Have you produced a "Dynamic" PQ yet? Or are you still thinkingpaspuggie48 wrote: ↑Sat Feb 26, 2022 8:55 amTo jump on the back of Peter's post, I do exactly this. Export the CSV file then use Power Query to format a basic meeting/race/horse table of contents.
Screenshot 2022-02-26 084521.png
This is based on my Guardian List (of those same Header Names)
If one wanted a more detailed set of data e.g. Form, Jockey & Trainer then alter your Guardian List and export. It will require a bit more work in PQ but it would be automated per se.
Maybe in time I can develop a 'dynamic' PQ for anyone to use...will have a think !
Caveat being Guardian is limited to 100 columns if I am correct, so always bear in mind the max of up to 40 runners, so if you wanted Form, Jockey & Trainer for those possible 40 runners as well then you already are maxing out the Columns permitted.