Methodology

Dashboard Objective

Show Struct Finance Vaults Performance.

Dashboard Structure

Introduction
Overview
- Vaults
- Depositors
- Finished Vaults
- Pending Vaults
Vault Stats
- Overview
- Fixed Tranche Investors
- Variable Tranche Investors
Key Takeaways
Methodology

Dashboard Method

Using Flipside Tables of Avalanche I'll track the activity of Struct Finance Vaults Using:

Method To track Struct Finance Vaults addresses:
select
decoded_log:productAddress as address
from avalanche.core.ez_decoded_event_logs
where tx_status = 'SUCCESS'
and event_name = 'ProductCreated'
and contract_address = '0x46f8765781ac36e5e8f9937658fa311af9d735d7'


Using the Following Table to get the USDC & BTC.b Transfers:
avalanche.core.ez_token_transfers join avalanche.core.ez_decoded_event_logs using(tx_hash)

Now we filter with event_name:
Deposited     --Deposits
Withdrawn     --Claimed Rewards
ExcessClaimed --Claimed Excess Volume

Dashboard Sources

Struct Finance Icon + Struct Finance Image

A guide to Struct Finance Open Beta

Behind the Tranched Curtain