Copy some data from a website into excel in a fast and accurate way
$500-5000 USD
Cancelled
Posted about 15 years ago
$500-5000 USD
Paid on delivery
The website is: http://sports.williamhill.com. I use excel 2007.
The subject is horse racing. In particular, us horse racing. The data there is not confidential (you don’t even have to be a member to see it). On the top of that, I can import it directly through excel by going to: “Data??, “From Web??, enter the exact web address of the race (e.g. [login to view URL]) and click “Import??. The problem with that, is that it’s very slow ??" takes about 6-7 seconds, and at that time, excel is paralyzed. So if I want to update the data every two seconds, it’s not only impossible (that way), but nothing can be done in excel (not manual things and also not marco running) at that whole time.
So, I want a program that will ask me for a web address, and will copy (when I enter a William hill horse racing web addres) it’s data into excel ,time after time, in less than two seconds(There should not be a case where William hill CURRENT race data, will take more than 2 seconds to get into the worksheet) until I tell it (click) to stop (usually, in order to pick the next race), in the next manner:
In column A, starting from cell A30, the horse number.
In column B, starting from cell B30, the horse name.
In column C, starting from cell C30, the "price guide".
In column D, starting from cell D30, the "pool guide".
In addition, I want that the program won’t “harm?? any other data that already exist in the spreadsheet and won’t disrupt the macro that is running in the same time (I use and oblige to use only ??" DoEvents method with [login to view URL] while calling the macro from itself (e.g. [login to view URL] Now, "Macro1" in the end of Macro1), so there probably should not be a problem, but it’s the responsibility of the programmer to make sure. I have an example in the attached files).
Last condition: sometimes I also use another program which automatically insert data to excel. It calls “betting assistant?? and you can download it from: [login to view URL] (use the upper link ??" the newest edition).
So, I want that the program also won’t harm the data flow from betting assistant into the same worksheet
There are further explanations and example in the attached files.
## Deliverables
* * *This broadcast message was sent to all bidders on Saturday Mar 21, 2009 7:36:44 PM:
I use excel 2007. Sorry i forgot to mention that.
* * *This broadcast message was sent to all bidders on Sunday Mar 22, 2009 11:12:10 AM:
Hi, I have 1 change and 1 condition in addition to what was in the bid: The change: I want that the data will be entered from cell A30,B30… and on (instead of A2,B2… and on). The condition: sometimes I also use another program which automatically insert data to excel. It calls “betting assistant?? and you can download it from: [login to view URL] (use the upper link ??" the newest edition). So, I want that the program also won’t harm the data flow from betting assistant into the same worksheet (and that’s why I asked line 30 instead of line 2) I added everything to the bid and the attached files (the "read this first" and "screen shots and result" files have been modified)