# The OpenGov.Watch Monitor

**URL:** <https://forum.polkadot.network/t/the-opengov-watch-monitor/12731>\
**Category:** Governance\
**Tags:** treasury\
**Created:** [April 29, 2025, 7:50am UTC](https://forum.polkadot.network/t/the-opengov-watch-monitor/12731 "2025-04-29T07:50:31Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![alice\_und\_bob](https://dub1.discourse-cdn.com/flex005/user_avatar/forum.polkadot.network/alice_und_bob/32/10098_2.png) [@alice\_und\_bob](https://forum.polkadot.network/u/alice_und_bob)\
**Post date:** [April 29, 2025, 7:50am UTC](https://forum.polkadot.network/t/the-opengov-watch-monitor/12731/1 "2025-04-29T07:50:31Z")

</div>

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](https://www.opengov.watch/monitoring)

## 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

- Code
  - [Open Source](https://github.com/OpenGov-Watch/opengov-monitor) (Unlicense)
  - a data source [implementation](https://github.com/OpenGov-Watch/opengov-monitor/blob/d6276a1a2c08a8fb62dc1f75f0cd2f30a1f1e6f3/data_providers/subsquare.py) for the Subsquare API (we are very grateful for their support!)
  - a data sink [implementation](https://github.com/OpenGov-Watch/opengov-monitor/blob/d6276a1a2c08a8fb62dc1f75f0cd2f30a1f1e6f3/data_sinks/google/spreadsheet.py) for Google Spreadsheets
  - with [instructions](https://github.com/OpenGov-Watch/opengov-monitor/blob/d6276a1a2c08a8fb62dc1f75f0cd2f30a1f1e6f3/README.md) for a Google Cloud deployment (can run on free quotas)
  - Here is a rough [code tour](https://studio.youtube.com/video/NbErnfkOJZM/edit) and here is an [coding session example where I built the new Outstanding Claims screen](https://studio.youtube.com/video/C_deF51dO0g/edit).

## Tour

### Referenda

 ![image](https://europe1.discourse-cdn.com/flex005/uploads/polkadot2/original/2X/b/bc40ccef3f0c3010e6800daa11e1b1819a744c30.png)  
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

 ![image](https://europe1.discourse-cdn.com/flex005/uploads/polkadot2/original/2X/f/fe532e8eaf2e8359bcbe6e23dcc4cdbeff046868.png)

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

 ![image](https://europe1.discourse-cdn.com/flex005/uploads/polkadot2/original/2X/1/1a5041087fdc6747a283a2c881579e18f0de7f50.png)

A manually curated list with relevant links to all bounties. Part of our initiative to push for more bounty transparency.

## Child Bounties & Fellowship

 ![image](https://europe1.discourse-cdn.com/flex005/uploads/polkadot2/original/2X/5/5ba520be54847d6060621a92cd8e90c61fb8e4f6.png)

 ![image](https://europe1.discourse-cdn.com/flex005/uploads/polkadot2/original/2X/7/75bd83b2b544a3532d4d137c87a8d28f04b9b27e.png)

Follow the same pattern as the Referenda screen.

## Treasury

 ![image](https://europe1.discourse-cdn.com/flex005/uploads/polkadot2/original/2X/8/8023807b464ea5ae63fb1d07ff24316c92639a8b.png)

A list of all past and future claims.

## Next Steps

Check it out at [Monitoring | OpenGov.Watch](https://www.opengov.watch/monitoring)

We are irregularly pushing new features/screens/columns to the Spreadsheet