Methodology

Dashboard Objective

Explain How Struct Finance Works, Using Past Vaults as Examples.

Dashboard Structure

Introduction
- A summary of my Past Dashboard
- Welcome to Struct Finance 101
What is Struct Finance?
- How Struct Finance Vaults Work?
Learning with an Example
- The USDC - USDC Vault from June 13 to July 11
- How Much Did the Investors Make?
Let's Add Imbalance
- The USDC - USDC Vault from July 2 to July 30
- Timeline of Activity
- Activity During the Subscription Period
- How the Vault Balances itself?
- How Much Did the Investors Make?
Understanding the BTC.b - USDC Vaults
- Struct Finance Latest Market vaults BTC.b - USDC
- The Impact of BTC.b Price
- The BTC.b - USDC Vault from July 15 to September 9
- How Much the Vault Invested?
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'

Vaults addresses used:
0xeece485142c2d723126500ce149c72feef24125b USDC-USDC Vault (June 13 → July 11)
0xb485225ceb1dbc3481ee70d5d42b3a5e9c811273 USDC-USDC Vault (July 2 → July 30)
0xa28a7fcfc5d3acd131fc4dcf9769069d9dfee0f7 BTC.b-USDC Vault (July 15 → September 9)

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
StatusUpdated --Vault Investing and Vault Claiming the Investment 
ExcessClaimed --Claimed Excess Volume

To segment Events in StatusUpdated use:
decoded_log:status=1 -- Vault Investing
decoded_log:status=2 -- Vault Claiming Invest

Dashboard Sources

Struct Finance Icon + Struct Finance Image + Tranche Image

A guide to Struct Finance Open Beta

Behind the Tranched Curtain

CaesarJulius0 Tweet + Omar Tweet

Struct Finance 101