Ask Your Question

Revision history [back]

Use formula result as Link to External Data

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