I cannot see how to show a website update in LO-Calc. Can it be done?
The site is “San Diego Padres Standing” and the link is San Diego Padres Standing
Image I like to show in the spreadsheet - standings results with updates as the games are played.
Thanks for any suggestions or solutions.
Get a blank sheet.
menu:Sheet>External Links…
Paste the URL into the upper box, hit Enter and confirm the dialog.
Thanks, but it is not what I’m really looking for. Below is the snapshot of the whole thing, what I want is just the hi-lighted area (NL West) Can that be done? Thanks for getting me going in the right area.
Also, I notice the external links does not update daily, is there a way to fix this?
I would like it to be a “live” data update each game day.
I finally got what I want, it just does not update, snapshot below. Again, thanks for any help with this.
It may be that foxsports have mechanisms in place to detect data extraction and block updates. IDK. In some settings it makes sense to inhibit other enterprises (competitiors or other) from leeching off of their datasets. If so, they may still offer updates but with restrictions/for a fee.
I would assume that the best source would be the MLB web service, which also hosts many (all?) of the teams’ web pages. They should be more liberal with allowing deep linking into their data. Alas, their standings table does not seem to provide sectioned ID, so you have to gobble up the whole thing and then create a new sheet where you extract the parts you want.
The first link you provided was a google search result, and I believe that Google has at one time provided the kind of data scraping you are after. That was a paid service (at least if you needed timely data refresh), and I am not sure whether it is still offered.
