I'm attempting to create a spreadsheet in LibreCalc for Fantasy Football that includes every active QB, RB, WR, TE, and K from Yahoo. I only picked Yahoo because I've gotten further along with their data than any other website.
So far, I've figured out how to get a list of names and teams for the above positions. What I've done so far is create a spreadsheet with each position on a separate worksheet. I was able to grab the names and teams for each position by doing the following (example for RBs): Insert > Link to External Data > URL of external data source > http://sports.yahoo.com/nfl/players?type=position&c=NFL&pos=RB > Available Tables/Ranges > HTML_10. That gets me a list of the names and teams for each position and also includes a hyperlink to the player's individual page. Here's my issue: From each player's individual page I also want to pull their Date of Birth (Running Backs over 30 are a red flag) and the year they entered the league (Wide Receivers tend to break out in Year 3). I haven't yet figured out how to dynamically pull the additional data based on the initial web hyperlink. The additional data that I need is all contained in the player's individual pages (HTML_2 from the player's page). The secondary links must be dynamic and based on the initial list of players, since it's likely that players will come and go. Can this be done at all? Will it require the use of macros? Would I be better served to just do this whole thing using LibreBase? That would bring up a whole host of new questions, considering I have very little experience creating a database. One more minor question: Can I just delete any unwanted lines before or after the data that is pulled in? For instance, when I pull in the position page there are 2 lines at the top that I would just assume delete. If I delete them will that mess things up when I refresh the dynamic data? There's obviously more hurdles to overcome further down the road with this list, but this is where I am right now. My reason for attempting this is because I have spent a ton of time trying to track down this data and manually populate my master spreadsheet. If I could figure out a way to "Push a button" and get all of this together automatically then that would save a bunch of time (even if I spend a ton of time figuring out how to do it initially). Plus, I'm just a geek and I want to say that I did it. Eventually, I'd like to pull the dynamic draft rankings data into my master spreadsheet so that I'll have several different websites' draft data updated automatically. If anybody is interested in helping out with this project I'd be more than willing to share my work (assuming you aren't in my Fantasy league). -- View this message in context: http://nabble.documentfoundation.org/Help-with-linking-to-data-on-a-website-tp3696924p3696924.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
