Hi, thanks for this great video... very informative. Quick question: Is it possible to pull or streamline also the related news for the company in blue with the related dates?
Instead of using the row and column numbers and then manually updating them, you could have used the Row() and Column() functions to return numbers. So using Row()-3, Column() would return 1,2 then you could just drag that down and not need to manually change the numbers.
The problem I am having with using all these import data feeds is extreme delays in the data loading every time i log in to my portfolio. Am I alone here?
The pulled data only seems to want to show as text (I've tried formatting the cells to be numbers but doesnt seem to work) I'd like to do conditional formatting, especially with PEG ratio.
Thank you so much! I find your videos very helpful. I am trying to pull the information from the Income Statement, Balance Sheet, and Cash Flow tables near the bottom of the page. I am stumped. Please help.
I'm getting "*-*" in many cells such as the Index cell. Also, for the cells that I can scrape, it's bracketed with asterisks, e.g. "*15.62B*" in the Market Cap cell. Perhaps Finviz is making changes to stop people from scraping their data for free?
The "*" symbols bold the data in the Finviz website. They are not trying to prevent scraping. You need to use the SUBSTITUTE function which is used in the video to replace the "*" with blank spaces ("").
Hey there, does someone know how to make "condItional formatting" work with IMPORTHTML function? since I guess the google sheets doesn't "sees" the cells as values because they are Imported. Thanks.
For some reason I can't get "table"6 work, I have tried table 4 thru 20 and been getting #ref errors. I'm sure finviz made some changes but unable to figure it out. Would someone be able to help me out?
So similarly to John, I have used the trackers of your video as well as others in youtube to create a "master". I would like to share it with you and perhaps you can share it again with others.
Hey Pasoon, thats awesome to hear! And sure, you can find my email in the about section on my channel if you want to share what you were able to create
Nov 27, 2023 Its TABLE 10 now !
Superb job with your explanations
***FINVIZ UPDATE*** In the video I'm pulling from table 8 but now it is table 9 you need to pull from. And for the company name, it is table 7.
I'm new and thanks for your video but the 6-9 is not pulling up the company name in table?
Thanks for the update on table numbers. Easy fix, took about a minute.
Can we access the THREE finance sheets data also for TTM, Annual and Quarterly?
Thanks for both of you.
It's really gem 👏👏
Man another banger of a video ✊🏽✊🏽 first he got me organized and now he’s made this I’m a long term loyal follower now 🤑
Thank you! And don't worry I got more to come!
Sir pls same type video make for Indian stock
Excellent sheet! Thanks for sharing.
Which table to be used now I tried 6, 9 10 none worked the earnings is row 12 in finviz now and column is 8 can someone please help me Thanks
Great video. Can you do a video that demonstrates how to find the table index number on Finviz and other sites? Thanks again.
Please show me how to get data from Income statement, balance sheet and cash flow? thanks
thank you very much for useful learning of mine, well done
Great breakdown bro! 👊🏼👊🏼
Thanks man!
Hi, thanks for this great video... very informative. Quick question: Is it possible to pull or streamline also the related news for the company in blue with the related dates?
Hi how do I get the next earnings date I've tried row, 11, 6 used to be table 9 but I've tried 7 and 8 and none are working
Instead of using the row and column numbers and then manually updating them, you could have used the Row() and Column() functions to return numbers. So using Row()-3, Column() would return 1,2 then you could just drag that down and not need to manually change the numbers.
I couldn't get this to work. Any help appreciated..
The problem I am having with using all these import data feeds is extreme delays in the data loading every time i log in to my portfolio. Am I alone here?
The pulled data only seems to want to show as text (I've tried formatting the cells to be numbers but doesnt seem to work) I'd like to do conditional formatting, especially with PEG ratio.
Great training session, oh, and useful!
Extremely useful! And all thanks to my awesome subscriber, John for sharing this with us!
As of now 7/11/2022 the table no. is 9 for example: for PEG ratio ....."table",9),3,4).....
Ma non funziona più ? Non carica dati. E' cambiato il numero della tabella ?
THANK YOU SO SO MUCH
Thank You...
Thank you so much! I find your videos very helpful. I am trying to pull the information from the Income Statement, Balance Sheet, and Cash Flow tables near the bottom of the page. I am stumped. Please help.
Why would anyone import this without also importing the THREE finance sheets also?
wow!
True.. Myself unable to track the international stocks
I'm getting "*-*" in many cells such as the Index cell. Also, for the cells that I can scrape, it's bracketed with asterisks, e.g. "*15.62B*" in the Market Cap cell. Perhaps Finviz is making changes to stop people from scraping their data for free?
The "*" symbols bold the data in the Finviz website. They are not trying to prevent scraping. You need to use the SUBSTITUTE function which is used in the video to replace the "*" with blank spaces ("").
Over the New Year, I believe Finviz has intentionally changed their website tables to break all the sheets scraping data from them. It's now Table 7.
Yeah. Mine all messed up, been looking which table it is now.
Hey there, does someone know how to make "condItional formatting" work with IMPORTHTML function?
since I guess the google sheets doesn't "sees" the cells as values because they are Imported. Thanks.
Does this update in real time?
How do i get all those descriptions that Jack put in for each item?
Just getting Error #Name?
The header info is now Table 7 in Finviz.
Incredible!! Can you create an Option Tracker Journal. Tks.
Has FINVIZ changed the table Number again?
Hi, I got it to work with 9
For some reason I can't get "table"6 work, I have tried table 4 thru 20 and been getting #ref errors. I'm sure finviz made some changes but unable to figure it out. Would someone be able to help me out?
Never mind Figured out my issue, I missed the t after ashx? and over looked it. Table 6 no longer works and now pulling from table 5.
So similarly to John, I have used the trackers of your video as well as others in youtube to create a "master". I would like to share it with you and perhaps you can share it again with others.
Hey Pasoon, thats awesome to hear! And sure, you can find my email in the about section on my channel if you want to share what you were able to create
@@ThinkStocks I will send you an email on saturday!
Company description is now in Table 11
👍🏻👍🏻👍🏻
NVR mind is table 5 now
As of now 26/6/22 the name and the table both are 7
going and using finviz is easier
Table 8 doesn't work anymore. What is it now?
It is now table 7
@@ThinkStocks how do you get the table number? Table 7 is not working from me up in Canada lol