CAI/cai_February_2024.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "5866e8b8",
   "metadata": {},
   "source": [
    "## CAI - Colony Avalanche Index - Rebalancing data for February 2024"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d6fc51ad",
   "metadata": {},
   "source": [
    "## Configuring packages"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "3be13cba",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import decouple\n",
    "import sys\n",
    "sys.path.append('../')\n",
    "from methodology import MethodologyProd\n",
    "from pycoingecko import CoinGeckoAPI\n",
    "key =  decouple.config(\"CG_KEY\")\n",
    "cg = CoinGeckoAPI(api_key=key)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "db58fc4e",
   "metadata": {},
   "source": [
    "## Index Variables"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "30bc6496",
   "metadata": {},
   "outputs": [],
   "source": [
    "date = '2024-02-01'\n",
    "min_mcap =  0.1e8\n",
    "min_weight = 0.005\n",
    "max_weight = 0.5\n",
    "circ_supply_threshold = 0.3\n",
    "liveness_threshold = 180 # In days\n",
    "liquidity_consistency = 90 # In days\n",
    "coingecko_category = \"avalanche-ecosystem\"\n",
    "\n",
    "# Calculating max slippage based on liquidity threshold\n",
    "liq = 2*1e6\n",
    "liq_os = liq / 2 # one-side liquidity \n",
    "trade_value_tiny = 1e2\n",
    "trade_value = 1e5\n",
    "max_slippage = (liq_os + trade_value_tiny) / (liq_os + trade_value) - 1\n",
    "# round to the nearest .01\n",
    "max_slippage = round(max_slippage, 2)\n",
    "\n",
    "# Dataframes to remove\n",
    "stablecoins = pd.DataFrame(cg.get_coins_markets('usd',category='stablecoins')).set_index('id')\n",
    "ctokens = pd.DataFrame(cg.get_coins_markets('usd',category='compound-tokens')).set_index('id')\n",
    "atokens = pd.DataFrame(cg.get_coins_markets('usd',category='aave-tokens')).set_index('id')\n",
    "\n",
    "methodology_class = MethodologyProd(\n",
    "                                date,\n",
    "                                1,\n",
    "                                \"avalanche\",\n",
    "                                \"0x48f88A3fE843ccb0b5003e70B4192c1d7448bEf0\",\n",
    "                                \"cai_benchmark_data\",\n",
    "                                \"cai_liquidities\",\n",
    "                                min_mcap,\n",
    "                                min_weight,\n",
    "                                max_weight,\n",
    "                                255,\n",
    "                                circ_supply_threshold,\n",
    "                                liveness_threshold,\n",
    "                                liquidity_consistency,\n",
    "                                max_slippage,\n",
    "                                coingecko_category)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "53ff27b8",
   "metadata": {},
   "source": [
    "## Token inclusion criteria\n",
    "\n",
    "1. **Project and token characteristics**\n",
    "    1. The project’s token should have been listed on CoinGecko with pricing data at least 6 months prior to the date of inclusion in the index.\n",
    "    1. The project should have a token that is native to Avalanche. This excludes wrapped variants, where the underlying tokens are locked on an alt-L1.\n",
    "    1. The project should be a going concern, with a dedicated team actively building, supporting and maintaining the project.\n",
    "    1. No rebasing or deflationary tokens.\n",
    "    1. The project must be widely considered to be building a useful protocol or product. Projects that have ponzi characteristics at the core of their offering will not be considered.\n",
    "    1. Synthetic tokens which derive their value from external price feeds are not permissible.\n",
    "    1. The project’s token must not have the ability to pause token transfers.\n",
    "    1. The project’s protocol or product must have significant usage.\n",
    "    <br>\n",
    "1. **Pricing requirements**\n",
    "    1. Token should have a Chainlink price feed to allow for manipulation resistant pricing.\n",
    "    <br>\n",
    "1. **Token Supply requirements**\n",
    "    1. The project's token must have a circulating supply greater than 30% of the max supply. In cases where a token does not have a max supply, the minting mechanics would need to be assessed.\n",
    "    <br>\n",
    "1. **Liquidity Requirements**\n",
    "    1. The token must be listed on a supported exchange. \n",
    "    1. The token should have in aggregate at least $2mm of onchain liquidity across Trader Joe, Platypus, Pangolin.\n",
    "    1. The token must have shown consistent DeFi liquidity on Avalanche.\n",
    "    <br>\n",
    "1. **Security Requirements**\n",
    "    1. The project must have been audited by smart contract security professionals with the audit report(s) publicly available. Alternatively, the protocol must have been operating long enough to create a consensus about its safety in the decentralised finance community."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d7535726",
   "metadata": {},
   "source": [
    "## Run Methodology"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "10643ec6",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Note: wrapped-avax, marketcap data available only for 0 < 180 days\n",
      "Excluding coq-inu, pricing data available only for 54 < 180 days\n",
      "Excluding platypus-usd, pricing data available only for 13 < 180 days\n",
      "0xbec243c995409e6520d7c41e404da5deba4b209b avalanche\n",
      "0x44c784266cf024a60e8acf2427b9857ace194c5d avalanche\n",
      "0xdf474b7109b73b7d57926d43598d5934131136b2 avalanche\n",
      "0x6b289cceaa8639e3831095d75a3e43520fabf552 avalanche\n",
      "0x644192291cc835a93d6330b24ea5f5fedd0eef9e avalanche\n",
      "0xf44ff799ea2bbfec96f9a50498209aac3c2b3b8b avalanche\n",
      "0x12d8ce035c5de3ce39b1fdd4c1d5a745eaba3b8c avalanche\n",
      "0xfcaf13227dcbfa2dc2b1928acfca03b85e2d25dd avalanche\n",
      "Dropping bitcoin-avalanche-bridged-btc-b because a price feed is unavailable\n",
      "Dropping euro-coin because a price feed is unavailable\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>spot price</th>\n",
       "      <th>delivery price</th>\n",
       "      <th>slippage</th>\n",
       "      <th>blockchain</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>euro-coin</th>\n",
       "      <td>9.141120e-01</td>\n",
       "      <td>9.134620e-01</td>\n",
       "      <td>-0.000711</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>bitcoin-avalanche-bridged-btc-b</th>\n",
       "      <td>2.298000e-05</td>\n",
       "      <td>2.294000e-05</td>\n",
       "      <td>-0.001741</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>wrapped-avax</th>\n",
       "      <td>2.761864e-02</td>\n",
       "      <td>2.751495e-02</td>\n",
       "      <td>-0.003754</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>benqi-liquid-staked-avax</th>\n",
       "      <td>2.450117e-02</td>\n",
       "      <td>2.439292e-02</td>\n",
       "      <td>-0.004418</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>joe</th>\n",
       "      <td>2.022754e+00</td>\n",
       "      <td>1.961387e+00</td>\n",
       "      <td>-0.030338</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>avalaunch</th>\n",
       "      <td>7.658098e-01</td>\n",
       "      <td>7.251820e-01</td>\n",
       "      <td>-0.053052</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>benqi</th>\n",
       "      <td>6.089699e+01</td>\n",
       "      <td>5.499487e+01</td>\n",
       "      <td>-0.096920</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>dexalot</th>\n",
       "      <td>1.811672e+00</td>\n",
       "      <td>1.464755e+00</td>\n",
       "      <td>-0.191490</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>colony</th>\n",
       "      <td>4.017343e+00</td>\n",
       "      <td>3.224450e+00</td>\n",
       "      <td>-0.197367</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>playa3ull-games-2</th>\n",
       "      <td>2.095201e+02</td>\n",
       "      <td>1.625068e+02</td>\n",
       "      <td>-0.224386</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>chainlink</th>\n",
       "      <td>6.327219e-02</td>\n",
       "      <td>4.755725e-02</td>\n",
       "      <td>-0.248371</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>aave</th>\n",
       "      <td>1.054362e-02</td>\n",
       "      <td>7.711117e-03</td>\n",
       "      <td>-0.268646</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ampleforth</th>\n",
       "      <td>9.840034e-01</td>\n",
       "      <td>7.131952e-01</td>\n",
       "      <td>-0.275211</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>osaka-protocol</th>\n",
       "      <td>1.818964e+07</td>\n",
       "      <td>6.402891e+06</td>\n",
       "      <td>-0.647992</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>trustswap</th>\n",
       "      <td>5.959761e+00</td>\n",
       "      <td>1.896553e+00</td>\n",
       "      <td>-0.681774</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>xana</th>\n",
       "      <td>8.066850e+01</td>\n",
       "      <td>2.523339e+01</td>\n",
       "      <td>-0.687197</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>orbs</th>\n",
       "      <td>2.762711e+01</td>\n",
       "      <td>8.087131e+00</td>\n",
       "      <td>-0.707276</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>pendle</th>\n",
       "      <td>1.808553e+01</td>\n",
       "      <td>2.386448e+00</td>\n",
       "      <td>-0.868047</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>synapse-2</th>\n",
       "      <td>1.247035e+00</td>\n",
       "      <td>1.626440e-01</td>\n",
       "      <td>-0.869575</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>spell-token</th>\n",
       "      <td>4.969631e+03</td>\n",
       "      <td>5.587920e+02</td>\n",
       "      <td>-0.887559</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>snowbank</th>\n",
       "      <td>4.089090e-03</td>\n",
       "      <td>2.568750e-04</td>\n",
       "      <td>-0.937180</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>step-app-fitfi</th>\n",
       "      <td>1.613468e+02</td>\n",
       "      <td>6.873005e+00</td>\n",
       "      <td>-0.957402</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>xen-crypto</th>\n",
       "      <td>1.870858e+08</td>\n",
       "      <td>7.390000e+06</td>\n",
       "      <td>-0.960499</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>beta-finance</th>\n",
       "      <td>7.521702e+00</td>\n",
       "      <td>2.711278e-01</td>\n",
       "      <td>-0.963954</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>frax-share</th>\n",
       "      <td>9.751383e-02</td>\n",
       "      <td>2.831172e-03</td>\n",
       "      <td>-0.970966</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>sushi</th>\n",
       "      <td>8.397860e-01</td>\n",
       "      <td>2.243965e-02</td>\n",
       "      <td>-0.973279</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>alpha-finance</th>\n",
       "      <td>8.997874e+00</td>\n",
       "      <td>1.110568e-01</td>\n",
       "      <td>-0.987657</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>insure</th>\n",
       "      <td>1.740644e+02</td>\n",
       "      <td>1.927095e+00</td>\n",
       "      <td>-0.988929</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>balancer</th>\n",
       "      <td>2.372593e-01</td>\n",
       "      <td>1.774245e-03</td>\n",
       "      <td>-0.992522</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ferrum-network</th>\n",
       "      <td>7.539551e+00</td>\n",
       "      <td>4.606980e-02</td>\n",
       "      <td>-0.993890</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>woo-network</th>\n",
       "      <td>2.120933e+00</td>\n",
       "      <td>9.709681e-03</td>\n",
       "      <td>-0.995422</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>uniswap</th>\n",
       "      <td>1.229095e-01</td>\n",
       "      <td>4.584599e-04</td>\n",
       "      <td>-0.996270</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1inch</th>\n",
       "      <td>1.362309e+00</td>\n",
       "      <td>3.507802e-03</td>\n",
       "      <td>-0.997425</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>dextf</th>\n",
       "      <td>1.201219e+00</td>\n",
       "      <td>2.902716e-03</td>\n",
       "      <td>-0.997584</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>maker</th>\n",
       "      <td>1.701819e-04</td>\n",
       "      <td>2.788773e-07</td>\n",
       "      <td>-0.998361</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>deapcoin</th>\n",
       "      <td>1.018753e+03</td>\n",
       "      <td>1.567608e+00</td>\n",
       "      <td>-0.998461</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>basic-attention-token</th>\n",
       "      <td>1.281724e+00</td>\n",
       "      <td>1.857069e-03</td>\n",
       "      <td>-0.998551</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>the-graph</th>\n",
       "      <td>2.386391e-01</td>\n",
       "      <td>2.707543e-04</td>\n",
       "      <td>-0.998865</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>uma</th>\n",
       "      <td>2.763317e-06</td>\n",
       "      <td>3.095738e-09</td>\n",
       "      <td>-0.998880</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>yearn-finance</th>\n",
       "      <td>1.292740e-05</td>\n",
       "      <td>1.415687e-08</td>\n",
       "      <td>-0.998905</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0x</th>\n",
       "      <td>6.112750e-02</td>\n",
       "      <td>6.240301e-05</td>\n",
       "      <td>-0.998979</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>compound-governance-token</th>\n",
       "      <td>2.097512e-08</td>\n",
       "      <td>2.117328e-11</td>\n",
       "      <td>-0.998991</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>meld-2</th>\n",
       "      <td>5.661702e+01</td>\n",
       "      <td>9.970375e-05</td>\n",
       "      <td>-0.999998</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>kyber-network-crystal</th>\n",
       "      <td>1.597430e+00</td>\n",
       "      <td>7.833000e-15</td>\n",
       "      <td>-1.000000</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                   spot price  delivery price  slippage  \\\n",
       "id                                                                        \n",
       "euro-coin                        9.141120e-01    9.134620e-01 -0.000711   \n",
       "bitcoin-avalanche-bridged-btc-b  2.298000e-05    2.294000e-05 -0.001741   \n",
       "wrapped-avax                     2.761864e-02    2.751495e-02 -0.003754   \n",
       "benqi-liquid-staked-avax         2.450117e-02    2.439292e-02 -0.004418   \n",
       "joe                              2.022754e+00    1.961387e+00 -0.030338   \n",
       "avalaunch                        7.658098e-01    7.251820e-01 -0.053052   \n",
       "benqi                            6.089699e+01    5.499487e+01 -0.096920   \n",
       "dexalot                          1.811672e+00    1.464755e+00 -0.191490   \n",
       "colony                           4.017343e+00    3.224450e+00 -0.197367   \n",
       "playa3ull-games-2                2.095201e+02    1.625068e+02 -0.224386   \n",
       "chainlink                        6.327219e-02    4.755725e-02 -0.248371   \n",
       "aave                             1.054362e-02    7.711117e-03 -0.268646   \n",
       "ampleforth                       9.840034e-01    7.131952e-01 -0.275211   \n",
       "osaka-protocol                   1.818964e+07    6.402891e+06 -0.647992   \n",
       "trustswap                        5.959761e+00    1.896553e+00 -0.681774   \n",
       "xana                             8.066850e+01    2.523339e+01 -0.687197   \n",
       "orbs                             2.762711e+01    8.087131e+00 -0.707276   \n",
       "pendle                           1.808553e+01    2.386448e+00 -0.868047   \n",
       "synapse-2                        1.247035e+00    1.626440e-01 -0.869575   \n",
       "spell-token                      4.969631e+03    5.587920e+02 -0.887559   \n",
       "snowbank                         4.089090e-03    2.568750e-04 -0.937180   \n",
       "step-app-fitfi                   1.613468e+02    6.873005e+00 -0.957402   \n",
       "xen-crypto                       1.870858e+08    7.390000e+06 -0.960499   \n",
       "beta-finance                     7.521702e+00    2.711278e-01 -0.963954   \n",
       "frax-share                       9.751383e-02    2.831172e-03 -0.970966   \n",
       "sushi                            8.397860e-01    2.243965e-02 -0.973279   \n",
       "alpha-finance                    8.997874e+00    1.110568e-01 -0.987657   \n",
       "insure                           1.740644e+02    1.927095e+00 -0.988929   \n",
       "balancer                         2.372593e-01    1.774245e-03 -0.992522   \n",
       "ferrum-network                   7.539551e+00    4.606980e-02 -0.993890   \n",
       "woo-network                      2.120933e+00    9.709681e-03 -0.995422   \n",
       "uniswap                          1.229095e-01    4.584599e-04 -0.996270   \n",
       "1inch                            1.362309e+00    3.507802e-03 -0.997425   \n",
       "dextf                            1.201219e+00    2.902716e-03 -0.997584   \n",
       "maker                            1.701819e-04    2.788773e-07 -0.998361   \n",
       "deapcoin                         1.018753e+03    1.567608e+00 -0.998461   \n",
       "basic-attention-token            1.281724e+00    1.857069e-03 -0.998551   \n",
       "the-graph                        2.386391e-01    2.707543e-04 -0.998865   \n",
       "uma                              2.763317e-06    3.095738e-09 -0.998880   \n",
       "yearn-finance                    1.292740e-05    1.415687e-08 -0.998905   \n",
       "0x                               6.112750e-02    6.240301e-05 -0.998979   \n",
       "compound-governance-token        2.097512e-08    2.117328e-11 -0.998991   \n",
       "meld-2                           5.661702e+01    9.970375e-05 -0.999998   \n",
       "kyber-network-crystal            1.597430e+00    7.833000e-15 -1.000000   \n",
       "\n",
       "                                blockchain  \n",
       "id                                          \n",
       "euro-coin                        avalanche  \n",
       "bitcoin-avalanche-bridged-btc-b  avalanche  \n",
       "wrapped-avax                     avalanche  \n",
       "benqi-liquid-staked-avax         avalanche  \n",
       "joe                              avalanche  \n",
       "avalaunch                        avalanche  \n",
       "benqi                            avalanche  \n",
       "dexalot                          avalanche  \n",
       "colony                           avalanche  \n",
       "playa3ull-games-2                avalanche  \n",
       "chainlink                        avalanche  \n",
       "aave                             avalanche  \n",
       "ampleforth                       avalanche  \n",
       "osaka-protocol                   avalanche  \n",
       "trustswap                        avalanche  \n",
       "xana                             avalanche  \n",
       "orbs                             avalanche  \n",
       "pendle                           avalanche  \n",
       "synapse-2                        avalanche  \n",
       "spell-token                      avalanche  \n",
       "snowbank                         avalanche  \n",
       "step-app-fitfi                   avalanche  \n",
       "xen-crypto                       avalanche  \n",
       "beta-finance                     avalanche  \n",
       "frax-share                       avalanche  \n",
       "sushi                            avalanche  \n",
       "alpha-finance                    avalanche  \n",
       "insure                           avalanche  \n",
       "balancer                         avalanche  \n",
       "ferrum-network                   avalanche  \n",
       "woo-network                      avalanche  \n",
       "uniswap                          avalanche  \n",
       "1inch                            avalanche  \n",
       "dextf                            avalanche  \n",
       "maker                            avalanche  \n",
       "deapcoin                         avalanche  \n",
       "basic-attention-token            avalanche  \n",
       "the-graph                        avalanche  \n",
       "uma                              avalanche  \n",
       "yearn-finance                    avalanche  \n",
       "0x                               avalanche  \n",
       "compound-governance-token        avalanche  \n",
       "meld-2                           avalanche  \n",
       "kyber-network-crystal            avalanche  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "results,liquidity = methodology_class.main(\n",
    "    single_chain=\"avalanche\",\n",
    "    df_to_remove=[stablecoins,ctokens,atokens],\n",
    "    ids_to_replace=[[\"avalanche-2\"],[\"wrapped-avax\"]],\n",
    "    add_category_assets=[\"shrapnel-2\"],\n",
    "    remove_category_assets=['wrapped-bitcoin',\"gmx\",\"pangolinx\"],\n",
    "    values_to_update=[{'id':'pangolin','category':'total_supply','value':230000000},\n",
    "                      {'id':'benqi-liquid-staked-avax','category':'market_cap','value':20000000000},\n",
    "                      {'id':'benqi-liquid-staked-avax','category':'symbol','value':\"sAVAX\"}\n",
    "                      ],\n",
    "    weight_split_data={\"asset_to_split\":\"wrapped-avax\",\"asset_to_receive\":\"benqi-liquid-staked-avax\",\"split_ratio\":0.6}\n",
    "    )\n",
    "liquidity"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a74ebe0c",
   "metadata": {},
   "source": [
    "## Show Results"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "b3a4ae5c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>symbol</th>\n",
       "      <th>market_cap</th>\n",
       "      <th>weight</th>\n",
       "      <th>weight_converted</th>\n",
       "      <th>address</th>\n",
       "      <th>blockchain_with_highest_liq</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>benqi-liquid-staked-avax</th>\n",
       "      <td>sAVAX</td>\n",
       "      <td>2.000000e+10</td>\n",
       "      <td>0.300000</td>\n",
       "      <td>76</td>\n",
       "      <td>0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>wrapped-avax</th>\n",
       "      <td>AVAX</td>\n",
       "      <td>1.327496e+10</td>\n",
       "      <td>0.200000</td>\n",
       "      <td>51</td>\n",
       "      <td>0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>joe</th>\n",
       "      <td>JOE</td>\n",
       "      <td>1.689867e+08</td>\n",
       "      <td>0.393414</td>\n",
       "      <td>101</td>\n",
       "      <td>0x6e84a6216ea6dacc71ee8e6b0a5b7322eebc0fdd</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>avalaunch</th>\n",
       "      <td>XAVA</td>\n",
       "      <td>4.578277e+07</td>\n",
       "      <td>0.106586</td>\n",
       "      <td>27</td>\n",
       "      <td>0xd1c3f94de7e5b45fa4edbba472491a9f4b166fc4</td>\n",
       "      <td>avalanche</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                         symbol    market_cap    weight  weight_converted  \\\n",
       "benqi-liquid-staked-avax  sAVAX  2.000000e+10  0.300000                76   \n",
       "wrapped-avax               AVAX  1.327496e+10  0.200000                51   \n",
       "joe                         JOE  1.689867e+08  0.393414               101   \n",
       "avalaunch                  XAVA  4.578277e+07  0.106586                27   \n",
       "\n",
       "                                                             address  \\\n",
       "benqi-liquid-staked-avax  0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be   \n",
       "wrapped-avax              0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7   \n",
       "joe                       0x6e84a6216ea6dacc71ee8e6b0a5b7322eebc0fdd   \n",
       "avalaunch                 0xd1c3f94de7e5b45fa4edbba472491a9f4b166fc4   \n",
       "\n",
       "                         blockchain_with_highest_liq  \n",
       "benqi-liquid-staked-avax                   avalanche  \n",
       "wrapped-avax                               avalanche  \n",
       "joe                                        avalanche  \n",
       "avalaunch                                  avalanche  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "results"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "84c4665c",
   "metadata": {},
   "source": [
    "## Contract Output"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "78d6dafd",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be,0x6e84a6216ea6dacc71ee8e6b0a5b7322eebc0fdd,0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7,0xd1c3f94de7e5b45fa4edbba472491a9f4b166fc4\n",
      "76,101,51,27\n"
     ]
    }
   ],
   "source": [
    "methodology_class.output_for_contract()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3.8.13 ('base')",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.6"
  },
  "vscode": {
   "interpreter": {
    "hash": "40d3a090f54c6569ab1632332b64b2c03c39dcf918b08424e98f38b5ae0af88f"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}