📌 What company profile and ownership data can you collect from Yahoo Finance?
This template looks up each supplied stock symbol and collects company profile, sector, industry, employee, executive, ownership, insider roster, governance, and sustainability fields from Yahoo Finance. It is useful for investors, financial analysts, researchers, and corporate intelligence teams.
Data is collected from Yahoo Finance. Yahoo Finance provides market data, company profiles, ownership information, and financial news.
💰 Pricing
This template is currently free of charge and has no per-line usage fee. Octoparse plan or resource limits may still apply.
📦 Output
The current published implementation can return the following fields:
Textbox_valueKeywordPage_URLCompany_nameCompany_addressStockExchangeInformationSectorIndustryFull_time_employeesKey_executivesDescriptionCorporate_governanceMajor_HoldersTop_Institutional_HoldersTop_Mutual_Fund_HoldersPage_URL1Source_codeInsider_rosterESG_risk_ratingControversy_levelSustainability_URL2Error_message
{
"Textbox_value": null,
"Keyword": "KO",
"Page_URL": "https://sg.finance.yahoo.com/quote/KO/profile?p=KO",
"Company_name": "The Coca-Cola Company",
"Company_address": "One Coca-Cola Plaza",
"StockExchangeInformation": "NYSE - Nasdaq Real-time price. Currency in USD",
"Sector": "Consumer Defensive",
"Industry": "Beverages—Non-Alcoholic",
"Full_time_employees": "79,000",
"Key_executives": "Mr. James Robert B. Quincey Chairman & CEO 8.12M N/A 1965 Mr. Brian John Smith Pres & COO 4.47M N/A 1955 Mr. John Murphy Exec. VP & CFO 3.27M N/A 1962 Mr. Manuel Arroyo Prieto Chief Marketing Officer 2.88M N/A 1968 Mr. Mario Alfredo Rivera Garcia Pres of North America Operating Unit 2.38M 175.27k 1962 Mr. Mark Randazza VP, Assistant Controller & Chief Accounting Officer N/A N/A 1966 Ms. Nancy W. Quan Sr. VP & Chief Technical and Innovation Officer N/A N/A 1966 Mr. Timothy K. Leveridge VP & Investor Relations Officer N/A N/A 1970 Ms. Monica Howard Douglas Sr. VP & Gen. Counsel N/A N/A 1973 Ms. Beatriz R. Perez Sr. VP & Global Chief of Communications, Sustainability and Strategic Partnerships Officer N/A N/A 1970",
"Description": "The Coca-Cola Company, a beverage company, manufactures, markets, and sells various nonalcoholic beverages worldwide. The company provides sparkling soft drinks; flavored and enhanced water, and sports drinks; juice, dairy, and plantbased beverages; tea and coffee; and energy drinks. It also offers beverage concentrates and syrups, as well as fountain syrups to fountain retailers, such as restaurants and convenience stores. The company sells its products under the Coca-Cola, Diet Coke/Coca-Cola Light, Coca-Cola Zero Sugar, Fanta, Fresca, Schweppes, Sprite, Thums Up, Aquarius, Ciel, dogadan, Dasani, glacéau smartwater, glacéau vitaminwater, Ice Dew, I LOHAS, Powerade, Topo Chico, AdeS, Del Valle, fairlife, innocent, Minute Maid, Minute Maid Pulpy, Simply, Ayataka, BODYARMOR, Costa, FUZE TEA, Georgia, and Gold Peak brands. It operates through a network of independent bottling partners, distributors, wholesalers, and retailers, as well as through bottling and distribution operators. The company was founded in 1886 and is headquartered in Atlanta, Georgia.",
"Corporate_governance": "The Coca-Cola Company’s ISS governance QualityScore as of 1 June 2022 is 8. The pillar scores are Audit: 5; Board: 6; Shareholder rights: 3; Compensation: 10. Corporate governance scores courtesy of Institutional Shareholder Services (ISS). Scores indicate decile rank relative to index or region. A decile score of 1 indicates lower governance risk, while 10 indicates higher governance risk.",
"Major_Holders": "0.66% % of shares held by all insiders 70.73% % of shares held by institutions 71.21% % of float held by institutions 3,455 Number of institutions holding shares",
"Top_Institutional_Holders": "Berkshire Hathaway, Inc 400,000,000 30 Mar 2022 9.23% 24,800,000,000 Vanguard Group, Inc. (The) 351,220,018 30 Mar 2022 8.10% 21,775,641,116 Blackrock Inc. 279,114,132 30 Mar 2022 6.44% 17,305,076,184 State Street Corporation 171,972,013 30 Mar 2022 3.97% 10,662,264,806 FMR, LLC 83,088,402 30 Mar 2022 1.92% 5,151,480,924 Wellington Management Group, LLP 80,654,038 30 Mar 2022 1.86% 5,000,550,356 JP Morgan Chase & Company 70,822,837 30 Mar 2022 1.63% 4,391,015,894 Geode Capital Management, LLC 70,444,447 30 Mar 2022 1.63% 4,367,555,714 Charles Schwab Investment Management, Inc. 51,570,921 30 Mar 2022 1.19% 3,197,397,102 Morgan Stanley 51,062,192 30 Mar 2022 1.18% 3,165,855,904",
"Top_Mutual_Fund_Holders": "Vanguard Total Stock Market Index Fund 110,475,263 30 Dec 2021 2.55% 6,541,240,322 Vanguard 500 Index Fund 85,073,273 30 Mar 2022 1.96% 5,274,542,926 SPDR S&P 500 ETF Trust 41,671,660 27 Feb 2022 0.96% 2,593,644,118 Fidelity 500 Index Fund 39,810,869 27 Feb 2022 0.92% 2,477,828,486 iShares Core S&P 500 ETF 33,703,978 30 Mar 2022 0.78% 2,089,646,636 Vanguard Index-Value Index Fund 32,371,809 30 Mar 2022 0.75% 2,007,052,158 Vanguard Specialized-Dividend Growth Fund 30,976,179 30 Jan 2022 0.71% 1,889,856,680 Vanguard Institutional Index Fund-Institutional Index Fund 29,137,368 30 Mar 2022 0.67% 1,806,516,816 Select Sector SPDR Fund-Consumer Staples 25,573,363 30 Mar 2022 0.59% 1,585,548,506 Vanguard Specialized-Dividend Appreciation Index Fund 25,489,921 30 Jan 2022 0.59% 1,555,140,080",
"Page_URL1": "https://sg.finance.yahoo.com/quote/KO/holders?p=KO",
"Source_code": null,
"Insider_roster": "BRAUN HENRIQUE Divisional Officer Sale 17 Mar 2022 45,442 DOUGLAS MONICA HOWARD General Counsel Sale 15 Mar 2022 20,906 KOUMETTIS NIKOLAOS Divisional Officer Sale 17 Apr 2022 136,513 MANN JENNIFER K Officer Sale 07 Apr 2022 73,037 MURPHY JOHN Chief Financial Officer Sale 03 Mar 2022 133,451 PEREZ BEATRIZ R Officer Sale 04 May 2022 142,251 QUAN NANCY W Chief Technology Officer Sale 13 Apr 2022 202,999 RIVERA ALFREDO Divisional Officer Sale 24 Feb 2022 62,113 SIMPSON BARRY Officer Sale 01 Mar 2022 27,273 SMITH BRIAN JOHN President Sale 24 Apr 2022 156,625",
"ESG_risk_rating": null,
"Controversy_level": "3Significant controversy level",
"Sustainability_URL2": null,
"Error_message": null
}
🎯 Use Cases
- Use Company_name, Sector, Industry, and Description to build company profiles.
- Use Key_executives and Insider_roster to research leadership and insider activity.
- Use Major_Holders, Top_Institutional_Holders, and Top_Mutual_Fund_Holders to analyze ownership.
- Use Corporate_governance, ESG_risk_rating, and Controversy_level to support governance and sustainability research.
🐙 Why Octoparse
- Ready-to-use workflow: The extraction steps for Yahoo Finance are already configured, so you do not need to build the scraper from scratch.
- Flexible execution: Choose the supported local or cloud run mode to fit one-off checks or repeatable collection work.
- Structured, repeatable output: Results are returned as consistent rows that are easier to compare, filter, deduplicate, and process than manually copied pages.
- Verified input guardrails: The form exposes the current inputs, selectable values, and meaningful limits configured for this template.
- Practical data handoff: Review results in Octoparse and export or process them using the options supported by your Octoparse environment.
📝 Input
Complete the following fields:
- Organization Stock Symbols(Up to 20K) (Required) — Please enter the Organization Stock Symbols you need to collect. Please separate them with the Enter key. Enter a maximum of 20,000 symbols at a time. Up to 20,000 entries per run.
🚀 How to Use
- Open the template and select Try it or Start.
- Complete the input fields listed above.
- Start the task using the supported local or cloud run mode.
- Review the output rows and export or process the structured data.
⚠️ Limitations
Results depend on what the source site exposes at run time. A listed output field can be empty when the source page does not provide that value. Input limits shown above are enforced by the template.
💡 Tips
Use specific, valid inputs and review a representative result before starting a large batch. Remove duplicate inputs when repeated records are not needed.
❓ FAQ
How does this scraper work?
The template opens Yahoo Finance symbol lookup, submits each stock symbol, then visits the Profile, Holders, Insider Roster, and Sustainability sections when available and combines their configured fields into structured company records.
What do I need to enter?
Use the fields and accepted values shown in the Input section. Only user-relevant limits and selectable options are listed.
What data does this template return?
The current output fields and a representative JSON Data Preview are listed in the Output section. Field availability can vary when the source page does not display a value.
Is this template free to use?
It is currently free of charge and has no per-line usage fee. Octoparse plan or resource limits may still apply.
Why can some output fields be empty?
Source pages do not always expose every value for every record, and layouts can vary by item, market, or current site response. The template returns a field when the current page provides it.
Can I export the collected data?
You can review the structured rows in Octoparse and export or process them using the options supported by your Octoparse environment.
🔗 Related Templates
- Scrape Yahoo Cryptocurrencies — Use Scrape Yahoo Cryptocurrencies for Yahoo-hosted cryptocurrency market listings.
- CoinMarketCap Scraper — Use CoinMarketCap Scraper for cryptocurrency rankings, prices, market capitalization, and supply data.