Googleスプレッドシート セクター名 業種 取得する morningstar.com

セクター名 (Sector)

=IMPORTXML("http://quotes.morningstar.com/stockq/c-company-profile?&t=" &B86,"//div[@class='gr_row_a2a'][1]//div[@class='gr_row3'][1]//div[@class='gr_colm1'][1]/span[@class='gr_text7']")

&B86 はティッカーシンボルをしているセルの値にしてください

業種 (Industry)

=IMPORTXML("http://quotes.morningstar.com/stockq/c-company-profile?&t=" &B86,"//div[@class='gr_row_a2a'][1]//div[@class='gr_row3'][1]//div[@class='gr_colm1a'][1]/span[@class='gr_text7']")

サイトの構成が、たまに変わるので、やり方のメモ

まずシンプルに、このURLで何が表示されるか確認。

この場合は KO
http://quotes.morningstar.com/stockq/c-company-profile?&t=KO

こんなページが表示されるので、ページのソースを表示させて文字列を確認して研究、修正する。

この値を取得したい。

What Does This Company Do?
Coca-Cola is the largest nonalcoholic beverage entity in the world, owning and marketing some of the leading carbonated beverage brands, such as Coke, Fanta, and Sprite, as well as nonsparkling brands, such as Minute Maid, Georgia Coffee, and Glaceau. Operationally, the firm focuses its manufacturing efforts early in the supply chain, making the concentrate (or beverage bases) for its drinks that are then processed and distributed by its network of more than 100 bottlers. Concentrate operations represented 85% of the company’s unit case volume in 2018. Coca-Cola recently expanded its presence in the hot-beverage market through its acquisition of Costa, a leading coffee company in the United Kingdom. The firm generates most of its revenue internationally.

Visit Company Website

Sector
Consumer Defensive

Industry
Beverages - Non-Alcoholic

Stock Type
High Yield

Employees
86,200

Fiscal Year Ends
2020-12-31

Stock Style

Large Core

日本語化

ほほう、ここに挟めばいいのか。

=googletranslate(XXXXXXXXXXXXXXXXXXXXXXX,"en","ja")

セクター名

=googletranslate(IMPORTXML("http://quotes.morningstar.com/stockq/c-company-profile?&t=" &F3,"//div[@class='gr_row_a2a'][1]//div[@class='gr_row3'][1]//div[@class='gr_colm1a'][1]/span[@class='gr_text7']"),"en","ja")

業種

=googletranslate(IMPORTXML("http://quotes.morningstar.com/stockq/c-company-profile?&t=" &F4,"//div[@class='gr_row_a2a'][1]//div[@class='gr_row3'][1]//div[@class='gr_colm1'][1]/span[@class='gr_text7']"),"en","ja")

日本語化ではお世話になりました。
https://nonbiri-reinvest.net/post-1555/#toc7