Importing multiple data from different pages in the same website with cycles
$30-250 USD
Cancelado
Publicado hace más de 10 años
$30-250 USD
Pagado a la entrega
The project I have in mind is as follows: (not sure if it can be done in excel though)
Initially I'd like to show you this link which is used to define country, stadium and the date range for dog races results:
1. [login to view URL] , let's say I chose Bellevue as stadium and the races going from January to September 2013
After setting the desired information above you will find a list of greyhound races from Bellevue in a date range given:
2. [login to view URL]
If you click one of the links it will ask for login details, however I have attached a screen shot of what's on th other side. This issue of logging in should also be taken into consideration.
I'd like to import data from such pages (see sample page picture in the attachment) according to a cycle I assign. Let me explain, the cycle I chose is 35 days, so the macro goes back and imports results data from Bellevue RACE 1 (see the HT column in link 2 above corresponding to Race number), 35 days ago, then from 70 days ago, then from 105 days ago, then from 140 days ago, so there should be a way for excel to import from August 8, then from july 4, then from may 30, and so on as long as today's date is set as reference (September 5/13). As I mentioned that cycle should be variable and how long it goes in the past should also be variable.
Thanks in advance.