I use Excel to keep track of my "for amusement only" wagers... is there a way to have the score for each game automatically be filled in using a feed of some sort? I know that they are out there (wagering apps use them) but I dont know how to access them, is it free?, can they be put into Excel?

Thanks

11/26/2011 4:21:00 PM

You can access web services using VBA.

11/26/2011 4:47:51 PM

so what would I do?



assume I am completely ignorant... which I am

11/26/2011 4:49:52 PM

You use to be able to link web pages in excel and it would dynamically access and parse the page placing content in cells. I'm not at my computer today. Can you post a web page withe the content you want and I'll see if I can help you tommorrow evening if no one has helped.

11/26/2011 5:11:42 PM

Does the Web service you're using publish feeds with JSON or XML? For JSON feeds, consider this: https://code.google.com/p/vba-json/

11/26/2011 10:25:47 PM

I dont have a web service/pages. I dont know where to find that. What I would like to have happen is for me to enter "North Carolina State" in a cell and then have excel go out and grab that day's current score automatically and post it in the next cell.

11/27/2011 3:14:19 AM

Where are you trying to get the data from?

11/27/2011 5:58:05 AM

that is kind of what I am asking... where do I get it, and then how do I incorporate. I have heard that some people get it from yahoo, but I dont even know what to look for, or if its free or costs something. There are TONS of apps/programs/pages that keep track of scores and I assume each one of them doenst have someone sitting there watching games and filling in scores haha. So its coming from somewhere...

11/27/2011 1:46:52 PM

Yahoo provides an API for fantasy sports. I don't know if you can pull game information, or if it's limited specifically to fantasy team data.

You could also do a little hacking and see where some of the live game apps pull their data from.

11/28/2011 5:08:04 PM

Is this something you can do or are you hoping with enough posts some nerd in here hand delivers the solution for you?

11/28/2011 5:55:23 PM

I really dont know... completely ignorant as to how you get the data, where you get it, what form its in etc.

11/28/2011 6:15:02 PM

Maybe I should have asked the question differently. Do you have any programming experience?

11/28/2011 7:45:59 PM

nope, well, nothing in the last 15 years and nothing that I would use for this haha.



[Edited on November 28, 2011 at 10:15 PM. Reason : d]

11/28/2011 10:14:46 PM

have you tried looking for an app that serves your purposes rather than trying to find a way to support your proposed methods?

11/29/2011 4:32:08 AM

there are apps that do it... but I need this to be in Excel

11/29/2011 6:34:37 PM

Are there not websites that let you make fake bets and keep score? That is ultimately what you want to do here right?

11/29/2011 7:27:53 PM

Here's the XML CBS Sports uses for basketball:

livestats.w w w.cstv.com/scoreboards/20111129-m-baskbl-scoreb.xml

[Edited on November 29, 2011 at 9:26 PM. Reason : remove the spaces (crazy code )]

11/29/2011 9:22:18 PM

^^ it needs to be in Excel for various reasons.

^ so ummm, what do I do with that?

[Edited on November 30, 2011 at 1:45 AM. Reason : d]

11/30/2011 1:42:37 AM

https://www.google.com/search?q=web+services+toolkit+site:microsoft.com

11/30/2011 3:21:14 AM

sigh, nevermind, I give up

11/30/2011 8:12:33 PM

Dude, we aren't stupid. You're on the damn wolf web asking for someone to get smart on some shirt you need to get smart on. Fuck that.

11/30/2011 9:19:23 PM

what? I should know what I am asking for because I should know it?

why would I ask then?

11/30/2011 11:59:26 PM

any real haxors out there?

12/3/2011 4:46:04 AM