Betfair Price Files Download Manager

Post Reply
Archery1969
Posts: 1031
Joined: Thu Oct 24, 2019 8:25 am

murdok wrote:
Thu Dec 24, 2020 10:35 am
the page where excel will download is this and excel is this I just downloaded and it worked well


link = https://promo.betfair.com/betfairsp/prices/

excel file = https://www.mediafire.com/file/cax8z1n3 ... .xlsm/file
But where does it download the files too. i have run it but cant find the files ?
User avatar
murdok
Posts: 148
Joined: Sun Apr 02, 2017 7:10 pm

Archery1969 wrote:
Thu Dec 24, 2020 11:05 am
murdok wrote:
Thu Dec 24, 2020 10:35 am
the page where excel will download is this and excel is this I just downloaded and it worked well


link = https://promo.betfair.com/betfairsp/prices/

excel file = https://www.mediafire.com/file/cax8z1n3 ... .xlsm/file
But where does it download the files too. i have run it but cant find the files ?

you need to send a folder with the correct name to C:\ ...

like this
C:\Greyhound WIN
Image
Archery1969
Posts: 1031
Joined: Thu Oct 24, 2019 8:25 am

murdok wrote:
Thu Dec 24, 2020 11:24 am
Archery1969 wrote:
Thu Dec 24, 2020 11:05 am
murdok wrote:
Thu Dec 24, 2020 10:35 am
the page where excel will download is this and excel is this I just downloaded and it worked well


link = https://promo.betfair.com/betfairsp/prices/

excel file = https://www.mediafire.com/file/cax8z1n3 ... .xlsm/file
But where does it download the files too. i have run it but cant find the files ?

you need to send a folder with the correct name to C:\ ...

like this
C:\Greyhound WIN
Image
Hi,

But where do you enter that in the spreadsheet ?

Thanks,
User avatar
murdok
Posts: 148
Joined: Sun Apr 02, 2017 7:10 pm

on youtube you have videos explaining how to do this and dealing with the date after uploading

https://www.youtube.com/watch?v=5L_5_kdXQHo

and if you search here on the forum there are already spreasheets with this date ;)
Archery1969
Posts: 1031
Joined: Thu Oct 24, 2019 8:25 am

But what’s the point of the spreadsheet that’s been posted. I run the initial setup, enter the year I want and then click the button. It then starts counting down from 335 to zero. But where do I enter where the files should go as that video doesn’t explain that part ?
spreadbetting
Posts: 3140
Joined: Sun Jan 31, 2010 8:06 pm

Archery1969 wrote:
Thu Dec 24, 2020 12:38 pm
But what’s the point of the spreadsheet that’s been posted. I run the initial setup, enter the year I want and then click the button. It then starts counting down from 335 to zero. But where do I enter where the files should go as that video doesn’t explain that part ?
It seems the program doesn't create the folders so you'd have to make those yourself before downloading. So if you wanted to download UK Win you'd need there to be a folder already on your C:\ hard drive named "C:\UK Win" if you were downloading Greyhound Win files you'd need a folder called "C:\Greyhound Win" already on the PC and so on.

If you're ok with VBA you can amend the directories by tweaking the UpdateFiles() sub routine or amending the DestinationFolder within the coding
Atho55
Posts: 439
Joined: Tue Oct 06, 2015 1:37 pm

You will need to create folders directly on the C: Drive with names that are the same as the titles on the Spreadsheet

Like this...
C Drive Folder Names.jpg
You do not have the required permissions to view the files attached to this post.
Archery1969
Posts: 1031
Joined: Thu Oct 24, 2019 8:25 am

Atho55 wrote:
Thu Dec 24, 2020 2:53 pm
You will need to create folders directly on the C: Drive with names that are the same as the titles on the Spreadsheet

Like this...

C Drive Folder Names.jpg
Awesome. Cheers. :)
Archery1969
Posts: 1031
Joined: Thu Oct 24, 2019 8:25 am

spreadbetting wrote:
Thu Dec 24, 2020 2:46 pm
Archery1969 wrote:
Thu Dec 24, 2020 12:38 pm
But what’s the point of the spreadsheet that’s been posted. I run the initial setup, enter the year I want and then click the button. It then starts counting down from 335 to zero. But where do I enter where the files should go as that video doesn’t explain that part ?
It seems the program doesn't create the folders so you'd have to make those yourself before downloading. So if you wanted to download UK Win you'd need there to be a folder already on your C:\ hard drive named "C:\UK Win" if you were downloading Greyhound Win files you'd need a folder called "C:\Greyhound Win" already on the PC and so on.

If you're ok with VBA you can amend the directories by tweaking the UpdateFiles() sub routine or amending the DestinationFolder within the coding
Cheers. :)
firlandsfarm
Posts: 1343
Joined: Sat May 03, 2014 8:20 am

cemocan70 wrote:
Thu Dec 24, 2020 9:27 am
After i've read firlandsfarm's post and changed the destination folder's name it looks like downloading the files but still getting the same error message, the main problem is the youtube links are not exists anymore so the excel dummies like me having problems.
Maybe it will help if I explain what I did and I apologise to Murdok and other contributors if they have already gone beyond this stage but it may be useful to some. Let me make something clear ... I am not an Excel expert nor a VBA person. I used to do coding when amateurs like me used BASIC language so I do have a rough idea how things work. :)

You need to see the VBA code and can do this by right clicking on any of the worksheet tabs at the bottom of the workbook and selecting "View Code". This opens the VBA editor.

In the left margin of the VBA editor you should see a section "Modules". Click on that and then Module 1 and the code will appear. You will see that the code is broken down in sections headed Sub UKWin() ... Sub UKPlace ... etc. And notice the first line of the code under those headings is the name of the folder where the downloaded files will be stored. Example ...

Sub UKWin()

FolderName = "UK Win"

I use the given folder names for storing the downloaded files but if you want to you can change them within the quotes.

Now scroll down to near the bottom of the code until you see the "Sub DownloadFiles()" ... this is the code instructing the app where to save the files. You will see a line (the 'bold text' is simply to highlight for you the text I changed).

DestinationFolder = "C:\" & FolderName & "\" & DownloadFileName

This is where you can change the destination. For example I changed this to read ...

DestinationFolder = "H:\Documents(H)\Money\Betting\Data\Betfair\Betfair SP's\" & FolderName & "\" & DownloadFileName

So I changed the destination from "C:\" to "b]H:\Documents(H)\Money\Betting\Data\Betfair\Betfair SP's\[/b]" ... you can choose any destination path that suits your folder structure but that destination path and the eventual folder name must already exist before downloading otherwise the files will look as if downloading but just disappear into the ether! :)

I hope this helps you to see how the code works, once you know that, you can customise it for your own purposes but only change things in "quotes" which are assignments of text ... do not change anything outside of "quotes" unless you really know what you are doing because that is the code! :o
Post Reply

Return to “Betfair Data”