December 2024: Top Posts of the SimTrade Blog about cryptos

In this article, Snehasish CHINARA (ESSEC Business School, Grande Ecole Program – Master in Management, 2022-2024) explains the evolution of high performance blockchain powered cryptocurrency, Solana.

Historical context and background

Solana, a relatively new entrant in the cryptocurrency arena, emerged against the backdrop of an increasingly crowded and competitive landscape in the digital currency space. Founded in 2020 by Anatoly Yakovenko, a former engineer at Qualcomm, Solana sought to address some of the inherent scalability and speed limitations plaguing earlier blockchain platforms like Ethereum. The platform is named after the Solana Beach in California, where Yakovenko often surfed, symbolizing the project’s ambition to ride the waves of innovation and technological advancement.

Unlike many other cryptocurrencies that primarily rely on Proof of Work (PoW) or Proof of Stake (PoS) consensus mechanisms, Solana introduced a novel consensus mechanism known as Proof of History (PoH). This mechanism aims to optimize transaction processing speed by organizing transactions into a series of chronological events, enabling parallel transaction processing, and significantly enhancing scalability. Solana’s emphasis on scalability and throughput has positioned it as a promising platform for decentralized applications (dApps) and decentralized finance (DeFi) projects seeking high-performance blockchain infrastructure. Its innovative approach has garnered attention and support from investors and developers alike, propelling Solana into the spotlight as one of the leading contenders in the cryptocurrency space.

Solana Logo

Source: Google.

Figure 1. Key Dates in Solana History.

Source: Yahoo! Finance.

Key features

Scalability

Solana is designed to be highly scalable, capable of processing thousands of transactions per second. Its unique consensus mechanism, Proof of History (PoH), combined with a network of nodes running parallel processing, enables Solana to handle a high throughput of transactions efficiently.

Fast Transaction Speeds

With its focus on scalability, Solana boasts incredibly fast transaction speeds. Transactions can be confirmed in milliseconds, making it suitable for applications requiring rapid transaction processing, such as decentralized finance (DeFi) platforms and high-frequency trading.

Low Transaction Costs

Solana aims to keep transaction costs low, even during periods of high network activity. Its efficient use of resources and high throughput allow for cost-effective transactions, making it accessible to users and developers alike.

Proof of History (PoH)

Solana’s unique consensus mechanism, PoH, serves as a historical record for the ordering and time-stamping of transactions. By leveraging PoH, Solana achieves high throughput without sacrificing decentralization or security.

Support for Smart Contracts

Solana is compatible with smart contracts, allowing developers to build decentralized applications (dApps) and execute programmable transactions on the blockchain. It supports smart contract languages like Rust and Solidity, enabling a wide range of developers to build on the platform.

Ecosystem and Development Tools

Solana boasts a growing ecosystem of projects and development tools to support developers in building decentralized applications. Its developer-friendly environment includes tools such as Solana Studio, a web-based IDE for building and deploying smart contracts, and libraries for interacting with the Solana blockchain.

Interoperability

Solana is designed to be interoperable with other blockchains and protocols, facilitating seamless communication and asset transfer between different networks. This interoperability opens up possibilities for cross-chain decentralized applications and enhances the overall utility of the Solana ecosystem.

Use cases

Non-Fungible Tokens (NFTs)

Solana provides an efficient infrastructure for minting, trading, and storing NFTs. Artists, creators, and collectors are utilizing Solana-based marketplaces like Solanart to buy and sell digital collectibles, artwork, and virtual assets. Solana’s high throughput enables seamless NFT transactions, while its low fees make it appealing for creators seeking an alternative to Ethereum’s congested network.

Gaming and Virtual Worlds

Solana’s high-performance blockchain is well-suited for gaming applications and virtual worlds that require fast transaction processing and scalability. Game developers are leveraging Solana’s infrastructure to create blockchain-based games, in-game assets, and decentralized gaming platforms. Projects like Star Atlas, a space-themed massively multiplayer online game (MMO) built on Solana, demonstrate the platform’s potential to disrupt the gaming industry.

Decentralized Autonomous Organizations (DAOs)

Solana provides a robust framework for building decentralized autonomous organizations (DAOs) that enable community governance and decision-making. DAOs on Solana leverage smart contracts to automate voting mechanisms, distribute governance tokens, and execute proposals transparently and efficiently. These DAOs empower communities to collectively manage and govern decentralized protocols, platforms, and resources.

Tokenization of Real-World Assets

Solana facilitates the tokenization of real-world assets such as real estate, stocks, and commodities, enabling fractional ownership and increased liquidity. Projects are exploring Solana’s blockchain to tokenize and trade various asset classes, unlocking new investment opportunities and reducing barriers to entry for traditional markets.

Technology and underlying blockchain

At the core of Solana’s architecture is the Proof of History (PoH) consensus mechanism, which orders transactions before they are processed into blocks. This deterministic sequencing allows for parallel transaction processing and enhances overall network efficiency. Additionally, Solana utilizes a Byzantine Fault Tolerance (BFT) consensus algorithm called Tower BFT, which further ensures network security and integrity.

Solana’s blockchain implements a novel data structure known as the “Solana Architecture,” which includes a combination of a single global state, a high-speed networking stack, and a high-performance virtual machine (VM). This architecture enables Solana to achieve impressive transaction throughput, with the capability to process thousands of transactions per second (TPS) and sub-second transaction finality. Furthermore, Solana leverages a unique mechanism called “Turbine” to optimize block propagation and reduce network latency, enhancing the overall scalability and performance of the platform.

The Solana ecosystem also features a built-in decentralized exchange (DEX), supporting seamless token swaps and liquidity provision directly on-chain. Smart contracts on Solana are executed using a high-performance VM called Sealevel, which is designed to efficiently process complex computations while maintaining low transaction costs. Overall, Solana’s technology stack, comprising innovative consensus mechanisms, advanced data structures, and optimized networking protocols, positions it as a leading blockchain platform capable of supporting a wide range of decentralized applications (dApps) and use cases at scale.

Supply of coins

Solana (SOL) operates on a fixed supply model, with a maximum supply of 489,026,837 SOL tokens. Unlike traditional fiat currencies, Solana’s tokenomics are governed by the principles of cryptocurrency protocols. The initial distribution of SOL tokens occurred through a combination of token sales, strategic partnerships, ecosystem incentives, and network validators’ rewards. Notably, Solana employs a deflationary economic model, wherein a portion of transaction fees is burned, reducing the overall token supply over time. This deflationary mechanism is designed to counterbalance any potential inflationary pressures as the network expands, ensuring the long-term sustainability and scarcity of SOL tokens. Additionally, SOL tokens are used to facilitate various functions within the Solana ecosystem, including transaction fees, staking rewards, governance participation, and decentralized application interactions. As Solana continues to grow and gain adoption, the controlled and predictable token supply dynamics play a crucial role in maintaining the network’s integrity and value proposition.

Historical data for Solana

How to get the data?

The Solana (SOL) is a popular cryptocurrency on the market, and historical data for the Solana such as prices and volume traded can be easily downloaded from the internet sources such as Yahoo! Finance, Blockchain.com & CoinMarketCap. For example, you can download data for Solana on Yahoo! Finance (the Yahoo! code for Solana is SOL-USD).

Figure 2. Solana data

Source: Yahoo! Finance.

Historical data for the Solana market prices

The historical data for Solana market prices demonstrates a dynamic evolution marked by significant fluctuations and notable trends since its inception. Initially, SOL experienced modest trading activity and price levels, but as Solana gained recognition for its innovative blockchain architecture and scalability features, its market value began to ascend. Early adopters and investors drove demand for SOL tokens, leading to periods of rapid appreciation interspersed with corrections and consolidation phases. Milestones such as protocol upgrades, partnerships, and successful dApp launches often coincided with significant price movements. Moreover, broader market trends and sentiment towards cryptocurrencies influenced SOL’s price dynamics, contributing to both bullish and bearish cycles over time. Overall, SOL’s price trajectory reflects Solana’s journey from its early stages to becoming a prominent player in the blockchain space, highlighting its potential to revolutionize decentralized applications and digital finance despite the inherent volatility of the cryptocurrency market.

Figure 3 below represents the evolution of the price of Solana (SOL) in US dollar over the period April 2020 – December 2023. The price corresponds to the “closing” price (observed at 10:00 PM CET at the end of the month).

Figure 3. Evolution of the Solana (SOL) price

Source: Yahoo! Finance.

R program

The R program below written by Shengyu ZHENG allows you to download the data from Yahoo! Finance website and to compute summary statistics and risk measures about the Solana (SOL).

The R program that you can download above allows you to download the data for the Solana (SOL) from the Yahoo! Finance website. The database starts on April, 2020.

Table 1 below represents the top of the data file for the Solana (SOL) downloaded from the Yahoo! Finance website with the R program.

Table 1. Top of the data file for the Solana (SOL)

Source: computation by the author (data: Yahoo! Finance website).

Python code

You can download the Python code used to download the data from Yahoo! Finance.

Python script to download Solana (SOL) historical data and save it to an Excel sheet::

import yfinance as yf

import pandas as pd

# Define the ticker symbol for Solana Coin

SOL_ticker = “SOL-USD”

# Define the date range for historical data

start_date = “2020-01-01”

end_date = “2022-01-01”

# Download historical data using yfinance

SOL_data = yf.download(SOL_ticker, start=start_date, end=end_date)

# Create a Pandas DataFrame from the downloaded data

doge_df = pd.DataFrame(SOL_data)

# Define the Excel file path

excel_file_path = “SOL_historical_data.xlsx”

# Save the data to an Excel sheet

SOL_df.to_excel(excel_file_path, sheet_name=”SOL_historical_data”)

print(f”Data saved to {excel_file_path}”)

# Make sure you have the required libraries installed and adjust the “start_date” and “end_date” variables to the desired date range for the historical data you want to download.

Evolution of the Solana (SOL)

Figure 4 below gives the evolution of the Solana (SOL) returns from April, 2020 to December 31, 2023 on a daily basis.

Figure 4. Evolution of the Solana (SOL) returns.

Source: computation by the author (data: Yahoo! Finance website).

Summary statistics for the Solana (SOL)

The R program that you can download above also allows you to compute summary statistics about the returns of the Solana (SOL). Table 2 below presents the following summary statistics estimated for the Solana (SOL):

The mean

The standard deviation (the squared root of the variance)

The skewness

The kurtosis.

The mean, the standard deviation / variance, the skewness, and the kurtosis refer to the first, second, third and fourth moments of statistical distribution of returns respectively.

Table 2. Summary statistics for Solana (SOL).

Source: computation by the author (data: Yahoo! Finance website).

Statistical distribution of the Solana (SOL) returns

Historical distribution

Figure 5 represents the historical distribution of the Solana (SOL) daily returns for the period from April, 2020 to December 31, 2023.

Figure 5. Historical Solana (SOL) distribution of the returns.

Source: computation by the author (data: Yahoo! Finance website).

Gaussian distribution

Figure 6 below represents the Gaussian distribution of the Solana (SOL) daily returns with parameters estimated over the period from April, 2020 to December, 2023.

Figure 6. Gaussian distribution of the Solana (SOL) returns.

Source: computation by the author (data: Yahoo! Finance website).

Risk measures of the Solana (SOL) returns

The R program that you can download above also allows you to compute risk measures about the returns of the Solana (SOL).

Table 3 below presents the following risk measures estimated for the Solana (SOL):

The long-term volatility (the unconditional standard deviation estimated over the entire period)

The short-term volatility (the standard deviation estimated over the last three months)

The Value at Risk (VaR) for the left tail (the 5% quantile of the historical distribution)

The Value at Risk (VaR) for the right tail (the 95% quantile of the historical distribution)

The Expected Shortfall (ES) for the left tail (the average loss over the 5% quantile of the historical distribution)

The Expected Shortfall (ES) for the right tail (the average loss over the 95% quantile of the historical distribution)

The Stress Value (SV) for the left tail (the 1% quantile of the tail distribution estimated with a Generalized Pareto distribution)

The Stress Value (SV) for the right tail (the 99% quantile of the tail distribution estimated with a Generalized Pareto distribution)

Table 3. Risk measures for the Solana (SOL).

Source: computation by the author (data: Yahoo! Finance website).

The volatility is a global measure of risk as it considers all the returns. The Value at Risk (VaR), Expected Shortfall (ES) and Stress Value (SV) are local measures of risk as they focus on the tails of the distribution. The study of the left tail is relevant for an investor holding a long position in the Solana (SOL) while the study of the right tail is relevant for an investor holding a short position in the Solana (SOL).

Why should I be interested in this post?

This blog offers an engaging exploration into a cryptocurrency that transcends traditional finance, appealing to a wide audience due to its cultural relevance, investment potential, and vibrant community. Solana’s reputation for high performance in blockchain technology, boasting the capability to process thousands of transactions per second, makes it an appealing option for developers and users seeking efficient transaction processing. Moreover, staying updated on Solana can offer insights into the growth of its ecosystem, including the development of decentralized applications (dApps) and strategic partnerships. For investors, Solana’s increasing popularity and ecosystem growth may signal investment opportunities, making it worthwhile to track news and discussions surrounding the platform. Additionally, Solana’s innovative technical advancements in scalability, consensus mechanisms, and developer tools are of interest to those intrigued by blockchain technology. Engaging with the Solana community provides opportunities for networking and gaining valuable insights into this rapidly expanding ecosystem.

Useful resources

Academic research about risk

Longin F. (2000) From VaR to stress testing: the extreme value approach Journal of Banking and Finance, N°24, pp 1097-1130.

Longin F. (2016) Extreme events in finance: a handbook of extreme value theory and its applications Wiley Editions.

Data

Yahoo! Finance

Yahoo! Finance Historical data for Solana

CoinMarketCap Historical data for Solana

About the author

The article was written in April 2024 by Snehasish CHINARA (ESSEC Business School, Grande Ecole Program – Master in Management, 2022-2024).

Bitcoin est un rêve, un idéal, un espoir

April 15, 2024April 9, 2024 by Jean-Marie CHOFFRAY

Bitcoin est un rêve, un idéal, un espoir

Dans cet article, Jean-Marie CHOFFRAY (Professeur Ordinaire Honoraire d’Informatique Décisionnelle à l’Université de Liège, PhD-77, Management Science, Massachusetts Institute of Technology) introduit son recent article “Mille quatre cent milliards de dollars”.

Personne ne sait précisément ce qu’est Bitcoin (avec « Bvle réseau). Au plan conceptuel, bitcoin (avec « b le jeton) est une chaîne, aussi indestructible que possible, de blocs d’enregistrements, aussi sécurisés que possible. Cette technologie nouvelle est donc un projet en cours dont personne ne peut préjuger l’avenir, quelle que soit la dimension considérée. Bitcoin deviendra ce que la majorité de ses utilisateurs décidera, et surtout aura le courage, d’en faire. Pour Satochi Nakamoto, c’était un rêve. Pour ceux qui travaillent aujourd’hui sur son code, c’est un idéal. Enfin, pour ceux qui l’utiliseront demain, c’est un espoir. L’Histoire de l’Humanité, une autre chaîne de blocs d’enregistrements – à l’évidence, non sécurisés et falsifiables ! – , s’apparente au reflet d’une montée de la Conscience individuelle et collective (cf. « Le phénomène humain » de Pierre Teilhard de Chardin). Bitcoin, c’est L’espoir maintenant (entretien entre Jean-Paul Sartre et Benny Lévy) : « une tension vers la fin, que l’échec, le tragique ne sauraient annuler… La valeur économique de bitcoin serait-elle le prix de la liberté ?

▶ Lire l’article Bitcoin est un rêve, un idéal, un espoir

Autres articles sur le blog

▶ Snehasish CHINARA Bitcoin: the mother of all cryptocurrencies

▶ Jean-Marie CHOFFRAY Mille quatre cent milliards de dollars

A propos de l’auteur

L’article a été rédigé en mars 2024 par Jean-Marie CHOFFRAY (Professeur Ordinaire Honoraire d’Informatique Décisionnelle à l’Université de Liège, PhD-77, Management Science, Massachusetts Institute of Technology).

Doge Coin: Unraveling the Phenomenon of the Internet’s Favourite Cryptocurrency

May 2, 2024April 5, 2024 by Snehasish CHINARA

In this article, Snehasish CHINARA (ESSEC Business School, Grande Ecole Program – Master in Management, 2022-2024) explains the evolution of the most popular memecoin, Dogecoin.

Historical context and background

Dogecoin, a cryptocurrency that started as a joke, quickly evolved into a significant player in the world of digital assets. Created in December 2013 by software engineers Billy Markus and Jackson Palmer, Dogecoin was initially intended to satirize the hype surrounding cryptocurrencies at the time. The coin’s logo features the Shiba Inu dog from the “Doge” meme, which was immensely popular on the internet during that period. Despite its humorous origins, Dogecoin gained traction due to its welcoming and inclusive community, as well as its low transaction fees and fast confirmation times.

The early days of Dogecoin saw rapid adoption and a vibrant online community rallying around the coin. It gained attention for its philanthropic efforts, including fundraising campaigns to sponsor charity events and support causes such as building water wells in developing countries and sponsoring Olympic athletes. These initiatives helped distinguish Dogecoin from other cryptocurrencies and fostered a sense of community among its users.

Over time, Dogecoin’s popularity continued to grow, fueled in part by endorsements from notable figures such as Elon Musk, who frequently tweeted about the coin, further amplifying its visibility. Despite facing occasional security issues and challenges, Dogecoin has persevered, becoming one of the most recognized and traded cryptocurrencies in the market. Its unique blend of humor, community spirit, and accessibility has endeared it to a wide range of users, making it a significant player in the ever-expanding crypto landscape.

Doge Coin Logo

Source: Yahoo! Finance.

Figure 1. Key Dates in Doge Coin History

Source: Yahoo! Finance .

Key features

Decentralization

Like most cryptocurrencies, Dogecoin operates on a decentralized network, meaning it is not controlled by any single entity or organization. Transactions are recorded on a public ledger known as the blockchain, which is maintained by a network of nodes.

Scrypt Algorithm

Dogecoin uses the Scrypt algorithm for its proof-of-work consensus mechanism, which is less energy-intensive compared to Bitcoin’s SHA-256 algorithm. This allows for greater accessibility to mining for individuals with standard computer hardware.

Fast Transactions

Dogecoin boasts relatively fast transaction times, with blocks being mined approximately every minute. This makes it suitable for quick and efficient transfers of value.

Low Transaction Fees

Transaction fees on the Dogecoin network are typically minimal, making it cost-effective for transferring even small amounts of value.

Meme Culture

Dogecoin’s branding and marketing heavily leverage internet meme culture, particularly the “Doge” meme featuring the Shiba Inu dog. This playful and approachable branding sets Dogecoin apart from other cryptocurrencies and contributes to its widespread appeal.

Use cases

Tipping

Dogecoin gained popularity early on for its use as a tipping currency on social media platforms like Reddit and Twitter. Users can easily send small amounts of Dogecoin to content creators or other users as a form of appreciation.

Charitable Donations

The Dogecoin community has a history of supporting charitable causes and disaster relief efforts. Dogecoin has been used to raise funds for various initiatives, including sponsoring athletes, funding clean water projects, and aiding during natural disasters.

E-commerce

Some online merchants and retailers accept Dogecoin as a form of payment for goods and services. This includes businesses ranging from small independent shops to larger e-commerce platforms.

Micropayments

Dogecoin’s low transaction fees and fast confirmation times make it suitable for micropayments, allowing users to easily transfer small amounts of value online.

Community Engagement

Dogecoin continues to serve as a vehicle for community engagement and participation. Its lighthearted and inclusive nature fosters a sense of camaraderie among its users, who often come together for events, fundraisers, and online discussions.

Experimental Projects

Developers and enthusiasts sometimes use Dogecoin for experimental projects or to explore new applications of blockchain technology. These projects can range from art and gaming to decentralized finance (DeFi) experiments.

Technology and underlying blockchain

Dogecoin operates on a blockchain-based technology similar to Bitcoin and many other cryptocurrencies. It employs a decentralized peer-to-peer network that relies on nodes spread across the globe to validate and record transactions. Dogecoin’s blockchain uses the Scrypt hashing algorithm, which was initially designed to facilitate quicker confirmation times compared to Bitcoin’s SHA-256 algorithm. This choice of algorithm allows for a more accessible mining process, enabling individuals with standard computer hardware to participate in securing the network and earning rewards. Transactions on the Dogecoin network are grouped into blocks, which are then added to the blockchain through a process known as mining. Miners compete to solve complex mathematical puzzles, and the first miner to solve a puzzle validates the transactions in a block and adds it to the blockchain. Dogecoin’s block time is approximately one minute, resulting in faster transaction confirmations compared to Bitcoin’s ten-minute block time. Additionally, Dogecoin originally had a limitless supply, with a fixed reward of 10,000 DOGE per block; however, this changed in 2014 to an inflationary model, where a fixed number of coins are added to the supply each year. This combination of technology and economic design contributes to Dogecoin’s unique characteristics and its appeal within the cryptocurrency ecosystem.

Supply of coins

Dogecoin’s supply dynamics are distinctive within the cryptocurrency landscape. Initially launched with no hard cap on its total supply, Dogecoin features an inflationary issuance model designed to maintain a steady influx of coins into the market. Unlike Bitcoin’s fixed supply of 21 million coins, Dogecoin’s issuance rate started at 5 billion coins per year and gradually decreases over time. This inflationary nature ensures a continuous supply of Dogecoin, theoretically allowing for ongoing miner rewards and a sustained incentive for network participation. However, it’s worth noting that while the supply of Dogecoin is technically infinite, the rate of new coin creation diminishes over time, resulting in a decreasing inflation rate and a more stable supply trajectory. This unique supply mechanism distinguishes Dogecoin from many other cryptocurrencies and can influence its long-term economic dynamics and utility as a medium of exchange or store of value.

Historical data for Doge Coin

How to get the data?

The Doge Coin is popular cryptocurrency on the market, and historical data for the Doge Coin such as prices and volume traded can be easily downloaded from the internet sources such as Yahoo! Finance, Blockchain.com & CoinMarketCap. For example, you can download data for Doge Coin on Yahoo! Finance (the Yahoo! code for Doge Coin is Doge-USD).

Figure 2. Doge Coin data

Source: Yahoo! Finance.

Historical data for the Doge Coin market prices

Since its inception in 2013, Dogecoin has experienced notable price fluctuations, driven by a combination of factors including market speculation, community engagement, and broader trends in the digital asset space. Initially launched as a joke currency, Dogecoin’s price remained relatively stable for several years, trading at fractions of a cent. However, its price surged dramatically in early 2021, fueled by social media hype and celebrity endorsements, reaching all-time highs of over 70 cents per coin. This unprecedented rally brought Dogecoin into the spotlight, attracting widespread attention from investors and media outlets. Despite subsequent price corrections, Dogecoin has maintained a prominent position in the cryptocurrency market, with its price influenced by various factors including Elon Musk’s tweets, meme culture, and broader market sentiment. Overall, the historical price evolution of Dogecoin exemplifies the volatile and dynamic nature of the cryptocurrency market, highlighting the interplay between community enthusiasm, market speculation, and broader industry trends.

Figure 3 below represents the evolution of the price of Doge Coin in US dollar over the period November 2018 – December 2022. The price corresponds to the “closing” price (observed at 10:00 PM CET at the end of the month).

Figure 3. Evolution of the Doge Coin price

Source: Yahoo! Finance.

R program

The R program below written by Shengyu ZHENG allows you to download the data from Yahoo! Finance website and to compute summary statistics and risk measures about the Doge Coin.

Data file

The R program that you can download above allows you to download the data for the Doge Coin from the Yahoo! Finance website. The database starts on October, 2018.

Table 1 below represents the top of the data file for the Doge Coin downloaded from the Yahoo! Finance website with the R program.

Table 1. Top of the data file for the DOGE Coin

Source: computation by the author (data: Yahoo! Finance website).

Python code

You can download the Python code used to download the data from Yahoo! Finance.

Python script to download Doge historical data and save it to an Excel sheet::

import yfinance as yf

import pandas as pd

# Define the ticker symbol for Doge Coin

doge_ticker = “DOGE-USD”

# Define the date range for historical data

start_date = “2020-01-01”

end_date = “2022-01-01”

# Download historical data using yfinance

doge_data = yf.download(doge_ticker, start=start_date, end=end_date)

# Create a Pandas DataFrame from the downloaded data

doge_df = pd.DataFrame(doge_data)

# Define the Excel file path

excel_file_path = “DOGE_historical_data.xlsx”

# Save the data to an Excel sheet

doge_df.to_excel(excel_file_path, sheet_name=”DOGE_historical_data”)

print(f”Data saved to {excel_file_path}”)

# Make sure you have the required libraries installed and adjust the “start_date” and “end_date” variables to the desired date range for the historical data you want to download

Evolution of the Doge Coin

Figure 4 below gives the evolution of the Doge Coin on a daily basis.

Figure 4. Evolution of the DOGE Coin Figure 5 below gives the evolution of the Doge Coin returns from November, 2018 to December 31, 2022 on a daily basis.

Figure 5. Evolution of the Doge Coin returns.

Source: computation by the author (data: Yahoo! Finance website).

Summary statistics for the Doge Coin

The R program that you can download above also allows you to compute summary statistics about the returns of the Doge Coin. Table 2 below presents the following summary statistics estimated for the Doge Coin:

The mean

The standard deviation (the squared root of the variance)

The skewness

The kurtosis.

The mean, the standard deviation / variance, the skewness, and the kurtosis refer to the first, second, third and fourth moments of statistical distribution of returns respectively.

Table 2. Summary statistics for Doge Coin.

Source: computation by the author (data: Yahoo! Finance website).

Statistical distribution of the Doge Coin returns

Figure 6 represents the historical distribution of the Doge Coin daily returns for the period from November, 2018 to December 31, 2022.

Figure 6. Historical Doge Coin distribution of the returns.

Source: computation by the author (data: Yahoo! Finance website).

Gaussian distribution

The Gaussian distribution (also called the normal distribution) is a parametric distribution with two parameters: the mean and the standard deviation of returns. We estimated these two parameters over the period from October, 2018 to December 31, 2022. Figure 7 below represents the Gaussian distribution of the Ethereum daily returns with parameters estimated over the period from October, 2018 to December, 2022.

Figure 9. Gaussian distribution of the Doge Coin returns.

Source: computation by the author (data: Yahoo! Finance website).

Risk measures of the Doge Coin returns

The R program that you can download above also allows you to compute risk measures about the returns of the Doge Coin.

Table 3 below presents the following risk measures estimated for the Doge Coin:

The long-term volatility (the unconditional standard deviation estimated over the entire period)

The short-term volatility (the standard deviation estimated over the last three months)

The Value at Risk (VaR) for the left tail (the 5% quantile of the historical distribution)

The Value at Risk (VaR) for the right tail (the 95% quantile of the historical distribution)

The Expected Shortfall (ES) for the left tail (the average loss over the 5% quantile of the historical distribution)

The Expected Shortfall (ES) for the right tail (the average loss over the 95% quantile of the historical distribution)

The Stress Value (SV) for the left tail (the 1% quantile of the tail distribution estimated with a Generalized Pareto distribution)

The Stress Value (SV) for the right tail (the 99% quantile of the tail distribution estimated with a Generalized Pareto distribution)

Table 3. Risk measures for the Doge Coin.

Source: computation by the author (data: Yahoo! Finance website).

The volatility is a global measure of risk as it considers all the returns. The Value at Risk (VaR), Expected Shortfall (ES) and Stress Value (SV) are local measures of risk as they focus on the tails of the distribution. The study of the left tail is relevant for an investor holding a long position in the XRP while the study of the right tail is relevant for an investor holding a short position in the Doge Coin.

Why should I be interested in this post?

This blog offers an engaging exploration into a cryptocurrency that transcends traditional finance, appealing to a wide audience due to its cultural relevance, investment potential, and vibrant community. From its origins as a meme coin to its remarkable price movements, understanding Dogecoin’s dynamics provides valuable insights into both the cryptocurrency market and internet culture. Delving into its technological underpinnings, community engagement, and market trends offers a concise yet comprehensive overview of Dogecoin’s significance in the evolving landscape of digital currencies.

Useful resources

Academic research about risk

Longin F. (2000) From VaR to stress testing: the extreme value approach Journal of Banking and Finance, N°24, pp 1097-1130.

Longin F. (2016) Extreme events in finance: a handbook of extreme value theory and its applications Wiley Editions.

Data

Yahoo! Finance

Yahoo! Finance Historical data for Doge Coin

CoinMarketCap Historical data for Doge Coin

About the author

The article was written in March 2024 by Snehasish CHINARA (ESSEC Business School, Grande Ecole Program – Master in Management, 2022-2024).

USD Coin: Deep Dive into the Role of Stablecoins in Modern Finance

January 15, 2025April 2, 2024 by Snehasish CHINARA

In this article, Snehasish CHINARA (ESSEC Business School, Grande Ecole Program – Master in Management, 2022-2024) explains the stable coin USD Coin.

Historical context and background

USD Coin (USDC) is a type of cryptocurrency known as a stablecoin, designed to maintain a stable value relative to the US dollar (USD). It was launched in September 2018 by Centre Consortium, a collaboration between cryptocurrency exchange Coinbase and blockchain technology company Circle. The primary goal of USDC is to provide a digital asset that can be easily transferred between users and used for transactions, while minimizing the volatility typically associated with other cryptocurrencies like Bitcoin or Ethereum.

The need for stablecoins like USDC arose due to the inherent volatility of many cryptocurrencies. While Bitcoin and other digital assets have gained significant attention and adoption, their prices can fluctuate dramatically over short periods, which can make them less practical for everyday transactions and financial contracts. Stablecoins like USDC offer a solution to this problem by pegging their value to a stable asset, such as the US dollar, thereby providing stability and predictability for users.

USDC operates on the Ethereum blockchain as an ERC-20 token, making it compatible with a wide range of decentralized applications (dApps) and enabling seamless integration with the broader cryptocurrency ecosystem. This infrastructure allows users to easily send and receive USDC tokens across various platforms and services, including exchanges, wallets, and payment processors.

Since its launch, USDC has seen significant growth in adoption and usage. It has become one of the most widely used stablecoins in the cryptocurrency market, with billions of dollars worth of USDC tokens in circulation. Its stability and liquidity have made it a popular choice for traders, investors, and businesses looking to transact in digital assets without exposure to the volatility of other cryptocurrencies.

USD Coin Logo

Source: Yahoo! Finance.

Figure 1. Key Dates in USDC History

Source: Yahoo! Finance.

Key features

Stability

USD Coin is a stablecoin, meaning it is pegged to the value of the US dollar on a 1:1 basis. This stability is maintained through regular audits and backing by reserves of US dollars held in custody by regulated financial institutions.

Transparency

USDC operates on blockchain technology, providing transparency and immutability of transactions. Every USDC token is backed by an equivalent number of US dollars held in reserve, which is regularly audited and transparently reported to ensure trust among users.

Speed and Efficiency

Transactions involving USDC can be executed quickly and efficiently on blockchain networks, enabling near-instantaneous settlement compared to traditional banking systems, which may take days for cross-border transactions.

Global Accessibility

USDC enables borderless transactions, allowing users to send and receive payments globally without the need for intermediaries such as banks. This accessibility empowers individuals and businesses, particularly in regions with limited access to traditional financial services.

Interoperability

USDC is compatible with various blockchain platforms and protocols, including Ethereum, Algorand, and Solana, among others. This interoperability facilitates its integration into a wide range of decentralized applications (DApps) and decentralized finance (DeFi) ecosystems.

Use cases

Remittances and Cross-Border Payments:

USDC provides a cost-effective and efficient solution for remittance payments and cross-border transactions, enabling individuals and businesses to transfer value across borders quickly and securely without the need for traditional banking intermediaries.

Stable Value Storage

Due to its stable value pegged to the US dollar, USDC serves as a reliable store of value and a hedge against volatility in the cryptocurrency market. Users can hold USDC as a stable asset to preserve purchasing power and mitigate the risks associated with price fluctuations in other cryptocurrencies.

Decentralized Finance (DeFi) Applications

USDC is widely used as a liquidity provider and collateral asset in various DeFi protocols and applications such as decentralized exchanges (DEXs), lending platforms, yield farming, and liquidity pools. Users can leverage USDC to earn interest, borrow assets, or participate in yield farming strategies within the DeFi ecosystem.

Commerce and Payments

Merchants and businesses can accept USDC as a form of payment for goods and services, leveraging its fast transaction settlement times and low transaction fees compared to traditional payment methods. Integrating USDC payments can streamline cross-border commerce and reduce friction associated with fiat currency conversions.

Financial Inclusion

USDC plays a crucial role in expanding financial inclusion by providing access to digital financial services for individuals and communities underserved by traditional banking infrastructure. By utilizing blockchain technology and stablecoins like USDC, individuals without access to traditional banking services can participate in the global economy and access a wide range of financial products and services.

Technology and underlying blockchain

USD Coin (USDC) operates on a blockchain-based infrastructure, primarily leveraging the Ethereum blockchain as its foundation. Utilizing Ethereum’s smart contract functionality, USDC tokens are issued, transferred, and redeemed in a transparent and trustless manner. The ERC-20 standard, a set of rules and protocols defining interactions between tokens on the Ethereum network, governs the behavior of USDC tokens, ensuring compatibility with a wide range of wallets, exchanges, and decentralized applications (DApps). Moreover, USDC employs a consortium model for governance and operation, with regulated financial institutions serving as members responsible for the issuance, custody, and redemption of USDC tokens. These institutions adhere to strict regulatory compliance measures and conduct regular audits to verify that each USDC token is fully backed by an equivalent reserve of US dollars held in custody. This combination of blockchain technology, smart contracts, and regulatory oversight ensures the integrity, transparency, and stability of USD Coin, making it a trusted and widely adopted stablecoin within the cryptocurrency ecosystem.

ERC-20 Standard of Ethereum for USD Coin

The ERC-20 standard, short for Ethereum Request for Comment 20, is a widely adopted technical specification governing the creation and implementation of fungible tokens on the Ethereum blockchain. Introduced by Fabian Vogelsteller and Vitalik Buterin in 2015, ERC-20 defines a set of rules and functions that enable seamless interoperability between different tokens, ensuring compatibility with various decentralized applications (DApps) and wallets. Tokens adhering to the ERC-20 standard are characterized by a consistent set of methods, including transfer, balance inquiry, and approval mechanisms, facilitating easy integration and widespread adoption across the Ethereum ecosystem. This standardization has played a pivotal role in the proliferation of tokenization, empowering developers to create diverse tokenized assets, conduct crowdfunding campaigns through Initial Coin Offerings (ICOs), and establish decentralized exchanges (DEXs) where ERC-20 tokens are traded autonomously. Additionally, ERC-20 compliance enhances security and interoperability, fostering trust and usability within the Ethereum network.

Supply of coins

The supply dynamics of USD Coin (USDC) are governed by its underlying smart contract protocol and the management of its issuer, Centre Consortium, a collaboration between Circle and Coinbase. USDC operates on a principle of full backing, where each USDC token issued is backed by an equivalent number of US dollars held in reserve. This backing ensures a 1:1 peg to the US dollar, maintaining its stability. The issuance and redemption of USDC are facilitated through regulated financial institutions that hold the corresponding fiat reserves. Moreover, USDC’s supply is transparently audited on a regular basis, with attestations provided by reputable auditing firms to verify the adequacy of reserves. Through these mechanisms, the supply of USDC remains elastic, expanding or contracting based on market demand while preserving its stability and trustworthiness as a stablecoin in the digital asset ecosystem.

Historical data for USDC

How to get the data?

The USDC is popular cryptocurrency on the market, and historical data for the USDC such as prices and volume traded can be easily downloaded from the internet sources such as Yahoo! Finance, Blockchain.com & CoinMarketCap. For example, you can download data for USDC on Yahoo! Finance (the Yahoo! code for USD Coin is USDC-USD).

Figure 2. USD Coin data

Source: Yahoo! Finance.

Historical data for the USD Coin market prices

The historical market price of USD Coin (USDC) has remained relatively stable, as its primary function is to maintain a value pegged to the US dollar at a 1:1 ratio. Since its inception, USDC has consistently traded around the $1 mark, with minor fluctuations typically attributed to market dynamics and liquidity conditions. Investors and traders often utilize USDC as a safe haven asset or a means of temporarily exiting volatile cryptocurrency markets, contributing to its stability. This stability has made USDC a preferred choice for individuals and institutions seeking to hedge against cryptocurrency volatility or facilitate seamless transitions between digital and fiat currencies. Additionally, the transparent backing of USDC by reserves of US dollars held in custody by regulated financial institutions further enhances market confidence and contributes to its stable market price over time.The historical market price of USD Coin (USDC) has remained relatively stable, as its primary function is to maintain a value pegged to the US dollar at a 1:1 ratio. Since its inception, USDC has consistently traded around the $1 mark, with minor fluctuations typically attributed to market dynamics and liquidity conditions. Investors and traders often utilize USDC as a safe haven asset or a means of temporarily exiting volatile cryptocurrency markets, contributing to its stability. This stability has made USDC a preferred choice for individuals and institutions seeking to hedge against cryptocurrency volatility or facilitate seamless transitions between digital and fiat currencies. Additionally, the transparent backing of USDC by reserves of US dollars held in custody by regulated financial institutions further enhances market confidence and contributes to its stable market price over time.

Figure 3 below represents the evolution of the price of USD Coin in US dollar over the period Oct 2018 – Dec 2022. The price corresponds to the “closing” price (observed at 10:00 PM CET at the end of the month).

Figure 3. Evolution of the USD Coin price

Source: Yahoo! Finance.

R program

The R program below written by Shengyu ZHENG allows you to download the data from Yahoo! Finance website and to compute summary statistics and risk measures about the USD Coin.

Data file

The R program that you can download above allows you to download the data for the USD Coin from the Yahoo! Finance website. The database starts on Oct, 2018. Table 1 below represents the top of the data file for the USD Coin downloaded from the Yahoo! Finance website with the R program.

Table 1. Top of the data file for the USD Coin

Source: computation by the author (data: Yahoo! Finance website).

Python code

You can download the Python code used to download the data from Yahoo! Finance.

Python script to download USD Coin historical data and save it to an Excel sheet::

import yfinance as yf

import pandas as pd

# Define the ticker symbol for USD Coin

usdc_ticker = “USDC-USD”

# Define the date range for historical data

start_date = “2020-01-01”

end_date = “2022-01-01”

# Download historical data using yfinance

usdc_data = yf.download(usdc_ticker, start=start_date, end=end_date)

# Create a Pandas DataFrame from the downloaded data

usdc_df = pd.DataFrame(usdc_data)

# Define the Excel file path

excel_file_path = “USDC_historical_data.xlsx”

# Save the data to an Excel sheet

usdc_df.to_excel(excel_file_path, sheet_name=”USDC Historical Data”)

print(f”Data saved to {excel_file_path}”)

# Make sure you have the required libraries installed and adjust the “start_date” and “end_date” variables to the desired date range for the historical data you want to download.

Evolution of the USD Coin

Figure 4 below gives the evolution of the USDC on a daily basis.

Figure 4. Evolution of the USD Coin.

Source: computation by the author (data: Yahoo! Finance website).

Figure 5 below gives the evolution of the USD Coin returns from Oct, 2018 to December 31, 2022 on a daily basis.

Figure 5. Evolution of the USD Coin returns

Source: computation by the author (data: Yahoo! Finance website).

Summary statistics for the USD Coin

The R program that you can download above also allows you to compute summary statistics about the returns of the USD Coin. Table 2 below presents the following summary statistics estimated for the USD Coin:

The mean

The standard deviation (the squared root of the variance)

The skewness

The kurtosis.

The mean, the standard deviation / variance, the skewness, and the kurtosis refer to the first, second, third and fourth moments of statistical distribution of returns respectively.

Table 2. Summary statistics for USDC.

Source: computation by the author (data: Yahoo! Finance website).

Statistical distribution of the USD Coin returns

Historical distribution

Figure 6 represents the historical distribution of the USD Coin daily returns for the period from Oct, 2018 to December 31, 2022.

Figure 6. Historical USDC distribution of the returns.

Source: computation by the author (data: Yahoo! Finance website).

Gaussian distribution

Figure 7 below represents the Gaussian distribution of the USD Coin daily returns with parameters estimated over the period from October, 2018 to December, 2022.

Figure 7. Gaussian distribution of the USDC returns.

Source: computation by the author (data: Yahoo! Finance website).

Risk measures of the USD Coin returns

The R program that you can download above also allows you to compute risk measures about the returns of the USD Coin.

Table 3 below presents the following risk measures estimated for the USD Coin:

The long-term volatility (the unconditional standard deviation estimated over the entire period)

The short-term volatility (the standard deviation estimated over the last three months)

The Value at Risk (VaR) for the left tail (the 5% quantile of the historical distribution)

The Value at Risk (VaR) for the right tail (the 95% quantile of the historical distribution)

The Expected Shortfall (ES) for the left tail (the average loss over the 5% quantile of the historical distribution)

The Expected Shortfall (ES) for the right tail (the average loss over the 95% quantile of the historical distribution)

The Stress Value (SV) for the left tail (the 1% quantile of the tail distribution estimated with a Generalized Pareto distribution)

The Stress Value (SV) for the right tail (the 99% quantile of the tail distribution estimated with a Generalized Pareto distribution)

Table 3. Risk measures for the USDC.

Source: computation by the author (data: Yahoo! Finance website).

The volatility is a global measure of risk as it considers all the returns. The Value at Risk (VaR), Expected Shortfall (ES) and Stress Value (SV) are local measures of risk as they focus on the tails of the distribution. The study of the left tail is relevant for an investor holding a long position in the XRP while the study of the right tail is relevant for an investor holding a short position in the XRP.

Why should I be interested in this post?

The post offers an opportunity for both newcomers and seasoned cryptocurrency enthusiasts to delve into the concept of stablecoins, gaining insights into how digital assets maintain stability amidst market volatility. Furthermore, the post highlights USDC’s role in fostering financial inclusion by enabling borderless transactions, appealing to readers passionate about democratizing finance. Additionally, exploring USDC’s significance in the burgeoning realm of decentralized finance (DeFi) could intrigue those interested in innovative financial technologies and investment opportunities. Examining USDC’s historical performance and market dynamics can offer valuable insights for investors and traders, while shedding light on its compliance measures and regulatory landscape can address concerns regarding legal risks, contributing to readers’ understanding and confidence in this digital asset.

Useful resources

Academic research about risk

Longin F. (2000) From VaR to stress testing: the extreme value approach Journal of Banking and Finance, N°24, pp 1097-1130.

Longin F. (2016) Extreme events in finance: a handbook of extreme value theory and its applications Wiley Editions.

Data

Yahoo! Finance

Yahoo! Finance Historical data for USDC

CoinMarketCap Historical data for USDC

About the author

The article was written in March 2024 by Snehasish CHINARA (ESSEC Business School, Grande Ecole Program – Master in Management, 2022-2024).

Tether: Unraveling the Impact of the Stablecoin on Modern Finance

May 20, 2024March 25, 2024 by Snehasish CHINARA

In this article, Snehasish CHINARA (ESSEC Business School, Grande Ecole Program – Master in Management, 2022-2024) explains the cryptocurrency Tether.

Historical context and background

Tether (USDT) emerged in July 2014 as a groundbreaking cryptocurrency designed to bridge the gap between traditional fiat currencies and the digital realm. Conceived by Brock Pierce, Craig Sellars, and Reeve Collins, Tether aimed to offer a stable alternative to the price volatility commonly associated with other cryptocurrencies like Bitcoin. Functioning as a stablecoin, Tether is pegged to the value of a fiat currency, primarily the US Dollar, maintaining a 1:1 ratio. This pegging mechanism provides a degree of price stability, making Tether an attractive option for traders and investors seeking to mitigate the risks inherent in the crypto market. Since its inception, Tether has grown to become one of the most widely used cryptocurrencies, playing a pivotal role in facilitating liquidity and serving as a gateway for funds within the broader digital asset ecosystem. Despite its popularity, Tether has faced scrutiny regarding its transparency and reserve backing, adding layers of complexity to its intriguing history within the crypto landscape.

Tether Logo

Source: Yahoo! Finance

Figure 1. Key Dates in Tether History

Source: Yahoo! Finance

Key features

Stability: Tether is designed to maintain a 1:1 peg with a fiat currency, typically the US Dollar. This pegging mechanism provides stability in value, reducing the volatility commonly associated with other cryptocurrencies.

Widespread Adoption: Tether is widely adopted across various cryptocurrency exchanges and platforms. Its broad acceptance makes it a popular choice for traders and investors.

Liquidity Provider: Tether serves as a crucial source of liquidity within the cryptocurrency market. Traders often use USDT as a safe haven during times of market turbulence.

Fast Transactions: Tether transactions are conducted on blockchain networks like Ethereum and Tron, enabling fast and efficient cross-border transactions compared to traditional banking systems.

Global Accessibility: Tether provides a borderless financial solution, allowing users to send and receive funds globally without the need for traditional banking intermediaries.

Smart Contract Compatibility: Tether is compatible with blockchain-based smart contracts, enabling developers to integrate it into decentralized applications (DApps) for various financial services.

Use cases

Trading Pairs: Tether is extensively used as a trading pair on cryptocurrency exchanges. It allows traders to quickly move in and out of positions while avoiding the market volatility associated with other digital assets.

Hedging: Investors often use Tether as a hedging tool to safeguard their portfolios against market fluctuations. By converting their holdings to USDT during uncertain times, investors can protect their capital.

Remittances: Tether facilitates cross-border remittances, offering a faster and potentially more cost-effective alternative to traditional money transfer services.

Stable Value Storage: Tether serves as a stable store of value, allowing users to preserve their wealth in a cryptocurrency that is less prone to price fluctuations compared to other volatile digital assets.

Decentralized Finance (DeFi): Tether is a common stablecoin used in decentralized finance protocols for lending, borrowing, and yield farming activities within the growing DeFi ecosystem.

Tokenized Assets: Tether is utilized to represent traditional assets in tokenized form on blockchain platforms, enabling fractional ownership and increased liquidity for real-world assets.

Controversy

While Tether has gained popularity for its stability and utility, it has also faced criticism and regulatory scrutiny, particularly regarding its reserve backing and transparency. The paper “Is Bitcoin Really Untethered?”, analyses Tether’s controversies revealing that the significant growth of Tether, the largest pegged cryptocurrency, may not solely be driven by organic investor demand but also by a scheme to artificially inflate cryptocurrency prices. By analyzing the blockchains of Bitcoin and Tether, the researchers found evidence suggesting that a major player on Bitfinex utilizes Tether to purchase large amounts of Bitcoin during price downturns, effectively supporting Bitcoin prices. This intervention is particularly pronounced near round-number price thresholds, indicating a strategic approach to price support. The data also suggests that Tether issuance correlates with a month-end need for dollar reserves, implying partial reserve backing. Overall, these findings lend support to the hypothesis that Tether’s growth is supply-driven and potentially manipulative.

Furthermore, the paper highlights the broader implications of these findings, suggesting that price manipulation in cryptocurrencies can have significant distortive effects beyond standard supply-and-demand dynamics. It highlights the need for external surveillance, monitoring, and regulatory frameworks in the cryptocurrency space, challenging the notion that innovative technologies alone can bypass the need for traditional oversight. The conclusion suggests that while cryptocurrencies offer new possibilities for financial innovation, they are not immune to the risks associated with dubious activities and speculative bubbles, which could ultimately lead to further price distortions and negative impacts on the market.

Technology and underlying blockchain

Tether (USDT), a the stablecoin, utilizes blockchain technology across various networks to provide a digital asset pegged to traditional fiat currencies. The Ethereum-based ERC-20 version is the most prevalent, benefiting from Ethereum’s widespread adoption and smart contract capabilities, making it a cornerstone for decentralized exchanges and DeFi applications. Tether also operates on the Tron blockchain (TRC-20), offering faster transactions and reduced fees, particularly appealing for high-frequency trading. Acknowledging the demand for scalability and cost-effectiveness, Tether has expanded to alternative blockchains like Binance Smart Chain and Solana. These adaptations highlight Tether’s commitment to meeting diverse market needs. Managed by Tether Limited, the stablecoin asserts stability through regular audits and claims of holding equivalent fiat reserves, although controversies have arisen regarding transparency. The dynamic interplay of Tether across various blockchains underscores its pivotal role in the evolving landscape of digital finance.

Supply of coins

The market supply of Tether (USDT), a leading stablecoin, plays a crucial role in the broader cryptocurrency ecosystem. Tether’s supply dynamics are intrinsically linked to its unique issuance mechanism. Tether Limited, the company behind USDT, mints new tokens by receiving equivalent amounts of fiat currency, primarily the US Dollar, in its reserves. This issuance process is supposed to ensure a 1:1 peg between USDT and the underlying fiat currency, promoting price stability.

The market supply of Tether expands as demand for the stablecoin increases. Traders and investors often turn to USDT as a safe haven during times of high volatility, effectively increasing the circulating supply. This heightened demand results in additional Tether being issued to maintain the peg, thus influencing the overall supply in the market.

Monitoring Tether’s supply is of particular interest due to its significant impact on liquidity within the cryptocurrency space. An influx of USDT into the market provides traders with a reliable means to navigate price fluctuations without fully exiting the crypto market, enhancing liquidity and potentially mitigating market volatility.

Historical data for Tether

How to get the data?

The Tether is popular cryptocurrency on the market, and historical data for the Tether such as prices and volume traded can be easily downloaded from the internet sources such as Yahoo! Finance, Blockchain.com & CoinMarketCap. For example, you can download data for Tether on Yahoo! Finance (the Yahoo! code for Tether is USDT-USD).

Figure 1. Tether data

Source: Yahoo! Finance.

Historical data for the Tether market prices

Exploring the historical market price of Tether (USDT) unveils a wealth of insights into the cryptocurrency’s role and its impact on the broader market. The stability of Tether, designed to maintain a 1:1 peg with traditional fiat currencies, is reflected in its price history. Observing deviations from this peg over time provides a gauge of Tether’s effectiveness as a stablecoin. Moreover, fluctuations in Tether’s historical price serve as a barometer for market sentiment, indicating periods of increased demand for stability during cryptocurrency market volatility. Tether’s price movements also offer a lens into liquidity trends, showcasing its role in various financial activities within the crypto ecosystem. Crucially, analyzing Tether’s historical price can illuminate market responses to controversies, regulatory developments, and its correlation with other major cryptocurrencies. Understanding these dynamics is essential for investors and traders seeking to navigate the intricate landscape of digital assets and stablecoins.

Figure 2 below represents the evolution of the price of Tether in US dollar over the period Nov 2017 – Dec 2023. The price corresponds to the “closing” price (observed at 10:00 PM CET at the end of the month).

Figure 2. Evolution of the Tether price

Source: Yahoo! Finance.

R program

The R program below written by Shengyu ZHENG allows you to download the data from Yahoo! Finance website and to compute summary statistics and risk measures about the Ethereum.

Data file

The R program that you can download above allows you to download the data for the Ethereum from the Yahoo! Finance website. The database starts on December, 2017.

Table 1 below represents the top of the data file for the Ethereum downloaded from the Yahoo! Finance website with the R program.

Table 1. Top of the data file for the Tether

Source: computation by the author (data: Yahoo! Finance website).

Python code

You can download the Python code used to download the data from Yahoo! Finance.

Python script to download Ethereum historical data and save it to an Excel sheet::

import yfinance as yf

import pandas as pd

# Define the ticker symbol for Tether

eth_ticker = “USDT-USD”

# Define the date range for historical data

start_date = “2020-01-01”

end_date = “2022-01-01”

# Download historical data using yfinance

usdt_data = yf.download(eth_ticker, start=start_date, end=end_date)

# Create a Pandas DataFrame from the downloaded data

usdt_df = pd.DataFrame(usdt_data)

# Define the Excel file path

excel_file_path = “tether_historical_data.xlsx”

# Save the data to an Excel sheet

usdt_df.to_excel(excel_file_path, sheet_name=”USDT Historical Data”)

print(f”Data saved to {excel_file_path}”)

# Make sure you have the required libraries installed and adjust the “start_date” and “end_date” variables to the desired date range for the historical data you want to download.

Evolution of the Tether

Figure 3 below gives the evolution of the Tether on a daily basis.

Figure 3. Evolution of the Tether.

Source: computation by the author (data: Yahoo! Finance website).

Figure 4 below gives the evolution of the Tether returns from November 09, 2017 to December 31, 2022 on a daily basis.

Figure 4. Evolution of the Tether returns.

Source: computation by the author (data: Yahoo! Finance website).

Summary statistics for the Ethereum

The R program that you can download above also allows you to compute summary statistics about the returns of the Tether.

Table 4 below presents the following summary statistics estimated for the Ethereum:

The mean

The standard deviation (the squared root of the variance)

The skewness

The kurtosis.

The mean, the standard deviation / variance, the skewness, and the kurtosis refer to the first, second, third and fourth moments of statistical distribution of returns respectively.

Table 2. Summary statistics for Tether.

Source: computation by the author (data: Yahoo! Finance website).

Statistical distribution of the Tether returns

Historical distribution

Figure 5 represents the historical distribution of the Tether daily returns for the period from November 09, 2017 to December 31, 2022.

Figure 5. Historical Tether distribution of the returns.

Source: computation by the author (data: Yahoo! Finance website).

Gaussian distribution

Figure 6 below represents the Gaussian distribution of the Tether daily returns with parameters estimated over the period from November 09, 2017 to December 31, 2022.

Figure 6. Gaussian distribution of the Tether returns.

Source: computation by the author (data: Yahoo! Finance website).

Risk measures of the Tether returns

The R program that you can download above also allows you to compute risk measures about the returns of the tether.

Table 3 below presents the following risk measures estimated for the Ethereum:

The long-term volatility (the unconditional standard deviation estimated over the entire period)

The short-term volatility (the standard deviation estimated over the last three months)

The Value at Risk (VaR) for the left tail (the 5% quantile of the historical distribution)

The Value at Risk (VaR) for the right tail (the 95% quantile of the historical distribution)

The Expected Shortfall (ES) for the left tail (the average loss over the 5% quantile of the historical distribution)

The Expected Shortfall (ES) for the right tail (the average loss over the 95% quantile of the historical distribution)

The Stress Value (SV) for the left tail (the 1% quantile of the tail distribution estimated with a Generalized Pareto distribution)

The Stress Value (SV) for the right tail (the 99% quantile of the tail distribution estimated with a Generalized Pareto distribution)

Table 5. Risk measures for the Tether.

Source: computation by the author (data: Yahoo! Finance website).

The volatility is a global measure of risk as it considers all the returns. The Value at Risk (VaR), Expected Shortfall (ES) and Stress Value (SV) are local measures of risk as they focus on the tails of the distribution. The study of the left tail is relevant for an investor holding a long position in the XRP while the study of the right tail is relevant for an investor holding a short position in the XRP.

Why should I be interested in this post?

Tether is a compelling subject for students, especially those in finance, economics, business, and technology. Ripple’s focus on revolutionizing cross-border transactions and its unique blockchain technology offer insights into innovations in financial technology. Exploring Tether provides a deeper understanding of blockchain, cryptocurrency markets, stable coins, regulatory challenges, and the practical applications of decentralized systems. Students can gain valuable knowledge about market dynamics, investment opportunities, and the intersection of technology and finance by delving into the complexities of Tether and its impact on the financial industry.

Useful resources

Academic research about risk

Longin F. (2000) From VaR to stress testing: the extreme value approach Journal of Banking and Finance, N°24, pp 1097-1130.

Longin F. (2016) Extreme events in finance: a handbook of extreme value theory and its applications Wiley Editions.

Data

Yahoo! Finance

Yahoo! Finance Historical data for Tether

CoinMarketCap Historical data for Tether

About the author

The article was written in January 2024 by Snehasish CHINARA (ESSEC Business School, Grande Ecole Program – Master in Management, 2022-2024).

XRP: Pioneering Financial Revolution

May 20, 2024March 25, 2024 by Snehasish CHINARA

In this article, Snehasish CHINARA (ESSEC Business School, Grande Ecole Program – Master in Management, 2022-2024) explains the cryptocurrency XRP/Ripple.

Historical context and background

XRP, the digital currency associated with the Ripple network, emerged against the backdrop of a growing interest in blockchain technology and its potential applications beyond cryptocurrencies. The development of Ripple began in 2012 when Jed McCaleb, Chris Larsen, and Arthur Britto joined forces to create a decentralized digital currency system. Ripple Labs, the company behind XRP, aimed to address the inefficiencies in traditional cross-border payments by providing a fast and cost-effective alternative. Unlike Bitcoin, which relies on a proof-of-work consensus mechanism, Ripple utilizes a unique consensus algorithm called the Ripple Protocol Consensus Algorithm (RPCA). The XRP Ledger, the underlying technology, is designed to facilitate quick and secure transactions, making it particularly appealing for financial institutions. Over the years, Ripple has garnered both support and criticism within the crypto community due to its centralized nature and ongoing legal challenges. Nevertheless, its focus on facilitating seamless global transactions has positioned XRP as a significant player in the evolving landscape of digital assets.

XRP Logo

Source: Yahoo! Finance

Figure 1. Key Dates in XRP History

Source: Yahoo! Finance and other internet sources

Key features and use cases

Fast and Low-Cost Transactions: One of the primary features of XRP is its speed and cost-effectiveness. The XRP Ledger is capable of processing transactions in just a few seconds, making it significantly faster than traditional banking systems and some other cryptocurrencies. The low transaction fees associated with XRP contribute to its appeal for cross-border payments.

Liquidity and Scalability: XRP is designed to handle a high volume of transactions, providing liquidity for financial institutions. This scalability is crucial for the adoption of XRP in large-scale financial applications, including remittances and institutional transfers.

Interoperability: Ripple aims to facilitate interoperability between different financial systems. XRP can act as a bridge currency between fiat currencies, enabling seamless and efficient transactions across borders. This interoperability is particularly valuable in the context of global finance.

Decentralization with Unique Consensus Algorithm: While Ripple has faced criticism for some aspects of centralization, the XRP Ledger employs the Ripple Protocol Consensus Algorithm (RPCA) for transaction validation. This consensus mechanism is more energy-efficient compared to proof-of-work used by some other cryptocurrencies.

Partnerships with Financial Institutions: Ripple has formed partnerships with various financial institutions, including banks and payment service providers. The aim is to leverage XRP for real-time, cross-border payments, reducing settlement times and costs for these institutions.

Smart Contracts and Tokenization: Ripple has also explored adding smart contract functionality to the XRP Ledger, expanding its use cases beyond simple transactions. Additionally, the platform has the potential for tokenization of real-world assets, allowing for the representation of various assets on the blockchain.

Stability and Predictable Supply: XRP has a fixed supply of 100 billion tokens, with a portion held by Ripple Labs. This fixed supply aims to provide stability and predictability, which could be attractive for businesses and investors.

While XRP has faced regulatory challenges and debates about its decentralization, its unique features and focus on solving real-world financial issues position it as a cryptocurrency with substantial potential in the global financial landscape.

Technology and underlying blockchain

XRP, the cryptocurrency associated with the Ripple network, operates on a distinct technological framework, utilizing a consensus algorithm that sets it apart from traditional proof-of-work systems. At the heart of XRP’s technology is the XRP Ledger, a decentralized blockchain that enables fast and secure transactions. The unique consensus mechanism employed by Ripple is known as the Ripple Protocol Consensus Algorithm (RPCA). Unlike the energy-intensive mining processes seen in proof-of-work systems, RPCA operates on a consensus model that involves a network of independent validators reaching agreement on the order and validity of transactions. This consensus mechanism allows the XRP Ledger to achieve high throughput and swift confirmation times, making it well-suited for the efficient processing of cross-border payments and financial transactions. Additionally, the XRP Ledger supports the issuance of various tokens, potentially expanding its use cases beyond its native cryptocurrency. Despite debates about the decentralization of Ripple, the technology behind XRP continues to evolve, showcasing a commitment to addressing the challenges and opportunities in the rapidly evolving blockchain and cryptocurrency space. Additionally, the platform has explored the integration of smart contract functionality, opening possibilities for more complex and programmable transactions. The focus on scalability, interoperability, and speed positions XRP as a blockchain solution tailored for the demands of the global financial industry, particularly in the context of cross-border payments and remittances.

Supply of coins

The supply dynamics of XRP, the native cryptocurrency of the Ripple network, play a crucial role in shaping its market characteristics. Unlike Bitcoin, which relies on a mining process to gradually release new coins into circulation, XRP was created with its entire supply generated at inception. XRP has a fixed maximum supply of 100 billion coins, a feature that distinguishes it from some other cryptocurrencies with potentially infinite supplies. Notably, a substantial portion of the XRP supply is held by Ripple Labs, the company behind the cryptocurrency. Approximately 55 billion XRP are held in escrow by Ripple Labs, the company behind the development of the Ripple protocol. This escrow mechanism is designed to release a specific amount of XRP into circulation each month, reducing the potential for market manipulation and ensuring a predictable supply trajectory.

This allocation has been a point of discussion and scrutiny within the crypto community, with debates surrounding the potential impact of such centralization on the coin’s decentralization ethos. Ripple has taken steps to address concerns, implementing strategies such as the escrow system, which locks a large amount of XRP in time-released contracts to be gradually released into circulation. The controlled release aims to provide transparency and mitigate concerns related to sudden market influxes. The fixed supply, along with Ripple’s strategic initiatives, contributes to the stability and predictability of XRP in the market, influencing investor perceptions and shaping the overall market dynamics of the cryptocurrency.

Figure 2. Number of XRP Transaction per Day

Source: BitInfoCharts (Ethereum Transactions historical chart)

Historical data for XRP

How to get the data?

The XRP is popular cryptocurrency on the market, and historical data for the XRP such as prices and volume traded can be easily downloaded from the internet sources such as Yahoo! Finance, Blockchain.com & CoinMarketCap. For example, you can download data for XRP on Yahoo! Finance (the Yahoo! code for XRP is XRP-USD).

Figure 3. XRP data

Source: Yahoo! Finance

Historical data for the XRP market prices

Access to historical data on XRP, the cryptocurrency affiliated with Ripple, offers investors valuable insights and tools for decision-making. By analyzing past price trends and patterns, investors can better anticipate potential movements in XRP’s value, aiding in strategic buy or sell decisions. Historical data also serves as a record of XRP’s volatility, allowing investors to assess and manage risks effectively. Examining market sentiment during different periods provides a nuanced understanding of external factors that may impact XRP, such as regulatory developments or technological upgrades. Additionally, historical performance comparisons with other cryptocurrencies or traditional assets help investors evaluate XRP’s relative strength and potential for returns, informing optimal portfolio management. Event analysis around significant occurrences, such as partnerships or regulatory changes, assists in anticipating market reactions to future events. Furthermore, historical data aids in identifying market cycles, supporting investors in aligning their strategies with the prevailing market conditions. Recognizing key support and resistance levels based on historical prices enhances risk management by guiding entry and exit points. While historical data is a valuable tool, investors should blend it with current market analysis and fundamental factors for comprehensive decision-making, considering the inherent unpredictability of the cryptocurrency market.

Figure 4 below represents the evolution of the price of XRP in US dollar over the period Nov 2017 – Dec 2023. The price corresponds to the “closing” price (observed at 10:00 PM CET at the end of the month).

Figure 4. Evolution of the XRP price

Source: Yahoo! Finance

R program

The R program below written by Shengyu ZHENG allows you to download the data from Yahoo! Finance website and to compute summary statistics and risk measures about the XRP.

Data file

The R program that you can download above allows you to download the data for the Ethereum from the Yahoo! Finance website. The database starts on December, 2017.

Table 3 below represents the top of the data file for the Ethereum downloaded from the Yahoo! Finance website with the R program.

Table 3. Top of the data file for XRP.

Source: computation by the author (data: Yahoo! Finance website)

Python code

You can download the Python code used to download the data from Yahoo! Finance.

Python script to download XRP historical data and save it to an Excel sheet::

import yfinance as yf

import pandas as pd

# Define the ticker symbol for Ethereum

xrp_ticker = “XRP-USD”

# Define the date range for historical data

start_date = “2020-01-01”

end_date = “2022-01-01”

# Download historical data using yfinance

xrp_data = yf.download(xrp_ticker, start=start_date, end=end_date)

# Create a Pandas DataFrame from the downloaded data

xrp_df = pd.DataFrame(xrp_data)

# Define the Excel file path

excel_file_path = “xrp_historical_data.xlsx”

# Save the data to an Excel sheet

xrp_df.to_excel(excel_file_path, sheet_name=”XRP Historical Data”)

print(f”Data saved to {excel_file_path}”)

# Make sure you have the required libraries installed and adjust the “start_date” and “end_date” variables to the desired date range for the historical data you want to download.

Evolution of the Ethereum

Figure 5 below gives the evolution of the Ethereum on a daily basis.

Figure 5. Evolution of the XRP.

Source: computation by the author (data: Yahoo! Finance website).

Figure 6 below gives the evolution of the Ethereum returns from November 09, 2017 to December 31, 2022 on a daily basis.

Figure 6. Evolution of the XRP returns.

Source: computation by the author (data: Yahoo! Finance website).

Summary statistics for the Ethereum

The R program that you can download above also allows you to compute summary statistics about the returns of the Ethereum.

Table 4 below presents the following summary statistics estimated for the Ethereum:

The mean

The standard deviation (the squared root of the variance)

The skewness

The kurtosis.

The mean, the standard deviation / variance, the skewness, and the kurtosis refer to the first, second, third and fourth moments of statistical distribution of returns respectively.

Table 4. Summary statistics for XRP

Source: computation by the author (data: Yahoo! Finance website).

Statistical distribution of the Ethereum returns

Figure 7 represents the historical distribution of the Ethereum daily returns for the period from November 09, 2017 to December 31, 2022.

Figure 7. Historical XRP distribution of the returns.

Source: computation by the author (data: Yahoo! Finance website).

Gaussian distribution

Figure 8 below represents the Gaussian distribution of the XRP daily returns with parameters estimated over the period from November 09, 2017 to December 31, 2022.

Figure 9. Gaussian distribution of the XRP returns.

Source: computation by the author (data: Yahoo! Finance website).

Risk measures of the Ethereum returns

The R program that you can download above also allows you to compute risk measures about the returns of the Ethereum.

Table 5 below presents the following risk measures estimated for the Ethereum:

The long-term volatility (the unconditional standard deviation estimated over the entire period)

The short-term volatility (the standard deviation estimated over the last three months)

The Value at Risk (VaR) for the left tail (the 5% quantile of the historical distribution)

The Value at Risk (VaR) for the right tail (the 95% quantile of the historical distribution)

The Expected Shortfall (ES) for the left tail (the average loss over the 5% quantile of the historical distribution)

The Expected Shortfall (ES) for the right tail (the average loss over the 95% quantile of the historical distribution)

The Stress Value (SV) for the left tail (the 1% quantile of the tail distribution estimated with a Generalized Pareto distribution)

The Stress Value (SV) for the right tail (the 99% quantile of the tail distribution estimated with a Generalized Pareto distribution)

Table 5. Risk measures for the XRP.

Source: computation by the author (data: Yahoo! Finance website).

The volatility is a global measure of risk as it considers all the returns. The Value at Risk (VaR), Expected Shortfall (ES) and Stress Value (SV) are local measures of risk as they focus on the tails of the distribution. The study of the left tail is relevant for an investor holding a long position in the XRP while the study of the right tail is relevant for an investor holding a short position in the XRP.

Why should I be interested in this post?

XRP, the cryptocurrency associated with Ripple, is a compelling subject for students, especially those in finance, economics, business, and technology. Ripple’s focus on revolutionizing cross-border transactions and its unique blockchain technology offer insights into innovations in financial technology. Exploring XRP provides a deeper understanding of blockchain, cryptocurrency markets, regulatory challenges, and the practical applications of decentralized systems. Students can gain valuable knowledge about market dynamics, investment opportunities, and the intersection of technology and finance by delving into the complexities of XRP and its impact on the financial industry.

Useful resources

Academic research about risk

Longin F. (2000) From VaR to stress testing: the extreme value approach Journal of Banking and Finance, N°24, pp 1097-1130.

Longin F. (2016) Extreme events in finance: a handbook of extreme value theory and its applications Wiley Editions.

Data

Yahoo! Finance

Yahoo! Finance Historical data for XRP

CoinMarketCap Historical data for XRP

About the author

The article was written in January 2024 by Snehasish CHINARA (ESSEC Business School, Grande Ecole Program – Master in Management, 2022-2024).

How to get crypto data

March 25, 2024October 4, 2023 by Snehasish CHINARA

How to get crypto data

In this article, Snehasish CHINARA (ESSEC Business School, Grande Ecole Program – Master in Management, 2022-2024) explains how to get crypto data.

Types of data

Number of coins

The information on the number of coins in circulation for a given currency is important to compute its market capitalization. Market capitalization is calculated by multiplying the current price of the cryptocurrency by its circulating number of coins (supply). This metric gives a rough estimate of the cryptocurrency’s total value within the market and its relative size compared to other cryptocurrencies. A lower circulating supply often implies a greater level of scarcity and rarity.

For cryptocurrencies (unlike fiat money), the number of coins in circulation is given by a mathematical formula. The number of coins may be limited (like the Bitcoin) or unlimited (like Ethereum and Dogecoin) over time.

Cryptocurrencies with limited supplies, such as Bitcoin’s maximum supply of 21 million coins, can be perceived as more valuable due to their finite nature. Scarcity can contribute to investor interest and potential price appreciation over time. A lower circulating supply might indicate the potential for future adoption and value appreciation, as the limited supply can create scarcity-driven demand, especially if the cryptocurrency gains more utility and usage.

Bitcoin’s blockchain also relies on a key equation to steadily allow new BTC to be introduced. The equation below gives the total supply of bitcoins:

Total supply of bitcoins

Figure 1 below represents the evolution of the supply of Bitcoins.

Figure 1. Evolution of the supply of Bitcoins

Source: computation by the author.

Market price of a coin

The market price of a cryptocurrency in the market holds crucial insights into how well the cryptocurrency is faring. Although not the sole factor, the market price significantly contributes to evaluating the cryptocurrency’s performance and its prospects. The market price of a cryptocurrency is a dynamic and intricate element that reflects a multitude of factors, both intrinsic and extrinsic. The gradual rise in market value over time indicates a willingness among investors and traders to offer higher prices for the cryptocurrency. This signifies a rising interest and strong belief in the project’s potential for the future. The market price reflects the collective sentiment of investors and traders. Comparing the market price of a cryptocurrency to other similar cryptocurrencies or benchmark assets like Bitcoin can provide insights into its relative strength and performance within the market. A rising market price can indicate increasing adoption of the cryptocurrency for various use cases. Successful projects tend to attract more users and real-world applications, which can drive up the price.

The value of cryptocurrencies in the market is influenced by a variety of elements, with each factor contributing uniquely to their pricing. One of the most significant influences is market sentiment and investor psychology. These factors can cause prices to shift based on positive news, regulatory changes, or reactive selling due to fear. Furthermore, the real-world implementation and usage of a cryptocurrency are crucial for its prosperity. Concrete use cases such as Decentralized Finance (DeFi), Non-Fungible Tokens (NFTs), and international transactions play a vital role in creating demand and propelling price appreciation. Meanwhile, adherence to basic economic principles is evident in the supply-demand dynamics, where scarcity due to limited issuance, halving events, and token burns interact with the balance between supply and demand.

With the number of coins in circulation, the information on the price of coins for a given currency is also important to compute its market capitalization.

Figure 2 below represents the evolution of the price of Bitcoin in US dollar over the period October 2014 – August 2023. The price corresponds to the “closing” price (observed at 10:00 PM CET at the end of the month).

Figure 2. Evolution of the Bitcoin price

Source: computation by the author (data source: Yahoo! Finance).

Trading volume

Trading volume is crucial when assessing the health, reliability, and potential price movements of a cryptocurrency. Trading volume refers to the total amount of a cryptocurrency that is bought and sold within a specific time frame, typically measured in units of the cryptocurrency (e.g., BTC) or in terms of its equivalent value in another currency (e.g., USD).

Trading volume directly mirrors market liquidity, with higher volumes indicative of more liquid markets. This liquidity safeguards against drastic price fluctuations when trading, contrasting with low-volume scenarios that can breed volatility, where even a single substantial trade may disproportionately shift prices. Price alterations are most reliable and meaningful when accompanied by substantial trading volume. Price movements upheld by heightened volume often hold greater validity, potentially pointing to more pronounced market sentiment. When price surges parallel rising trading volume, it suggests a sustainable upward trajectory. Conversely, low trading volume amid rising prices may hint at a forthcoming correction or reversal. Scrutinizing the correlation between price oscillations and trading volume can uncover potential divergences. For instance, ascending prices coupled with dwindling trading volume may suggest a weakening trend.

Figure 3 below represents the evolution of the monthly trading volume of Bitcoin over the period October 2014 – July 2023.

Figure 3. Evolution of the trading volume of Bitcoin

Source: computation by the author (data source: Yahoo! Finance).

Bitcoin data

You can download the Excel file with Bitcoin data used in this post as an illsutration.

Python code

You can download the Python code used to download the data from Yahoo! Finance.

Python script to download Bitcoin historical data and save it to an Excel sheet:

import yfinance as yf
import pandas as pd

# Define the ticker symbol and date range
ticker_symbol = “BTC-USD”
start_date = “2020-01-01”
end_date = “2023-01-01”

# Download historical data using yfinance
data = yf.download(ticker_symbol, start=start_date, end=end_date)

# Create a Pandas DataFrame
df = pd.DataFrame(data)

# Create a Pandas Excel writer object
excel_writer = pd.ExcelWriter(‘bitcoin_historical_data.xlsx’, engine=’openpyxl’)

# Write the DataFrame to an Excel sheet
df.to_excel(excel_writer, sheet_name=’Bitcoin Historical Data’)

# Save the Excel file
excel_writer.save()

print(“Data has been saved to bitcoin_historical_data.xlsx”)

# Make sure you have the required libraries installed and adjust the “start_date” and “end_date” variables to the desired date range for the historical data you want to download.

APIs

Calculating the total number of Bitcoins in circulation over time
Access – Bitcoin Blockchain data
By running a Bitcoin node or by using blockchain data providers like Blockchain.info, Blockchair, or a similar service.

Extract Block Data: Once you have access to the blockchain data, you would need to extract information from each block. Each block contains a record of the transactions that have occurred, including the creation (mining) of new Bitcoins in the form of a “Coinbase” transaction.

Calculate Cumulative Supply: You can calculate the cumulative supply of Bitcoins by adding up the rewards from each block’s Coinbase transaction. Initially, the block reward was 50 Bitcoins, but it halves approximately every four years due to the Bitcoin halving events. So, you’ll need to account for these halving in your calculations.

Code – python

import requests

# Replace ‘YOUR_API_KEY’ with your CoinMarketCap API key
api_key = ‘YOUR_API_KEY’

# Define the endpoint URL for CoinMarketCap’s API
url = ‘https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest’

# Define the parameters for the request
params = {
‘symbol’: ‘BTC’,
‘convert’: ‘USD’,
‘CMC_PRO_API_KEY’: api_key
}

# Send the request to CoinMarketCap
response = requests.get(url, params=params)

# Parse the response JSON
data = response.json()

# Extract the circulating supply from the response
circulating_supply = data[‘data’][‘BTC’][‘circulating_supply’]

print(f”Current circulating supply of Bitcoin: {circulating_supply} BTC”)

## Replace ‘YOUR_API_KEY’ with your actual CoinMarketCap API key.

Why should I be interested in this post?

Cryptocurrency data is becoming increasingly relevant in these fields, offering opportunities for research, data analysis skill development, and even career prospects. Whether you’re aiming to conduct research, stay informed about the evolving financial landscape, or simply enhance your data analysis abilities, understanding how to access and work with crypto data is an asset. Plus, as the cryptocurrency industry continues to grow, this knowledge can open new career paths and improve your personal finance decision-making. In a rapidly changing world, diversifying your knowledge with cryptocurrency data acquisition skills can be a wise investment in your future.

Useful resources

APIs

CoinMarketCap Source of API keys and program

CoinGecko Source of API keys and Programs

CryptoNews Source of API keys and Programs

Data sources

Yahoo! Finance Historical data for Bitcoin

Coinmarketcap Historical data for Bitcoin

Blockchain.com Market Data and charts on Bitcoin history

About the author

The article was written in October 2023 by Snehasish CHINARA (ESSEC Business School, Grande Ecole Program – Master in Management, (2022-2024).

The regulation of cryptocurrencies: what are we talking about?

March 5, 2022 by Hugo MEYER

The regulation of cryptocurrencies: what are we talking about?

In this article, Hugo MEYER (ESSEC Business School, Master in Strategy & Management of International Business (SMIB), 2020-2021) presents the regulation of cryptocurrencies.

Introduction

The first cryptocurrency – Bitcoin – launched in 2008 by Satoshi Nakamoto had for ambition to “break the rules and change the world”.

Thirteen years later, cryptocurrency represents a 2$ trillion market, with an increasing institutional presence, from crypto hedge funds to large banks. Behind this bewildering evolution, public authorities lagged behind, slowly empowering with feverish regulation actions.

The lack of regulation in this burgeoning area has created an opening for boundless fraud and money laundering, forcing some countries to get to grips with the cryptocurrency’s pitfalls.

What are cryptocurrencies?

Cryptocurrencies are at the edge of revolutionizing the way we’ve been trading since thousands of years. By definition, a cryptocurrency is an encrypted, digital, and decentralized medium of exchange that allows two parties that could be located everywhere on the globe to transfer funds directly, without relying on any trusted third party.

Instead of being secured by public institutions and/or companies, these transfers are carried out on the Blockchain which is a “digital database or ledger containing information that can be simultaneously used and shared within a large decentralized, publicly accessible network”.

Example: To make it simple, let’s say that A wants to send money to B. This transaction is included in a ‘block’. This block is broadcasted to every member in the network, and then validated or not by them. Once validated, the block is added to the chain, triggering the money to move from A to B.

Figure 1. Process of transaction with the blockchain
Schema of the blockchain
Source: Institut des actuaires.

This distributed network provides an indelible and transparent record of transactions as the chain cannot be counterfeited. If someone tried to change any information contained in one block, the different parties of the network would not approve the transaction as they could check the whole history of the blockchain and compare it to the new one.

Thus, many cryptocurrencies such as Bitcoin, Ethereum and Monero rely on public blockchains to allow transactions in complete security and transparency.

“I do think Bitcoin is the first money that has the potential to do something like change the world” – Peter THIEL.

What is the regulation about?

By definition, regulation tally with the act of controlling something, or enacting an official rule. What does it imply for cryptocurrencies?

A cryptocurrency is entirely defined by its creator, that must foremost determine its characteristics. This creation process is divided into three steps:

Pick or create its blockchain platform
Choose a consensus algorithm
Design the blockchain architecture.

His creator defines the rules around it, while the ecosystem built accordingly to these rules regulate it and make it functional. Once the crypto is launched, it is impossible to modify its architecture and the rules. In this way, a cryptocurrency cannot be regulated, even by his founder. Thus, authorities do not have any grip with cryptocurrencies in themselves. They are auto-regulated by their initial algorithms, and nothing else.

Thereby, what are we talking about when dealing with the regulation of cryptocurrency?

Cryptocurrencies are mainly exchanged through platforms called “exchanges” such as Coinbase, Binance or eToroX. The first existing regulation framework is the accessibility to these platforms. For most of them, requirements like providing its identity are requested, following the Know Your Customer (KYC) compliance.

Secondly, the regulatory framework for these platforms depends on where they are based. Each country has a different approach of cryptocurrency, meaning that the regulation can be different in any of them.

For example, cryptocurrency exchanges are legal in the United States and fall under the regulatory scope of the Bank Secrecy Act (BSA). Therefore, exchanges service providers must register with FinCEN, implement an anti-money laundering (AML) and combating the financing of terrorism (CFT) program, maintain appropriate records, and submit reports to the authorities. It does not mean their trading activities are regulated.

These requirements permit exchanges to operate as licensed Money Service Businesses (MSBs), leading regulators to focus on anti-money laundering (AML) and due diligence measures, but not trading (and all the aspects of market manipulation).

Given the lack of significant regulatory oversight of actual trading activity, it is not surprising to see many cryptocurrency exchanges carry out questionable activities, such as offering leverage to their clients and wash trading, during times of market instability. But these are not the only problems raised by the lack of regulation.

Why should exchanges be more regulated?

The blockchain is a recent technology, understood by a few. As regulation always comes after innovation, the crypto market has been sidelined by public authorities for many years. The question of regulating it has recently appeared in response to the many downsides incurred to cryptos.

Customer protection

When investing in cryptocurrencies, the customer is lacking protection. An investor could be facing fake websites, hacking, and platform bankrupts without any legal recourse to recover his money. These situations could never happen in a traditional investment as it is institutionally regulated. To become more secure, exchanges must follow the example of itBit, an US-based exchange oversighted by the New York Department of Financial Services (DFS) and registered as a bank.

Illegal Financial flows & crime

Cryptocurrency can be used for illicit transactions and for laundering criminal proceeds that may or may not have started as cryptocurrency. These illicit transactions occur on the dark web, including the purchase/sale of illicit drugs and debit and credit card information. According to a study published in 2019 by Oxford Academics, 76$ billion of illegal activity per year involve bitcoin, which represents half of total Bitcoin transactions.

Cryptos can also be used for ransomware attacks, like the one that shut down the Colonial Pipeline in May 2021. This attack was one of many others high-profile instances of hackers seeking Bitcoin ransoms, that should tend to multiply in the upcoming years.

Price stability

Blockchain technology has increasingly become a speculative tool for investing and achieving high returns in the short term, leading to market volatility. These fast and unpredictable price changes also have a direct impact on the velocity, where more and more people hold their cryptocurrencies instead of selling or using them.

Plus, the volatility of cryptos prices may let the market suffer from illiquidity. The notion of liquidity for a financial asset refers to the ease with which an asset can be bought or sold (without a strong price impact, e.g., limit implicit transaction costs).

Tax evasion

One of the first problem that arise from tax evasion is taxation. Many countries have their own regulatory framework, either taxing cryptos as an asset (Israel), a financial asset (Bulgaria), or even a foreign currency (Switzerland). Once the taxation rule found out, authorities will tackle another problem: The investors resistance to report their gains.

Taking the example of USA, authorities ask filers on their income tax forms – like any form of income – whether they received or made any transactions with cryptocurrency. However, third-party reporting in the sector is scarce; making it even more difficult to attribute gains to one natural person.

Thus, how can regulation allow the crypto market to take over these pitfalls?

Worldwide market regulation

“Bitcoin is not unregulated. It is regulated by algorithm instead of being regulated by government bureaucracies” – Andreas Antonopoulos

Despite being a global phenomenon, every country does not hang up with the same type of regulation.

First, some countries have expanded their laws on money laundering, counterterrorism, and organized crimes to include cryptocurrency markets, and require banks and other financial institutions that facilitate such markets to conduct all the due diligence requirements imposed under such laws. For instance, Australia and Canada recently enacted laws to bring cryptocurrency transactions and institutions that facilitate them under the ambit of money laundering and counter-terrorist financing laws.

Some jurisdictions have gone even further and imposed restrictions on investments in cryptocurrencies. Some countries – Algeria, Bolivia, Morocco, Vietnam – explicitly ban any and all activities involving cryptocurrencies. Qatar and Bahrain consider that their citizens are forbidden from engaging in any kind of activities involving cryptocurrencies locally but allow them to do so outside their borders.

There are also countries that, while not banning their citizens from investing in cryptocurrencies, impose indirect restrictions by hindering transactions involving cryptocurrencies, such as China, Iran, or Thailand.

A limited number of countries regulate initial coin offerings (ICOs), which use cryptocurrencies as a mechanism to raise funds. Of the jurisdictions that address ICOs, some (mainly China, Macau, and Pakistan) ban them altogether, while most tend to focus on regulating them.

When it comes to taxation, the challenge appears to be how to categorize cryptocurrencies and the specific activities involving them. This matters primarily because whether gains are categorized as income or capital gains invariably determines the applicable tax bracket. For instance, in Israel, cryptos gains are taxed as assets, while there are subject to income tax in Spain and Argentina.

Advocates of digital currencies say that accepting cryptocurrencies is much more relevant than rejecting it. For instance, El Salvador became the 7th of September 2021 the first country in the world to make Bitcoin a legal tender. One day after, the “Regulation of the Bitcoin Law” entered into force, that establishes standards of conducts supervised by the Superintendency of the Financial System (SSF), the equivalent of the Securities Exchange Commission (SEC) in the United States or the Autorité des Marchés Financiers (AMF) in France. This regulation will bring much more protection to Bitcoin users, while setting up numerous programs in cybersecurity, anti-money laundering, and tax evasion.

Conclusion

As Bitcoin – and other cryptocurrencies – become more and more popular, regulation will have to step up altogether, despite asking extensive questions on its bounding by International Authorities.

Economic threat, exacerbated risks and investigation complications are all issues that can be counteracted by regulation laws on the crypto market. Central banks will play a major role in this governance, going along with their traditional missions such as ensuring price stability and a proper operating financial system.

Nevertheless, regulation may lead to underestimated consequences. As it goes on, crypto investment will progressively become “mainstream” and dismiss the first and most powerful investors. This trend might also push innovators to take a step back from it, thus decreasing the number of cryptocurrencies created and newly innovative blockchains.

Useful resources

Academic research

Sean, F. Jonathan, R K. Talis, P. 2019. Sex, Drugs, and Bitcoin: How much illegal activity is financed through cryptocurrencies?” The Review of Financial Studies. Vol. 32, p. 1798-1853.

Business Analysis

L, S. 2016. Who is Satoshi Nakamoto, The Economist explains.

Thiemann, A. 2021. Cryptocurrencies: An empirical View from a Tax Perspective, JRC Working Papers on Taxation and Structural Reforms. No 12/2021, European Commission, Joint Research Centre, Seville, JRC126109.

Global Legal Research Directorate. 2018. Regulation of Cryptocurrency Around the World. LL File No. 2018-016036 LRA-D-PUB-002438.

Ryan, H. 2021. U.S. Officials send mixed messages on crypto regulation. Here’s what it all means for investors. NextAdvisor.

American Overseas, 2021. Washington Monthly: Catching Bitcoin tax evaders.

Alexis, G. 2021. Crypto doesn’t have to enable tax cheats Bloomberg Opinion.

Douma, S. 2016. Bitcoin: The pros and cons of regulation. s1453297.

About the author

The article was written in March 2022 by Hugo MEYER (ESSEC Business School, Master in Strategy & Management of International Business (SMIB), 2020-2021).

Cryptocurrencies

July 31, 2021 by Alexandre VERLET

Cryptocurrencies

In this article, Alexandre VERLET (ESSEC Business School, Master in Management, 2017-2021) explores explores the latest and most fashionable investment trend.

They are everywhere on the news, in (young) people’s daily conversations, and probably in a corner of your head if you have already invested a bit of money in them. Cryptocurrencies are a daily drama, as it allows people to make or lose big money in record time. Everyone’s heard of it, but few people actually understand where cryptos come from and how they work. You may not necessarily need that to invest in them in the short term, as simply following Elon Musk on twitter might be a quicker and more efficient way to predict its evolution. But in the long run, and to understand the impact it will have on society, you need to know what’s going on. For some, it might become an actual currency in the coming years and will compete with the national currencies. For others, regulation will eventually tame cryptos and people will therefore lose interest in them. What’s for sure is that a public debate will arise at some point, and you might as well have the keys to understand cryptos so you can forge your own opinion. So here we go.

What is a cryptocurrency?

In a nutshell, it’s a virtual currency. What makes it a completely different and original currency is that it is not centrally managed; in other terms, it is the user who has full control over the cryptocurrency in their possession (peer-to-peer). This process is done through the implementation of Blockchain technology: the latter is a distributed and decentralized data storage and transmission technology at its core. The most frequently used analogy is that of a ledger that is accessible to all, indestructible and unpublishable once the data is embedded in the system. Like cryptocurrency, the Blockchain also relies on peer to peer to operate in a decentralized manner. Note that Blockchain can be used for much more than cryptocurrency; being a database, this technology represents a potentially huge evolution in the way we (businesses) deal with data. However, it was with the advent of Bitcoin, the first of many cryptocurrencies, that the distributed blockchain was seen as a potential successor to existing storage technology. The main cryptocurrencies are Bitcoin- the world’s most widely used and legitimate cryptocurrency-, Ethereum – founded in 2015 and known for its enhanced architecture using “smart contracts”-, Litecoin – released in 2011, similar to Bitcoin but with a higher programmed supply limit (84 million units vs 21 million).

Where do cryptos come from?

Before cryptos as we know them were invented, some early cryptocurrency proponents already shared the goal of applying cutting-edge mathematical and computer science principles to solve what they perceived as practical and political shortcomings of “traditional” currencies. It goes back to the 1980s when an American cryptographer named David Chaum invented a “blinding” algorithm that allowed for secure, unalterable information exchanges between parties, laying the groundwork for future electronic currency transfers. Then, the late 1990s and early 2000s saw the rise of more conventional digital finance intermediaries, such as Elon Musk’s Paypal. But no true cryptocurrency emerged until the late 2000s when Bitcoin came onto the scene. Bitcoin is widely regarded as the first modern cryptocurrency, because it combined decentralized control, user anonymity, record-keeping via a blockchain, and built-in scarcity. It all began in 2008, when Satoshi Nakamoto (an anonymous person or group of people) published a white paper about the Bitcoin. Nakamoto then released Bitcoin to the public. In 2010, the very first Bitcoin purchase was made: an Internet user exchanged 10,000 Bitcoins for two pizzas. At today’s prices, that would be the equivalent of about 500 million euros: that’s a lot of money for a pizza. By late 2010, dozens of other cryptocurrencies started popping out as more and more people started to mine and exchange cryptos. It grew in legitimacy when it became accepted as a means of payment by major companies, such as WordPress, Microsoft or Tesla. As of May 2021, the cryptos’ market cap is $2 trillion.

How do cryptos work?

There are several concepts that you should know about in order to get how cryptos work. Cryptocurrencies use cryptographic protocols, or extremely complex code systems that encrypt sensitive data transfers, which make cryptos them virtually impossible to break, and thus to duplicate or counterfeit the protected currencies. These protocols also mask the identities of cryptocurrency users.Then the crypto’s blockchain records and stores all prior transactions and activity, validating ownership of all units of the currency at all times. Identical copies of the blockchain are stored in every node of the cryptocurrency’s software network — the network of decentralized server farms, run by miners, that continually record and authenticate cryptocurrency transactions. The term “miners” relates to the fact that miners’ work literally creates wealth in the form of brand-new cryptocurrency units. Miners serve as record-keepers for cryptocurrency communities, using vast amounts of computing power, often manifested in private server farms owned by mining collectives that comprise dozens of individuals. The scope of the operation is quite similar to the search for new prime numbers, which requires tremendous amounts of computing power. Miners’ work periodically creates new copies of the blockchain, adding recent, previously unverified transactions that aren’t included in any previous blockchain copy — effectively completing those transactions. Each addition is known as a block, which consist of all transactions executed since the last new copy of the blockchain was created. Sincce the cryptocurrencies’ supply and value are controlled by the activities of their users and highly complex protocols built into their governing codes, not the conscious decisions of central banks or other regulatory authorities, which is why cryptos are said to be decentralized. Although mining periodically produces new cryptocurrency units, most cryptocurrencies are designed to have a finite supply — a key guarantor of value. Generally, this means miners receive fewer new units per new block as time goes on. For instance, if current trends continue, observers predict that the last Bitcoin unit will be mined sometime around 2150.

Why are cryptocurrencies so successful?

You may be wondering why crypto-currencies are gaining so much momentum today. With no intrinsic value, and no commodity to fall back on, economically speaking it makes no sense for this market to reach such an astronomical price. There are two rationales that often come up in the argument for cryptocurrencies. On the one hand, the anonymity via cryptography provided by blockchain technology: as there is very little regulation in this industry yet, one can end up with astronomical amounts of money without necessarily having to pay taxes on it, as there is no centralized body to follow what is going on. The second reason is more sociological: since there are people mining and trading cryptocurrencies, the logic is that they must have value. The consequence is that other people join the rush, and so on until it becomes a global phenomenon. You could call it a crowd movement, or a 21st century digital gold rush.

But these two reasons don’t necessarily answer the question of why Bitcoin and all these other cryptocurrencies are valuable. To get a clear answer, we need to go back to the basics of economics: any value applied to a commodity or currency is subjective. That is, if we, as individuals, see value in it, the commodity in question has value. The snowball effect resulting from a group of people’s growing interest in a commodity is at the origin of any bubble, and from that point of view cryptos are a massive bubble. Which does not mean that it is a bad investment: after all, a bubble is a bubble when it blows up, but it might never happen.

Summary

To sum up, if you want to invest in cryptocurrencies, there are a couple of things you should consider. First, if you’re aiming for the long-term (if you believe cryptocurrencies will keep increasing in value as “deflationary currencies”) or the short-term (pure speculation). Second, you should examine the specific characteristics of the cryptos and see which best fits you in terms of anonymity, growth potential and liquidity. Last but not least, follow the latest regulation announcements on cryptos, such as central banks or governments comments on cryptos, which are a pretty good indicator of the crypto’s evolution on both the long and short term.

About the author

Article written in July 2021 by Alexandre VERLET (ESSEC Business School, Master in Management, 2017-2021).

December 2024: Top Posts of the SimTrade Blog about cryptos

Most Read Posts

SimTrade choice

Historical context and background

Key features

Scalability

Fast Transaction Speeds

Low Transaction Costs

Proof of History (PoH)

Support for Smart Contracts

Ecosystem and Development Tools

Interoperability

Use cases

Non-Fungible Tokens (NFTs)

Gaming and Virtual Worlds

Decentralized Autonomous Organizations (DAOs)

Tokenization of Real-World Assets

Technology and underlying blockchain

Supply of coins

Historical data for Solana

How to get the data?

Historical data for the Solana market prices

R program

Python code

Evolution of the Solana (SOL)

Summary statistics for the Solana (SOL)

Statistical distribution of the Solana (SOL) returns

Historical distribution

Gaussian distribution

Risk measures of the Solana (SOL) returns

Why should I be interested in this post?

Related posts on the SimTrade blog

About cryptocurrencies

About statistics

Useful resources

Academic research about risk

Data

About the author

Bitcoin est un rêve, un idéal, un espoir

Autres articles sur le blog

A propos de l’auteur

Historical context and background

Key features

Decentralization

Scrypt Algorithm

Fast Transactions

Low Transaction Fees

Meme Culture

Use cases

Tipping

Charitable Donations

E-commerce

Micropayments

Community Engagement

Experimental Projects

Technology and underlying blockchain

Supply of coins

Historical data for Doge Coin

How to get the data?

Historical data for the Doge Coin market prices

R program

Data file

Python code

Evolution of the Doge Coin

Summary statistics for the Doge Coin

Statistical distribution of the Doge Coin returns

Gaussian distribution

Risk measures of the Doge Coin returns

Why should I be interested in this post?

Related posts on the SimTrade blog

About cryptocurrencies

About statistics

Useful resources

Academic research about risk

Data

About the author

Historical context and background

Key features

Stability

Transparency