The Scenario
Your team just finished a competitor landscape analysis and produced a workbook with 30 company names in column A — a mix of public companies, some well-known, some obscure mid-caps from emerging markets. The next step is to pull price history for all of them from Marketstack. The problem is that column A has names like "Reliance Industries," "Prosus N.V.," and "Haleon plc" — not ticker symbols. Marketstack needs symbols.
Someone has to resolve the company names to confirmed ticker symbols before the price data pipeline can start. The person who built the list does not know the symbols. You do not know most of them either. Looking them up one by one on a financial site and then verifying they are valid Marketstack symbols is exactly the kind of thing that eats an afternoon.
The bad version:
- Google each company name, find what looks like the right ticker on a financial site, write it into column B
- Then call Marketstack's ticker search endpoint for each symbol to verify it is actually supported — discovering that three of your guesses were wrong (wrong exchange, wrong class of shares, delisted variant)
- Go back and fix the wrong ones, re-verify, and add 45 minutes to the project for a task that should have taken 10
The price data pipeline cannot start until the symbols are confirmed. Confirmed means they exist in Marketstack, not just on the internet.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the company names in column A and through its Marketstack integration it can search for each one, confirm the best-matching ticker, and write the symbol and exchange MIC into the adjacent columns.
Look up all 30 company names in column A of this Excel workbook against Marketstack's ticker list and fill column B with the matched ticker symbol and column C with the exchange; write UNRESOLVED in column B for any name where no confident match is found
What You Get
- Confirmed ticker symbol in column B for each company in column A
- Exchange MIC in column C showing which exchange the match is listed on
- UNRESOLVED in column B for any company where Marketstack returned no confident match, so you know exactly which rows need manual review
What If the Data Is Not Quite Ready
Some companies are listed on multiple exchanges and you want the one with the highest liquidity
For each company name in column A, search Marketstack and write the ticker symbol and exchange MIC into columns B and C — where multiple listings exist, prefer the listing with the highest average daily volume, and note the alternative listings in column D
The list includes some tickers that are already correct and you want to leave those untouched
For each row in column A: if the value looks like a ticker symbol (all caps, 1-5 characters), verify it exists in Marketstack and write the exchange MIC into column C; if the value looks like a company name, search Marketstack and write the best-matching symbol into column B and the exchange into column C
You want to confirm that every resolved ticker is on a major exchange before using it downstream
For each company name in column A, search Marketstack and write the matched ticker into column B and exchange MIC into column C; in column D, write MAJOR if the exchange is one of NYSE, NASDAQ, LSE, TSX, or ASX — write MINOR for everything else so I can decide whether to include those tickers in the analysis
Full resolution pipeline: resolve names, verify symbols, fetch latest close price for each
For each company name in column A, search Marketstack for the best-matching ticker and write the symbol into column B and exchange into column C; for every successfully resolved ticker, also fetch the latest EOD close price from Marketstack and write it into column D; leave a note in column E for any row that did not resolve or had no recent price data
Combining the name resolution and the first price pull in one prompt means the dataset is ready for analysis as soon as the operation completes.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook with your company name list in column A, then ask it to resolve each one to a confirmed Marketstack ticker symbol. The Marketstack integration is included in every SheetXAI plan.
See also: enriching tickers with exchange and sector metadata and pulling historical OHLCV data.