Library Euronext

Koffi Frederic SESSIE

19 février,2024

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 37.11
Date of last update 19/02/2024 - 09:06 CET
Since Open -0.04 (-0.11%)
Since Previous Close -0.14 (-0.38%)

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,525.27
Date of last update 19/02/2024 - 09:07 CET
Since Open -26.75 (-0.59%)
Since Previous Close -26.97 (-0.59%)

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 €37.11
ABN AMRO BANK N.V. ABN NL0011540547 XAMS €15.015
ACCSYS AXS GB00BQQFX454 XAMS €0.647
ACOMO ACOMO NL0000313286 XAMS €18.26
ADUX ADUX FR0012821890 XPAR, XAMS €1.33
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.74
138 WERELDHAVE BELGIUM WEHB BE0003724383 XBRU €47.70
139 WHAT WHATS BE0003573814 XBRU €58.60
140 WHITESTONE GROUP ROCK BE0974401334 ALXB €11.50
141 XIOR XIOR BE0974288202 XBRU €26.65
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 €26.80
2CRSI AL2SI FR0013341781 ALXP €4.98
A.S.T. GROUPE ALAST FR0000076887 ALXP €0.92
AB SCIENCE AB FR0010557264 XPAR €3.58
ABC ARBITRAGE ABCA FR0004040608 XPAR €4.00
ABEO ABEO FR0013185857 XPAR €13.55
# 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.56
ATRIUM BIRE SIGI MLATR PTTBI0AM0006 ENXL NANA
B.COM.PORTUGUES BCP PTBCP0AM0015 XLIS €0.2675
BENFICA SLBEN PTSLB0AM0010 XLIS €2.82
COFINA,SGPS CFN PTCFN0AE0003 XLIS €0.416
# 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 1ZTS US98978V1035 BGEM €174.40
1906 ZOETIS 2ZTS US98978V1035 MTAH €173.20
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.05
# 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.27
29 OVOCA BIO PLC OVXA IE00B4XVDC01 XESM €0.01
30 PERM. TSB GP. HOLD PTSB IE00BWB8X525 XMSM €1.65
31 RYANAIR HOLD. PLC RYA IE00BYTBXV33 XMSM €20.07
32 SMURFIT KAPPA GP SK3 IE00B1RR8406 XMSM €38.21
33 UNIPHAR PLC UPR IE00BJ5FQX74 XESM €2.885
# 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 €37.11
ABN AMRO BANK N.V. ABN NL0011540547 XAMS €15.015
ACCSYS AXS GB00BQQFX454 XAMS €0.647
ACOMO ACOMO NL0000313286 XAMS €18.26
ADUX ADUX FR0012821890 XPAR, XAMS €1.33
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] 1263    8
Name Isin Symbol Last Percentage change (in %) Date_Time YTD% Ticker_adn
SBF Top 50 ESG EW GR FR0013371432 ESF5G €1269.06 +0.45% 16 Feb 2024 +0.59% FR0013371432-ESF5G
SBF Top 50 ESG EW NR FR0013371424 ESF5N €1209.36 +0.45% 16 Feb 2024 +0.54% FR0013371424-ESF5N
SBF Top 80 EW FR0013017936 SBF80 €1263.47 +0.54% 16 Feb 2024 +0.91% FR0013017936-SBF80
SBF Top 80 EW Decrement 50 Points FR0013017969 SBF8D €1014.72 +0.52% 16 Feb 2024 +0.35% FR0013017969-SBF8D
SBF Top 80 EW GR FR0013017951 SBF8G €1609.10 +0.53% 16 Feb 2024 +1.03% FR0013017951-SBF8G
SBF Top 80 EW NR FR0013017944 SBF8N €1505.70 +0.53% 16 Feb 2024 +0.99% 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 UK Gov Infl GILI LU1407893301 XPAR
€160.79 0.04
496 AMUNDI US CORP SRI UCRP LU1806495575 XPAR 55.75 56.026 $55.888 -0.02
497 AMUNDI US MIN VO MIVU LU1589349734 XPAR 81.50 NA €83.294 -0.36
498 AMUNDI US MIN VO MIVU LU1589349734 XAMS
$89.831 -0.20
499 AMUNDI US STEEPEN STPU LU2018762653 XPAR 86.939 87.126 €87.055 0.03
500 AMUNDI US TIPS UIFL LU1525419294 XPAR 58.072 58.405 $58.218 0.12
#> [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.7767 4.8224 $4.7952 -0.17
-1X SHORT DIS SDIS XS2337085422 XAMS
€5.8883 0.20
-1X SHORT PLTR SPLR XS2337086669 XAMS
€1.2385 -0.67
-1X SHORT PLUG SPLU XS2336362079 XAMS
€4.2378 -1.79
-3X ARK INNOVATION SARKK XS2399368906 XAMS 0.30 0.75 €0.4817 2.77
-3x China Tech SKWE XS2399370126 XAMS
€0.2784 -4.46

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 ALLY FINANCIAL 8% ALLY FINANCIAL INC NO0012698358 ETLX 2031-11-01 0.0% 109.11 -0.06%
496 ALPERIA GREEN TF 5 Alperia S.p.A NO0012698358 ETLX 2028-07-05 0.0% 99.85 0.14%
497 ALPHATHAI8%28JAN25 ALPHA THAI BENELUX SA NO0012698358 VPXB 2025-01-28 8.0%
498 ALSTO0.125%27JUL27 ALSTOM NO0012698358 XPAR 2027-07-27 0.125%
499 ALSTOM0%11JAN29 ALSTOM NO0012698358 XPAR 2029-01-11 0.0% 99.22 0.30%
500 ALSTOM0.25%14OCT26 ALSTOM NO0012698358 XPAR 2026-10-14 0.25%
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 4.05 4.47 4.70 5.12 6.12 4.87 6.60 7.78 8.15 8.15 14.85
Date of the highest 16/02/2024 - 09:00 12/02/2024 19/01/2024 29/11/2023 01/09/2023 09/01/2024 21/02/2023 19/04/2022 22/03/2021 22/03/2021 25/02/2000
Lowest 3.885 3.82 3.82 3.82 3.82 3.82 3.82 3.82 3.82 3.82 1.50
Date of the lowest 16/02/2024 - 12:55 15/02/2024 15/02/2024 15/02/2024 15/02/2024 15/02/2024 15/02/2024 15/02/2024 15/02/2024 15/02/2024 11/10/2002
% -0.62 -8.88 -14.16 -19.84 -33.77 -16.75 -39.02 -44.13 -45.80 -34.75 -58.76
Change -0.025 -0.39 -0.66 -0.99 -2.04 -0.805 -2.56 -3.16 -3.38 -2.13 -5.70
Turnover 367538.43 2568022.13 6828052.76 13.270M 22.874M 9123983.01 47.826M 104.455M 181.444M 313.052M 1.371B
Volume 93006 634586 1622438 2946448 4735638 2107947 8841351 16.992M 27.645M 47.487M 82.247B
Avg Vol 93006 105764 73747 46038 36710 60227 34537 33122 35810 36984 12.683M
Avg Price 3.95 4.05 4.21 4.50 4.83 4.33 5.41 6.15 6.56 6.59 0.02
Nb days 1 6 22 64 129 35 256 513 772 1284 6485
# 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.790 6.989 7.241 7.271 7.271 7.241 7.271 7.271 7.271 7.271 7.271
Date of the highest 16/02/2024 - 09:04 12/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.790 6.527 6.527 6.527 6.281 6.527 5.35 4.700 4.030 4.030 4.030
Date of the lowest 16/02/2024 - 09: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
% 1.23 -6.33 -5.14 -5.22 3.32 -5.76 15.31 11.68 59.69 59.69 59.69
Change 0.083 -0.441 -0.354 -0.360 0.210 -0.399 0.867 0.683 2.439 2.439 2.439
Turnover
9162.92 26525.61 28952.20 58815.60 28765.10 142004.42 370782.42 448038.65 448038.65 448038.65
Volume
1327 3825 4185 8670 4159 23103 66058 80750 80750 80750
Avg Vol
221 174 66 68 119 91 129 105 63 12
Avg Price
6.90 6.93 6.92 6.78 6.92 6.15 5.61 5.55 5.55 5.55
Nb days 1 6 22 63 128 35 255 512 771 1283 6484
# 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.02 0.26 0.86 1.62 0.13 1.97 -4.42 -7.78 -4.64 -2.92
Change -0.06 0.02 0.26 0.84 1.57 0.13 1.90 -4.55 -8.30 -4.79 -2.96
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 13636 13846 9231 20000 12692 14038 9603 6748 2899
Avg Price 0.01
0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01
Nb days 1 6 22 65 130 35 260 520 781 1304 6554
# 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 10.679 9.955 9.955 9.955 9.955 9.955 10.679 10.847 12.185 12.185 12.185
Date of the highest 06/07/2023 - 15:01 07/12/2023 07/12/2023 07/12/2023 07/12/2023 07/12/2023 06/07/2023 01/06/2022 12/11/2021 12/11/2021 12/11/2021
Lowest 10.679 9.955 9.955 9.955 9.955 9.955 1.00 1.00 1.00 1.00 1.00
Date of the lowest 06/07/2023 - 15:01 07/12/2023 07/12/2023 07/12/2023 07/12/2023 07/12/2023 24/03/2023 24/03/2023 24/03/2023 24/03/2023 24/03/2023
% 6.59 0.00 0.00 0.00 0.00 0.00 -4.33 -16.47 -7.05 26.03 28.07
Change 0.66 0.00 0.00 0.00 0.00 0.00 -0.454 -1.975 -0.76 2.069 2.196
Turnover 5125.92
447.98 447.98
7428.04 291434.81 327124.48 781736.51 1027788.16
Volume 480 45 45 90 90 45 750 26941 30049 86089 118276
Avg Vol 480 8 2 1 1 1 3 53 39 68 18
Avg Price 10.68
4.98 4.98
9.90 10.82 10.89 9.08 8.69
Nb days 1 6 22 63 128 35 254 510 767 1275 6497
# 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,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 4,553.63
Date of the highest 16/02/2024 - 17:51 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 12/02/2024
Lowest 4,508.00 4,453.24 4,120.71 3,989.24 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 16/02/2024 - 09:00 13/02/2024 19/01/2024 21/11/2023 23/10/2023 17/01/2024 20/03/2023 13/10/2022 13/10/2022 16/03/2020 04/06/2012
% 0.99 -0.19 9.79 13.00 16.96 8.21 13.12 19.50 26.58 63.54 248.00
Change 44.59 -8.58 403.32 520.33 656.07 343.39 524.81 738.34 949.95 1,757.81 3,224.08
Turnover
Volume
Avg Vol
Nb days 1 6 22 63 128 35 255 512 771 1283 6484

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:

# 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

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 37.25 [16/02/2024 17:35]
Valuation Close 37.25 [16/02/2024]
Volume 164,119 [16/02/2024 17:35]
Turnover 6,108,815
Transactions 1,511
VWAP 37.2219
Open 37.09
High 37.53 [11:32]
Low 36.97 [14:33]
Threshold 40.97 - 33.53 [19/02/2024 07:30]
Previous Close 36.78 [15/02/2024]
52 Week 28.83 - 48.53
Market Cap 4.119B

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,508.00
High 4,552.25 [17:51]
Low 4,508.00 [09:00]
Previous Close 4,507.65 [15/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 [16/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
1OK98JYWA 17:35:01 3.995 13 Auction
1OK98JYW9 17:35:01 3.995 105 Auction
1OK98JYW8 17:35:01 3.995 46 Auction
1OK98JYW7 17:35:01 3.995 34 Auction
1OK98JYW6 17:35:01 3.995 186 Auction
1OK98JYW5 17:35:01 3.995 21 Auction
1OK98JYW4 17:35:01 3.995 73 Auction
1OK98JYW3 17:35:01 3.995 93 Auction
1OK98JYW2 17:35:01 3.995 185 Auction
1OK98JYW1 17:35:01 3.995 47 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
5FC6J23R 15:00:48 9.955 45 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:21 6.7904 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:02 4,552.24
Closing Reference index
18:00:01 4,552.24
Closing Reference index
18:00:00 4,552.25
Real-time index
17:59:30 4,552.24
Real-time index
17:59:00 4,552.25
Real-time index
17:58:46 4,552.24
Real-time index
17:51:15 4,552.25
Real-time index
17:42:30 4,552.24
Real-time index
17:42:15 4,552.23
Real-time index
17:42:00 4,552.24
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.

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 7768.18 0.32
CAC ALL SHARES 9461.65 0.36
CAC NEXT 20 11131.35 0.89
CAC SMALL 11790.97 -0.28
SBF 120 5883.26 0.36
#> [1] "Summary data for 'EURONEXT indices'"
Instrument name Last price Day change relative (%)
EURONEXT 100 1447.13 0.47
CLIMATE EUROPE 1860.64 0.63
LOW CARBON 100 159.57 0.73
NEXT BIOTECH 2260.42 0.05
ESG 80 1996.90 0.44
#> [1] "Summary data for 'Currency rate'"
Instrument name Last price Day change relative (%)
EUR / USD 1.07838 0.07
EUR / GBP 0.85448 -0.07
EUR / JPY 161.74450 -0.10
EUR / CHF 0.95049 -0.13
GBP / USD 1.26204 0.15

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
22 3652 NA NA 52 2
1 122 4.1 3.8 339 1
1 250 4.03 3.9 500 1
1 193 4.02 3.995 139 2
6 656 4 4 1263 5
1 27 3.995 4.02 614 2
1 30 3.99 4.05 1623 5
2 307 3.98 4.06 176 2
1 500 3.96 4.07 122 1
5 531 3.95 4.08 14 1
41 6268
4842 22
# 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 580 7.5 NA NA NA
1 1 5 NA NA NA
2 581
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"
ALBON_OB_chart <- EN_OrderBook.Chart("ALBON")
ALBON_OB_chart

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

Authors :
* Koffi Frederic Sessie (koffisessie@gmail.com)

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

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