OpenFIGI Identifier Mapping Scraper

OpenFIGI Identifier Mapping Scraper

Map ISINs, CUSIPs, SEDOLs, and tickers to full OpenFIGI composite records. Feed it a list of identifiers and get back every associated exchange code, security name, market sector, and FIGI. No Bloomberg Terminal required.

Financial data often arrives as a mess of local identifiers. An ISIN from one system, a CUSIP from another, and a ticker that changes with the exchange. The OpenFIGI API from Bloomberg normalizes these, but hitting it manually means rate limits, pagination, and mapping one ID at a time. This Actor automates bulk lookups so you get a clean, flat dataset of every mapping in one run.

It reads your list of ISINs, CUSIPs, SEDOLs, or tickers and returns the full OpenFIGI composite record for each match.

Who uses it	What they scrape OpenFIGI for
Quantitative analysts	Normalize a portfolio of mixed identifiers into a single FIGI-based security master.
Data operations teams	Reconcile vendor feeds by mapping proprietary IDs to exchange-level FIGI codes.
Compliance officers	Verify that a list of ISINs maps to the correct legal entities and share classes.
Financial data vendors	Enrich a security database with missing exchange codes and market sector metadata.

What it does

This Actor collects OpenFIGI identifier mappings for a list of ISINs, CUSIPs, SEDOLs, or tickers and returns each security's full composite record as a flat row.

• 🔗 Multi-identifier input: Paste a comma-separated list of ISINs, CUSIPs, SEDOLs, or tickers directly into the input field.
• 🏦 Exchange filtering: Limit results to a single exchange code, such as US or XNAS, to reduce noise in the output.
• 📊 Full composite record: Each row returns the FIGI, share class FIGI, security name, ticker, exchange code, market sector, and security type.
• ⚡ Bulk mapping: Map up to 1,000,000 identifiers in a single run for paid users, bypassing the manual one-by-one API lookup.

Results export to CSV, JSON, Excel, or XML, or straight from the API.

What you can do with OpenFIGI data

📈 Build a security master from mixed identifiers.

A quant researcher feeds a list of ISINs and CUSIPs from multiple brokers into the Actor to produce a single, FIGI-keyed reference table for backtesting.

🔍 Reconcile vendor data feeds.

A data operations team runs a daily batch of SEDOLs through the Actor to confirm that each one maps to the expected exchange and ticker before loading it into the warehouse.

🏛️ Verify regulatory filings.

A compliance analyst maps a list of ISINs from a client report to their legal entity names and share class FIGIs to check for discrepancies.

🌐 Enrich a proprietary database.

A financial data vendor uses the Actor to backfill missing exchange codes and market sectors for thousands of securities identified only by ticker.

Why choose this scraper

	What you get
Input format	Comma-separated identifier values
Supported ID types	ISIN, CUSIP, SEDOL, Ticker, Base Ticker, BB Unique ID, Wertpapier, Common ID
Output record	Full OpenFIGI composite with FIGI, name, ticker, exchange, sector, and type
Exchange filter	Optional single exchange code to restrict results
Scale	Up to 1,000,000 mappings per run for paid users

How it compares

No other Store actor targets OpenFIGI the same way, so the honest comparison is with the alternatives teams actually weigh.

	OpenFIGI Identifier Mapping Scraper	Build it in-house	By hand
Setup	Run it now, zero config	Days of engineering	None, but hours per pull
When OpenFIGI changes	Maintained for you	You fix it	You re-learn the page
Proxies, retries, anti-bot	Built in	Your problem	Browser only
Output	Fixed JSON schema, CSV/Excel export	Whatever you build	Copy-paste
Cost	Pay per result	Engineering time	Analyst hours

Configure the run

Drive the Actor from a list of identifier values and an optional exchange code, and each identifier is resolved against the OpenFIGI API so only successful mappings reach your dataset. The Input tab lists every parameter.

A first run with the defaults:

{
  "idValues": "US0378331005,US5949181045",
  "maxItems": 10
}

A larger pull:

{
  "idValues": "US0378331005,US5949181045",
  "maxItems": 200
}

Pricing

Pay-per-result: $0.0085 per result collected. You pay only for the results written to your dataset.

Results collected	Approximate cost
100 results	$0.85
1,000 results	$8.50
10,000 results	$85.00

New Apify accounts start with $5 in free credit.

Free users

Free-plan runs return up to 10 results as a preview. Upgrade your Apify plan to collect up to 1,000,000 results per run.

Run it

1. Create a free Apify account with $5 in credit.
2. Open the OpenFIGI Identifier Mapping Scraper.
3. Set your inputs and any filters, then click Start.
4. Export the results as CSV, Excel, JSON, or XML from the Dataset tab.

Run it programmatically through the Apify API (run-sync-get-dataset-items) or the ApifyClient for JavaScript and Python.

Use with AI agents (MCP)

Give an AI agent live access to OpenFIGI through the Model Context Protocol. Add the Actor to Claude, Cursor, or any MCP client:

$claude mcp add --transport http apify "https://mcp.apify.com?tools=parseforge/openfigi-mapping-scraper"

Then prompt it in plain language to run the scraper and read back the results.

Troubleshooting

Why am I getting no results?

Check that your identifier values are correct and match the selected ID type. An ISIN entered when the type is set to CUSIP will not map. Also verify that the identifiers are comma-separated with no extra spaces or line breaks.

Why is my run limited to 10 results?

Free Apify accounts are limited to 10 mappings per run as a preview. Upgrade to a paid plan to increase the limit up to 1,000,000 mappings.

Why are some of my identifiers missing from the output?

The OpenFIGI API may not have a mapping for every identifier. The Actor returns only successful matches. Try the identifier on the OpenFIGI website directly to confirm it exists.

Why is the run taking so long?

The OpenFIGI API has rate limits, and the Actor processes requests one at a time to comply. A batch of 100,000 identifiers can take several hours. Use the exchange code filter to reduce the number of API calls per identifier.

Why do I see duplicate rows for the same identifier?

A single identifier can map to multiple FIGIs if the security trades on several exchanges. Use the exchange code filter to narrow results to one venue, or deduplicate in post-processing.

FAQ

Question	Answer
What identifier types can I map?	You can map ISINs, CUSIPs, SEDOLs, tickers, base tickers, Bloomberg Unique IDs, Wertpapier codes, and Common IDs. Select the type from the dropdown and paste the values as a comma-separated list.
How many identifiers can I map in one run?	Free users on the Apify platform are limited to 10 mappings as a preview. Paid users can map up to 1,000,000 identifiers in a single run.
What does the output look like?	Each row is a flat JSON or tabular record containing the FIGI, share class FIGI, security name, ticker, exchange code, market sector, security type, and the original input identifier you provided.
Can I filter results by exchange?	Yes. Use the optional exchange code field to limit results to a single exchange, such as 'US' for United States exchanges or 'XNAS' for NASDAQ.
Do I need a Bloomberg Terminal or API key?	No. This Actor uses the public OpenFIGI API, which does not require a Bloomberg Terminal subscription or an API key.
What happens if an identifier does not map?	Identifiers that return no mapping from the OpenFIGI API are omitted from the results. Your dataset contains only successful mappings.
Can I map identifiers from different types in the same run?	No. Each run uses a single identifier type. If you have a mix of ISINs and CUSIPs, run the Actor twice, once for each type.
Is there a rate limit on the OpenFIGI API?	The Actor respects the OpenFIGI API rate limits and processes requests sequentially to avoid throttling. Large batches may take longer to complete.
What export formats are supported?	You can export your results to CSV, JSON, Excel, or XML from the Apify dataset tab.
Can I schedule this Actor to run daily?	Yes. Apify supports scheduled runs. You can set this Actor to run daily with a fixed list of identifiers or integrate it with an external service via the API.

Related actors

Browse the full ParseForge collection for more scrapers.

🆘 Need help? Email parseforge@protonmail.com with your run ID, your input, and what you expected.

⚠️ Disclaimer. This Actor is unofficial and is not affiliated with, endorsed by, or sponsored by Bloomberg Finance L.P. It collects only publicly available data. You are responsible for using the collected data in compliance with the source's terms of service and applicable data-protection laws, including GDPR, CCPA, and PIPL. Do not use it to collect personal data unlawfully.