*UPDATE Finviz likes to occasionally change the order that their data tables are listed. At the time of this video, you had to import table 7. It is now table 9 that should be imported. So the new formula will look something like this: =importhtml("@t
I haven't used this sheet in a while but I'm trying to give my investments a renewed focus. When I came back to it, the finviz web scrapes weren't working. Your comment solved this. However, now the data appears like this *1.50* so that the other cells don't recognize it as a number to complete the other calculations. Not sure why this is as I'm not seeing the asterisks on the table on finviz. I've tried the Find and Replace function but that is not working.
It took all day, but I got all this in a Google sheet today. Table 8 has changed to 9 now. I had to keep changing the number until I found out it is now table 9. Then on last tab, I put in the tickers for all my portfolio just to be sure. Thanks man. Now I can start the PortfolioDividend Tracker Video.
Incredibly useful technic, I shared it with some friends that would benefit from it. Thanks for the videos, I just subscribed to your Patreon, fully deserved.
Yo, best tutorial ever! Super handy Table code and straightforward solutions! I used to do these in desktop excel with ''Data Query from Web'', no idea it calls ''Web Scrape Data''. I bet more people will find your video if you put the ''Data Query from Web'' somewhere in the description. Thanks for the video!
Holy crap. This is such a good tutorial, I'm impressed by how easy it is to follow/implement, and it looks really useful for a indicator/tracking automation project I've been thinking about for a while. If you don't have another Sheets/Excel/Technical tutorial type channel, you definitely should.
Very cool, its working. I got a problem, i cant' use the data i guet from the function "IMPORTHTML" because these are text data. How can i transform them into numbers data ?
I'm looking for a way to validate data that I get from yahoo finance using importhtml. For example if you look at an ETF in Yahoo finance and say I'm looking for dividend yield. So there might be 2 tables where the yield in in second table. So if there a way to say if (importhtml for table 2, A1="Yield", then importhtml...A2 field, so it brings back the yield only if it's the correct line? Great videos btw, learning a lot from your videos.
Great video, how do you scrape something that you can not find within the console? Are images scraped the same way? Im trying to scrape the heatmap from finviz. Its tables 11-14, but whatever series of numbers I can not find my info. Can you help with this? Its the image to the right of the losers.
This is useful, thanks What about the links that have the ticker at half part through the link? How should we alter the formula? So it's like a specific word dash ticker and after that slash and some other words.
Hi, thanks for this great video. Question: How can I scrape data from what appears to be an embedded Google Sheets spreadsheet that is on a web page? Thanks.
Great video and well paced, I learned alot. Any chance you have ideas on how to obtain data for International stocks from countries such as in Singapore and Hong Kong?
This was great. I know nothing. And was able to figure this out. Thanks so much. The only thing is I have the * symbol before and after my data. Any ideas?
Dividend: It seems finviz has changed the way to pull dividends from their website. I have corrected the spreadsheet and it now works. Here is the updated formula: =substitute(SUBSTITUTE(index(importhtml("finviz.com/quote.ashx?t="&A4,"table",7),7,2),"*",""),"-","0.00")
Does not appear that the formula works. I tried dozen of different table and nothing seemed to work. This was great and would be exactly what I wanted but since this was created it appears that something changed and this no longer works. If you could post the new formula format that would be awesome.
Do you know how we could scrape data from Macrotrends? I tried to run the line in the description, but it seems like they have their data in divs, and not on tables.
I’m cases where the data isn’t in a table or list, you will typically have to use the =importantxml function. I used this formula to import industry data in many of my portfolio tracker tutorials. I don’t yet have an in depth video on this formula yet though.
Hello Dividendology, would you help me on how to get the eps of stocks from last year,(2021) these year estimates(2022) and the following year 2023 estimates? I am running a project and I feel I just hit a wall with those metrics . thank you
Also , I will like to extract data from multiples sources and have it in an automated mode. The idea is to create a google sheet with a list of indicators that update themselves as soon as new data is posted. Any advice on how to proceed? Thank you
Hi, thanks for your work, it's been very helpful. The only problem that I have is that my website data are not refreshing. How can I fix that ? Thanks for your return
Should be able to just refresh the browser and have it update. Otherwise try to - go to File | Settings - and under the Calculation tab, you can use the pulldown to set refresh to On Change and 1 minute or somesuch... that works with the TIME related functions - so somewhere on your page just throw in a cell with "=now()" and the whole sheet may update again. You might need to exit and open the sheet again after the calculation tab change.
The main focus of this video was for tables, but if the data you are wanting to scrape is in a list, the only change that you have to make to your formula is to switch "table" to "list" in your google sheets formula. There are also other ways to go about web scraping in google sheets that I may cover in future videos.