How to install:

  1. The extension use our API Euronext - PEA - Stocks and ETFs hosted on Rapid API. To use the extension, you will need an authentication key to request the web service.
    To retrieve your personal key, please go to the Rapid API website and:
    • Create your account or login
    • Create a new application into the section Apps
    • Use the API Euronext - PEA - Stocks and ETFs by selecting it in your application
    • Retrieve the API key generated for your new application
  2. Install the extension in your Google Workspace's space.
  3. In the menu PEA Extension, select Enter API Key and enter the API key you've just obtained in the previous step on the Rapid API website.

How to use the functions of the extension:

A. PEAGetMarkets(): retrieve the list of markets.

Properties of the result lines:
Name Usage
Code MIC code of the targeted market.
Example: XPAR
Name Fullname of market
Nb ETFs Number of ETF available on the market
Nb Stocks Number of stocks available on the market



B. PEAGetStocks([market]): retrieve the list of stocks eligibles to the PEA

Input parameters:
Name Mandatory Usage
market yes MIC code of the targeted market.
Example: XPAR

Properties of the result lines:
Name Usage
ISIN ISIN code of stock
Symbol Stock ticker
Name Name of stock
Type Type of stock
SubType Sub-type of stock
Amount unit amount of stock
Evol Last evolution of stock
Industry Industry from the ICB classification
Super sector Super sector from the ICB classification
Sector Sector from the ICB classification
Sub sector Sub sector from the ICB classification
Admitted shares Number of admitted shares
Nominal value Nominal value of stock
Last updated at Last update date



C. PEAGetETFs([market]): retrieve the list of ETFs eligible to PEA

Input parameters:
Name Mandatory Usage
market yes MIC code of the targeted market.
Example: XPAR

Properties of the result lines:
Name Usage
ISIN ISIN code of ETF
Symbol ETF Ticker
Short Name Short name of ETF
Long Name Long name of ETF
Issuer Name Issuer name
Type Type
SubType Sub-titre
Amount Unit amount of the ETF
Evol Last evolution
Last updated at Last update date