Data from the web

[footysystems]

I am a rookie at Excel but would love some help

I can drag data from the website where i get it from, but was wondering weather there was away of getting live bookmaker / Betting exchange prices into an excel sheet to run along side the data ???

Any help would be greatful

Footysystems

 

[wigi]

Hello

About 1 minute ago, I pasted code in this topic:

http://www.mrexcel.com/forum/showthread.php?t=571657

Have a look there.

Obviously, there are more advanced ways but this should get you started.
If you indicate you're a rookie at Excel, you will first need to invest time in understanding this one.

Also look at importing data from the web with a webquery. If I'm not mistaken you, you can schedule it to update at a certain time interval.

 

[footysystems]

Thanks for the prompt reply Wigi i will take a look at the thread link you posted

 

[footysystems]

Hi Wigi

Without sounding a complete fool.

I would be looking at changing the web adress in the code you have written on the other thread ????

Regards

 

[wigi]

Without sounding a complete fool.

Too late

I would be looking at changing the web adress in the code you have written on the other thread ????

Among other things, yes. But that's the first you must do.

But I think the first thing to do is get the other code working (which it does for me).
Then go and study that code, read on the internet.
After that, try to solve your problem at hand with that new knowledge.

 

[footysystems]

Plenty of reading to do then Wigi i will give it a go and see where i get

 

[wigi]

Plenty of reading to do then Wigi i will give it a go and see where i get

That's true. What else are Sundays for ?

 

[footysystems]

Yes i will make it the first thing i do when i get home from working a 12 hour shift

 

[footysystems]

I am one happy man Wigi i got it to work, well the code that you wrote for that chap i ran it through VBA and the data appears

Made my day that has