What You Will Learn
You will learn how to use Gemini to infer a likely public-company ticker from a company name, then validate it manually before using that ticker in GOOGLEFINANCE.
Required Dataset
Use the workbook from Lessons 53 and 55.
Use:
Company_Enrichment
Market_Cap_Practice
Create three new tabs:
Ticker_Identification
Ticker_Validation
Ticker_Check
Before You Start
This lesson is a research workflow, not a formula-only task. Gemini can suggest likely tickers, but a ticker must be validated before it is used for market data.
Step-by-Step Instructions
Step 1. Create ticker identification fields
In Ticker_Identification, create fields for:
Company Name
Website
Country
Ownership Type
Likely Public Parent
Candidate Ticker
Candidate Exchange
Exchange-Qualified Ticker
Candidate Confidence
Validation Status
Review Needed
Notes
Add company names such as:
Microsoft
Alphabet
Toyota Motor
Stripe
YouTube
Unilever
Step 2. Ask Gemini for ticker candidates
Use this prompt:
Act as a public-company research analyst.
For each company in Ticker_Identification, identify whether the company is public, private, or a subsidiary. If public, suggest the likely ticker and exchange. If it is a subsidiary, identify the likely public parent if known.
Return candidate ticker, exchange-qualified ticker, confidence level, validation status, review needed, and notes.
Do not invent tickers. Treat all suggestions as candidates requiring manual validation.
Paste the output into Ticker_Identification.
Step 3. Test the candidate ticker
In Ticker_Validation, use the exchange-qualified ticker and test whether GOOGLEFINANCE returns data.
For price:
=IFERROR(GOOGLEFINANCE(B2,”price”),””)
For currency:
=IFERROR(GOOGLEFINANCE(B2,”currency”),””)
For market cap:
=IFERROR(GOOGLEFINANCE(B2,”marketcap”),””)
Step 4. Add validation status
Use status values such as:
Confirmed
Needs Review
Formula Test Passed
Formula Failed
Private / Not Applicable
Subsidiary / Parent Ticker
A formula test means the ticker returns data. It does not prove the ticker belongs to the company you intended.
Expected Result
You should have a ticker research table with candidate tickers, confidence levels, validation status, formula test outputs, and review flags.
Check Your Work
Confirm that public/private status is correct, subsidiaries are not confused with parents, exchange-qualified tickers are used, and only confirmed tickers are approved for market data.
Optional Extension
Ask Gemini:
Review the Ticker_Validation tab. Identify ambiguous tickers, private companies, subsidiary-parent cases, ADRs, multiple share classes, and rows that should not be used in GOOGLEFINANCE until manually verified.
