![\"](\"https:\/\/www.simtrade.fr\/blog_simtrade\/wp-content\/uploads\/2023\/07\/img_SimTrade_Photo1_Snehasish_Chinara.png\" "\\"\\"")
<\/a><\/p>\nIn this article, Snehasish CHINARA<\/a> (ESSEC Business School, Grande Ecole<\/i> Program – Master in Management, 2022-2024) explains how to get crypto data.<\/p>\n 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.<\/p>\n 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.<\/p>\n 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.<\/p>\n Bitcoin\u2019s blockchain also relies on a key equation to steadily allow new BTC to be introduced. The equation below gives the total supply of bitcoins:<\/p>\n Figure 1 below represents the evolution of the supply of Bitcoins.<\/p>\n Figure 1. Evolution of the supply of Bitcoins 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.<\/p>\n 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.<\/p>\n 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.<\/p>\n Figure 2 below represents the evolution of the price of Bitcoin in US dollar over the period October 2014 \u2013 August 2023. The price corresponds to the \u201cclosing\u201d price (observed at 10:00 PM CET at the end of the month).<\/p>\n Figure 2. Evolution of the Bitcoin price 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).<\/p>\n 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.<\/p>\n Figure 3 below represents the evolution of the monthly trading volume of Bitcoin over the period October 2014 \u2013 July 2023.<\/p>\n Figure 3. Evolution of the trading volume of Bitcoin You can download the Excel file with Bitcoin data used in this post as an illsutration.<\/p>\n You can download the Python code used to download the data from Yahoo! Finance.<\/p>\n Python script to download Bitcoin historical data and save it to an Excel sheet:<\/p>\n import yfinance as yf # Define the ticker symbol and date range # Download historical data using yfinance # Create a Pandas DataFrame # Create a Pandas Excel writer object # Write the DataFrame to an Excel sheet # Save the Excel file print(“Data has been saved to bitcoin_historical_data.xlsx”)<\/p>\n # Make sure you have the required libraries installed and adjust the \u201cstart_date\u201d and \u201cend_date\u201d variables to the desired date range for the historical data you want to download.<\/p>\n Calculating the total number of Bitcoins in circulation over time 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.<\/p>\n 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.<\/p>\n Code \u2013 python<\/p>\n import requests<\/p>\n # Replace ‘YOUR_API_KEY’ with your CoinMarketCap API key # Define the endpoint URL for CoinMarketCap’s API # Define the parameters for the request # Send the request to CoinMarketCap # Parse the response JSON # Extract the circulating supply from the response print(f”Current circulating supply of Bitcoin: {circulating_supply} BTC”)<\/p>\n ## Replace ‘YOUR_API_KEY’ with your actual CoinMarketCap API key.<\/p>\n 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.<\/p>\n \u25b6 Alexandre VERLET Cryptocurrencies<\/a><\/p>\n \u25b6 Youssef EL QAMCAOUI Decentralised Financing <\/a><\/p>\n \u25b6 Hugo MEYER The regulation of cryptocurrencies: what are we talking about?<\/a><\/p>\n CoinMarketCap Source of API keys and program<\/a><\/p>\n CoinGecko Source of API keys and Programs <\/a><\/p>\n CryptoNews Source of API keys and Programs <\/a><\/p>\n Yahoo! Finance Historical data for Bitcoin<\/a><\/p>\n Coinmarketcap Historical data for Bitcoin<\/a><\/p>\n Blockchain.com Market Data and charts on Bitcoin history <\/a><\/p>\n The article was written in October 2023 by Snehasish CHINARA<\/a> (ESSEC Business School, Grande Ecole<\/i> Program – Master in Management, (2022-2024).<\/p>\n","protected":false},"excerpt":{"rendered":"Types of data<\/h2>\n
Number of coins<\/h3>\n
![\"Total](\"https:\/\/www.simtrade.fr\/blog_simtrade\/wp-content\/uploads\/2023\/10\/img_Equation_Total_supply_Bitcoins.png\")
<\/p>\n
\n![\"\"](\"https:\/\/www.simtrade.fr\/blog_simtrade\/wp-content\/uploads\/2023\/10\/img_-Number_of_Bitcoin_in_Circulation-300x160.png\")
\nSource: computation by the author.<\/p>\nMarket price of a coin<\/h3>\n
\n![\"Evolution](\"https:\/\/www.simtrade.fr\/blog_simtrade\/wp-content\/uploads\/2023\/10\/img_Evolution_Bitcoin_price.png\")
\nSource: computation by the author (data source: Yahoo! Finance).<\/p>\nTrading volume<\/h3>\n
\n![\"Evolution](\"https:\/\/www.simtrade.fr\/blog_simtrade\/wp-content\/uploads\/2023\/10\/img_Evolution_Bitcoin_trading_volume.png\")
\nSource: computation by the author (data source: Yahoo! Finance).<\/p>\nBitcoin data<\/h2>\n
![\"Download](\"https:\/\/www.simtrade.fr\/blog_simtrade\/wp-content\/uploads\/2021\/05\/img_SimTrade_Btn_Download_Excel_file_US.png\" "\\"Download")
<\/a><\/p>\nPython code<\/h2>\n
\nimport pandas as pd<\/p>\n
\nticker_symbol = “BTC-USD”
\nstart_date = “2020-01-01”
\nend_date = “2023-01-01”<\/p>\n
\ndata = yf.download(ticker_symbol, start=start_date, end=end_date)<\/p>\n
\ndf = pd.DataFrame(data)<\/p>\n
\nexcel_writer = pd.ExcelWriter(‘bitcoin_historical_data.xlsx’, engine=’openpyxl’)<\/p>\n
\ndf.to_excel(excel_writer, sheet_name=’Bitcoin Historical Data’)<\/p>\n
\nexcel_writer.save()<\/p>\nAPIs<\/h2>\n
\nAccess \u2013 Bitcoin Blockchain data
\nBy running a Bitcoin node or by using blockchain data providers like Blockchain.info, Blockchair, or a similar service.<\/p>\n
\napi_key = ‘YOUR_API_KEY’<\/p>\n
\nurl = ‘https:\/\/pro-api.coinmarketcap.com\/v1\/cryptocurrency\/quotes\/latest’<\/p>\n
\nparams = {
\n‘symbol’: ‘BTC’,
\n‘convert’: ‘USD’,
\n‘CMC_PRO_API_KEY’: api_key
\n}<\/p>\n
\nresponse = requests.get(url, params=params)<\/p>\n
\ndata = response.json()<\/p>\n
\ncirculating_supply = data[‘data’][‘BTC’][‘circulating_supply’]<\/p>\nWhy should I be interested in this post?<\/h2>\n
Related posts on the SimTrade blog<\/h2>\n
Useful resources<\/h2>\n
APIs<\/h3>\n
Data sources<\/h3>\n
About the author<\/h2>\n