Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Comptroller #111

Open
pazza83 opened this issue Oct 18, 2021 · 101 comments
Open

Comptroller #111

pazza83 opened this issue Oct 18, 2021 · 101 comments

Comments

@pazza83
Copy link

pazza83 commented Oct 18, 2021

Comptroller

This Comptroller role has been created following the proposal bisq-network/proposals#340

As per the roles wiki I will outline the key aspects of the role to:

  • To maximize role owner autonomy in order to achieve Bisq's decentralization goals
  • To maximize transparency so that DAO stakeholders can effectively review and vote on role owner compensation requests

Objectives of the comptroller role

To make it easy for Bisq contributors and stakeholders to access brief monthly reports that give a snapshot as to how Bisq is performing in terms of profit / loss ie, is Bisq earning more in trade fees that it is spending (both in terms of USD and BTC).

This would have a positive impact on making it:

  • Easier to ascertain progress
  • Easier to make real-time decisions on budgets and what resources are available
  • Be better able to see the impact of work done to the success of Bisq
  • Easier to use as starting point for any future audit (to validate financials)

Duties

The following are the Comptroller duties:

To report monthly on the following:

Month USD BTC BSQ
Volume XXX XXX XXX
Revenue XXX XXX XXX
- BSQ trade fees XXX XXX XXX
- BTC trade fees XXX XXX XXX
- Arbitration fees XXX XXX XXX
Compensation (XXX) (XXX) (XXX)
Net Profit (Loss) XXX XXX XXX

To report monthly on the what percentage of fees paid were paid in BSQ.

Rights

None

Owners

N/A

Team

@bisq-network/support

Reporting

I will provide monthly reports underneath this role. As the reports are provided for each calendar month there may be cycles that do not have reports provided.

A annual report similar will also be provided at the start of each fiscal year to report on the previous fiscal year. I will include a summary of observations alongside the report.

Bonding

None as this role is not vital to Bisq operations, nor is any special permissions required.

Compensation

The following compensation will be requested for the role:

Amount Duty
$75 USD Monthly report
$150 USD Annual report

Limitations

Some elements lie outside the scope of this role. Specifically auditing the financials. More more information please see comments on the original proposal: bisq-network/proposals#340

Wiki

A wiki will be created for the role in the future and linked here.

Tagging in @cbeams in case I have missed anything

@pazza83
Copy link
Author

pazza83 commented Oct 18, 2021

Profit and loss - August 2021

This is my first cycle as for the Comptroller role.

Please see below the report for August 2021 (which coincides with cycle 27):

August 2021 USD BTC BSQ
Volume 6,527,571 143.0199 4,157,688
Revenue 38,358 0.84043077 24,440.29
- BSQ trade fees 8,562 0.18759448 5,461.81
- BTC trade fees 29,313 0.6422537 18,670
- Arbitration fees 483 0.01058259 307.64
Compensation (17,351) (0.38015315) (11,051.32)
Net Profit (Loss) 21,006 0.46024407 13,379

Percentage of fees paid in BSQ in August 2021 was: 22.61%

Total fees paid as a percentage of revenue: 0.58%

I will maintain a link to the spreadsheet I used with comments on the individual line items.

Summary

I have previously reported on the profit and loss for the fiscal year 2020/21 ($51,997 for the whole year), and for July 2021 ($5,325).

Although this is my first cycle as the Comptroller a profit of $21,006 is a significant increase in profits when compared to the previous figures. I think it is likely this is the most profitable month to date excluding April 2021 when BTC prices and trade volumes and maybe September 2021 that I have yet to calculate (although contributor costs were higher).

The only anomaly with the figures is cycle 27 had low contributor costs.

If anyone has any comments, questions or suggestions please let me know.

@cbeams
Copy link
Member

cbeams commented Oct 18, 2021

Great to see this come together @pazza83.

A few items of feedback, in no particular order:

  • I would, in principle, see this as an @bisq-network/admin role as opposed to @bisq-network/support, but for practical purposes, I agree it should be managed under support. @leo816, are you OK with reviewing and approving @pazza83's compensation requests relating to this role?

  • The compensation amount requested looks reasonable to me. Certainly worth it to have ongoing profit and loss numbers.

  • I like the simple breakdown of numbers you've started with here. I think it would be worth having a single rolled up, USD denominated revenue number that sums up the BSQ and BTC revenue numbers above, but this is a minor point.

  • It would be good to see the actual BSQ number in the BSQ trade revenue fees line item. Same with contributor costs. Since these are actually denominated in BSQ, it would be good to see a third column "BSQ" that lists these values. Perhaps you could bold the values for each row that represent the original denomination.

  • the link to the spreadsheet above is broken.

  • In the table above, ((BSQ trade revenue fees + BTC trade revenue fees) - Contributor costs) = Net Profit (Loss), but the actual values in the table do not add up. (($8,562+$35,096) - $17,351) = $26,307, but the total listed above is $26,790. This is a minor discrepancy, but it makes me wonder what's missing from the table and/or spreadsheet that led to this.

In any case, I think this is a good start, and if all we do with this role is apply the same methodology to produce the same set of numbers every month, that'll already be a massive improvement. Thanks for taking it on @pazza83.

@pazza83
Copy link
Author

pazza83 commented Oct 19, 2021

Hi @cbeams

Many thanks for the feedback. I have updated the report to include your feedback.

  • I would, in principle, see this as an @bisq-network/admin role as opposed to @bisq-network/support, but for practical purposes, I agree it should be managed under support. @leo816, are you OK with reviewing and approving @pazza83's compensation requests relating to this role?

Yes, agreed. @leo816 asked me to list under support.

  • I like the simple breakdown of numbers you've started with here. I think it would be worth having a single rolled up, USD denominated revenue number that sums up the BSQ and BTC revenue numbers above, but this is a minor point.

I am not sure what you mean with this? Can you expand?

  • It would be good to see the actual BSQ number in the BSQ trade revenue fees line item. Same with contributor costs. Since these are actually denominated in BSQ, it would be good to see a third column "BSQ" that lists these values. Perhaps you could bold the values for each row that represent the original denomination.

Included, and updated.

  • the link to the spreadsheet above is broken.

Fixed

  • In the table above, ((BSQ trade revenue fees + BTC trade revenue fees) - Contributor costs) = Net Profit (Loss), but the actual values in the table do not add up. (($8,562+$35,096) - $17,351) = $26,307, but the total listed above is $26,790. This is a minor discrepancy, but it makes me wonder what's missing from the table and/or spreadsheet that led to this.

The prior table did not include the $483 income from for the DAO received from arbitration fees as a line item. I have included it now and it all balances.

($8,562+$35,096+$483) - $17,351) = $26,790

@cbeams
Copy link
Member

cbeams commented Oct 23, 2021

  • I like the simple breakdown of numbers you've started with here. I think it would be worth having a single rolled up, USD denominated revenue number that sums up the BSQ and BTC revenue numbers above, but this is a minor point.

I am not sure what you mean with this? Can you expand?

I just mean that when a reader sees the two line items below:

August 2021 USD BTC BSQ
BSQ trade revenue fees $8,562 0.18759448 BTC 546.81 BSQ
BTC trade revenue fees $35,096 0.76895773 BTC N/A

They must mentally add up the items to get a "rolled up revenue number", making it hard to answer the basic question "how much did we take in this month?".

I think it's good to see a single, top-line revenue number, denominated in USD, but it can have the calculated BTC and BSQ equivalents right next to it, just for reference.

Basically, it's this top-line revenue number that I would want to track over time. Is that number going up or down, cycle-over-cycle?

Being able to break the top-line revenue number down into BTC and BSQ parts is of course important information too, but I wouldn't want to miss making the top line number explicit and easily trackable.

  • It would be good to see the actual BSQ number in the BSQ trade revenue fees line item. Same with contributor costs. Since these are actually denominated in BSQ, it would be good to see a third column "BSQ" that lists these values. Perhaps you could bold the values for each row that represent the original denomination.

Included, and updated.

Thanks for adding the BSQ column. Instead of putting 'N/A' in the "BTC trade fee revenues" row, however, I'd suggest putting the calculated equivalent BSQ number there too. Just like we do in the other rows with calculated BTC and USD values.

@pazza83
Copy link
Author

pazza83 commented Oct 23, 2021

I have made the above changes and added a few heading to try and make things clearer.

Might also be good to see if I can breakdown trade volume into; Fiat, XMR, other altcoins. I will see if I can do this for the next cycle.

@cbeams
Copy link
Member

cbeams commented Oct 24, 2021

I have made the above changes and added a few heading to try and make things clearer.

The updated report looks great now, IMO. Really gives the at-a-glance overview I think we're all wanting. Will be great to see the trendlines in the reported numbers over time. Thanks!

Here are a few tweaks I'd suggest to tighten up the presentation:

Before

August 2021 USD BTC BSQ
Trade volume
Trade volume $6,527,571 143.0199 BTC 4,157,688 BSQ
Revenue
Total revenue fees $43,658 0.9671348 BTC 28,115.28 BSQ
- Trade revenue fees from BSQ $8,562 0.18759448 BTC 5,461.81 BSQ
- Trade revenue fees from BTC $35,096 0.76895773 BTC 22,354.14 BSQ
- Arbitration fees $483 0.01058259 BTC 307.64 BSQ
Expenses
Contributor costs $17,351 0.38015315 BTC 11,051.32 BSQ
P&L
Net Profit (Loss) $26,790 0.58697158 BTC 17,063.69 BSQ

After

August 2021 USD BTC BSQ
Volume 6,527,571 143.0199 4,157,688
Revenue 43,658 0.9671348 28,115.28
- BSQ trading fees 8,562 0.18759448 5,461.81
- BTC trading fees 35,096 0.76895773 22,354.14
- Arbitration fees 483 0.01058259 307.64
Compensation (17,351) (0.38015315) (11,051.32)
Net Profit (Loss) 26,790 0.58697158 17,063.69

@pazza83
Copy link
Author

pazza83 commented Oct 24, 2021

Thanks, I will use your example as the template for the reports. I have used the template to update the role summary and August's report.

@pazza83
Copy link
Author

pazza83 commented Nov 14, 2021

Profit and loss - September 2021

This is my second cycle as for the Comptroller role.

Please see below the report for September 2021 (which coincides with cycle 28):

September 2021 USD BTC BSQ
Volume 8,838,387 187.3413 5,996,598
Revenue 58,946 1.25615003 40,523
- BSQ trade fees 12,873 0.27286023 8,734
- BTC trade fees 45,408 0.9624898 30,808
- Arbitration fees 665 0.0208 981
Compensation (34,905) (0.73985668) (23,682)
Net Profit (Loss) 24,357 0.51627877 16,525

Percentage of fees paid in BSQ in September 2021 was: 22.09%

Total fees paid as a percentage of revenue was: 0.66%

Link to the spreadsheet I used with comments on the individual line items.

Summary

The profit for September 2021 is roughly the same as August 2021. Trade volume was up in September but as were contributor costs.

There are no anomalies to report.

I have still to complete a review of the data pulled from exporting Bisq associated BTC wallet transactions: bisq-network/bisq#5762

If anyone has any comments, questions or suggestions please let me know.

@ripcurlx
Copy link
Contributor

Please see below the report for September 2021 (which coincides with cycle 28):

Is this exactly the same timeframe as Cycle 28 or just roughly?
Looking at https://bisq.network/dashboard/cycle-28/, there is a different amount e.g. for the BSQ trade fees: 8840 instead of 8374.

@pazza83
Copy link
Author

pazza83 commented Nov 15, 2021

Hi @ripcurlx for the reports I use calendar months as opposed to DAO cycles.

This report is for 1st September - 30th September 2021.

Cycle 28 ran from 29th August - 29th September.

@pazza83
Copy link
Author

pazza83 commented Dec 24, 2021

Profit and loss - October 2021

This is my third cycle as for the Comptroller role.

Please see below the report for October 2021 (which coincides with cycle 29):

October 2021 USD BTC BSQ
Volume 12,896,781 213.6731 6,973,008
Revenue 85,747 1.41182456 46,361
- BSQ trade fees 20,276 0.33592895 10,963
- BTC trade fees 64,418 1.05844561 34,829
- Arbitration fees 1,053 0.01745 569
Compensation (23,090) (0.38255078) (12,484)
Net Profit (Loss) 62,657 1.0380893 33,877

Percentage of fees paid in BSQ in October 2021 was: 32.38% this is up from September's 23.94%.

Total fees paid as a percentage of revenue was: 0.66%

Link to the spreadsheet I used with comments on the individual line items.

Summary

The profit for October 2021 is roughly double that of September 2021. This is because:

  • Trade volume increase
  • BTC price increased
  • Contributor costs were lower than usual

October 2021 shows a very positive increase in all trading metrics.

There are no anomalies to report.

If anyone has any comments, questions or suggestions please let me know.

@pazza83
Copy link
Author

pazza83 commented Jan 20, 2022

Profit and loss - November 2021

Please see below the report for November 2021 (which coincides with cycle 30):

November 2021 USD BTC BSQ
Volume 12,576,491 199.23469978 6,595,600
Revenue 89,512 1.41803696 46,943
- BSQ trade fees 20,873 0.33066666 10,947
- BTC trade fees 66,139 1.0477703 34,685
- Arbitration fees 2,500 0.0396 1,311
Compensation (55,468) (0.87871491) (29,090)
Net Profit (Loss) 34,043 0.53930359 17,853

Percentage of fees paid in BSQ in November 2021 was: 35.46% this is up from October's 23.99%.

Total fees paid as a percentage of revenue was: 0.69%

Link to the spreadsheet I used with comments on the individual line items.

Summary

The profit for November 2021 is roughly half of that for October 2021. This is because revenue stayed roughly the same but contributor costs doubled (I think October was a low month for contributor costs).

There are no anomalies to report.

If anyone has any comments, questions or suggestions please let me know.

@pazza83
Copy link
Author

pazza83 commented Jan 22, 2022

Profit and loss - December 2021

I am posting two reports this month so that going forward the figures should be the preceding month. This should give more up-to-date information.

Here is the report for December 2021 (which coincides with cycle 31):

December 2021 USD BTC BSQ
Volume 12,605,326 245.49772134 8,038,598
Revenue 76,780 1.49535389 48,963
- BSQ trade fees 26,011 0.50658279 16,588
- BTC trade fees 49,873 0.9713211 31,804
- Arbitration fees 896 0.01745 571
Compensation (79,587) (1.55001363) (50,754)
Net Profit (Loss) (2,807) (0.05466832) (1,790)

Percentage of fees paid in BSQ in December 2021 was: 34.27%.

Total fees paid as a percentage of revenue was: 0.6%

Link to the spreadsheet I used with comments on the individual line items.

Summary

The DAO made a small loss of approximately $2,807. Revenue stayed roughly the same but contributor increased by ~ $20,000 (December's contributor costs were higher than usual due to work being complete for large projects such as BSQ Swaps).

There are no anomalies to report.

If anyone has any comments, questions or suggestions please let me know.

@cbeams
Copy link
Member

cbeams commented Jan 22, 2022

So great to see these reports, @pazza83, thanks. Interesting to see how consistent the USD volume / revenue numbers have been over the last several months. Exciting to see that users are trading on the order of a half a million USD of bitcoin every day now (420k/day to be exact 😉).

@pazza83
Copy link
Author

pazza83 commented Feb 4, 2022

Profit and loss - January 2022

Here is the report for January 2022 (which coincides with cycle 32):

January 2022 USD BTC BSQ
Volume 9,981,833 236.0418 8,082,455
Revenue 68,467 1.5701381 55,407
- BSQ trade fees 15,706 1.61907949 12,711
- BTC trade fees 50,511 1.1944739 40,876
- Arbitration fees 2,250 0.0532 1,820
Compensation (37,963) (0.89772512) (30,722)
Net Profit (Loss) 30,504 0.72133938 24,685

Percentage of fees paid in BSQ in January 2022 was: 23.72%.

Total fees paid as a percentage of revenue was: 0.66%

Link to the spreadsheet I used with comments on the individual line items.

Summary

The DAO made a profit of approximately $30,504. Revenue dropped slightly but contributor costs were down were 50% lower than last month, returning to a more usual level.

There are no anomalies to report.

I am going to try and release a report as soon as possible after each cycle to keep reports as current as possible.

If anyone has any comments, questions or suggestions please let me know.

@cbeams
Copy link
Member

cbeams commented Feb 4, 2022

I am going to try and release a report as soon as possible after each cycle to keep reports as current as possible.

Great. I noticed that this one came out faster than last month's. Thanks!

If anyone has any comments, questions or suggestions please let me know.

I notice that what I've started to do every cycle as these reports come out, is to compare the current numbers with the previous cycles' numbers. I bring up a few separate browser windows side-by-side and visually compare the numbers to try to get a sense of how things are trending. I'm trying to get a bigger picture view with regard to history and change over time. A chart would help.

With the reports you've been putting together so far, we finally know the state of the DAO's financials after any given cycle. That's excellent. With these data in hand, we can start plotting them to see trends and get an even better sense of how things are going.

I don't have a particular prescription for how to do such charting, whether it's a single chart, multiple charts, etc, but at a high level, I'd like to see the information in the reports above overlaid with the following additional information:

Seeing trade volume, trade count, revenue and BSQ supply numbers plotted together over time would, I think, open up new levels of insight and intuition about the state of the DAO and the project overall. @pazza83, it seems to me that these are all data we have on hand and it would "just" be about plotting them out and, say, adding a screenshot of and link to that plot in the monthly cycle reports here. I don't want to trivialize the effort that might require, but it seems at least doable. Do you agree? Would others find this valuable? Anyone have anything to add or change about what I've suggested above?

@cbeams
Copy link
Member

cbeams commented Feb 4, 2022

... and I'd also add the 30-day volume-weighted average BSQ/USD price to the list of data points above, as found in the app at DAO > Facts & Figures > Dashboard.

@pazza83
Copy link
Author

pazza83 commented Feb 5, 2022

I notice that what I've started to do every cycle as these reports come out, is to compare the current numbers with the previous cycles' numbers. I bring up a few separate browser windows side-by-side and visually compare the numbers to try to get a sense of how things are trending. I'm trying to get a bigger picture view with regard to history and change over time. A chart would help.

Yes, agreed.

Next month I will propose to complete the reports for:

  • April 2021
  • May 2021
  • June 2021
  • July 2021

This will then mean for the current fiscal year all monthly reports will have been completed.

Once I have this data I will look at putting it into table and then charting the values.

With the reports you've been putting together so far, we finally know the state of the DAO's financials after any given cycle. That's excellent. With these data in hand, we can start plotting them to see trends and get an even better sense of how things are going.

Yes, I think it the reports will be useful for decision making.

I don't have a particular prescription for how to do such charting, whether it's a single chart, multiple charts, etc, but at a high level, I'd like to see the information in the reports above overlaid with the following additional information:

Seeing trade volume, trade count, revenue and BSQ supply numbers plotted together over time would, I think, open up new levels of insight and intuition about the state of the DAO and the project overall. @pazza83, it seems to me that these are all data we have on hand and it would "just" be about plotting them out and, say, adding a screenshot of and link to that plot in the monthly cycle reports here. I don't want to trivialize the effort that might require, but it seems at least doable. Do you agree? Would others find this valuable? Anyone have anything to add or change about what I've suggested above?

Yes , agreed it would be beneficial to have all the data in one chart with ability to toggle on/off the data one requires.

I have no experience of creating charts though so will take it one step at a time. Initially I will likely tabulate the data and then next step work out how best to present it.

In the long-term I think it be useful for the data to all be contained in one place rather than spread between reports here, https://bisq.network/dashboard/ and the DAO section in Bisq.

@pazza83
Copy link
Author

pazza83 commented Feb 5, 2022

... and I'd also add the 30-day volume-weighted average BSQ/USD price to the list of data points above, as found in the app at DAO > Facts & Figures > Dashboard.

Currently for the BSQ calculation I am using the average monthly BSQ/USD price taken from the chart in the DAO:

Capture

Not sure if this is weighted or not? Assuming it is?

@cbeams
Copy link
Member

cbeams commented Feb 6, 2022

All the above sounds good, @pazza83, thanks.

I have no experience of creating charts though so will take it one step at a time. Initially I will likely tabulate the data and then next step work out how best to present it.

I imagine you could get an initial cut put together in the same Google Sheet where you've been doing your calculations so far. For example, @ripcurlx has maintained a variety of different charts this way in the Bisq Reporting Sheet.

Not sure if this [BSQ/USD price] is value weighted or not? Assuming it is?

It is, as per the "30-day volume-weighted average BSQ/USD price" label seen at the top of the screenshot you posted above.

@cbeams
Copy link
Member

cbeams commented Feb 6, 2022

@ripcurlx has maintained a variety of different charts this way in the Bisq Reporting Sheet.

and @pazza83, you may also like to have a look at this, simpler, Bisq Trading Volume Google Sheet if you don't already know about it.

@pazza83
Copy link
Author

pazza83 commented Mar 9, 2024

Profit and loss - February 2024

Here is the profit and loss report for February 2024.

February 2024 USD BTC BSQ
Volume 24,825,121 487.5893 12,859,425
Revenue 197,934 3.8876323 102,531
- BSQ trade fees 66,231 1.30084063 34,308
- BTC legacy trade fees 2,498 **0.04907725 ** 1,294
- BTC legacy delayed payments 202 0.00397125 105
- Burning Man revenue 129,003 2.53374317 66,824
Expenses (235,790) (4.63114269) (122140)
- Contributor costs (68,011) (1.33580154) (35,230)
- DAO Reimbursements (507) (0.00995796) (263)
- Refunds paid out from new DPTs by Refund Agent (167,272) (3.28538319) (86,647)
Net Profit (Loss) (37,856) (0.74351039) (19,609)

The percentage of fees paid in BSQ in February 2024: 22.50%
The total fees paid as a percentage of trading volume in February 2024: 1.19%

Link to the spreadsheet I used with comments on the individual line items.

Summary

The DAO made a loss of approximately $37,856 in February 2024. The main reason for this was that the amount of BSQ burned by burning man reduced by about 60,000 BSQ.

BTC distributed in February 2024 (8.00884733 BTC): 211,221 BSQ
Amount of BSQ burnt in February 2024: 66,824 BSQ
Amount of BSQ burnt as a percentage of the burn target: 32%

@pazza83
Copy link
Author

pazza83 commented Apr 9, 2024

Profit and loss - March 2024

Here is the profit and loss report for March 2024.

March 2024 USD BTC BSQ
Volume 20,119,585 294.06 7,783,205
Revenue 241,548 3.53037264 94,054
- BSQ trade fees 45,147 0.65985092 17,465
- BTC legacy trade fees 3 0.00005 9
- BTC legacy delayed payments 275 0.00401455 710
- Burning Man revenue 188,521 2.53374317 72,929
- Bisq Easy revenue 7,602 0.11110786 2,941
Expenses (306,650) (4.48187663) (118,627)
- Contributor costs (129,643) (1.89481145) (50,152)
- DAO Reimbursements (0) (0) (0)
- Refunds paid out from new DPTs by Refund Agent (177,007) (2.58706518) (68,475)
Net Profit (Loss) (65,102) (0.95150399) (24573)

The percentage of fees paid in BSQ in March 2024: 19.58%
The total fees paid as a percentage of trading volume in March 2024: 1.15%

Link to the spreadsheet I used with comments on the individual line items.

Summary

The DAO made a loss of approximately $65,102 in March 2024. The main reason for this was an increase in contributor compensation and a reduction in trade volume.

BTC distributed in March 2024 (6.05805403 BTC): 160,345 BSQ
Amount of BSQ burnt in March 2024: 72,929 BSQ
Amount of BSQ burnt as a percentage of the burn target: 45%

@pazza83
Copy link
Author

pazza83 commented Apr 9, 2024

Bisq Easy Report - April 2024

I will include a brief report each cycle for some of the obtainable statistics from Bisq Easy. I will publish this at the same time as the profit and loss report. Therefore, it will provide a snapshot to the progress being made with Bisq Easy.

Bisq Easy April May June
Published user profiles 2,109 - -
Offers online 115 - -
Reputation
- No of sellers with reputation >0 126 - -
- No of user above 10,000 Reputation 36 - -
- No of user above 30,000 Reputation 13 - -
Revenue
- BSQ Burnt TBC - -
- BSQ Bonded TBC - -
Problem users
- No of banned buyers TBC - -
- No of banned sellers TBC - -
- No of bonds confiscated TBC - -
- No of confirmed scams (buyer sent payment no BTC received) TBC - -

I will edit the 'TBC' stats at the start of the new month.

If anyone has any ideas on what else they would like to see included please let me know.

@pazza83
Copy link
Author

pazza83 commented Apr 27, 2024

Profit and loss - Fiscal Year 2023/24

Here is the report for June Fiscal Year 2023/24 (1st April 2022 - 31 March 2023)

Fiscal Year 2023/24 USD BTC BSQ
Volume 153,560,562 4117.6779 130,625,916
Revenue $1,699,192 45.5633 1,445,413
Expenses (1,376,082 ) (36.8992 ) (1,170,560)
Average Price of BSQ 1.175575 0.00003152 984,166
Average Price of BTC 37,293 1 31,723
Net Profit (Loss) 323,110 8.6641 274,852

Here are the results for the last 2 fiscal years in USD:

Fiscal Year 2022/3 2023/4
Volume 96,683,552 153,560,562
Revenue 828,570 1,699,192
Expenses (505,656) (1,376,082)
Average Price of BSQ 0.8419 1.175575
Average Price of BTC 24,136 37,293
Net Profit (Loss) 322,914 323,110

Link to the spreadsheet

Summary

In the Fiscal Year 2023/24 the DAO made a profit of approximately $323,110.

The bold amounts in the preceding table show the actual revenue / expenses in their native currency (USD/BTC/BSQ).

A profit of $322,914 USD is roughly equivalent to a reduction in the BSQ supply by 274,852 over this fiscal period.

There are no anomalies to report.

@pazza83
Copy link
Author

pazza83 commented Apr 27, 2024

DAO Profit and loss since introduction of new trade protocol in Jan 2023

Here is the report for the burning men activity between 1st Jan 2023 - 31st March 2024.

Burning Men Protocol USD BTC BSQ
BTC Distributed to Burning Men 2,349,166 64.3398213 2,123,725
BSQ Burnt by Burning Men 1,425,632 41.34183969 1,305,900
Net Profit (Loss) (923,534) (22.99798161) (817,825)

Since the introduction of the new burning men protocol in Jan 2023 the burning men have made a profit of $923,534 (about 23 BTC) from their burning activity. This represents a cost to the DAO of about $923,534 (this is about 817,825 BSQ). This represents the cost of decentralizing the BTC trade fee and delayed payout addresses.

The means for every $1 a burning men receives they are burning $0.60.

Or to put it another way for every $1 in BSQ burnt the burning men receive $1.66 back in BTC.

This is a return of approximately 66%.

This amount would likely be reduced by a change to the protocol to allow the non-absent Trade Peer to Claim Funds Before Arbitration. This will likely be introduced when the existing trade protocol moves over to Bisq 2.

Here is a link to the spreadsheet used.

@pazza83
Copy link
Author

pazza83 commented May 17, 2024

Profit and loss - April 2024

Here is the profit and loss report for April 2024.

April 2024 USD BTC BSQ
Volume 10,917,716 162.7518 4,804,909
Revenue 96,451 1.43782104 42,448
- BSQ trade fees 22,742 0.33901791 10,009
- BTC legacy trade fees 0 0 0
- BTC legacy delayed payments 329 0.00491805 144
- Burning Man revenue 67,695 1.00913806 29,793
- Bisq Easy revenue 5,685 0.08474702 2,502
Expenses (143,543) (2.13981395) (63,174)
- Contributor costs (49,958) (0.74473033) (21,987)
- DAO Reimbursements (0) (0) (0)
- Refunds paid out from new DPTs by Refund Agent (93,585) (1.39508362) (41,187)
Net Profit (Loss) (47,092) (0.70199291) (20,726)

The percentage of fees paid in BSQ in April 2024: 19.64%
The total fees paid as a percentage of trading volume in April 2024: 1.06%

Link to the spreadsheet I used with comments on the individual line items.

Summary

The DAO made a loss of approximately $47,092 in April 2024. The main reason for this was a reduction in trade volume.

BTC distributed in April 2024 (2.55416991 BTC): 75,406 BSQ
Amount of BSQ burnt in April 2024: 29,793 BSQ
Amount of BSQ burnt as a percentage of the burn target: 40%

@pazza83
Copy link
Author

pazza83 commented May 28, 2024

Bisq Easy Report - May 2024

Bisq Easy April May June
Published user profiles 2,109 4,046 -
Offers online 115 89 -
Reputation
- No of sellers with reputation >0 126 192 -
- No of user above 10,000 Reputation 36 51 -
- No of user above 30,000 Reputation 13 15 -
Revenue
- BSQ Burnt 2,941 2,813 -
- BSQ Burnt (cumulative) 2,941 5,754 -
- BSQ Bonded (cumulative) 0 14,457 -
Problem users
- No of banned buyers 0 0 -
- No of banned sellers 0 0 -
- No of bonds confiscated 0 0 -
- No of successful scams 0 0 -
- No of attempted scams 0 1 -

Changing these reports to the end of the month to make it easier to be able to access all the data needed.
Will provide the

@cbeams
Copy link
Member

cbeams commented May 29, 2024

Really appreciate these reports, @pazza83. Thanks!

@pazza83
Copy link
Author

pazza83 commented Jun 24, 2024

Profit and loss - May 2024

Here is the profit and loss report for May 2024.

May 2024 USD BTC BSQ
Volume 8,595,282 132.4552 3,891,028
Revenue 171,222 2.63857630 77,512
- BSQ trade fees 24,844 0.3828515 11,247
- BTC legacy trade fees 0 0 0
- BTC legacy delayed payments 99 0.00153323 45
- Burning Man revenue 140,823 2.17011341 63,750
- Bisq Easy revenue 5,456 0.08407816 2,470
Expenses (112,186) (1.72881093) (50,786)
- Contributor costs (47,659) (0.73443567) (21,575)
- DAO Reimbursements (0) (0) (0)
- Refunds paid out from new DPTs by Refund Agent (64,527) (0.99437526) (29,211)
Net Profit (Loss) 59,036 0.90976537 26,726

The percentage of fees paid in BSQ in May 2024: 24.09%
The total fees paid as a percentage of trading volume in May 2024: 1.20%

Link to the spreadsheet I used with comments on the individual line items.

Summary

The DAO made a profit of approximately $59,036 in May 2024. The main reason for this was an increase in BSQ burnt by burning men.

BTC distributed in May 2024 (2.58299674 BTC): 75,878 BSQ
Amount of BSQ burnt in May 2024: 63,750 BSQ
Amount of BSQ burnt as a percentage of the burn target: 84%

@cbeams
Copy link
Member

cbeams commented Jun 25, 2024

The total fees paid as a percentage of trading volume in April 2024: 1.20%

This looks like a typo above; should be May instead.

@pazza83
Copy link
Author

pazza83 commented Jul 11, 2024

Thanks, I have edited the above.

@pazza83
Copy link
Author

pazza83 commented Jul 11, 2024

Bisq Easy Report - June 2024

Bisq Easy April May June
Published user profiles 2,109 4,046 5,427
Offers online 115 89 87
Reputation
- No of sellers with reputation >0 126 192 215
- No of user above 10,000 Reputation 36 51 68
- No of user above 30,000 Reputation 13 15 21
Revenue
- BSQ Burnt 2,941 2,813 2,470
- BSQ Burnt (cumulative) 2,941 5,754 8,224
- BSQ Bonded (cumulative) 0 14,457 16,612
Problem users
- No of banned buyers 0 0 0
- No of banned sellers 0 0 0
- No of bonds confiscated 0 0 0
- No of successful scams 0 0 0
- No of attempted scams 0 1 0

@pazza83
Copy link
Author

pazza83 commented Jul 17, 2024

Profit and loss - June 2024

Here is the profit and loss report for June 2024.

June 2024 USD BTC BSQ
Volume 15,395,938 233.1976 7,147,271
Revenue 121,682 1.84308744 56,489
- BSQ trade fees 59,532 0.90171309 27,637
- BTC legacy trade fees 0 0 0
- BTC legacy delayed payments 140 0.00212775 65
- Burning Man revenue 57,928 0.87741779 26,892
- Bisq Easy revenue 4,082 0.06182881 1,895
Expenses (138,673) (2.10043773) (64,377)
- Contributor costs (59,849) (0.90651459) (27,784)
- DAO Reimbursements (0) (0) (0)
- Refunds paid out from new DPTs by Refund Agent (78,824) (1.19392314) (36,593)
Net Profit (Loss) (16,991) (0.25735029) (7,888)

The percentage of fees paid in BSQ in June 2024: 22.58%
The total fees paid as a percentage of trading volume in June 2024: 0.79%

Link to the spreadsheet I used with comments on the individual line items.

Summary

The DAO made a loss of approximately $16,991 in June 2024.

BTC distributed in June 2024 (2.52610673 BTC): 77,422 BSQ
Amount of BSQ burnt in June 2024: 26,892 BSQ
Amount of BSQ burnt as a percentage of the burn target: 35%

@pazza83
Copy link
Author

pazza83 commented Aug 4, 2024

Bisq Easy Report - July 2024

Bisq Easy April May June July
Published user profiles 2,109 4,046 5,427 9,009
Offers online 115 89 87 122
Reputation
- No of sellers with reputation >0 126 192 215 213
- No of user above 10,000 Reputation 36 51 68 68
- No of user above 30,000 Reputation 13 15 21 21
Revenue
- BSQ Burnt 2,941 2,813 2,470 1,895
- BSQ Burnt (cumulative) 2,941 5,754 8,224 10,119
- BSQ Bonded (cumulative) 0 14,457 16,612 16,712
Problem users
- No of banned buyers 0 0 0 0
- No of banned sellers 0 0 0 0
- No of bonds confiscated 0 0 0 0
- No of successful scams 0 0 0 0
- No of attempted scams 0 1 0 0

@apemithrandir
Copy link

apemithrandir commented Aug 17, 2024

Profit and loss - June 2024

Here is the profit and loss report for June 2024.
June 2024 USD BTC BSQ
Volume 15,395,938 233.1976 7,147,271
Revenue 121,682 1.84308744 56,489

  • BSQ trade fees 59,532 0.90171309 27,637
  • BTC legacy trade fees 0 0 0
  • BTC legacy delayed payments 140 0.00212775 65
  • Burning Man revenue 57,928 0.87741779 26,892
  • Bisq Easy revenue 4,082 0.06182881 1,895
    Expenses (121,682) (2.10043773) (64,377)
  • Contributor costs (78,824) (0.90651459) (27,784)
  • DAO Reimbursements (0) (0) (0)
  • Refunds paid out from new DPTs by Refund Agent (64,527) (1.19392314) (36,593)
    Net Profit (Loss) (16,991) (0.25735029) (7,888)

The percentage of fees paid in BSQ in June 2024: 22.58% The total fees paid as a percentage of trading volume in June 2024: 0.79%

Link to the spreadsheet I used with comments on the individual line items.

Summary

The DAO made a loss of approximately $16,991 in June 2024.

BTC distributed in June 2024 (2.52610673 BTC): 77,422 BSQ Amount of BSQ burnt in June 2024: 26,892 BSQ Amount of BSQ burnt as a percentage of the burn target: 35%

I know the bitcoin price fluctuates but in the expenses Contributor costs how does (0.90651459) BTC equal (78,824) USD during June?

edit: I see from the spreadsheet the numbers are different. Can the post be updated with the correct numbers?

@pazza83
Copy link
Author

pazza83 commented Aug 17, 2024

I know the bitcoin price fluctuates but in the expenses Contributor costs how does (0.90651459) BTC equal (78,824) USD during June? edit: I see from the spreadsheet the numbers are different. Can the post be updated with the correct numbers?

Thanks for spotting. I have made the edits. Looks like there were three numbers in the expenses section that had not been copied over from the table correctly. I will start checking the table here after posting to make sure the numbers add up in future to prevent this. Many thanks

@pazza83
Copy link
Author

pazza83 commented Aug 17, 2024

Posting for reference:

Bisq BTC address snapshots 17.08.24

Address Notes BTC balance
38bZBj5peYS3Husdz7AH3gEUiUbYRD951t Trade fees 0.04912725
34VLFgtFKAtwTdZ5rengTT2g2zC99sWQLC Donation address ‎0.01586118
1BVxNn3T12veSK6DgqwU4Hdn7QHcDDRag7 Default donation address ‎0.06158135
3EtUWqsGThPtjwUczw27YCo6EWvQdaPUyp burning2019 0.00020000
3A8Zc1XioE2HRzYfbb5P8iemCS72M6vRJV burningman2 0.02210000

Still just the occasional payment is going to the above addresses.

The funds in address 34VLFgtFKAtwTdZ5rengTT2g2zC99sWQLC were used by the old burning man to purchase 15,735.72 BSQ and burn them in February 2024..

@pazza83
Copy link
Author

pazza83 commented Aug 17, 2024

Profit and loss - July 2024

Here is the profit and loss report for July 2024.

July 2024 USD BTC BSQ
Volume 9,827,513 155.3266 4,804,220
Revenue 163,550 2.58496567 79,972
- BSQ trade fees 26,738 0.42260154 13,071
- BTC legacy trade fees 0 0 0
- BTC legacy delayed payments 36 0.0005813 18
- Burning Man revenue 135,048 2.13447131 66,019
- Bisq Easy revenue 1,728 0.02731152 864
Expenses (123,277) (1.94842736) (60,265)
- Contributor costs (72,976) (1.15340603) (35,675)
- DAO Reimbursements (0) (0) (0)
- Refunds paid out from new DPTs by Refund Agent (50,301) (0.79502133) (24,590)
Net Profit (Loss) 40,273 0.63653831 19,707

Average Price of BSQ July 2024 = $2.0456
Average Price of BTC July 2024 = $63,270

The percentage of fees paid in BSQ in July 2024: 22.58%
The total fees paid as a percentage of trading volume in July 2024: 0.97%

Link to the spreadsheet I used with comments on the individual line items.

Summary

The DAO made a profit of approximately $40,273 in July 2024.

BTC distributed in July 2024 (1.89498378 BTC): 58,611 BSQ
Amount of BSQ burnt in July 2024: 66,019 BSQ
Amount of BSQ burnt as a percentage of the burn target: 112%

@pazza83
Copy link
Author

pazza83 commented Sep 2, 2024

Bisq Easy Report - August 2024

Bisq Easy April May June July August
Published user profiles (active in last 15 days) 2,109 4,046 5,427 9,009 6,250
Offers online 115 89 87 122 112
Reputation
- No of sellers with reputation >0 126 192 215 213 209
- No of user above 10,000 Reputation 36 51 68 68 73
- No of user above 30,000 Reputation 13 15 21 21 21
Revenue
- BSQ Burnt 2,941 2,813 2,470 1,895 897
- BSQ Burnt (cumulative) 2,941 5,754 8,224 10,119 11,016
- BSQ Bonded (cumulative - from profiles active in last 15 days)** 0 14,457 16,612 16,712 14,705
Problem users
- No of banned buyers 0 0 0 0 0
- No of banned sellers 0 0 0 0 1
- No of bonds confiscated 0 0 0 0 0
- No of successful scams 0 0 0 0 4
- No of attempted scams 0 1 0 0 0

There is a current issue with the data only including information with users connected in the last 15 days. This is why the cumulative BSQ bonded amount has dropped. Will find out if this can be fixed so the report can include all users for Bisq Easy.

@pazza83
Copy link
Author

pazza83 commented Sep 26, 2024

Profit and loss - August 2024

Here is the profit and loss report for August 2024.

August 2024 USD BTC BSQ
Volume 10,847,645 177.6526 5,914,423
Revenue 151,045 2.47367792 77,999
- BSQ trade fees 31,961 0.52342739 13,071
- BTC legacy trade fees 0 0 0
- BTC legacy delayed payments 103 0.0016909 56
- Burning Man revenue 117,334 1.92158661 63,974
- Bisq Easy revenue 1,647 0.02697302 898
Expenses (90,342) (1.47953685) (49,257)
- Contributor costs (63,942) (1.04718232) (34,863)
- DAO Reimbursements (0) (0) (0)
- Refunds paid out from new DPTs by Refund Agent (26,400) (0.43235453) (14,394)
Net Profit (Loss) 60,703 0.99414107 28,742

Average Price of BSQ August 2024 = $1.8341
Average Price of BTC August 2024 = $61,061

The percentage of fees paid in BSQ in August 2024: 33.40%
The total fees paid as a percentage of trading volume in August 2024: 0.88%

Link to the spreadsheet I used with comments on the individual line items.

Summary

The DAO made a profit of approximately $60,703 in August 2024.

BTC distributed in August 2024 (1.52738828 BTC): 50,849 BSQ
Amount of BSQ burnt in August 2024: 63,974 BSQ
Amount of BSQ burnt as a percentage of the burn target: 126%

@pazza83
Copy link
Author

pazza83 commented Oct 5, 2024

Bisq Easy Report - August 2024

Bisq Easy April May June July August September
Published user profiles (active in last 15 days) 2,109 4,046 5,427 9,009 6,250 6296
Offers online 115 89 87 122 112 117
Reputation
- No of sellers with reputation >0 126 192 215 213 209 164
- No of user above 10,000 Reputation 36 51 68 68 73 59
- No of user above 30,000 Reputation 13 15 21 21 21 22
Revenue
- BSQ Burnt 2,941 2,813 2,470 1,895 897 2,645
- BSQ Burnt (cumulative) 2,941 5,754 8,224 10,119 11,016 13,661
- BSQ Bonded (cumulative - from profiles active in last 15 days)** 0 14,457 16,612 16,712 14,705 10,351
Problem users
- No of banned buyers 0 0 0 0 0 0
- No of banned sellers 0 0 0 0 1 0
- No of bonds confiscated 0 0 0 0 0 0
- No of successful scams 0 0 0 0 4 0
- No of attempted scams 0 1 0 0 0 0

These stats might move around a bit when the way the reputation score is calculated in changed in the next release.

@pazza83
Copy link
Author

pazza83 commented Oct 21, 2024

Profit and loss - September 2024

Here is the profit and loss report for September 2024.

September 2024 USD BTC BSQ
Volume 16,856,711 279.6866 9,962,595
Revenue 142,723 2.36807027 84,352
- BSQ trade fees 52,741 0.87507881 31,171
- BTC legacy trade fees 0 0 0
- BTC legacy delayed payments 23 0.0003915 13
- Burning Man revenue 85,484 1.41835075 50,523
- Bisq Easy revenue 4,475 0.07424921 2,645
Expenses (98,568) (1.63544051) (49,257)
- Contributor costs (57,575) (0.95528455) (34,028)
- DAO Reimbursements (0) (0) (0)
- Refunds paid out from new DPTs by Refund Agent (40,993) (0.68015596) (24,228)
Net Profit (Loss) 44,155 0.73262976 26,096

Average Price of BSQ September 2024 = $1.692
Average Price of BTC September 2024 = $60,270

The percentage of fees paid in BSQ in September 2024: 41.04%
The total fees paid as a percentage of trading volume in September 2024: 0.76%

Link to the spreadsheet I used with comments on the individual line items.

Summary

The DAO made a profit of approximately $44,155 in September 2024.

BTC distributed in September 2024 (1.9952805 BTC): 71,073 BSQ
Amount of BSQ burnt in September 2024: 50,523 BSQ
Amount of BSQ burnt as a percentage of the burn target: 71%

@pazza83
Copy link
Author

pazza83 commented Nov 2, 2024

Bisq Easy Report - October 2024

Bisq Easy April May June July August September October
Published user profiles (active in last 15 days) 2,109 4,046 5,427 9,009 6,250 6,296 6,755
Offers online 115 89 87 122 112 117 99
Reputation (active in last 15 days)
- No of sellers with reputation >0 126 192 215 213 209 164 178
- No of user above 10,000 Reputation 36 51 68 68 73 59 94
- No of user above 30,000 Reputation 13 15 21 21 21 22 30
Revenue
- BSQ Burnt 2,941 2,813 2,470 1,895 897 2,645 1,007
- BSQ Burnt (cumulative) 2,941 5,754 8,224 10,119 11,016 13,661 14,668
- BSQ Bonded (cumulative - from profiles active in last 15 days)** 0 14,457 16,612 16,712 14,705 10,351 20,051
Problem users
- No of banned buyers 0 0 0 0 0 0 0
- No of banned sellers 0 0 0 0 1 0 0
- No of bonds confiscated 0 0 0 0 0 0 0
- No of successful scams 0 0 0 0 4 0 0
- No of attempted scams 0 1 0 0 0 0 0

These stats have moved around a bit due the way the reputation score changed the way it was calculated in v2.1.2.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

7 participants