• Contact
main menu
    back
      img

      Platform Guide: Uploading and Managing Portfolios

      Platform guide

      This guide shows you how to upload a portfolio to the Integrum ESG Platform as a CSV file, share it with colleagues and keep it up to date. Portfolios can also be uploaded directly from your own systems through our API, as set out at the end of this guide.

      Download this guide as a PDF

      Step 1: Prepare your file

      Set out your file in Excel like this:

      Cell A1The portfolio name
      Cell B1 (optional)NON-AGGREGATE, to keep repeat ISINs as separate positions
      Column A, from row 2The holding name
      Column B, from row 2The ISIN or LEI
      Column C, from row 2The weighting, with no % symbol

      Then save the file as CSV (comma delimited).

      Good to know

      • Weightings do not need to add up to 100. They are recalibrated automatically.
      • Leave column C empty for equal weightings. Do not enter 0.
      • Enter short positions as negative weightings.
      • Do not add column headings, blank rows or notes.

      Example portfolio CSV layout with the portfolio name in cell A1, holdings in column A, ISINs in column B and weightings in column C

      Step 2: Open the upload page

      1. Click your initials in the top right corner.
      2. Select Portfolios & Profiles.
      3. Click Upload Portfolio.
      Account menu opened from the user's initials, with Portfolios and Profiles selectedPortfolios and Profiles page with the Upload Portfolio button

      Step 3: Upload the file

      1. Choose By ISIN or By LEI, to match your file.
      2. Drop your CSV into the upload box, or click the box to choose it.
      3. Check the file name under Files to be uploaded.
      4. Click Upload Portfolios.

      Upload New Portfolio box with a CSV file ready to upload by ISIN

      Step 4: View your portfolio

      1. Wait for the message confirming the upload.
      2. Click Portfolio View in the left-hand sidebar.
      3. Choose your portfolio from the Portfolios drop-down.

      The overview shows how much of the portfolio is covered directly, how much uses proxy scores and how much is not covered. Use the Include proxy scores toggle to switch proxy scores on or off.

      Confirmation message after a portfolio uploadPortfolio overview showing holdings, direct coverage, proxy coverage and the dataset tabs

      The tabs below the overview open each dataset: ESG Overview, Material Risks, Footprint, Global Warming Impact, Regulatory and Revenue Data. The methodology behind each one is on our Methodologies and Tutorials page.

      Step 5: Share it with colleagues

      1. Go to Portfolios & Profiles.
      2. Click the three dots next to the portfolio.
      3. Select Edit Users.
      4. Click the green plus sign next to a colleague to add them. Click the red minus sign to remove someone.
      Portfolio menu with Edit Users, Rename Portfolio and Update PortfolioEdit Users window listing current and available users for a portfolio

      Step 6: Update a portfolio

      To change weightings or add holdings:

      1. Click the three dots next to the portfolio.
      2. Select Update Portfolio.
      3. Upload a file in the same layout, without the portfolio name in cell A1.

      To replace a portfolio completely, including removing holdings:

      1. Upload a new file with the same portfolio name in cell A1. The portfolio is refreshed to match the new file.

      To change a portfolio’s name, select Rename Portfolio from the same menu.

      Upload portfolios through our API

      Your technology team can upload portfolios directly from your own systems, so holdings stay current without manual uploads.

      • Send the same CSV layout, with ISINs in column B, to our portfolio upload endpoint, authenticated with your API key.
      • Each response confirms the upload and lists any ISINs that could not be mapped, so they can be corrected at source.
      • API keys are created by Super Users on the Account page, as explained in our guide to managing your account and team.
      • The API Portfolio Management guide sets out the request format in full, and the API Guide covers the wider API.

      Frequently asked questions

      What file format do I need?

      A CSV (comma delimited) file, with the portfolio name in cell A1 and, from row 2, the holding name in column A, the ISIN or LEI in column B and the weighting in column C.

      Do weightings need to add up to 100?

      No. Weightings are recalibrated automatically. Leave column C empty for an equally weighted portfolio.

      Can I upload short positions?

      Yes. Enter short positions as negative weightings.

      Can I upload by LEI instead of ISIN?

      Yes. Choose By LEI on the upload page to match the identifiers in your file.

      What happens to holdings that are not covered?

      The portfolio overview shows the share of the portfolio covered directly, the share shown using proxy scores and the share not covered. Proxy scores can be switched on or off, as explained in our Proxy ESG Scores Methodology.

      Can I upload portfolios directly from my own systems?

      Yes. Your technology team can send portfolio files to our API, authenticated with an API key, so holdings stay current without manual uploads. The API Portfolio Management guide sets out the request format.

      Prefer a walkthrough?

      Your Account Manager can take you through this on a short call and answer any questions as you go. You can also email contact@integrumesg.com.

      Book a portfolio set-up call