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 workbook 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 to loop over all 200 rows, call the endpoint once per ISIN, extract the ticker symbol and exchange code from the response, and handle cases where the search returns multiple results.
- Import the output into the workbook, manually review rows where EODHD returned more than one match, and make a judgment call on which exchange to use.
The reconciliation is next week. This is Monday.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. 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.
Convert each ISIN in column A of my 'Holdings' Excel 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 (US, XETRA, LSE, etc.)
- Any ISIN that returns multiple matches flagged in column D with alternatives listed
- 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 has both 12-character ISINs and 9-character CUSIPs.
For each identifier in column A of my 'Holdings' Excel workbook, 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' Excel workbook, 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 — you need the primary home exchange listing, not the ADR.
Convert each ISIN in column A of my 'Holdings' Excel workbook to a ticker and exchange code using EODHD. Where multiple listings are returned, prefer the primary home exchange over US ADR listings. 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' Excel workbook, 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 Excel workbook with a list of ISINs or CUSIPs, then ask it to run the EODHD identifier mapping. You can also ask it to build a full global ticker reference workbook or see all EODHD use cases at the integration hub.