Smartgambler
Pro-Punter

Go Back   OZmium Sports Betting and Horse Racing Forums > Public Forums > General Topics
User Name
Password
Register FAQ Search Today's Posts Mark all topics as read

To advertise on these
forums, e-mail us.

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 29th September 2005, 03:55 PM
mad mad is offline
Member
 
Join Date: Aug 2005
Posts: 898
Default Any excel experts out there....

Hey all,

Was wondering how, if at all, you could use an xml feed to update prices into an excel spreadsheet. Is it possible? I have the xml feed data but am not sure how to go about it, you have to use macros in excel i think. Is this correct?
Any help would be more than cool....

Thanks.
__________________
I like Bing Lee.
Reply With Quote
  #2  
Old 29th September 2005, 05:55 PM
SeeDee SeeDee is offline
Member
 
Join Date: Apr 2005
Posts: 39
Question XML Feed

Uhhhh. What is xml feed?
Reply With Quote
  #3  
Old 29th September 2005, 08:28 PM
marcus25 marcus25 is offline
Member
 
Join Date: Dec 2004
Posts: 172
Default

Quote:
Originally Posted by SeeDee
Uhhhh. What is xml feed?

Must be the stuff they feed the b...y nags I'm betting on!?
Reply With Quote
  #4  
Old 29th September 2005, 08:38 PM
davez davez is offline
Member
 
Join Date: Jan 1970
Posts: 301
Default

Quote:
Originally Posted by SeeDee
Uhhhh. What is xml feed?


very interested to find that out as well as google turns up diddly squat
Reply With Quote
  #5  
Old 29th September 2005, 08:48 PM
marcus25 marcus25 is offline
Member
 
Join Date: Dec 2004
Posts: 172
Default

Quote:
Originally Posted by davez
very interested to find that out as well as google turns up diddly squat

davez!
I was just jesting, XML stands for Extensible Markup Language (XML).
It is just an other file format to transmit info. Nothing special.
Still think the horses I'm betting on must be high on the stuff?
Reply With Quote
  #6  
Old 29th September 2005, 09:17 PM
davez davez is offline
Member
 
Join Date: Jan 1970
Posts: 301
Thumbs up excel

no worries marcus, i spend an unhealthy amount of time these days using excel, both for the punt & the my other "work", so when i read a line like "xml feed" i get a strange sort of fuzzy feeling allover, which i guess relates to me looking for another way to make my life a bit easier, data entry wise that is.
Reply With Quote
  #7  
Old 30th September 2005, 07:51 AM
marcus25 marcus25 is offline
Member
 
Join Date: Dec 2004
Posts: 172
Default

Quote:
Originally Posted by davez
no worries marcus, i spend an unhealthy amount of time these days using excel, both for the punt & the my other "work", so when i read a line like "xml feed" i get a strange sort of fuzzy feeling allover, which i guess relates to me looking for another way to make my life a bit easier, data entry wise that is.

davez
If you are using recent versions (not Excel97) of Excel you will find an option under the Data tab, Import external data/Import data and on the window "Select data source" you will find "Files of type" option, there is an option to select XML files. Of course you would have to know the location of the file.
Cheers
Reply With Quote
  #8  
Old 30th September 2005, 07:55 AM
mad mad is offline
Member
 
Join Date: Aug 2005
Posts: 898
Default

Hi Marcus,
How would you use that function to import an xml feed from an online bookies, to update prices, given that they freely provide the feed and associated data references?
__________________
I like Bing Lee.
Reply With Quote
  #9  
Old 30th September 2005, 08:12 AM
marcus25 marcus25 is offline
Member
 
Join Date: Dec 2004
Posts: 172
Default

Quote:
Originally Posted by mad
Hi Marcus,
How would you use that function to import an xml feed from an online bookies, to update prices, given that they freely provide the feed and associated data references?

If you follow what I wrote above you should be able to get it. In the field "File name" just paste in the site address.
If you have a problem, I can try it for you.
Give me the site address in plane language just the middle bit, no http or htm at the end, because as I gether, management will blank it out.
Reply With Quote
  #10  
Old 30th September 2005, 10:41 PM
mad mad is offline
Member
 
Join Date: Aug 2005
Posts: 898
Default

Thanks Marcus, that did the trick.
__________________
I like Bing Lee.
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump



All times are GMT +10. The time now is 09:32 AM.


Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
©2008 OZmium Pty. Ltd. All rights reserved . ACN 091184655