Hello all.
I have an issue i’m struggling with.
I have a spreadsheet with a list of Magic The Gatherimg cards
What I want is to scrape live price data at some interval from the web.
I accomplished this easily be in Google sheets (see test file )
https://docs.google.com/spreadsheets/d/1Ttd57-be_Rx1X3huR34-tbOZlCxVyC6Hz5XBNOCnsBc/edit?usp=drive_web
But my actual sheet uses other things that make using google sheets to house it impractical
I tried my damnedest to get web service and filterxml to pull me the data I want but had no luck
Maybe one of you gurus knows how to pull this off.
In the case that webservice and filter xml can’t do this
I’m not apposed to learning macros to do this
I haven’t ever dealt with macros in libre but if that’s what it takes I’m down to learn