Hi,
I think I might just be missing the simple answer but…
I’d like to import player data from a website. But I’d like to easily change what data is imported based on a calculation inside my LO Calc file.
Using concatenate I can take these inputs:
Week 13
Position 1
Offset 0
and create this url link: http://fantasy.nfl.com/research/scoringleaders?&offset=0&position=1&sort=pts&statCategory=stats&statSeason=2018&statType=weekStats&statWeek=13
If you go to the website you will see this a real link with 25 rows of real player data.
If you change the week or position number the web page reloads appropriately.
For example:
Week 13
Position 2
Offset 26
http://fantasy.nfl.com/research/scoringleaders?&offset=26&position=2&sort=pts&statCategory=stats&statSeason=2018&statType=weekStats&statWeek=13
Inside calc though I have to actually update and redo each of my external links each week.
Is there a simple way to make a macro or something to save some time and effort for these steps?
Thanks so much,
TC