Bitcoin ETF flow bot - Methodology

Introduction

My Bitcoin ETF flow bot which posts updates at the X account @ubiqetfbot works by scraping the associated web sites of the ETFs to gather the updated reported Bitcoin holdings in the respective fund/trust.

Specific details for each ETF is outlined below (in alphabetical order by Ticker).

Details

ARKB - ARK 21Shares Bitcoin ETF

Data is from their fund web site.

Historically, the holdings are updated 10+ hours after the close of trading.

There is close alignment with other reported data sources.

BITB - Bitwise Bitcoin ETF

Data is from their fund web site.

Historically, the holdings are updated 4.5+ hours after the close of trading.

There is close alignment with other reported data sources.

BRRR - Valkyrie Bitcoin Fund

Data is from their fund web site holdings page.

Historically, the holdings are updated 10+ hours after the close of trading.

There is close alignment with other reported data sources.

BTCW - WisdomTree Bitcoin Fund

Data is from their fund web site.

Historically, the holdings are updated 13+ hours after the close of trading.

There is close alignment with other reported data sources.

This fund often has 0 daily flows.

DEFI - Hashdex Bitcoin ETF

Data is from their fund web site.

EZBC - Franklin Bitcoin ETF

Data is from their fund web site.

Historically, the holdings are updated 5.5+ hours after the close of trading.

There is close alignment with other reported data sources.

This fund often has 0 daily flows.

FBTC - Fidelity Wise Origin Bitcoin Fund

Data is from their fund web site.

Historically, the holdings are updated 16+ hours after the close of trading.

There is close alignment with other reported data sources.

GBTC - Grayscale Bitcoin Trust

Data is from their fund web site.

Historically, the holdings are updated 25 hours after the close of trading. Yes, the data is 1 day late :(.

There is close alignment with other reported data sources.

HODL - VanEck Bitcoin Trust

Data is from their fund web site.

Historically, the holdings are updated 37+ hours after the close of trading. Yes, the data is 1 day late :(.

There is close alignment with other reported data sources.

IBIT - iShares Bitcoin Trust

Data is from their fund web site.

Historically, the holdings are updated 13+ hours after the close of trading.

There is close alignment with other reported data sources.

Untracked

BTCO - Invesco Galaxy Bitcoin ETF

The fund holdings page is blank.

Technical details

Colly is the scraper of choice used.

Disclaimer

Tweet data is generated automatically, in real time. The methodology used to produce the Tweets focuses on speed rather than on accuracy. Data based on the ETF provider websites mentioned on this page. The data contains estimates. The data is likely to contain errors. I am not liable for any errors or inaccuracies in the data.