セクター名 (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.Sector
Consumer DefensiveIndustry
Beverages - Non-AlcoholicStock Type
High YieldEmployees
86,200Fiscal Year Ends
2020-12-31Stock 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
