<aside> 💡

You can do everything on one sheet or on several. Whichever you consider necessary. It's important that the report is convenient and understandable for the end user.

</aside>

• Segment Users by “ABCD” Segment, where user volumes are:

  User Category	Min Volume	Max Volume
  A	2000000	♾️
  B	200000	2000000
  C	20000	200000
  D	1	20000

  • Volumes should not include “paper” exchanges

• Trader count monthly by segment

• Segment percent by total user count monthly

• Average volume per user

• User “card” where I can see total volume, volume dynamics, user segment change by dynamics, A segment count (how much times user hit A segment)

• Compare 3Commas volumes vs global volumes by exchanges (volumes should be in usd) 34 = BTC, 8516 = USD

  • time cut: list of exchanges needed from the file (or not):

    binance

    binance_dex_mini

    binance_futures

    binance_us

    bitfinex

    bitfinex_futures

    bitget

    bitget_futures

    bybit

    bybit_spot

    coinbase_international

    coinbase_international_derivatives

    deribit_spot

    gate

    gate_futures

    kraken

    kraken_futures

    kucoin

    okex

    okex_ordinals

    okex_swap

    huobi

    huobi_dm

    huobi_japan

    gemini

    gemini_derivatives

    bitstamp

Files to work with:

3Commas Volumes.csv

Currency Rates.csv

Exchange Volumes.csv