Import live data from the web.

[serge]

Hi All,

I'm looking for some help to figure out, how to import Lottery data from the web ?

I was watching this tutorial video about it and, I was able to go as far as getting the last draw, but what I'm looking for is to download the whole history of the game, and the most important is to have the excel spreadsheet to up date the draw numbers automatically when the new draw is available on the web ?

The site I need it from is :
http://www.calottery.com/Games/MegaMillions/WinningNumbers/


Here the video link :
http://www.youtube.com/watch?v=qluB6IZ98rc&feature=related

Thank you in advance for any help.
Serge.

 

[RSXchin]

record yourself
1. Import web data
2. Go to the site in the browser it gives you
3. Find the table that has your winning numbers and click it
4. click Import

 

[serge]

Thank you rsxchin,

I got that, but when I want to download the whole history of the game ,I can't, when I click on " Download all numbers " it's on a note pad ???
which don't have no arrows to download.

And the refresh link only have minutes in it,I would need date as refresh button.

The refresh button is very important to me, Can a macro be built in excel for having this refresh button to work for date ?

I forgot to mention, I'm on Excel 07.

I'm just trying to see if there is a way, to make it happen ?
Thanks.

 

[RSXchin]

Just curious... you aren't trying to find out what numbers happen more often, are you? that's just silly.

 

[serge]

I just want to be able to update my file without doing it manually.

 

[serge]

Does anyone have an idea ?