Good stuff man! been working on my own spreadsheet to track my stocks and came across one of your videos the other night, helped me a lot. This video just solved one of my problems I've been trying to fix for a few days. (industry) Keep it up! Subbed & Liked!
This was very helpful thank you and you just got a new subscriber. I am having trouble with part 2 however, I'm not sure if fidelity changed the layout but I cannot locate that exact phrase. I also tried just copying yours but I'm getting an error message.
Great video! Any ideas of how to get the industry sector for UK companies? I am trying to figure out how to use yahoo finance but I can't seem to get it to work...
Thank you so much for doing this, but I can not get the industry script to work. Is there an update? Thank you
2 года назад+2
YES! Thanks so much man! I keep googling things like that and keep being suggested your videos. You've already helped me so much with several of your videos, you have no idea! Might as well subscribe! ✅ BTW, if you then want to pull the Industry, rather than the Sector, just change the "1" to a "2" at the end of that function. I did it and it works.
After you get the Inspect Link, on the right side of your screen, right click on the link then click on "Copy Full Xpath", you will then paste that in the place of "//div......" =if(isblank(A2),"",importxml("eresearch.fidelity.com/eresearch/goto/evaluate/snapshot.jhtml?symbols="&A2,"/html/body/table/tbody/tr/td[4]/table[2]/tbody/tr/td[1]/div[3]/div[8]/span/a")
So for those of you who are still searching for the answer, I managed to find a formula which works for me (EU). For industry: =IMPORTXML("eresearch.fidelity.com/eresearch/evaluate/snapshot.jhtml?symbols="&A2;"/html/body/table/tbody/tr/td[4]/table[2]/tbody/tr/td[1]/div[3]/div[13]/span") For sector: =IMPORTXML("eresearch.fidelity.com/eresearch/evaluate/snapshot.jhtml?symbols="&A2;"/html/body/table/tbody/tr/td[4]/table[2]/tbody/tr/td[1]/div[3]/div[8]/span") Change semi-column (;) to comma (,) for US.
Hi, thank you! Could you please help? In the video you took Sector info, how to get Industry info, it is in row below on Fidelity web. I believe I have to change second part of formula, but can't figure out what exactly.
Seems Fidelity changed their website structure so this won't work no more. Can't even retrieve data from it using that technique. Maybe an Update on this feature? Ps: I'm using same technique using Benzinga but won't retrieve no more than 3-4 data points on the spreadsheet. Cheers
This doesn’t 100% work for me. For a start, most of my stocks say N/A and a lot of the others take so long to load it’s ridiculous. Is there any fix for this? Mainly the fact that they show up as N/A
Is the historical price data accurate? Other than the weekends and holidays, it seems as if some of the data is omitted. Have u noticed? Thx. Please feel free to reply.
Thank you for this! Do you know if there's something like fidelity to pull data for the Toronto stock exchange by any chance? I'm inputting everything manually, but if I could automate it like this it would save so much time!
On the Inspect Link, right click on the link then click on "Copy Full Xpath", you will then paste that in the place of "//div......" =if(isblank(A2),"",importxml("eresearch.fidelity.com/eresearch/goto/evaluate/snapshot.jhtml?symbols="&A2,"/html/body/table/tbody/tr/td[4]/table[2]/tbody/tr/td[1]/div[3]/div[8]/span/a")
Thank you for the video! Could you please help? In the video you took sector info. How to get industry info? It's row below on Fidelity web. I believe, I have to change second part of formula, but can't figure out how.
only comes up as N/A you can adjust the formula to replace with ETF =ifna(if(isblank(A3),"",index(importxml("eresearch.fidelity.com/eresearch/goto/evaluate/snapshot.jhtml?symbols="&A3&"","//div[@class='sub-heading']//span[@class='right']"),2)),"ETF")
Thank you for the very informative video. I have subscribed to your channel and look forward to more great videos. I hadn't heard of scraping with Google sheets but this was a good introducing to that. I wanted to know what part of the industry the stock was in such as Bank, Airline, Pharmaceuticals, Automobiles, etc. I found that if I changed the 1 at the end of the formula to a 2 it gave me that information. Again, thank you and I look forward to more videos.
Thank you so much for these videos! I'm new at this so bare with me... I have copied everything, but I am getting an error saying "resource at URL not found" Can you give some guidance and help me figure out what I am doing wrong?? Thank you so much!
@@ThinkStocks thank you for your answer, but I mean Market name like NYSE or NASDAQ, or DAX, London Exchange....etc You know what I mean? If we have more stocks from more markets?
Hi - I am getting the "Resource at url not found" error message. When I do the "inspect" of the Fidelity page, it definitely shows the " " as you show it, so I know I am telling google to go to the right place. Any thoughts? Your other videos on webscraping have been invaluable to me - thanks for the great info. Please comment on this issue if you can. Thanks.
Hmm that is interesting, I just tested the function to make sure it is still good and it's still working on my end. It could be one of three things. Google sheets is acting up on your end, there is something missing in the function or the stock you are trying to pull data from might not have the sufficient data. Which stock are you trying to pull and did you copy and paste the function in the description or write it out yourself?
@@ThinkStocks So I followed your suggestion and laboriously typed out the whole string and it worked!! Thanks very much for the quick reply. Your content is excellent.
Extremely helpful! Thanks for the tutorial. For some reason whenever I close, and re-open the sheet, some of the cells say "Loading..." while others do show the industry. Anyone having the same problem?
Glad you enjoyed it! And Its just google sheets pulling all the data from the sight (which might take a few second upon start up). Its not a perfect system but its the best we got for now
I have etf's in my portfolio and when i import industry it doesn't give me anything because there isn't an industry. My question is how do i substitute the #N/A to lets say the word "other"?
"A nice graph" *shows a 3d chart* All joking aside, great video and very helpful! :) I'm sure you could scrape the code from your personal accounts (i.e. Fidelity, Robinhood, etc) to update how many shares you own of each stock as well couldn't you?
You should tell us how to import //div[@class='sub-heading']//span[@class='right']"),1)) from inspect session not just leave code like this ... so.. how to get that code from inspector? I want to do like this on my other sheets. thanks
It depends the website you are pulling from. Some are easier than others. Yahoo Finance and finviz are very simple. Websites like seeking alpha on the other hand are not. Which websites are you having trouble with?
Fidelity uses Java to prevent web scrapping, meaning that =importxml cannot pull information from Fidelity. You will have to find an alternative webpage.
02:30 come to see how to pull stocks into google sheets and get told that "these are functions i should aleady know" and doesn't explain, like wtf is this lmao
Good stuff man! been working on my own spreadsheet to track my stocks and came across one of your videos the other night, helped me a lot. This video just solved one of my problems I've been trying to fix for a few days. (industry) Keep it up! Subbed & Liked!
Thanks bro, and glad my videos helped you out! Thanks for the like and sub!
Your explaination was very clear. Thank you so much.
Your Sheets are amazing. Helped me a lot mate. Appreciate your work and effort very much! Keep on doin!
Thank you so much for making such a useful and knowledgeable video bro. God bless you 🙏❤😊
Ahh this was pretty cool to know! Excel / spreadsheet king! 🔥haha
Lol thanks!
Thanks, I have been looking for a way to add this information to my spreadsheet. You da man.
Thank you for this trick. I was looking for something industry of a stock since quite long
Thank you, you are awesome! I have been struggling with this for weeks.
You're welcome!
@@ThinkStocks Can we do this just with pulling info from yahoo finance or seeking alpha?
Thank you for teaching me new formulas. You are awesome. Subscribed and liked.
Thanks!
This was very helpful thank you and you just got a new subscriber. I am having trouble with part 2 however, I'm not sure if fidelity changed the layout but I cannot locate that exact phrase. I also tried just copying yours but I'm getting an error message.
Great video! Any ideas of how to get the industry sector for UK companies? I am trying to figure out how to use yahoo finance but I can't seem to get it to work...
Thanks, this is an excellent tutorial. would really like to pull the industry instead of the sector. this is pulling the sectors not the industry.
This isnt working any longer, I think fidelity updated the site. Any idea how to fix it?? @thinkstocks
THAT's what I was looking for!!!!!! Thank you very much!!!
Did it work ok for you? i have tried to copy the link in description and entering it automatic?
the code doesn't work for ETFs. I have tried on different way but it doesn't work for ETFs
Amigo - y`re the best, thank you
This is a big help. Thank you!
Thank you so much for doing this, but I can not get the industry script to work. Is there an update? Thank you
YES! Thanks so much man! I keep googling things like that and keep being suggested your videos. You've already helped me so much with several of your videos, you have no idea! Might as well subscribe! ✅
BTW, if you then want to pull the Industry, rather than the Sector, just change the "1" to a "2" at the end of that function. I did it and it works.
is your Industry code still working? Mine comes up with Imported Content is Empty
After you get the Inspect Link, on the right side of your screen, right click on the link then click on "Copy Full Xpath", you will then paste that in the place of "//div......"
=if(isblank(A2),"",importxml("eresearch.fidelity.com/eresearch/goto/evaluate/snapshot.jhtml?symbols="&A2,"/html/body/table/tbody/tr/td[4]/table[2]/tbody/tr/td[1]/div[3]/div[8]/span/a")
How to use Google finance function of Asian stocks in google sheets?
Thanks bro!
An awesome approach! Like to pick your brain a little more...any ways to get the stock option data? Thanks.
Does anyone have any code for Canadian stocks? TIA
Unfortunatly the code is giving me an 'empty' result. Even if I try the solution of Mathew, I get no result. Any advice?
So for those of you who are still searching for the answer, I managed to find a formula which works for me (EU).
For industry:
=IMPORTXML("eresearch.fidelity.com/eresearch/evaluate/snapshot.jhtml?symbols="&A2;"/html/body/table/tbody/tr/td[4]/table[2]/tbody/tr/td[1]/div[3]/div[13]/span")
For sector:
=IMPORTXML("eresearch.fidelity.com/eresearch/evaluate/snapshot.jhtml?symbols="&A2;"/html/body/table/tbody/tr/td[4]/table[2]/tbody/tr/td[1]/div[3]/div[8]/span")
Change semi-column (;) to comma (,) for US.
I had the same thing happen to me - apparently its a "bug" in google sheets - just have to refresh the page and it should work - Worked for me!
Hi, thank you! Could you please help? In the video you took Sector info, how to get Industry info, it is in row below on Fidelity web. I believe I have to change second part of formula, but can't figure out what exactly.
@@gdekatya285 I did not make this video, but I did write the formula for industry in the comment above
@@pasoonhellamand5364 oh thank you so much! Unfortunately it didn't work. I don't now why.
You're GOD! Thanks! Very needed that function, but couldn't find the solution. Until saw your video 👍
Seems Fidelity changed their website structure so this won't work no more. Can't even retrieve data from it using that technique. Maybe an Update on this feature?
Ps: I'm using same technique using Benzinga but won't retrieve no more than 3-4 data points on the spreadsheet.
Cheers
Great video, although i can't create my sector spreadsheet by simply copying the link, not sure why
This doesn’t 100% work for me. For a start, most of my stocks say N/A and a lot of the others take so long to load it’s ridiculous. Is there any fix for this? Mainly the fact that they show up as N/A
Thank you sir!
Is the historical price data accurate? Other than the weekends and holidays, it seems as if some of the data is omitted. Have u noticed? Thx. Please feel free to reply.
Feature not longer available in Fidelity site... any other idea? thank you very much for your vids! really helpful!
Thank you for this!
Do you know if there's something like fidelity to pull data for the Toronto stock exchange by any chance?
I'm inputting everything manually, but if I could automate it like this it would save so much time!
It worked for me, just need to correct the formula he entered for us to copy.... he is missing some entries after eresea...
just found this channel i subed and like thank bro
is it possible to sort the sectors by their market value so you have them in order
Looks like this method is already broken by Fidelity changing it's code.
On the Inspect Link, right click on the link then click on "Copy Full Xpath", you will then paste that in the place of "//div......"
=if(isblank(A2),"",importxml("eresearch.fidelity.com/eresearch/goto/evaluate/snapshot.jhtml?symbols="&A2,"/html/body/table/tbody/tr/td[4]/table[2]/tbody/tr/td[1]/div[3]/div[8]/span/a")
@@matthewsodetola9359 thank you so much! It helps to know the proper steps to do it.
@@matthewsodetola9359 Do you have an updated version of this? Currently not working. Much appreiated.
Hello, Thanks for the video. I followed but get error "Imported Content is Empty" Do you why I am getting the error. I entered the code 100% the same.
is anyones industry column not working now?
Yeah wont work now, any workaround?
Thank you for the video! Could you please help? In the video you took sector info. How to get industry info? It's row below on Fidelity web. I believe, I have to change second part of formula, but can't figure out how.
Hello, is there any possible way to pull a stocks options chain?
thank you
That's really interesting. Might you know how to pull this info for UK stocks, please?
Very helpful tutorial By the way, what number Yahoo table is used for ETFs It is not 7 Thank you for all
Can we do this just with pulling info from yahoo finance or seeking alpha?
hi, how can I calculate sma using Google finance
how did you generate part 2 of de equation?
Does this work for ETF's too?
only comes up as N/A you can adjust the formula to replace with ETF
=ifna(if(isblank(A3),"",index(importxml("eresearch.fidelity.com/eresearch/goto/evaluate/snapshot.jhtml?symbols="&A3&"","//div[@class='sub-heading']//span[@class='right']"),2)),"ETF")
How much will u charge fees... for customise things for india stocks ??? Plz reply BIG BROTHER
Hello!! nice video.. now, i am opcions seller, how can i import to a google sheet the ASK price, current price, in real time always of any stock??
Thank you for the very informative video. I have subscribed to your channel and look forward to more great videos. I hadn't heard of scraping with Google sheets but this was a good introducing to that. I wanted to know what part of the industry the stock was in such as Bank, Airline, Pharmaceuticals, Automobiles, etc. I found that if I changed the 1 at the end of the formula to a 2 it gave me that information. Again, thank you and I look forward to more videos.
Thank you so much for these videos! I'm new at this so bare with me... I have copied everything, but I am getting an error saying "resource at URL not found" Can you give some guidance and help me figure out what I am doing wrong?? Thank you so much!
Nice video and Info. There is a way to import the Market name also?
Thanks, and try =googlefinance(A2,"Name")
@@ThinkStocks thank you for your answer, but I mean Market name like NYSE or NASDAQ, or DAX, London Exchange....etc
You know what I mean? If we have more stocks from more markets?
Ohh okay. So to automatically pull that information ill have to look into that for you and see if I can come up with something
Please tell how I can add sector of the company of NSE india index, the provided link is not working for NSE india index. Please help 🙏🏼
How would I pull Industry for mutual funds?
Hey its not working now, does the syntax need updating?
Hi - I am getting the "Resource at url not found" error message. When I do the "inspect" of the Fidelity page, it definitely shows the "
" as you show it, so I know I am telling google to go to the right place. Any thoughts? Your other videos on webscraping have been invaluable to me - thanks for the great info. Please comment on this issue if you can. Thanks.
Hmm that is interesting, I just tested the function to make sure it is still good and it's still working on my end. It could be one of three things. Google sheets is acting up on your end, there is something missing in the function or the stock you are trying to pull data from might not have the sufficient data. Which stock are you trying to pull and did you copy and paste the function in the description or write it out yourself?
@@ThinkStocks So I followed your suggestion and laboriously typed out the whole string and it worked!! Thanks very much for the quick reply. Your content is excellent.
Glad it worked and thanks! I have some more awesome sheets coming out over the next few weeks!
Extremely helpful! Thanks for the tutorial.
For some reason whenever I close, and re-open the sheet, some of the cells say "Loading..." while others do show the industry. Anyone having the same problem?
Glad you enjoyed it! And Its just google sheets pulling all the data from the sight (which might take a few second upon start up). Its not a perfect system but its the best we got for now
@@ThinkStocks You the man
Hi I tried your for google function for pulling stock industry and it won't work?
It doesn't work for Indian stock exchange NSE
Is there an updated code for pulling sector into Sheets? I'm not having any luck
Angela Wymer
code works fine as of 1-2-2022 - See in comments
I have etf's in my portfolio and when i import industry it doesn't give me anything because there isn't an industry. My question is how do i substitute the #N/A to lets say the word "other"?
use an iferror function
Hey Bro, Great video, can you make an update code to pull the stock's Industry name? PLS
Follow this video and you can figure it out! I use Finviz as the url now ruclips.net/video/BLa9HKGos8U/видео.html
doesn't work for me anymore :(
"A nice graph"
*shows a 3d chart*
All joking aside, great video and very helpful! :) I'm sure you could scrape the code from your personal accounts (i.e. Fidelity, Robinhood, etc) to update how many shares you own of each stock as well couldn't you?
it doesnt work for me , the code is different
Thanks :)
You should tell us how to import //div[@class='sub-heading']//span[@class='right']"),1))
from inspect session not just leave code like this ... so.. how to get that code from inspector? I want to do like this on my other sheets. thanks
please reply.........
Angela Wymer
code works fine as of 1-2-2022
Tried this now, gives me a resourse at url not found. :( To bad, i really love this videos's
How you solve this error "could not fetch url"?
I use importxml and importhtml from diferent websites. And sometimes i get this error
It depends the website you are pulling from. Some are easier than others. Yahoo Finance and finviz are very simple. Websites like seeking alpha on the other hand are not. Which websites are you having trouble with?
@@ThinkStocks dividendinvestor
Yeah the source code might be a bit tricky on that one. Not saying it's impossible. I'll look into it and see if I can figure it out!
@@ThinkStocks sometimes works but other times no. i think the problem is i have a lot of request and the websites block my requests
This no longer works, Fidelity changed something.
Doesn't work.
doesn't work anymore. N/A for all stocks
November 2023 and this no longer works.
Unfortunately this didn't work
It stopped working for me guys!!! is it still working with you or there is something changed??
Fidelity uses Java to prevent web scrapping, meaning that =importxml cannot pull information from Fidelity. You will have to find an alternative webpage.
❤
Plz reply brother
02:30 come to see how to pull stocks into google sheets and get told that "these are functions i should aleady know" and doesn't explain, like wtf is this lmao
Doesn’t work