About thirty days ago I shared a chart on Price Discovery in this sub. There was a lot of interest in it and I promised to explain in detail a Bitcoin price discovery algorithm.
. I do so in this post. *this text post is a slightly shorter version of what I wrote in my blog
I applied price discovery algorithms to 5 Min OHLCV data from Bitmex and CME contracts and Bitstamp, Coinbase, HitBTC, Kraken, Poloniex, Binance, and OkEx BTCUSD/BTCUSDT markets from March 2016 to May 2020. Some exciting results I got was:
- Before the 2017/18 bull run, Bitfinex dominated the price discovery process. They started the run. But as the price increased, trades on other exchanges, Binance and Bitstamp played a more dominant role in leading the price up.
- Since then, CME Contracts and Bitmex contracts have had an increasing role in price discovery. Today Bitmex and CME Contracts play the most substantial role in determining the direction of Bitcoin price.
- In 2020, market dominance by Bitmex has been negatively correlated with price. Dominance by Bitfinex, Huobi and OkCoin has had high positive correlation with price.
Price discovery is the overall process of setting the price of an asset. Price discovery algorithms identify the leader exchanges whose traders define the price. Two approaches are most famous for use in Price Discovery. Gonzalo and Granger (1995) and Hasbrouck (1995). But they assume random walk, and a common efficient price. I do not feel comfortable assuming random walk and common efficient price in Bitcoin Markets. So I used this little know method by De Blasis (2019)
for this analysis. This work assumes that "the fastest price to reflect new information releases a price signal to the other slower price series." I thought this was valid in our market. It uses Markov Chains to measure Price Discovery. Without going into the mathematical details the summary steps used was:
De Blasis (2019)
- Data is first grouped into a daily interval. Then inside each daily interval's 5-minute candles, the change in prices between the current time t and previous time t-1 is calculated. The difference across the same time t across all exchanges in a given day is juxtaposed to create an initial matrix.
- The initial matrix is used to create a Transition Matrix, which measures the probability of price changing to something else at time t+1 for its state at t.
- Then other Markov Chain based algorithms are used to measure the influence an exchange at time t had over all other exchanges' price movement at time t+1 individually.
- Reduction and normalization is done to this data. In the end, each exchange receives a single number that sums to 1 for a given day.
names this number Price Leadership Share (PLS). High PLS indicates a large role in price discovery. As the sum of the numbers is 1, they can be looked at as a percentage contribution. I recommend reading the original paper
if you are interested to know more about the mathematical detail.
Data Andersen (2000)
argues that 5 Minute window provides the best trade-off between getting enough data and avoiding noise. In one of the first work on Bitcoin's Price Discovery, Brandvold et al. 2015
had used 5M window. So I obtained 5M OHLCV data using the following sources:
- Poloniex, Bitfinex, Binance and HitBTC: Exchange's API through CCXT.
- Huobi: Official Websocket Market API
- Coinbase: Official API using cbpro
- Kraken, Bitstamp, OkCoin: I created candles from the trade data obtained from Bitcoincharts
- OkEx: Bitdataset API
- CME: Okay, this was was supposed to be tricky and expensive. I broke a TOS and scraped the data for free, removing the expensive part from the equation. I will not go into detail about where I scraped this data.
- Bitmex: I got Bitmex data from the API.
Futures data are different from other data because multiple futures contract trades at the same time. I formed a single data from the multiple time series by selecting the nearest contract until it was three days from expiration. I used the next contract when the contract was three days from expiration. This approach was advocated by Booth et al ( 1999 )
I can't embed the chart on reddit so open this https://warproxxx.github.io/static/price_discovery.html
In the figure above, each colored line shows the total influence the exchange had towards the discovery of Bitcoin Price on that day. Its axis is on the left. The black line shows a moving average of the bitcoin price at the close in Bitfinex for comparison. The chart was created by plotting the EMA of price and dominance with a smoothing factor of 0.1. This was done to eliminate the noise. Let's start looking from the beginning. We start with a slight Bitfinex dominance at the start. When the price starts going up, Bitfinex's influence does too. This was the time large Tether printing was attributed to the rise of price by many individuals. But Bitfinex's influence wanes down as the price starts rising (remember that the chart is an exponential moving average. Its a lagging indicator). Afterward, exchanges like Binance and Bitstamp increase their role, and there isn't any single leader in the run. So although Bitfinex may have been responsible for the initial pump trades on other exchanges were responsible for the later rally.
CME contracts were added to our analysis in February 2018. Initially, they don't have much influence. On a similar work Alexandar and Heck (2019)
noted that initially CBOE contracts had more influence. CBOE later delisted Bitcoin futures so I couldn't get that data. Overall, Bitmex and CME contracts have been averaging around 50% of the role in price discovery. To make the dominance clear, look at this chart
where I add Bitmex Futures and Perp contract's dominance figure to create a single dominance index. There bitmex leads 936 of the total 1334 days (Bitfinex leads 298 days and coinbase and binance get 64 and 6 days). That is a lot. One possible reason for this might be Bitmex's low trading fee. Bitmex has a very generous -0.025% maker fee and price discovery tend to occur primarily in the market with smaller trading costs (Booth et al, 1999
). It may also be because our market is mature. In mature markets, futures lead the price discovery.
|Exchange ||bitmex_futures ||bitfinex ||coinbase ||bitmex ||okex ||binance ||cme ||bitstamp ||okcoin ||kraken ||poloniex |
|Days Lead ||571 ||501 ||102 ||88 ||34 ||12 ||8 ||7 ||6 ||4 ||1 |
Table 1: Days Lead
Out of 1334 days in the analysis, Bitmex futures leads the discovery in 571 days or nearly 43% of the duration. Bitfinex leads for 501 days. Bitfinex's high number is due to its extreme dominance in the early days.
|Exchange ||binance ||huobi ||cme ||okcoin ||bitmex_futures ||okex ||hitbtc ||kraken ||poloniex ||bitstamp ||bitfinex ||coinbase ||bitmex |
|Correlation ||0.809190 ||0.715667 ||0.648058 ||0.644432 ||0.577147 ||0.444821 ||0.032649 ||-0.187348 ||-0.365175 ||-0.564073 ||-0.665008 ||-0.695115 ||-0.752103 |
Table 2: Correlation between the close price and Exchange's dominance index
Binance, Huobi, CME, and OkCoin had the most significant correlation with the close price. Bitmex, Coinbase, Bitfinex, and Bitstamp's dominance were negatively correlated. This was very interesting. To know more, I captured a yearwise correlation.
| ||index ||2016 ||2017 ||2018 ||2019 ||2020 |
|0 ||bitfinex ||0.028264 ||-0.519791 ||0.829700 ||-0.242631 ||0.626386 |
|1 ||bitmex ||0.090758 ||-0.752297 ||-0.654742 ||0.052242 ||-0.584956 |
|2 ||bitmex_futures ||-0.011323 ||-0.149281 ||-0.458857 ||0.660135 ||0.095305 |
|3 ||bitstamp ||0.316291 ||-0.373688 ||0.600240 ||-0.255408 ||-0.407608 |
|4 ||coinbase ||-0.505492 ||-0.128336 ||-0.351794 ||-0.410874 ||-0.262036 |
|5 ||hitbtc ||0.024425 ||0.486229 ||0.104912 ||-0.200203 ||0.308862 |
|6 ||kraken ||0.275797 ||0.422656 ||0.294762 ||-0.064594 ||-0.192290 |
|7 ||poloniex ||0.177616 ||-0.087090 ||0.230987 ||-0.135046 ||-0.154726 |
|8 ||binance ||NaN ||0.865295 ||0.706725 ||-0.484130 ||0.265086 |
|9 ||okcoin ||NaN ||0.797682 ||0.463455 ||-0.010186 ||-0.160217 |
|10 ||huobi ||NaN ||0.748489 ||0.351514 ||-0.298418 ||0.434164 |
|11 ||cme ||NaN ||NaN ||-0.616407 ||0.694494 ||-0.012962 |
|12 ||okex ||NaN ||NaN ||-0.618888 ||-0.399567 ||0.432474 |
Table 3: Yearwise Correlation between the close price and Exchange's dominance index
Price movement is pretty complicated. If one factor, like a dominant exchange, could explain it, everyone would be making money trading. With this disclaimer out of the way, let us try to make some conclusions. This year Bitfinex, Huobi, and OkEx, Tether based exchanges, discovery power have shown a high correlation with the close price. This means that when the traders there become successful, price rises. When the traders there are failing, Bitmex traders dominate and then the price is falling. I found this interesting as I have been seeing the OkEx whale who has been preceding price rises in this sub. I leave the interpretation of other past years to the reader.
My analysis does not include market data for other derivative exchanges like Huobi, OkEx, Binance, and Deribit. So, all future market's influence may be going to Bitmex. I did not add their data because they started having an impact recently. A more fair assessment may be to conclude this as the new power of derivative markets instead of attributing it as the power of Bitmex. But Bitmex has dominated futures volume most of the time (until recently). And they brought the concept of perpetual swaps.
There is a lot in this data. If you are making a trading algo think there is some edge here. Someday I will backtest some trading logic based on this data. Then I will have more info and might write more. But, this analysis was enough for to shift my focus from a Bitfinex based trading algorithm to a Bitmex based one
. It has been giving me good results.
If you have any good ideas that you want me to write about or discuss further please comment. If there is enough interest in this measurement, I can setup a live interface that provides the live value.
bitcoin historical price data csv - Get historical data for the Bitcoin prices. You'll find the historical Bitcoin market data for the selected range of dates. The data can be viewed in daily, weekly or monthly time intervals. - To ensure that the value of Bitcoin is not compromised by an infinite supply, Satoshi Nakamoto wrote in a “halving event” that happens every 210,000 blocks. Bitcoincharts is the world's leading provider for financial and technical data related to the Bitcoin network. It provides news, markets, price charts and more. I used google apps script to fetch data from Binance, then drew candle stick charts in google sheet automatically. The quality of chart is not enough satisfactory. Please someone say how can I insert ... google-apps-script google-sheets binance tradingview-api. asked Oct 18 at 6:19. user9830671. 11 4 4 bronze badges. 0. votes. 0answers 16 views Best place to define a infinite loop for reading ... The Bitcoin.com Explorer provides block, transaction, and address data for the Bitcoin Cash (BCH) and Bitcoin (BTC) chains. The data is displayed within an awesome interface and is available in several different languages. Discover historical prices for BTC-USD stock on Yahoo Finance. View daily, weekly or monthly format back to when Bitcoin USD stock was issued. bitcoin csv historical data - For individual cryptoassets – for example, on the Ethereum price page – there are download buttons on the Markets and Historical Data tabs. Choose Markets for trading pairs (e.g. ETH/BTC) and Historical Data for OHLCV records. To download market or coverage data for all cryptocurrency exchanges, click the “Free CSV” button on the main ... So the purpose of this article will be to sift these details for the reader and explain them in a palatable manner. There are three types of wallets/addresses that most exchanges have. They are: 1. Deposit addresses 2. Hot Wallets 3. Cold Wallets. How They Work: Deposit addresses are the wallets give you to credit your account. For example, when you set up an account at Binance/Coinbase ...
Bitcoin Ethereum Litecoin Ripple Binance Technical Analysis Chart 6/4/2019 by ChartGuys.com ... The ULTIMATE beginners guide to reading a candlestick chart - Duration: 16:26. The Trading Channel ... How to Read Cryptocurrency Charts! - Part 1 https://blockgeeks.com/guides/learn-how-to-read-crypto-charts/ If you've been involved at cryptocurrency at all, ... Depth Chart Binance Explained for Crypto Trading. How to Read Binance Depth Chart for beginners. GET YOUR FREE STOCK in Robinhood http://share.robinhood.com/... Candlestick charts: The ULTIMATE beginners guide to reading a candlestick chart - Duration: 16 ... How to BUY, SELL, DEPOSIT AND WITHDRAW Using Binance Bitcoin Sinhalen - Duration: 7:55. Darsana ... https://www.binance.com/?ref=15183219 This is a very crude overview of what you're looking at when you see a depth chart. Green = buy orders, Red= sell order... http://tinyurl.com/Bitcoin-Trade-2014 = Make Money Trading Bitcoins How to Read the Bitcoin Charts Ultimate Guide to Bitcoins Trading 2014 - Just follow t... Trading cryptocurrency on charts is a mistake! Yes, you heard that right. Without the order book information I will discuss on this video, as well as other i...