[EPIC] Make business metrics easily accessible for the Rebalancer

[uditvira]

We need the certain information easily accessible to give us an insight about how the rebalancer is doing (e.g., do we have sufficient market making capacity)

Summary of information we need

• [x] Number of accounts (separated out by active and inactive/paused) - This is done
• [ ] Total amount being managed in valence accounts - We decided not to calculate the total value, instead we can just calculate the aggregate balances of each individual denom across all accounts
• [x] When did the last rebalancing occur - The purpose of this is to ensure that the rebalancer is running each day. We can monitor this on Slack now thanks to the slackbot
• [x] When will the next rebalancing occur - It occurs at midnight UTC
• [x] What was the volume in the last rebalancing - This is coming through in the slackbot
• [x] From the last rebalancing, how much was successfully auctioned off vs. how much was returned back to the users due to lack of market making activity We decided to remove this, given our mm contract is successfully running and the arb bot is about to be functional
• [ ] For each auction, what was the price of the last successful bid - Missing, will be fixed soon
• [x] For each auction, how does the price of the last successful bid compare to prices on a CEX - This is handled by the front end

This information should be easily accessible for non technical people on the team. Ideally, this can be scripted up and available as a JSON. We can build a UI around this in the future

---

Tasks

• [x] Udit to summarize what the metrics we need and get sign off from everyone on the team
• [x] Yan to make a decision about which Indexer to use
  • Reece's https://github.com/Reecepbcups/interchain-indexer
  • Subquery https://academy.subquery.network/indexer/quickstart/quickstart_chains/cosmos-neutron.html
  • A secret third one?
• [x] Yan to add Events or Queries in the Rebalancer and Auction code so that everything can be indexed
• [ ] Yan to create a basic API for the metrics we decided on for v0.0.1 - In progress
• [x] Udit to create a new issue for alerting on key metrics Superseded because Yan has made the slackbot
• [x] Create slackbot
• [x] #66

[stiiifff]

Some basic metrics:

• Is it running (righ now), when was the last crossing, and bid by the bot ?
• Capital efficiency of the trade execution (wrt. price disco on CEX e.g. Binance API)

[maximusdm1]

Questions:

1. For these, is it by auction or by account? "When did the last rebalancing occur, When will the next rebalancing occur, What was the volume in the last rebalancing"

2. Is this metric the amount of capital we were short in order for our market making to handle the full amount? "From the last rebalancing, how much was successfully auctioned off vs. how much was returned back to the users"

Requests

1. [high priority] If the answer to #2 above is "yes", can we trigger some sort of automatic alert if it is ever greater than 0 so that I can respond quickly?

2. [medium low priority] would be great to have churn metrics. how much capital has remained in the system, how much as left the system, and how much is net-new.

[uditvira]

Discussed with @maximusdm1 on a call:

• we should be tracking active vs inactive accounts
• after we can capture these metrics, we should add an alerting system for certain events such as when the auction system is unable to auction of funds due to a lack of market making activity

[Art3miX]

This should be a milestone rather then a single issue, we have separate parts to this issue, and separate uses for those parts.

[stiiifff]

Agreed. I suggest to keep this issue as is though (and leave it in "On hold" ) state, and to link to it from newly created finer-grained ones.

[uditvira]

Revising this:

• Number of accounts (separated out by active and inactive/paused) - This is done
• Total amount being managed in valence accounts - We decided not to calculate the total value, instead we can just calculate the aggregate balances of each individual denom across all accounts
• When did the last rebalancing occur - The purpose of this is to ensure that the rebalancer is running each day. We can monitor this on Slack now thanks to the slackbot
• When will the next rebalancing occur - It occurs at midnight UTC
• What was the volume in the last rebalancing - This is coming through in the slackbot
• From the last rebalancing, how much was successfully auctioned off vs. how much was returned back to the users due to lack of market making activity - We decided to remove this, given our mm contract is successfully running and the arb bot is about to be functional
• For each auction, what was the price of the last successful bid - Missing, will be fixed soon
• For each auction, how does the price of the last successful bid compare to prices on a CEX - This is handled by the front end

Updated this above

[stiiifff]

@elenamik @Art3miX to sync and define what remains to be done for this issue (please update the issue once you've synced).