LinkBack URL
About LinkBacks
Is it possible to automatically import data from a webpage into excel?
If so, then how to do it?
I will attach a picture with data marked with blue that I want automatically imported into a excel spreadsheet:
Is it possible to automatically import data from a webpage into excel?
If so, then how to do it?
I will attach a picture with data marked with blue that I want automatically imported into a excel spreadsheet:
Hi Stockman,
An add-in for Excel 2013 called Power Query does what I think you are looking for. It is built into 2016. See:
http://www.mattmasson.com/2014/11/it...g-power-query/
for some examples.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
What is the different from paying for an API and get data from there vs using some excel plug in to fetch the data for free?
They're different things.
If you pay for/use an API, then you're paying for the ease of importing data. It will be of a standardised format that will not change and has clearly defined methods and properties that you can query.
A plugin may use the API you pay for, but more likely it will "web scrape" this means that it reads the html and not the data, should the html change (and it will change) the plugin will need updating or will break.
An API will not suffer from this since there's a clearly defined format that the vendor will not change
Last edited by Kyle123; 04-20-2016 at 04:39 AM.
Ok, so If I want a reliable data and stability I should go for API. The websites changes there html frequently to avoid web scraping?
Yes, one should always prefer an API over webscraping - it's what they're for. Not to mention, an API will be much more performant
Ok I see. Because I consider monetize a spreadsheet that I have made. The point is to make it fully automatic. So in this case it means the user input a stock ticker and all the raw data (financial information) will be imported via API and my formulas will calculate different ratios etc..
Do you know if it would be legal and possible for me to pay for this API data, and then charge a customer a fee for using my spreadsheet with the API. So that many users will be using my subscription for API data. Hope you understand what I mean
You'll need to check the terms and conditions of the particular API you want to use - they will vary. It's likely that if you want to do this you'll have to purchase a much more expensive licence, the other option would be to require the end use to have a subscription and have them enter the credentials into your spreadsheet, you then charge for your spreadsheet and they have the API subscription seperately
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks