top of page

How to scrape investment and VC data from London Stock Exchange

Every day, new instruments appear on the London Stock Exchange. Bonds, ETFs, structured notes tied to equities, commodities, or indices across multiple currencies and market segments. The London Stock Exchange new issues page at londonstockexchange.com/live-markets/new-issues captures all of them in a single paginated listing. Getting that data into a structured format manually is slow. This guide shows how to do it automatically using the Minexa.ai Chrome extension.

What the data looks like

Each record on the new issues page carries several fields worth understanding before you extract them.

The name field contains the full instrument name as listed. These names encode a lot: the issuer, the structure type, the linked underlying, and the maturity date. For example, a name like CITIGROUP GLOBAL MARKETS FUND LUX WRST FXD CPN ATCL NTS LKD ETFS 11/06/27 tells you the issuer, that it is a worst-of fixed coupon autocall note linked to ETFs, maturing June 2027.

The stock_code field is the unique ticker for each instrument on the exchange. It anchors deduplication and is the key you would use to deep-link to the individual instrument page via the stock_link field, which provides a relative URL path you can append to the base domain to reach the full detail page for any listing.

The market field tells you which segment the instrument is listed on. ISM refers to the International Securities Market, while MAINMARKET indicates the Main Market. This distinction matters when filtering by regulatory regime or investor eligibility.

The currency field captures the denomination of the instrument. Across a typical extraction run, you will see USD, GBP, EUR, SGD, and JPY appearing across different records, reflecting the genuinely multi-currency nature of new issuance activity on the exchange.

The type field classifies the instrument. Most new issues on this page are Bonds, though ETFs and other instrument types appear as well. The investment_strategy field currently shows Track across all records, indicating the strategy classification assigned at listing.

The price field captures the listed price where available. For many newly issued instruments, this field returns a dash, indicating the price has not yet been set or is not displayed at the listing stage.

Watch the extraction walkthrough

How to extract the data step by step

Open the Minexa.ai Chrome extension from your browser toolbar while on the Minexa home page. The extension loads your scraping dashboard as the starting point.

Navigate to the London Stock Exchange new issues page. Once the page has fully loaded, open the extension again. Minexa detects the page content and prepares to begin configuration.

The extension popup appears with a confirmation prompt. Click the button to confirm you are on the correct page and ready to proceed.

Minexa then shows you the pagination it detected on the page, including the next page button. Review the pagination logic and click Continue to proceed.

You are then asked whether to scrape the listing only, or the listing plus the detail page for each instrument. For most investment monitoring use cases, the list-level data is sufficient. Select your preferred option and continue.

Minexa highlights the full data container on the page automatically. You do not need to click on individual fields. The entire repeating structure is identified in one step.

All extracted data points are displayed with navigation controls so you can review each column before confirming. Once satisfied, complete the configuration to save the scraper.

The job summary screen shows your scraper is ready. From here you can connect a Google Sheet or set up a recurring schedule to keep the dataset updated automatically.

Sample extracted data

Below are three records from a real extraction run on the London Stock Exchange new issues page, with field names cleaned up for readability.

[
  {
    "name": "CITIGROUP GLOBAL MARKETS FUND LUX WRST FXD CPN ATCL NTS LKD ETFS 11/06/27",
    "stock_code": "4UB4",
    "currency": "USD",
    "market": "ISM",
    "investment_strategy": "Track",
    "type": "Bonds",
    "price": "-",
    "stock_link": "stock/4UB4/citigroup-global-markets-funding-luxembourg-s-c-a"
  },
  {
    "name": "MORGAN STANLEY EUROPE SE EQTY LKD NTS 08/06/27",
    "stock_code": "3CO1",
    "currency": "USD",
    "market": "ISM",
    "investment_strategy": "Track",
    "type": "Bonds",
    "price": "-",
    "stock_link": "stock/3CO1/morgan-stanley-europe-se"
  },
  {
    "name": "ISHARES IV PLC ISHARES SPACE TECHNOLOGIES UCITS ETF USD",
    "stock_code": "STRR",
    "currency": "GBP",
    "market": "MAINMARKET",
    "investment_strategy": "Track",
    "type": "",
    "price": "3.69",
    "stock_link": "stock/STRR/ishares"
  }
]

Exporting and reusing the scraper

Once the job completes, you can export the full dataset to Excel, Google Sheets, or JSON directly from the results screen. The scraper you trained on this page can be reused on any structurally similar paginated listing on the London Stock Exchange without repeating the setup process.

Recent Posts

See All

Comments


Heading 2

bottom of page