How you can validate Circulation from the Kinesis blockchains

You can download a CSV file of the KAU or KAG blockchains from the watcher node that Derek has set up.
There are two separate blockchains, one for KAU and one for KAG.
The explorer that Derek has attached is from a third party, so you will be using independent tools for your analysis.
The CSV file is I think a raw Stellar format, rather than what Kinesis have summarised/formatted in the Kinesis Explorer.
The process below should be accessible to anyone with basic spreadsheet understanding and webpage navigation.

Once you have the CSV files, you can use them in conjunction with the spreadsheet templates attached below.

The whole process, including the download should take less than 15 mins for each blockchain.
Once done, you should be able to match the Circulation figures displayed in the Kinesis Explorer.
You will also have a historical running total of the mintings, redemptions and circulation after each blockchain operation.

I've included some explanation of the format and calculation fields included in my spreadsheet.

Format of spreadsheet
The template spreadsheet for KAG below includes a sample of 500 or so records from a complete CSV download of the KAG blockchain.
The one for KAU includes a sample of 1500 or so records.


Calculation columns added
You'll notice that I've added 3 basic data columns.

• Minted1
• Minted2
• Redeemed1

Then some running total columns

• Cumulative Minted (working from the earliest record, Minted1+Minted2+ previous Cumulative Minted)
• Cumulative Redeemed (working from the earliest record, Redeemed+ previous Cumulative Redeemed)
• Net Circulation (Cumulative Minted-Cumulative Redeemed)

Once you have identified the timestamp that you're interested in (createdAt field), you can just read off the Net Circulation for that row.


Within the Kinesis blockchain, most of the accounts are "inside the KMS", however there are a few accounts that are not.
Examples of those that are not are:

• Root account
• Emissions account

In corresponding fashion, some of the gold and silver exists "inside the KMS" vaults, while some exists outside, even if that is available to purchase via the minting process.


Explanation of the basic data columns
Mintings
Minted1
Captures mintings to a pre-existing address eg a wallet that's previously had a balance.
TypeI of 1 indicates a Payment operation.
If the from field is the Minting emission account, and it's not a transfer to the root or inflation accounts, then it's a valid minting, with the amount field giving the amount minted.


Minted2
Captures mintings to an account that doesn't yet exist (have a balance). This could be an as yet unused wallet (no balance) or a KM account (always has zero balance apart from fleetingly before the balance is swept to the central Kinesis Exchange account).
TypeI of 0 indicates a Create account operation.
If the funder field contains the Minting emission account, and the account field is neither root or inflation account, the startingBalance gives the amount minted.

Redemptions
With redemptions, the Minting emission/Redemption account will always have a balance so we don't need to look for the type of operations in Minted2. It had to be seeded at the start to facilitate mintings and given it's core function, it won't have been merged with another account, causing it not to exist/not have a balance.


Redeemed
TypeI indicates Payment operations.
Redemptions are only valid if from the Hot wallet and must be to the Emissions/Root account.
For these records, the amount field will give the amount redeemed.


As a guideline, as at 16th Feb 2023, these were the number of records in the CSV download files (inc header):
KAU 82k+
KAG 29k+

 

[Uchiki]

Step by Step

This is what I found worked best. It took about well under 15 mins. Probably a bit less for KAG as the file is smaller.
If you want to validate the mintings/redemptions/circulation figures at the top of the Kinesis Explorer, refresh that as you start step 4.

1. Open the KAU template.
2. Go to watcher.aboutkinesis.com. Just remember to go into the Set Custom Network button and set it either to https://kau.aboutkinesis.com or https://kag.aboutkinesis.com. (This is a service that Derek is running). Chose https://kau.aboutkinesis.com
3. Click on Operations, then scroll down to bottom of page and click on Export data as CSV
4. Open the CSV file in Excel/LibreOffice/etc.
5. Next you want to copy columns A to U from the CSV and paste into the template. In theory, this should be as simple as literally highlighting columns A to U, ctrl-C to copy to clipboard (the complete columns, not cells).
   In practice, the 3rd party explorer on Derek's watcher node doesn't output the CSV columns in a consistent order. So, to do the copying, you'll first need to match up the column headers between the CSV and the template. If A to U match, copy them in one block. If not, you'll need to copy and paste them in matching blocks. This just affects steps 5 to 7. The instructions below assume that the sequence matches from A to U.
6. Switch to the KAU template.
7. Put the cursor in cell A1 and ctrl-V to paste the clipboard.
8. Identify the last row of data and click in cell AC{last row}
9. Scroll back to the top (scrollbar will be quickest). Shift click in cell W2. This will select all the cells you want the forumlae to be in.
10. ctrl-D to copy down the formulae.
11. Save the file. Depending on your machine's resources, you may experience pauses as your spreadsheet application becomes unresponsive while it catches up to processing the amount of data involved.
12. You now have the accumulated mintings, redemptions and circulation, which you can read off for any timestamp since the KMS was started.

For some reason if you paste the formulae cells into the CSV, they don't function - all return zero.
In a previous iteration, for each formula, I copied the part after the = sign to a wordpad doc, then pasted it back into the cell. This got them working again. I'm using LibreOffice.
The above numbered steps worked well for me without having to mess about with the formulae.