How to get Industry in Google Sheets! (Automatically get Industry!)

[@Dividendology]

Here is an updated video on how to get industry!: How to Automatically get Industry in Google Sheets! (Tutorial) kzbin.info/www/bejne/mH3SqWeGd95_oKM

[@ernestaskuznecovas6831]

Thank You

[@nicholascrisler4912]

Extremely helpful! Thank YOU for taking the time to make this video!

[@Dividendology]

You’re welcome!

[@remembernaveen30]

Many of the cells loaded sucessfuly but majority cells showing imported content is empty

[@SaraanInvesting]

Great video on stock industry information! Thanks for sharing!

[@Dividendology]

Glad it was helpful!

[@TheFinancialMinute]

Great explanation video!

[@ConsciousCrypto]

tried building my own because those html are no longer functional. Always great tutorials, but perhaps can you update this formula?

[@Dividendology]

I used updated formulas in this video! Check it out: kzbin.info/www/bejne/qp21iHmjqNqKaM0

[@wingon695]

GREAT VIDEO, HOWEVER I TRY THE INDUSTRY LINK PROVIDED, IT RETURNS THE CONTENT PAGE IS EMPTY. LIKE TO KNOW HOW TO FIX THAT

[@Dividendology]

will post an update soon

[@jakeplimack1710]

@dividendology, can you post an updated formula?

[@Dividendology]

Here’s the new way to do it!: How to Automatically get Industry in Google Sheets! (Tutorial) kzbin.info/www/bejne/mH3SqWeGd95_oKM

[@jwildbaum]

Still works, Thanks.

[@Dividendology]

You’re welcome!

[@gg80108]

Where is the formula posted in the comments?

[@Dividendology]

its pinned at the top!

[@chrisc5991]

can u link ur latest video that includes this? can't access fidelity

[@Dividendology]

kzbin.info/www/bejne/n5u9o52XpcSieNU

[@chrisc5991]

@@Dividendology thanks

[@diegokatsan6580]

HI, is it limited only in the US area, while in other geographical areas? Type in Italy industrial sectors such as ENI, ENEL, UNIPOLSAI, BANCA GENERALI and others. What is the formula to enter? THANKS YOU 🙏

[@Dividendology]

I’ll have to look into this!

[@alm3ida79]

Hi, formula isn't working, do you know what's changed? Thanks

[@Dividendology]

I have a new method that I use in my spreadsheets!

[@alm3ida79]

@@Dividendology Hi, where can we find that method? Thanks

[@endrigorizzi5043]

Please try my alternative solution (source Yahoo finance): =IMPORTXML("finance.yahoo.com/quote/"&A7,"/html/body/div[1]/div/div/div[1]/div/div[3]/div[2]/div/div/div/div/div/div[13]/div/div/div/div/div/div/p[2]/span[2]"). Cell A7 = corresponding stock code.

[@JBS7551]

This does not work anymore, fidelity updated everything. Any idea how to fix this?

[@Dividendology]

I have a video coming out tomorrow that will show how to do this! :)

[@JBS7551]

@@Dividendology fantastic, I just figured it out via your Xml instruction vid!! I use finviz

[@flushy4348]

I get an error everytime i put the code in. It wont give me the sector

[@Dividendology]

Im working on a new solution!

[@JBS7551]

Follow this video and you can figure it out! I use Finviz as the url now kzbin.info/www/bejne/eH3EanuBfNSmbrc

[@joejanco836]

@@Dividendology

[@financewithjohnstanton2866]

Great!

[@bouweenvermogen]

The formula is not working anymore, do you have the new one?

[@Dividendology]

I do!! I’ll put an update in the description soon.

[@bouweenvermogen]

@@Dividendology great! Thanks a lot! 🙏🏼

[@JBS7551]

Follow this video and you can figure it out! I use Finviz as the url now kzbin.info/www/bejne/eH3EanuBfNSmbrc

[@SirSavvySavage]

this formula stopped working for me recently?

[@Dividendology]

I just made a new method for scraping industry! Check out my latest video!

[@a-b-c]

This is not working for Indian stocks

[@tonmoysaha6745]

please give a link for indian nse also

[@ai_dividend_daily_1]

😎

[@TheFinancialMinute]

PS 1st like!

[@mangekyousharingan7335]

Too bad this no longer works

[@Dividendology]

This is an error on google as end. They are working to fix it now.

[@Dividendology]

It’s been fixed!

[@mangekyousharingan7335]

@@Dividendology thanks bro, love it

[@mangekyousharingan7335]

@@Dividendology now it does not work again?...