The Scenario
The fund administrator who held all the ISIN-to-ticker mappings left the firm two months ago. You've inherited an Excel export with 200 rows of ISINs — one column, no tickers, no exchange codes — and next week's reconciliation against the Bloomberg feed requires ticker symbols. The mapping spreadsheet this person kept locally isn't accessible. The path forward is rebuilding it from scratch.
The bad version:
- Open the EODHD API documentation, find the ISIN search endpoint, figure out the authentication header format, and run a test call for one ISIN to confirm the response structure.
- Write a script — or adapt someone else's — to loop over all 200 rows, call the endpoint once per ISIN, extract the ticker symbol and exchange code from the response, and handle the cases where the search returns multiple results for the same ISIN (different exchanges, different share classes).
- Import the output into the sheet, manually review the rows where EODHD returned more than one match, and make a judgment call on which exchange to use for each one.
The reconciliation is next week. This is Monday.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the ISIN list, calls the EODHD ID mapping API for each entry, writes the ticker symbol and exchange code into the adjacent columns, and flags any ambiguous results for your review — without a script or API documentation.
Convert each ISIN in column A of my 'Holdings' sheet to a ticker symbol and exchange code using EODHD ID mapping and write the results into columns B and C.
What You Get
- Column B: primary exchange ticker symbol for each ISIN
- Column C: exchange code (e.g., US, XETRA, LSE)
- Any ISIN that returns multiple matches flagged in column D with the alternatives listed, so you can make the judgment call
- Any ISIN with no match returned marked "NOT FOUND" rather than left blank
What If the Data Is Not Quite Ready
The identifier list has a mix of ISINs and CUSIPs
Column A is inconsistent — some rows are 12-character ISINs, others are 9-character CUSIPs. The EODHD endpoint for each is different.
For each identifier in column A of my 'Holdings' sheet, detect whether it is an ISIN or CUSIP by length and format, call the appropriate EODHD lookup endpoint, and write the resulting ticker and exchange code into columns B and C.
You need to add the full company name alongside the ticker
The Bloomberg reconciliation also needs a display name column for audit purposes.
For each ISIN in column A of my 'Holdings' sheet, use EODHD to look up the ticker symbol, exchange code, and company name, then write them into columns B, C, and D respectively.
Some securities are cross-listed on multiple exchanges
A portion of the holdings are cross-listed — the same ISIN exists on NYSE ADR and the primary home exchange. You need the primary listing, not the ADR.
Convert each ISIN in column A of my 'Holdings' sheet to a ticker and exchange code using EODHD. Where multiple listings are returned, prefer the primary home exchange over US ADR listings and write the preferred mapping into columns B and C. Flag any row where only an ADR listing was found in column D.
Full reconciliation prep: map identifiers, verify against Bloomberg names, flag mismatches
For each ISIN in column A of my 'Holdings' sheet, use EODHD to resolve the ticker and company name into columns B and C. Then compare the company name in column C against the name already in column E (from the Bloomberg export) and flag any row where the names differ by more than minor formatting differences in column F.
One prompt handles the lookup, the enrichment, and the QA check.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with a list of ISINs, CUSIPs, or company names, then ask it to run the EODHD identifier mapping. You can also ask it to build a full global ticker reference sheet or see all EODHD use cases at the integration hub.