is this one of most bizarre posts in recent days or is it just me?
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.
is this one of most bizarre posts in recent days or is it just me?
14 Teams H2H Dynasty, 28 roster spots (8 bench), 15 minors under 100
Weekly Matchups - Daily Lineups
Skaters: G/A/Pt/PIM/SoG/STP/H+B/ToI/Corsi
Goalies: W/GAA/SVs/SV%/SHO
C: Eichel, Kadri, Mcdavid, Sodeberg, Schenn
LW: Ehlers, Landeskog, Meier, Debrusk, Foegele, Lee
RW: Pastrnak, Marner, Palmieri, Terry, D. Brown, Bailey, Granlund
D: Krug, Josi, Ekholm, Faulk, Muzzin, Karlsson, Cernak,
G: Hellebuyck, Biship, M Jones
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")
Interested in being a Dobber Hockey champion?
Join Our Tiered League Now!
Climb your way to the top of a three tiered Roto league.
Check out the link below for more info or PM me!
https://forums.dobbersports.com/show...League-2023-24
ESPN Roto 10 team
24 man roster (+3 IR) - Keep 20 - Daily settings
Start 3C, 3LW, 3RW, 5D, 2G, 1UTIL
G,A,PTS, +/-, PIM, PPA, PPG, D PTS - W, SV, SV%
C- Zegras, Rossi, Carlsson, Fantilli, Norris
RW- Batherson, Michkov, Quinn, Perfetti(C,LW), Foerster, Kakko
LW- BTkachuk, Stutzle(C), McTavish(C), Benson
D- Mintyukov, Sanderson, LHughes, Clarke, Drysdale, Korchinski
G- Wolf, Askarov, Wallstedt
IR-
IR-
IR-
Picks in 2024/25 1, 2, 4, 5
Picks in 2025/26 rounds 1,3,4,4
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.
Want a Signature? Go to Settings, and you'll find Edit Signature down the list on the left.
Contact me for Frozen Tools bug reports and inquiries
Follow Frozen Tools on Twitter @FrozenTools
Follow me on Twitter @DH_EricDaoust
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..
ESPN Roto 10 team
24 man roster (+3 IR) - Keep 20 - Daily settings
Start 3C, 3LW, 3RW, 5D, 2G, 1UTIL
G,A,PTS, +/-, PIM, PPA, PPG, D PTS - W, SV, SV%
C- Zegras, Rossi, Carlsson, Fantilli, Norris
RW- Batherson, Michkov, Quinn, Perfetti(C,LW), Foerster, Kakko
LW- BTkachuk, Stutzle(C), McTavish(C), Benson
D- Mintyukov, Sanderson, LHughes, Clarke, Drysdale, Korchinski
G- Wolf, Askarov, Wallstedt
IR-
IR-
IR-
Picks in 2024/25 1, 2, 4, 5
Picks in 2025/26 rounds 1,3,4,4
ESPN Roto 10 team
24 man roster (+3 IR) - Keep 20 - Daily settings
Start 3C, 3LW, 3RW, 5D, 2G, 1UTIL
G,A,PTS, +/-, PIM, PPA, PPG, D PTS - W, SV, SV%
C- Zegras, Rossi, Carlsson, Fantilli, Norris
RW- Batherson, Michkov, Quinn, Perfetti(C,LW), Foerster, Kakko
LW- BTkachuk, Stutzle(C), McTavish(C), Benson
D- Mintyukov, Sanderson, LHughes, Clarke, Drysdale, Korchinski
G- Wolf, Askarov, Wallstedt
IR-
IR-
IR-
Picks in 2024/25 1, 2, 4, 5
Picks in 2025/26 rounds 1,3,4,4
I don't think the question itself is that odd, but the choice of venues for asking it might be.
16 team Pts only dynasty league
G, A, PPG, SHG, GWG, Svs, SO's, W's
Pro Roster Starters: 9 F, 6 D 1 G
FWD: Hertl, Forsberg, Quinn, Rantanen, Debrincat, Couturier, Dach, Trocheck, Larkin, Seguin
D: Chychrun, Grzelcyk, Trouba, Burns, Walman, Karlsson, Graves
G: Kahkkonen, Keumper, Reimer
Farm (notables):
F: Pekarcik, Dellandrea, Cowan, Puistola, Halttunen, Simoneau, Bolduc, Nadeau, Stankhoven
D: Brzustewicz, Alexeyev, Jiricek, Reinbacher, Minnetian
G: Fedotov, Tarasov, Kochetkov, Skarek, M. Gibson
Well there will be two sources that perform a refresh/update - your page and your source page (frozenpool)
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.
Interested in being a Dobber Hockey champion?
Join Our Tiered League Now!
Climb your way to the top of a three tiered Roto league.
Check out the link below for more info or PM me!
https://forums.dobbersports.com/show...League-2023-24
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
Contact me for Frozen Tools bug reports and inquiries
Follow Frozen Tools on Twitter @FrozenTools
Follow me on Twitter @DH_EricDaoust