Updated data pulls

[rorytate]

Hi - I'm new. Long time player, first time poster. Usually I'll play just randoms on yahoo for a season in a draft pool however this year I want to run my own charity pool, as a one year box pick em pool.

Anyways what I'm trying to figure out is where can I pull data automatically in to let's say google sheets or excel or whatever?

Currently I do run a 'Celebrity Death Pool' but I don't have to pull data, rather I just update their death when it happens and it automatically calculates everything.
I'm semi familiar with google sheets/excel. The only issue I have it pulling live data automatically within a spreadsheet. More like finding a reliable source.

Now I have seen somewhere in the forums this =importhtml("https://frozenpool.dobbersports.com/frozenpool_stats.php", "table", 0) where it pulls the magical numbers in to the spreadsheet as I wanted.
From there I can manipulate the numbers to auto update and pump out the scores.

So my question is - will =importhtml("https://frozenpool.dobbersports.com/frozenpool_stats.php", "table", 0) automatically reset for the next season and how often does it update to have the numbers current? is it live (as the games go?) nightly, daily, weekly? Or are there other sources that can be pulled in to a spreadsheet automatically?

Thanks for your assist on this.

[Belexus75]

is this one of most bizarre posts in recent days or is it just me?

[Invictus]

I'm not sure on frozen pool but would imagine it updates when the game is completed/finalized.

I pull data from NaturalStatTrick and that's how it is done... Frozenpool may pull from another website??? have to check on that.

=IMPORTXML("https://www.naturalstattrick.com/teamtable.php?fromseason=20222023&thruseason=20222 023&stype=2&sit=all&score=all&rate=n&team=all&loc= B&gpf=410&fd=&td=","//tr")

[finnys_fanatsy]

is this one of most bizarre posts in recent days or is it just me?

nope nit jut you my friend..i had a feeling it was code related but i got freaked out and left..responses drew me back in though lol

[stevegamer]

I know that you can pull data in from Fantrax into .csv format. However, I would NOT recommend pulling "live" data, but rather pulling it once a day a time when no games are happening. This eliminates issues with scoring adjustments, which appen more often in hockey than in any other major sport, and it's not close.

You might want to set the thing up on Fantrax for free, that way you eliminate a lot of back end management, and you can have people look at that site.

[ericdaoust]

So my question is - will =importhtml("https://frozenpool.dobbersports.com/frozenpool_stats.php", "table", 0) automatically reset for the next season and how often does it update to have the numbers current? is it live (as the games go?) nightly, daily, weekly? Or are there other sources that can be pulled in to a spreadsheet automatically?

During the season the stats are updated every 15 minutes.

[rorytate]

LoL looks like I've confused a few people...
ok - so that import data line is basically live - (every 15 mins) - once I have the actual live data I can figure out the rest of stat tracking/awarding of points and have it display online and everything else..

[rorytate]

is this one of most bizarre posts in recent days or is it just me?

LOL what was so bizarre about it? I just wanted to figure out how to acquire the updated data during the season automatically in to my google sheets... was it too much info>?

[finnys_fanatsy]

LOL what was so bizarre about it? I just wanted to figure out how to acquire the updated data during the season automatically in to my google sheets... was it too much info>?

lol, nah man, just nothing we've seen before asked here (well at least for me anyway) ..all good mate!

[rorytate]

lol, nah man, just nothing we've seen before asked here (well at least for me anyway) ..all good mate!

I thought maybe my death pool threw ya off -

[finnys_fanatsy]

I thought maybe my death pool threw ya off -

welll...maybe lol

[random-d]

I don't think the question itself is that odd, but the choice of venues for asking it might be.

[rorytate]

I don't think the question itself is that odd, but the choice of venues for asking it might be.

So I think I threw everyone off mentioning my death pool (runs separate)..

I just want to be able to pull the current years stats (so 23-24) to excel/sheets via an import option - if I can have it done automatically then that would be more beneficial...

[Invictus]

So I think I threw everyone off mentioning my death pool (runs separate)..

I just want to be able to pull the current years stats (so 23-24) to excel/sheets via an import option - if I can have it done automatically then that would be more beneficial...

Well there will be two sources that perform a refresh/update - your page and your source page (frozenpool)

During the season the stats are updated every 15 minutes.

So that takes care of Frozenpool.

ImportXML updates itself to your source upon startup (So whenever you open the google sheet). From there to refresh the data, you'll need to manually re-enter the formula or use Google Apps Script to write a function.

I believe (but I haven't tested) you can just refresh the webpage for it to update itself or if that doesn't work close the tab and reopen it.

[ericdaoust]

Found this with a Google search

How Often Does IMPORTHTML Refresh? Google Sheets automatically check for updates every hour when the document is open to keep getting fresh data, even if the user doesn't change the formula or the sheet.Feb 14, 2023