CRAN Status Lifecycle: experimental PRs Welcome

EN-good2-Logo

Overview

Description:

Unlock the power of financial data from the Euronext stock exchange with the Euronext R package. Dive into the world of stocks, indices, funds, ETFs, and bonds, and harness the convenience of a user-friendly interface for seamless data retrieval. Whether you’re a researcher, investor, or financial enthusiast, this package provides a valuable resource for accessing and analyzing historical data, share prices, trading volumes, and more.

Disclaimer:

Please note that the Euronext R package is a tool designed to access and retrieve public financial information from the Euronext stock exchange. The data returned by the Euronext R package originates from Euronext, and the package author is not the source of this data. All information is derived from the public domain, and users are advised to refer to the official Euronext website for specific data needs.

Get in touch with the Euronext package and elevate your understanding of financial markets through the lens of R.

Description

English

The Euronext R Package is a powerful tool for accessing and retrieving financial information from the Euronext stock exchange. Whether you are interested in stocks, indexes, funds, ETFs, or bonds, this package provides a convenient interface to gather essential data for analysis and decision-making in the financial domain. With user-friendly functionalities, it simplifies the process of collecting historical data on share prices, trading volumes, and other financial indicators. Researchers, investors, and other users can extract valuable insights and make informed decisions based on the comprehensive information available. In essence, the ‘Euronext’ library is a valuable asset for those seeking a deeper understanding of Euronext and the financial markets in Europe.

Français

Le package R Euronext est un outil puissant pour accéder et récupérer des informations financières de la bourse Euronext. Que vous soyez intéressé par les actions, les indices, les fonds, les ETF ou les obligations, ce package offre une interface pratique pour collecter des données essentielles pour l’analyse et la prise de décision dans le domaine financier. Avec des fonctionnalités conviviales, il simplifie le processus de collecte de données historiques sur les prix des actions, les volumes de transactions et d’autres indicateurs financiers. Les chercheurs, les investisseurs et d’autres utilisateurs peuvent extraire des informations précieuses et prendre des décisions éclairées en se basant sur les informations complètes disponibles. En somme, la bibliothèque ‘Euronext’ est un atout précieux pour ceux qui cherchent à approfondir leur compréhension d’Euronext et des marchés financiers en Europe.

Html version of the Readme Since the size of the readme is huge due to the charts, you can visit the html version of the readme on RPubs

Installation

Installation guidelines

You can install the development version of EURONEXT from github with:

# github dev version
## We can use devtools
# Install the development version from GitHub
devtools::install_github("Fredysessie/Euronext")

# Or use remotes
# install.packages("remotes")

remotes::install_github("Fredysessie/Euronext")

EN_GetProfile() function

To better utilize the various functions of the ‘Euronext’ package, it is crucial to provide accurate information (such as ticker Name, ISIN, Symbol, or DNA) to the functions.

This function retrieves the profile of a given ticker - Equity, Index, Fund, ETF, or Bond - listed on the Euronext exchange based on its ticker Name, ISIN, Symbol, or DNA. It returns a list with details such as Name, ISIN, Symbol, and DNA information. It receives two (2) parameters: - ‘ticker’ : A character string representing the company’s ticker Name, ISIN, Symbol or DNA, - ‘stock_type’ : The type of the ticker: ‘Eq_Ind’ for Stocks and Indexes, ‘Fund’ or “F” for Fund tickers, ‘Bond’ or “B” for Bond tickers, and ‘Etfs’ or “E” for EFTs.

Example 1.a : Retrieve the profile (characteristics) of a specified Equity, Index, Fund, ETF, or Bond listed on Euronext.

Please refer to the respective functions EN_GetISIN(), EN_GetISIN_Etf(), EN_GetISIN_F(), and EN_GetISIN_B() if you wish to obtain the DNA of a giving Equity or Index, ETF, Fund, and Bond listed on Euronext (retrieving DNA is useful in case you decide to use ‘escape = TRUE’ option).

# Note: For Equity, Index, Fund, and ETF, provide the giving Symbol, ISIN, Name, or DNA for best results, but for a Bond, provide its DNA and sometimes its Name for best results because a company or country can issue more than one Bond.

 ## Equities
 # Example a : '3D SYSTEMS CORP' equity
 EN_GetProfile("4ddd")  # By providing Symbol
#> $Name
#> [1] "3D SYSTEMS CORP"
#> 
#> $ISIN
#> [1] "US88554D2053"
#> 
#> $DNA
#> [1] "US88554D2053-ETLX"
#> 
#> $Symbol
#> [1] "4DDD"

 # Example b : 'ALFEN' equity
 EN_GetProfile("NL0012817175") # By providing ISIN
#> $Name
#> [1] "ALFEN"
#> 
#> $ISIN
#> [1] "NL0012817175"
#> 
#> $DNA
#> [1] "NL0012817175-XAMS"
#> 
#> $Symbol
#> [1] "ALFEN"

 # Example c : 'LES HOTELS BAVEREZ' equity
 EN_GetProfile("LES HOTELS BAVEREZ") # By providing Name
#> $Name
#> [1] "LES HOTELS BAVEREZ"
#> 
#> $ISIN
#> [1] "FR0007080254"
#> 
#> $DNA
#> [1] "FR0007080254-ALXP"
#> 
#> $Symbol
#> [1] "ALLHB"
 
 # Example d : 'BE SEMICONDUCTOR' equity
 EN_GetProfile("NL0012866412-XAMS") # By providing DNA
#> $Name
#> [1] "BE SEMICONDUCTOR"
#> 
#> $ISIN
#> [1] "NL0012866412"
#> 
#> $DNA
#> [1] "NL0012866412-XAMS"
#> 
#> $Symbol
#> [1] "BESI"
 
 ## Indices 
 # Example a : 'AEX CONS STAPL GR' Index
 EN_GetProfile("NLCSG") # By providing Symbol
#> $Name
#> [1] "AEX CONS STAPL GR"
#> 
#> $ISIN
#> [1] "QS0011225420"
#> 
#> $DNA
#> [1] "QS0011225420-XAMS"
#> 
#> $Symbol
#> [1] "NLCSG"
 
 # Example b : 'AEX All-Share Index' Index
 EN_GetProfile("NL0000249100") # By providing ISIN
#> $Name
#> [1] "AEX ALL-SHARE"
#> 
#> $ISIN
#> [1] "NL0000249100"
#> 
#> $DNA
#> [1] "NL0000249100-XAMS"
#> 
#> $Symbol
#> [1] "AAX"

 # Example c : 'Euronext Core Europe 30 EW Decrement 5% NR' Index
 EN_GetProfile("EN CE EW30 D 5% NR") # By providing Name
#> $Name
#> [1] "EN CE EW30 D 5% NR"
#> 
#> $ISIN
#> [1] "NL0012483929"
#> 
#> $DNA
#> [1] "NL0012483929-XAMS"
#> 
#> $Symbol
#> [1] "COR30"
 
 # Example d : 'SBF 120 NR' Index
 EN_GetProfile("QS0011131842-XPAR") # By providing DNA
#> $Name
#> [1] "SBF 120 NR"
#> 
#> $ISIN
#> [1] "QS0011131842"
#> 
#> $DNA
#> [1] "QS0011131842-XPAR"
#> 
#> $Symbol
#> [1] "PX4NR"
 
 ## ETFs 
 # Example a : 'Asia IG Corp US A' Etf
 EN_GetProfile("$Asia IG Corp US A", stock_type = 'E') # By providing Name
#> $Name
#> [1] "$ASIA IG CORP US A"
#> 
#> $ISIN
#> [1] "IE0007G78AC4"
#> 
#> $DNA
#> [1] "IE0007G78AC4-XAMS"
#> 
#> $Symbol
#> [1] "ASIG"
 
 # Example b : '1X MSFT' Etf
 EN_GetProfile("MSFT", stock_type = 'E') # By providing Symbol
#> $Name
#> [1] "1X MSFT"
#> 
#> $ISIN
#> [1] "XS2337100320"
#> 
#> $DNA
#> [1] "XS2337100320-XAMS"
#> 
#> $Symbol
#> [1] "MSFT"
 
 # Example c : '3X LONG COINBASE' Etf
 EN_GetProfile("XS2399367254", stock_type = 'E') # By providing ISIN of 3X LONG COINBASE
#> $Name
#> [1] "3X LONG COINBASE"
#> 
#> $ISIN
#> [1] "XS2399367254"
#> 
#> $DNA
#> [1] "XS2399367254-XAMS"
#> 
#> $Symbol
#> [1] "3CON"
 
 # Example d : '3X PLTR' Etf
 EN_GetProfile("XS2663694680-XAMS", stock_type = 'E') # By providing DNA
#> $Name
#> [1] "3X PLTR"
#> 
#> $ISIN
#> [1] "XS2663694680"
#> 
#> $DNA
#> [1] "XS2663694680-XAMS"
#> 
#> $Symbol
#> [1] "3PLT"

 # Funds
 # Example a : 'ACOMEA PERFORMANCE' Fund
 EN_GetProfile("ACAPER", stock_type = 'F') # By providing Symbol
#> $Name
#> [1] "ACOMEA PERFORMANCE"
#> 
#> $ISIN
#> [1] "IT0005090912"
#> 
#> $DNA
#> [1] "IT0005090912-ATFX"
#> 
#> $Symbol
#> [1] "ACAPER"
 
 # Example b : 'BNP ESGNL' Fund
 EN_GetProfile("BNP ESGNL", stock_type = 'F') # By providing Name
#> $Name
#> [1] "BNP ESGNL"
#> 
#> $ISIN
#> [1] "NL0012727432"
#> 
#> $DNA
#> [1] "NL0012727432-XAMS"
#> 
#> $Symbol
#> [1] "ESGNL"
 
 # Example c : 'SWIF2' Fund
 EN_GetProfile("NL0015000W40", stock_type = 'F') # By providing ISIN of SWIF2
#> $Name
#> [1] "SWIF2"
#> 
#> $ISIN
#> [1] "NL0015000W40"
#> 
#> $DNA
#> [1] "NL0015000W40-XAMS"
#> 
#> $Symbol
#> [1] "SWIF2"

 # Example d : 'GOLDMAN SACHS PARAPLUFONDS 2 N' Fund
 EN_GetProfile("NL0000293181-XAMS", stock_type = 'F') # By providing DNA of GSDM5
#> $Name
#> [1] "GS DYN MIX FD V"
#> 
#> $ISIN
#> [1] "NL0000293181"
#> 
#> $DNA
#> [1] "NL0000293181-XAMS"
#> 
#> $Symbol
#> [1] "GSDM5"

 # Examples for Bonds
 # Example a: 'A2A SLB TF 0,625%' Bond
 EN_GetProfile("XS2364001078-XMOT", stock_type = 'B') # By providing DNA
#> $Name
#> [1] "A2A SLB TF 0,625%"
#> 
#> $ISIN
#> [1] "IT0005386724"
#> 
#> $DNA
#> [1] "XS2364001078-XMOT"
#> 
#> $Issuer
#> [1] "A2A S.p.A."

 # Example b: 'AAB1.50%30SEP30' Bond
 EN_GetProfile("AAB1.50%30SEP30", stock_type = 'B') # By providing Name
#> $Name
#> [1] "AAB1.50%30SEP30"
#> 
#> $ISIN
#> [1] "IT0005386724"
#> 
#> $DNA
#> [1] "XS1298431799-XAMS"
#> 
#> $Issuer
#> [1] "ABN AMRO BANK N.V."

EN_Get_News() function

This function retrieves the update information of a company listed on the Euronext exchange based on its ticker symbol. It returns a table with details such as its real Name, ISIN, Last traded Price, Date of last update, and other relevant informations.

Inputs : - ticker A character string representing the company’s ticker, name, or ISIN. - stock_type The type of the ticker: ‘Eq_Ind’ for Stocks and Indexes, ‘Fund’ or “F” for Fund tickers,‘Bond’ or “B” for Bond tickers, and ‘Etfs’ or “E” for EFTs. - escape Boolean, either TRUE or FALSE. If escape is True, it means you’re providing the DNA (ISIN-Market identifier) directly. Giving T to escape is helpful to avoid time-consuming operations; otherwise, F means you need to provide the Ticker symbol, name, or ISIN and the type of market to which it belongs.

Example 1.b : Get Latest News for an Equity

# Retrieve news for the equity "AALBERTS N.V." using its DNA
equity_news <- EN_Get_News("NL0000852564-XAMS", escape = TRUE)
print(equity_news)
Information Detail
Name AALBERTS N.V.
Belongs to Euronext Amsterdam
ISIN NL0000852564
Type Stock
Last traded Price 36.82
Date of last update 21/02/2024 - 17:35 CET
Since Open -0.14 (-0.38%)
Since Previous Close -0.03 (-0.08%)
Valuation Close 36.82

Example 1.c : Get Latest News for an Index

# Retrieve news for the index "AEX All-Share Index GR" using its symbol
index_news <- EN_Get_News("QS0011224977-XAMS", escape = TRUE)
print(index_news)
Information Detail
Name AEX All-Share Index GR
Belongs to Euronext Amsterdam
ISIN QS0011224977
Type Index
Last level 4,482.11
Date of last update 21/02/2024 - 18:05 CET
Since Open -5.35 (-0.12%)
Since Previous Close -5.32 (-0.12%)

Example 1.d : Get Latest News for a Bond

# Retrieve news for the bond "AAB0.45%12DEC2036" using its DNA
bond_news <- EN_Get_News("XS2093705064-XAMS", escape = TRUE)
print(bond_news)
Information Detail
Name AAB0.45%12DEC2036
Belongs to Euronext Amsterdam
ISIN XS2093705064
Type Bond
Valuation Close 100.00

EN_Stocks_List() function

This function receives as input stock_choice and then retrieves a list of companies listed on the provided Euronext stock exchanges, filtered by the initial letter of their names. It provides information such as the company name, ticker symbol, ISIN code, market, last closing price, percentage change, and a link to the company’s details on the Euronext website. - stock_choice A character string specifying the stock exchange. Options include “A” or “Amsterdam,” “B” or “Brussels,” “D” or “Dublin”, “L” or “Lisbon,” “M” or “Milan,” “P” or “Paris,” and “O” or “Oslo.”

Example 2.a : Get Euronext Stocks List

# The columns names of the initial dataframe is c("Date", "Name", "Ticker", "Code_ISIN", "Market", "Last_price", "Percentage change (in %)", "URL", "Ticker_adn")

# So I will only display columns "Name", "Ticker", "Code_ISIN", "Market", "Last_price" and "Percentage change (in %)"

# For Amsterdam Stock
a_result_df <- EN_Stocks_List("A")
head(a_result_df)[,c(2:6)]
Name Ticker Code_ISIN Market Last_price
AALBERTS NV AALB NL0000852564 XAMS €36.82
ABN AMRO BANK N.V. ABN NL0011540547 XAMS €14.505
ACCSYS AXS GB00BQQFX454 XAMS €0.63
ACOMO ACOMO NL0000313286 XAMS €17.88
ADUX ADUX FR0012821890 XPAR, XAMS €1.32
ADYEN ADYEN NL0012969182 XAMS €1 
# For Brussels Stock
b_result_df <- EN_Stocks_List("B")[,c(2:6)]
tail(b_result_df)
Name Ticker Code_ISIN Market Last_price
137 WDP WDP BE0974349814 XBRU, XAMS €25.38
138 WERELDHAVE BELGIUM WEHB BE0003724383 XBRU €47.50
139 WHAT WHATS BE0003573814 XBRU €59.00
140 WHITESTONE GROUP ROCK BE0974401334 ALXB €11.50
141 XIOR XIOR BE0974288202 XBRU €25.95
142 ZENOBE GRAMME CERT ZEN BE0003809267 XBRU €180.00 
# For Paris Stock
p_result_df <- EN_Stocks_List("P")[,c(2:6)]
head(p_result_df)
Name Ticker Code_ISIN Market Last_price
1000MERCIS ALMIL FR0010285965 ALXP €25.60
2CRSI AL2SI FR0013341781 ALXP €4.28
A.S.T. GROUPE ALAST FR0000076887 ALXP €0.864
AB SCIENCE AB FR0010557264 XPAR €3.30
ABC ARBITRAGE ABCA FR0004040608 XPAR €3.72
ABEO ABEO FR0013185857 XPAR €13.70 
# For Lisbon Stock
l_result_df <- EN_Stocks_List("L")[,c(2:6)]  
head(l_result_df)
Name Ticker Code_ISIN Market Last_price
AGUAS DA CURIA CUR PTCUR0AP0000 ENXL €1.17
ALTRI SGPS ALTR PTALT0AE0002 XLIS €4.51
ATRIUM BIRE SIGI MLATR PTTBI0AM0006 ENXL NANA
B.COM.PORTUGUES BCP PTBCP0AM0015 XLIS €0.275
BENFICA SLBEN PTSLB0AM0010 XLIS €2.82
COFINA,SGPS CFN PTCFN0AE0003 XLIS €0.422 
# For Milan Stock
m_result_df <- EN_Stocks_List("M")[,c(2:6)]  # For Milan Stock
tail(m_result_df)
Name Ticker Code_ISIN Market Last_price
1905 ZOETIS 4ZTS US98978V1035 ETLX €175.85
1906 ZOETIS 2ZTS US98978V1035 MTAH €174.50
1907 ZOOM VIDEO COMM 4ZM US98980L1017 ETLX €59.43
1908 ZOOM VIDEO COMM 1ZM US98980L1017 BGEM €58.78
1909 ZOOM VIDEO COMM 2ZM US98980L1017 MTAH €64.31
1910 ZUCCHI ZUC IT0005395071 MTAA €2.04 
# For Dublin Stock
d_result_df <- EN_Stocks_List("D")[,c(2:6)]  
tail(d_result_df)
Name Ticker Code_ISIN Market Last_price
28 ORIGIN ENT. PLC OIZ IE00B1WV4493 XESM €3.30
29 OVOCA BIO PLC OVXA IE00B4XVDC01 XESM €0.0145
30 PERM. TSB GP. HOLD PTSB IE00BWB8X525 XMSM €1.59
31 RYANAIR HOLD. PLC RYA IE00BYTBXV33 XMSM €20.23
32 SMURFIT KAPPA GP SK3 IE00B1RR8406 XMSM €37.97
33 UNIPHAR PLC UPR IE00BJ5FQX74 XESM €2.90 
# For Oslo Stock
o_result_df <- EN_Stocks_List("O")[,c(2:6)]
head(o_result_df, 10)
Name Ticker Code_ISIN Market Last_price
AALBERTS NV AALB NL0000852564 XAMS €36.82
ABN AMRO BANK N.V. ABN NL0011540547 XAMS €14.505
ACCSYS AXS GB00BQQFX454 XAMS €0.63
ACOMO ACOMO NL0000313286 XAMS €17.88
ADUX ADUX FR0012821890 XPAR, XAMS €1.32
ADYEN ADYEN NL0012969182 XAMS €1

Example 2.b : Euronext Paris ticker ISIN

# Retrieve the ISIN for a company with ticker "abca"
EN_P_Ticker_adn("abca")
#> [1] "FR0004040608-XPAR"

# Example result for a valid ticker "AAA"
result <- EN_P_Ticker_adn("AAA")
print(result)
#> [1] "FR0000062465-XPAR"

# Example for a non-existing ticker "afsf"
print(EN_P_Ticker_adn("afsf"))  # Ticker is not existing
#> [1] "Ticker not found"

Example 2.c : Show in detail Paris Euronext Stocks

EN_Indices_List() function

It receives no argument and retrieves information about all indices available on Euronext.

Example 3 : Get the list of Euronext Indexes

# Get list of Indices available on Euronext
all_indices = EN_Indices_List()
dim(all_indices)
tail(all_indices)
#> [1] 1311    8
Name Isin Symbol Last Percentage change (in %) Date_Time YTD% Ticker_adn
SBF Top 50 ESG EW GR FR0013371432 ESF5G €1265.31 +0.36% 21 Feb 2024 +0.29% FR0013371432-ESF5G
SBF Top 50 ESG EW NR FR0013371424 ESF5N €1205.78 +0.35% 21 Feb 2024 +0.24% FR0013371424-ESF5N
SBF Top 80 EW FR0013017936 SBF80 €1257.48 +0.23% 21 Feb 2024 +0.43% FR0013017936-SBF80
SBF Top 80 EW Decrement 50 Points FR0013017969 SBF8D €1009.23 +0.22% 21 Feb 2024 -0.19% FR0013017969-SBF8D
SBF Top 80 EW GR FR0013017951 SBF8G €1601.48 +0.23% 21 Feb 2024 +0.55% FR0013017951-SBF8G
SBF Top 80 EW NR FR0013017944 SBF8N €1498.57 +0.23% 21 Feb 2024 +0.52% FR0013017944-SBF8N

EN_Etfs_List() and EN_Etfs_List_bis functions

EN_Etfs_List receives as input tot_page which is the total number of pages to retrieve. In contrast, EN_Etfs_List_bis receives as input target_page which represents the target page. For example, the function EN_Etfs_List_bis(5), retrieves only the fifth page of the Etfs list, allowing more granular control of the data retrieval process (ordered list of 100 Etfs), whereas EN_Etfs_List(5) would return an ordered list of 500 Etfs listed on Euronext (on each page there are 100 Etfs, so for 5 pages 5*100 = 500).

Example 4 : Get the list of ETFs quoted on Euronext markets

# Get 1st 500 Etfs in alphabetic order
dt_ <- EN_Etfs_List()
tail(dt_[, c(2:9)])

# The number of columns and rows
dim(dt_)
Name Ticker Code_ISIN Market Bid Ask Last_price Percentage_change
495 AMUNDI TPX GBP HD TPHG LU1681038086 XPAR
NA107.4884 0.28
496 AMUNDI TPX USD HD TPHU LU1681037948 XPAR
$119.1413 0.41
497 AMUNDI UK Gov Infl GILI LU1407893301 XPAR
€160.61 -0.56
498 AMUNDI US CORP SRI UCRP LU1806495575 XPAR 55.88 55.993 $56.091 -0.06
499 AMUNDI US MIN VO MIVU LU1589349734 XPAR 81.50 NA €82.984 -0.22
500 AMUNDI US MIN VO MIVU LU1589349734 XAMS
$89.71 -0.31 
#> [1] 500  11
# By default, EN_Etfs_List_bis() returns the list of 100 Etfs in alphabetic order
dt_1 <- EN_Etfs_List_bis()  
# The number of columns and rows
dim(dt_1)
# Head
dt_1.h <- head(dt_1[, c(2:9)])

#> [1] 100  11
Name Ticker Code_ISIN Market Bid Ask Last_price Percentage_change
$Asia IG Corp US A ASIG IE0007G78AC4 XAMS 4.775 NA $4.8231 0.08
-1X SHORT DIS SDIS XS2337085422 XAMS
€6.0208 1.30
-1X SHORT PLTR SPLR XS2337086669 XAMS
€1.3595 0.82
-1X SHORT PLUG SPLU XS2336362079 XAMS
€4.6115 2.00
-3X ARK INNOVATION SARKK XS2399368906 XAMS 0.515 0.679 €0.5799 7.19
-3x China Tech SKWE XS2399370126 XAMS
€0.2581 -1.90

EN_Bonds_List() and EN_Bonds_List_bis functions

EN_Bonds_List receives as input tot_page which is the total number of pages to retrieve. In contrast, EN_Bonds_List_bis receives as input target_page which represents the target page. For example, the function EN_Bonds_List_bis(5), retrieves only the fifth page of the Bonds list, allowing more granular control of the data retrieval process (ordered list of 100 Bonds), whereas EN_Bonds_List(5) would return an ordered list of 500 Bonds listed on Euronext (on each page there are 100 Bonds, so for 5 pages 5*100 = 500).

Example 5 : Get the list of Bonds quoted on Euronext markets

# Get 1st 500 Bonds in alphabetic order
dt_b <- EN_Bonds_List()
head(dt_b[, c(2:9)])

tail(dt_b[, c(2:9)])
Name Issuer Code_ISIN Market Maturity Coupon Last_price Percentage change
2019 PB RMBS TV EU 2019 POPOLARE BARI RMBS IT0005386724 XMOT 2069-05-31 0.0%
2019 PB RMBS TV EU 2019 POPOLARE BARI RMBS IT0005386724 XMOT 2069-05-31 0.0%
2019 PB RMBS TV EU 2019 POPOLARE BARI RMBS IT0005386724 XMOT 2069-05-31 0.0%
2I RETE GAS TF 2,1 2I RETE GAS IT0005386724 XMOT 2025-09-11 0.0%
2IRG 1.608% CALL 3 2I RETE GAS IT0005386724 ETLX 2027-10-31 0.0% 93.65 -0.62%
2IRG 1.75% CALL 28 2I RETE GAS IT0005386724 ETLX 2026-08-28 0.0%
Name Issuer Code_ISIN Market Maturity Coupon Last_price Percentage change
495 ALLIAN3.25%13JUN28 ALLIANDER N.V. NO0012698341 XAMS 2028-06-13 3.25%
496 ALLIANDER1.625%PL ALLIANDER N.V. NO0012698341 XAMS
1.625%
497 ALLY FINANCIAL 8% ALLY FINANCIAL INC NO0012698341 ETLX 2031-11-01 0.0% 110.49 0.91%
498 ALPERIA GREEN TF 5 Alperia S.p.A NO0012698341 ETLX 2028-07-05 0.0% 99.85 0.14%
499 ALPHATHAI8%28JAN25 ALPHA THAI BENELUX SA NO0012698341 VPXB 2025-01-28 8.0%
500 ALSTO0.125%27JUL27 ALSTOM NO0012698341 XPAR 2027-07-27 0.125% 
dt_b1 <- EN_Bonds_List_bis() #By default returns the list of 100 Bonds in alphabetic order 
head(dt_b1[, c(2:9)])

tail(dt_b1[, c(2:9)])
Name Issuer Code_ISIN Market Maturity Coupon Last_price Percentage change
2019 PB RMBS TV EU 2019 POPOLARE BARI RMBS IT0005386724 XMOT 2069-05-31 0.0%
2019 PB RMBS TV EU 2019 POPOLARE BARI RMBS IT0005386724 XMOT 2069-05-31 0.0%
2019 PB RMBS TV EU 2019 POPOLARE BARI RMBS IT0005386724 XMOT 2069-05-31 0.0%
2I RETE GAS TF 2,1 2I RETE GAS IT0005386724 XMOT 2025-09-11 0.0%
2IRG 1.608% CALL 3 2I RETE GAS IT0005386724 ETLX 2027-10-31 0.0% 93.65 -0.62%
2IRG 1.75% CALL 28 2I RETE GAS IT0005386724 ETLX 2026-08-28 0.0%
Name Issuer Code_ISIN Market Maturity Coupon Last_price Percentage change
95 AAB1.95%7DEC2048 ABN AMRO BANK N.V. IT0005386724 XAMS 2048-12-07 1.95%
96 AAB2.29%29JUL30 ABN AMRO BANK N.V. IT0005386724 XAMS 2030-07-29 2.29%
97 AAB2.375%1JUN2027 ABN AMRO BANK N.V. IT0005386724 XAMS 2027-06-01 2.375%
98 AAB2.47%13DEC29 ABN AMRO BANK N.V. IT0005386724 XAMS 2029-12-13 2.47%
99 AAB2.47%13DEC29RS ABN AMRO BANK N.V. IT0005386724 XAMS 2029-12-13 2.47%
100 AAB3%1JUN2032 ABN AMRO BANK N.V. IT0005386724 XAMS 2032-06-01 3.0%

EN_GetISIN() function

The function takes a single parameter, ‘ticker,’ which can be the symbol, name, or ISIN of a given stock or index, and then returns its DNA.

Example 6.a : Get DNA (ISIN-Market identifier) of a given Stock or Index listed on Euronext by providing the Symbol or Name, or ISIN of a Stock or an Index.

To efficiently use the ‘Euronext’ package, it is important to understand how to handle Ticker Names, ISIN, and DNA, as many functions in the package rely on these. Note: There is a small difference between ISIN and DNA. Here’s a simple example: the ticker “4DDD” has the ISIN “US88554D2053,” and its DNA is “US88554D2053-ETLX.” As you can see, the DNA is composed of the ISIN and the market identifier “ETLX,” preceded by “-”.

Please refer to the respective functions EN_Stocks_List(), EN_Indices_List(), EN_Etfs_List() or EN_Etfs_List_bis(), EN_Funds_List(), and EN_Bonds_List() or EN_Bonds_List_bis() if you wish to obtain a list of available Stocks, Indices, ETFs, Funds, and Bonds on Euronext.

# Get DNA of ticker "4DDD"
EN_GetISIN("4DDD")
#> [1] "US88554D2053-ETLX"

# Get DNA for the ticker name "ADS MARITIME HOLD"
EN_GetISIN("ADS MARITIME HOLD")
#> [1] "CY0108052115-MERK"

# Get DNA for ATENOR company by providing its ISIN
EN_GetISIN("BE0003837540")
#> [1] "BE0003837540-XBRU"

EN_GetISIN_F() function

Example 6.b : Get DNA (ISIN-Market identifier) of a given fund listed on Euronext by providing its symbol, name, or ISIN.

# Get Fund 'ACOMEA GLOBALE' DNA
aco_dna <- EN_GetISIN_F("ACOMEA GLOBALE")

# In case you want the ISI only
sub("-.*", "", aco_dna) #To get only the ISIN
#> [1] "IT0005091100"

# Get Fund 'ASNU SMALL MIDCAPF' DNA
asnu_dna <- EN_GetISIN_F("ASN5")
print(asnu_dna)
#> [1] "NL0014270217-XAMS"

# Get Fund 'COMPAM ACTIVE GLOB' DNA
EN_GetISIN_F("LU1275425897")
#> [1] "LU1275425897-ATFX"

EN_GetISIN_Etf() function

Example 6.c : Get DNA (ISIN-Market identifier) of a given ETF listed on Euronext by providing its Symbol or Name, or ISIN of a Stock or an Index.

# Get ETF 'AAPL' DNA
EN_GetISIN_Etf("AAPL")
#> [1] "XS2337099563-XAMS"

# Get ETF '-1X SHORT DIS' DNA
EN_GetISIN_Etf("-1X SHORT DIS")
#> [1] "XS2337085422-XAMS"

# Get ETF '3x Long Coinbase' DNA
EN_GetISIN_Etf("XS2399367254")
#> [1] "XS2399367254-XAMS"

EN_GetISIN_B() function

Example 6.d : Get DNA (ISIN-Market identifier) of a given Bond listed on Euronext by providing its Symbol or Name, or ISIN of a Stock or an Index.

#To get only the DNA of all same bonds issued
the_dna1 <- EN_GetISIN_B("ABN AMRO BANK N.V.")
print(the_dna1)
#> [1] "XS1344751968-XAMS"

the_isin1 <- sub("-.*", "", the_dna1) #To get only the ISINs
print(the_isin1)
#> [1] "XS1344751968"

#To get only the DNA of Bond 'A2A GREEN BOND TF'
the_dna2 = EN_GetISIN_B("A2A GREEN BOND TF")
the_isin2 =sub("-.*", "", the_dna2) #To get only the ISIN
print(the_isin2)
#> [1] "XS2403533263"

EN_Ticker_Performance() function

This function retrieves the historical performance data of a company listed on the Euronext exchange based on its ticker symbol. It returns a table with details such as the highest and lowest stock prices, date of the highest and lowest prices, and other relevant information. It receives three (3) parameters such us : * ‘ticker’ : A character string representing the company’s ticker symbol, * ‘stock_type’ : The type of the ticker: ‘Eq_Ind’ for Stocks and Indexes, ‘Fund’ or “F” for Fund tickers, ‘Bond’ or “B” for Bond tickers, and ‘Etfs’ or “E” for EFTs. * ‘escape’ : Boolean, either TRUE or FALSE. If escape is True, it means you’re providing the DNA (ISIN-Market identifier) directly. Giving T to escape is helpful to avoid time-consuming operations; otherwise, F means you need to provide the Ticker symbol, name, or ISIN and the type of market to which it belongs. By default, escape = ‘FALSE’

Example 7 : Retrieve historical performance

# Get Performance of Ticker ABCA
dt = EN_Ticker_Performance("ABCA")
print(dt)
D-1 1W 1M 3M 6M YTD 52W 2Y 3Y 5Y MAX
Highest 3.985 4.05 4.62 5.12 6.12 4.87 6.58 7.78 8.15 8.15 14.85
Date of the highest 20/02/2024 - 14:20 16/02/2024 23/01/2024 29/11/2023 01/09/2023 09/01/2024 22/02/2023 19/04/2022 22/03/2021 22/03/2021 25/02/2000
Lowest 3.90 3.72 3.72 3.72 3.72 3.72 3.72 3.72 3.72 3.72 1.50
Date of the lowest 20/02/2024 - 09:07 21/02/2024 21/02/2024 21/02/2024 21/02/2024 21/02/2024 21/02/2024 21/02/2024 21/02/2024 21/02/2024 11/10/2002
% 0.25 -5.34 -18.33 -24.92 -38.21 -22.58 -43.47 -47.61 -49.93 -39.31 -61.65
Change 0.01 -0.21 -0.835 -1.235 -2.30 -1.085 -2.86 -3.38 -3.71 -2.41 -5.98
Turnover 219177.25 2079382.72 7733642.74 14.199M 23.911M 10.272M 48.792M 105.273M 182.531M 313.910M 1.372B
Volume 55681 712773 2046139 3378793 5193659 2584397 9290122 17.422M 28.113M 47.916M 82.248B
Avg Vol 55681 118796 85256 51981 39646 68010 36148 33829 36322 37318 12.677M
Avg Price 3.94 2.92 3.78 4.20 4.60 3.97 5.25 6.04 6.49 6.55 0.02
Nb days 1 6 24 65 131 38 257 515 774 1284 6488 
# Get Performance of ETF AAPL
dt_ = EN_Ticker_Performance("AAPL", stock_type = "E")
print(dt_)
D-1 1W 1M 3M 6M YTD 52W 2Y 3Y 5Y MAX
Highest 6.680 6.790 7.241 7.271 7.271 7.241 7.271 7.271 7.271 7.271 7.271
Date of the highest 20/02/2024 - 09:04 16/02/2024 06/02/2024 15/12/2023 15/12/2023 06/02/2024 15/12/2023 15/12/2023 15/12/2023 15/12/2023 15/12/2023
Lowest 6.622 6.527 6.527 6.527 6.281 6.527 5.35 4.700 4.030 4.030 4.030
Date of the lowest 20/02/2024 - 16:04 19/02/2024 19/02/2024 19/02/2024 27/10/2023 19/02/2024 02/03/2023 06/01/2023 07/06/2021 07/06/2021 07/06/2021
% -0.76 -1.48 -3.34 -3.01 5.50 -3.49 19.14 17.07 63.53 63.53 63.53
Change -0.051 -0.101 -0.231 -0.207 0.348 -0.242 1.074 0.975 2.596 2.596 2.596
Turnover 662.19 2347.68 27036.00 29614.39 59111.43 29427.29 135854.86 371444.61 448700.84 448700.84 448700.84
Volume 100 350 3903 4285 8712 4259 21989 66158 80850 80850 80850
Avg Vol 100 58 163 67 67 112 86 129 105 63 12
Avg Price 6.62 6.71 6.93 6.91 6.79 6.91 6.18 5.61 5.55 5.55 5.55
Nb days 1 6 24 64 130 38 256 514 773 1283 6487 
# Get Performance of Bond issued by A2A S.p.A.
dt1 = EN_Ticker_Performance("XS1195347478-ETLX", escape = TRUE)
print(dt1)
D-1 1W 1M 3M 6M YTD 52W 2Y 3Y 5Y MAX
Highest 98.20 99.25 99.25 99.25 99.25 99.25 99.25 99.28 102.85 107.14 108.98
Date of the highest 02/01/2024 - 09:32 11/01/2024 11/01/2024 11/01/2024 11/01/2024 11/01/2024 11/01/2024 09/08/2022 03/02/2022 11/09/2019 14/07/2016
Lowest 98.20 98.45 98.45 97.21 97.02 98.20 96.30 95.38 95.38 95.38 94.28
Date of the lowest 02/01/2024 - 09:32 11/01/2024 11/01/2024 22/11/2023 06/11/2023 02/01/2024 24/02/2023 20/10/2022 20/10/2022 20/10/2022 24/06/2015
% -0.06 0.05 0.16 0.97 1.73 0.18 2.48 -4.33 -7.67 -4.25 -2.87
Change -0.06 0.05 0.16 0.95 1.67 0.18 2.38 -4.45 -8.18 -4.37 -2.91
Turnover 98200.00
590560.00 883180.00 394800.00 2934650.00 6824010.00 7029220.00 8402410.00 18.669M
Volume 100000 300000 300000 900000 1200000 700000 3300000 7300000 7500000 8800000 19.000M
Avg Vol 100000 50000 12500 13636 9091 18421 12644 13985 9579 6748 2898
Avg Price 0.01
0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01
Nb days 1 6 24 66 132 38 261 522 783 1304 6557 
# Get Performance of ACOMEA EMERGING Q2 Fund
dt2 = EN_Ticker_Performance("IT0005091126", 'F', escape = FALSE)
print(dt2)
D-1 1W 1M 3M 6M YTD 52W 2Y 3Y 5Y MAX
Highest 9.955 10.005 10.005 10.005 10.005 10.005 10.679 10.847 12.185 12.185 12.185
Date of the highest 07/12/2023 - 15:00 19/02/2024 19/02/2024 19/02/2024 19/02/2024 19/02/2024 06/07/2023 01/06/2022 12/11/2021 12/11/2021 12/11/2021
Lowest 9.955 10.005 10.005 9.955 9.955 10.005 1.00 1.00 1.00 1.00 1.00
Date of the lowest 07/12/2023 - 15:00 19/02/2024 19/02/2024 07/12/2023 07/12/2023 19/02/2024 24/03/2023 24/03/2023 24/03/2023 24/03/2023 24/03/2023
% -0.64 0.00 0.00 0.00 0.00 0.00 -4.63 -15.66 -7.74 25.39 28.07
Change -0.064 0.00 0.00 0.00 0.00 0.00 -0.486 -1.861 -0.841 2.029 2.196
Turnover 447.98 40.02 40.02 488.00 488.00 40.02 7468.06 291474.83 327164.50 781608.81 1027828.18
Volume 45 8 8 53 53 8 713 26904 30012 86031 118239
Avg Vol 45 1 0 1 0 0 3 53 39 67 18
Avg Price 9.96 5.00 5.00 9.21 9.21 5.00 10.47 10.83 10.90 9.09 8.69
Nb days 1 6 24 64 130 38 255 512 769 1275 6500 
# Get Performance of AEX All-Share Index
dt3 = EN_Ticker_Performance("AEX All-Share Index GR", escape = FALSE)
print(dt3)
D-1 1W 1M 3M 6M YTD 52W 2Y 3Y 5Y MAX
Highest 4,534.94 4,552.25 4,553.63 4,553.63 4,553.63 4,553.63 4,553.63 4,553.63 4,553.63 4,553.63 4,553.63
Date of the highest 20/02/2024 - 09:00 16/02/2024 12/02/2024 12/02/2024 12/02/2024 12/02/2024 12/02/2024 12/02/2024 12/02/2024 12/02/2024 12/02/2024
Lowest 4,479.12 4,464.25 4,128.31 3,993.51 3,719.88 4,053.49 3,696.85 3,164.52 3,164.52 2,001.91 1,271.98
Date of the lowest 20/02/2024 - 15:45 21/02/2024 22/01/2024 22/11/2023 23/10/2023 17/01/2024 20/03/2023 13/10/2022 13/10/2022 16/03/2020 04/06/2012
% -1.04 0.08 8.60 12.19 16.05 7.21 13.40 21.26 24.48 61.58 244.77
Change -47.28 3.43 354.98 486.85 619.90 301.39 529.58 785.72 881.44 1,708.16 3,182.08
Turnover
Volume
Avg Vol
Nb days 1 6 24 64 130 38 256 514 773 1283 6487

EN_Overview_plot() function

As its name suggests, this function retrieves data from the ticker(s) and displays it in graphical form. It offers a convenient method to obtain a quick overview of price trends, facilitating further analysis.

This function accepts up to seven arguments:

  • ticker: is the name of the ticker(s)
  • from: A quotation start date, i.e. “2020-01-01” or “2020/01/01”. The date must be in ymd format “YYYY-MM-DD” or “YYYY/MM/DD”.
  • until : A quoted end date, i.e. “2022-01-31” or “2022/01/31”. The date must be in ymd format “YYYY-MM-DD” or “YYYY/MM/DD”.
  • ‘stock_type’: Ticker type: ‘Eq_Ind’ for stocks and indices, ‘Fund’ or “F” for fund tickers, ‘Bond’ or “B” for bond tickers, and ‘Etfs’ or “E” for EFTs.
  • escape’: Boolean, either TRUE or FALSE. If escape is True, this means you’re supplying the ISIN-Market identifier (ADN) directly. Giving T to escape is useful to avoid tedious operations; otherwise, F means you must provide the Ticker symbol, the name or ISIN and the type of market to which it belongs. By default, escape = ‘FALSE’.
  • up.col : is the color of the rise
  • down.col : is the color of the fall
# The default colors for the up and down are 'darkgreen' and 'red', respectively.
chart <- EN_Overview_plot("4ddd")  

chart
ov_plot  <- EN_Overview_plot(c("NL0010614533", "QS0011211206", "QS0011095914", "QS0011146899"), up.col = "blue")

ov_plot
Overview of price evolution and last price

Ticker

Last Price

Price evolution

AEX2S

4.526

AEXEN

4,965.720

AEXSH

113.487

ATAWN

3,139.980

EN_plot() function

This EN_plot() function is distinct from the EN_Overview_plot() function, although they share similar parameters (ticker, from, to, stock_type, escape, up.col, down.col) Note: Important to note that when using EN_plot(),only historical data from the past two years is available. This differs from EN_Overview_plot(), where data is available from the inception year of the company’s listing.

Example 8 : Get historical performance

#It is also possible to plot stock data chart for more than one ticker
#Let's plot '3D SYSTEMS CORP' chart

chart1 <- EN_plot("AAX")

chart1
# You can change up and down colors # Etf AAPL # EN_plot("aapl", stock_type = 'E', up.col = "blue", down.col = "pink") 
# It is also possible to plot stock data chart for more than one ticker
# Let's plot some equities chart

chart2 <- EN_plot(c("AAX", "QS0011016480", "AEX2S", "ADIDAS", "ADOBE", "ALFEN BEHEER", "1GOOGL"))

chart2
# It is also possible to plot stock data chart for more than one ticker
# Let's plot three ETFs chart

chart3 <- EN_plot(c("IE0007G78AC4", "MANA", "3TSM"), stock_type = 'E')

chart3

EN_Ticker_infos() function

This function retrieves detailed information for a given stock ticker on the Euronext exchange. It includes information such as currency, last traded price, valuation close, volume, turnover, transactions, VWAP (Volume Weighted Average Price), open, high, low, threshold, previous close, 52-week range, and market capitalization. The data is returned as a data frame.

Inputs : - ticker A character string representing the company’s ticker, name, or ISIN. - stock_type The type of the ticker: ‘Eq_Ind’ for Stocks and Indexes, ‘Fund’ or “F” for Fund tickers,‘Bond’ or “B” for Bond tickers, and ‘Etfs’ or “E” for EFTs. - escape Boolean, either TRUE or FALSE. If escape is True, it means you’re providing the DNA (ISIN-Market identifier) directly. Giving T to escape is helpful to avoid time-consuming operations; otherwise, F means you need to provide the Ticker symbol, name, or ISIN and the type of market to which it belongs.

Example 9.a : Get Information for an Equity

# Retrieve news for the equity "AALBERTS N.V." using its DNA
equity_infos <- EN_Ticker_infos("NL0000852564-XAMS", escape = TRUE)
print(equity_infos)
Information Detail Update date/Time
Currency EUR
Last Traded 36.82 [21/02/2024 17:35]
Valuation Close 36.82 [21/02/2024]
Volume 143,154 [21/02/2024 17:35]
Turnover 5,271,059
Transactions 1,111
VWAP 36.8209
Open 36.96
High 37.13 [09:02]
Low 36.60 [09:43]
Threshold 40.50 - 33.14 [22/02/2024 07:30]
Previous Close 36.85 [20/02/2024]
52 Week 28.83 - 48.53
Market Cap 4.072B

Example 9.b : Get Information for an Index

# Retrieve news for the index "AEX All-Share Index GR" using its symbol
index_infos <- EN_Ticker_infos("QS0011224977-XAMS", escape = TRUE)
print(index_infos)
Information Detail Update date/Time
Open 4,487.46
High 4,493.99 [09:00]
Low 4,464.25 [16:31]
Previous Close 4,487.43 [20/02/2024]
52 Week 3,696.85 - 4,553.63

Example 9.c : Get Information for a Bond

# Retrieve news for the bond "AAB0.45%12DEC2036" using its DNA
bond_infos <- EN_Ticker_infos("XS2093705064-XAMS", escape = TRUE)
print(bond_infos)
Information Detail Update date/Time
Currency %
Last Traded
Valuation Close 100.00 [21/02/2024]
Open
High
Low
Threshold 103.00 - 97.00 [03/04/2023 03:01]
Previous Close
52 Week 
  • - </td>

EN_intraday_Data() function

The EN_intraday_Data() function fetches intraday price data for a specified stock on Euronext. It allows you to retrieve either today’s intraday prices or the previous day’s intraday prices, with “Today” being the default option. The function returns a data frame containing the intraday stock information.

Inputs : - ticker: A character string representing the stock ticker or name. - day_type : A character string specifying the type of intraday price to fetch. Options are “Today” or “Previous” day. Default is “Today.” You can also use ‘T’ for ‘Today’ or ‘P’ for ‘Previous’. - stock_type : The type of the ticker, which can be ‘Eq_Ind’ for Stocks and Indexes, ‘Fund’ or “F” for Fund tickers, ‘Bond’ or “B” for Bond tickers, and ‘Etfs’ or “E” for ETFs. escape: A Boolean value (either TRUE or FALSE). If escape is set to True, it indicates that the DNA (ISIN-Market identifier) is provided directly. Using True for escape can help avoid time-consuming operations. If escape is set to False, the function expects the Ticker symbol, name, or ISIN, along with the type of market to which it belongs. - nbitems: An integer specifying the number of items to fetch. Default is 30 (also the maximum).

Example 10.a : Get recent intraday prices for an Equity

# Get recent intraday prices of ABCA share for 10 items
intra_ = EN_intraday_Data("ABCA", day_type = 'T', nbitems = 10)
print(intra_)
Tradeid Time Price Volume Type
1OK98KQ84 17:35:16 3.72 500 Trading at last
1OK98KQ83 17:35:16 3.72 249 Trading at last
1OK98KQ82 17:35:16 3.72 1 Auction
1OK98KQ81 17:35:16 3.72 150 Auction
1OK98KQ80 17:35:16 3.72 95 Auction
1OK98KQ7Z 17:35:16 3.72 268 Auction
1OK98KQ7Y 17:35:16 3.72 25 Auction
1OK98KQ7X 17:35:16 3.72 221 Auction
1OK98KQ7W 17:35:16 3.72 163 Auction
1OK98KQ7V 17:35:16 3.72 227 Auction

Example 10.b : Get recent intraday prices of ACOMEA EMERGING Q2 Fund

intra_1 = EN_intraday_Data("IT0005091126", 'F', escape = FALSE, day_type = 'T')
print(intra_1)
Tradeid Time Price Volume Type
5FC6JN8N 15:00:38 10.005 4 OffBook On Exchange

Example 10.c : Get Previous intraday prices of ETF AAPL by providing directly the ISIN-Market identifier

intra_2 = EN_intraday_Data("XS2337099563-XAMS", escape = TRUE, day_type = 'Previous')
print(intra_2)
Tradeid Time Price Volume Type
09:04:20 6.6587 1 Valuation Trade

Example 10.d : Get Previous intraday prices of AEX All-Share Index

intra_3 = EN_intraday_Data("AEX All-Share Index GR", day_type = 'P')
print(intra_3)
Tradeid Time Price Volume Type
18:05:03 4,482.11
Closing Reference index
18:00:01 4,482.11
Closing Reference index
18:00:00 4,482.07
Real-time index
17:53:45 4,482.08
Real-time index
17:53:30 4,482.07
Real-time index
17:52:15 4,482.08
Real-time index
17:52:00 4,482.07
Real-time index
17:51:00 4,482.08
Real-time index
17:50:45 4,482.07
Real-time index
17:49:45 4,482.08
Real-time index

En_Market.Sumarry() function

The En_Market.Sumarry() function retrieve from Euronext the summaries of a giving Stock Market.

Input : - stock_choice: A character string specifying the market of interest. Available options include “a” or “amsterdam” for Amsterdam, “b” or “brussels” for Brussels, “d” or “dublin” for Dublin, “l” or “lisbon” for Lisbon, “m” or “milan” for Milan, “p” or “paris” for Paris, and “o” or “oslo” for Oslo.

Return Value : A list containing summary data for the selected market, including information on stock indices and currency rates. The list includes the following components: * Indices_summary: A data frame summarizing stock market indices for the selected market. It includes columns for the index name, last price, and percentage change. If the summary is not available, this component will be set to NA.

  • EU_indices: A data frame summarizing EURONEXT indices for the selected market. It includes columns for the instrument name, last price, and percentage change. If the summary is not available, this component will be set to NA.

  • Currency_rate: A data frame summarizing currency exchange rates for the selected market. It includes columns for the instrument name, last price, and percentage change. If the summary is not available, this component will be set to NA.

Example 11 : Retrieve Stocks Summary data

# Retrieve summary data for 'Paris stock'
En_Market.Sumarry("p")

#> [1] "Summary data for 'Amsterdam stock indices'"
Index Last price Change (%)
CAC 40 7812.09 0.22
CAC ALL SHARES 9491.97 0.21
CAC NEXT 20 10998.09 0.49
CAC SMALL 11576.84 -0.51
SBF 120 5906.90 0.22 
#> [1] "Summary data for 'EURONEXT indices'"
Instrument name Last price Day change relative (%)
EURONEXT 100 1445.06 0.23
CLIMATE EUROPE 1858.95 -0.31
LOW CARBON 100 159.58 -0.23
NEXT BIOTECH 2265.23 0.23
ESG 80 2006.55 0.08 
#> [1] "Summary data for 'Currency rate'"
Instrument name Last price Day change relative (%)
EUR / USD 1.08362 0.15
EUR / GBP 0.85678 0.07
EUR / JPY 162.84100 0.12
EUR / CHF 0.95125 -0.05
GBP / USD 1.26477 0.08

EN_Get_OB() function :

Purpose : Retrieves order book data for a given stock or ETF ticker on the Euronext exchange.

Inputs: • ticker: A character string representing the company’s (equity or ETF) ticker, name, or ISIN. • stock_type: The type of the ticker. It can be ‘Equity’ for stocks or ‘Etf’ for ETFs.

Output : Returns a data frame containing order book data with columns representing buy (bid) and sell (ask) orders, including order quantity and price.

Example 12 : Get order book data

# Get order book data for ABC ARBITRAGE ticker
ABCA_OB <- EN_Get_OB("ABCA")
print(ABCA_OB)
B_order B_quantity Bid_Price Ask_Price A_quantity A_order
4 742 NA NA 3004 8
1 23 4.35 3.7 768 1
1 400 4 3.72 20000 1
4 1508 3.8 3.75 203 1
3 189 3.75 3.81 20000 1
3 664 3.74 3.85 5000 1
1 1500 3.73 3.86 129 1
3 102 3.72 3.88 500 1
3 140 3.715 3.9 6179 4
4 2077 3.71 3.92 127 1
27 7345
55910 20 
# Get order book data for MSFT ETF
MSFT_OB <- EN_Get_OB("MSFT", stock_type = 'Etf')
print(MSFT_OB)
B_order B_quantity Bid_Price Ask_Price A_quantity A_order
1 1 5 NA NA NA
1 1
0 0

EN_OrderBook.Chart() function

Purpose : Retrieves order book data from Euronext for a given stock or ETF ticker and plots its chart. Inputs : - ticker: The ticker symbol for which the order book chart will be plotted. - bid.col: Color for bid prices in the chart. Default is ‘#00FF00’ (green). - ask.col: Color for ask prices in the chart. Default is ‘#FF0000’ (red). - plot_type: Type of visualization (‘depth’ or ‘barh’). Default is ‘depth’ - stock_type: The type of the ticker. It can be ‘Equity’ for stocks or ‘Etf’ for ETFs.

Output : Returns a Highchart plot displaying the order book for the provided ticker.

Example 13 : Plot Order Book chart

# Plot order book chart for ABC ARBITRAGE ticker using default colors
ABCA_OB_chart <- EN_OrderBook.Chart("FR0004040608", plot_type = 'barh')

ABCA_OB_chart
# Plot order book Market Depth chart for LEBON ticker with default colors ie "darkgreen" and "red"

# In case you want to change colors 
# ALBON_OB_chart <- EN_OrderBook.Chart("ALBON", bid.col = 'cyan', ask.col ='gold')

ALBON_OB_chart <- EN_OrderBook.Chart("ALBON") #Using default parameters
ALBON_OB_chart

Authors :
* Koffi Frederic Sessie ()

Creator : Koffi Frederic Sessie
cph (Copyright Holder) : Koffi Frederic Sessie

License : MIT 2024, Koffi Frederic SESSIE. All rights reserved.