#12731 The OpenGov.Watch Monitor
I just realized I haven’t made a post about the OpenGov.Watch Monitor yet. Shocker.
The OpenGov.Watch Monitor is a Polkadot OpenGov Explorer in the form of a Google Spreadsheet. It curates relevant infos on referenda, spends, bounties, etc…
The big USP is that you have ALL refs on one screen available for search/filtering/sorting.
Link: Monitoring | OpenGov.Watch
Highlights
- Views
- On-chain data: Referenda, Child Bounties, Treasury Spends, Fellowship Subtreasury Spends
- hourly updated
- clickable links to the full Subsquare page
- Bounties - A manually curated list with relevant links
- Outstanding future claims on Treasury DOT, USDC, USDT
- On-chain data: Referenda, Child Bounties, Treasury Spends, Fellowship Subtreasury Spends
- Code
- Open Source (Unlicense)
- a data source implementation for the Subsquare API (we are very grateful for their support!)
- a data sink implementation for Google Spreadsheets
- with instructions for a Google Cloud deployment (can run on free quotas)
- Here is a rough code tour and here is an coding session example where I built the new Outstanding Claims screen.
Tour
Referenda
Tired of having to navigate multiple screens?
- This is one table that you can search, filter, sort
- Color coded status and proposal amounts
- Calculates DOT and USD equivalent values of all proposals at propose time and payout time
- Shows spends split into DOT, USDC, USDT component
Outstanding Claims
This is our newest screen and shows you spends which will be coming and might be coming in the form of “claims”. This needs a short explainer: When the Treasury approves spends via treasury.spend(), these come in the form of a voucher/claim to retrieve the value from the Polkadot Hub. Since the claim is only valid for 4 weeks, it can be timed to become active at a certain point in the future. This creates a timeline of future claims that need to be kept track of.
- This view aggregates all future claims on the Treasury by month and by ref (and there is a table for expired claims)
- We also try to guesstimate incoming claims by taking all refs that are deciding or confirming and multiplying their current approval with the ask size.
Bounties
A manually curated list with relevant links to all bounties. Part of our initiative to push for more bounty transparency.
Child Bounties & Fellowship
Follow the same pattern as the Referenda screen.
Treasury
A list of all past and future claims.
Next Steps
Check it out at Monitoring | OpenGov.Watch
We are irregularly pushing new features/screens/columns to the Spreadsheet
I just realized I haven’t made a post about the OpenGov.Watch Monitor yet. Shocker.
The OpenGov.Watch Monitor is a Polkadot OpenGov Explorer in the form of a Google Spreadsheet. It curates relevant infos on referenda, spends, bounties, etc…
The big USP is that you have ALL refs on one screen available for search/filtering/sorting.
Link: Monitoring | OpenGov.Watch
Highlights
Tour
Referenda
Tired of having to navigate multiple screens?
Outstanding Claims
This is our newest screen and shows you spends which will be coming and might be coming in the form of “claims”. This needs a short explainer: When the Treasury approves spends via treasury.spend(), these come in the form of a voucher/claim to retrieve the value from the Polkadot Hub. Since the claim is only valid for 4 weeks, it can be timed to become active at a certain point in the future. This creates a timeline of future claims that need to be kept track of.
Bounties
A manually curated list with relevant links to all bounties. Part of our initiative to push for more bounty transparency.
Child Bounties & Fellowship
Follow the same pattern as the Referenda screen.
Treasury
A list of all past and future claims.
Next Steps
Check it out at Monitoring | OpenGov.Watch
We are irregularly pushing new features/screens/columns to the Spreadsheet