Exporting Tokens and Transactions
TL;DR
OISY allows you to export your token or transaction lists into a text file in CSV format.
Export tokens or transactions
Please have a look at the chapter on rounding before you process the exported data via a spreadsheet tool.
You can initiate your export on the "Settings" page:

The Basic exports contain a smaller set of exported columns and focus mainly on the information needed to get a good overview and don't expose blockchain specific details.
Extended exports also add blockchain specific information to the exports, such as contract addresses, token precision, or token standard. Those are intended for advanced crypto users.
Please verify that all token balances and prices have completely loaded before you start an export, or you might miss some some tokens or transactions in the export.
You can access the Google Sheets template we made for the following screenshots and make a copy for your own use. https://docs.google.com/spreadsheets/d/1RWnR_Y0qqMQmHuWjSko7oWEfzuhcXGqIcmusEt3omv0/edit?usp=sharing
Token Exports
Basic
Exports a minimal set of columns
The Balance is exported regular number, e.g. 12.4789654
The Value is exported in your currently selected currency

Extended
Also exports the token standard and the address of the token
The Balance is exported as full integer, together with the number of digits precision
Price and Value are both exported in USD and in your currently selected currency

Transaction Exports
Basic
Exports the core data for a transaction
The Timestamp is in your local timezone
The Amount is exported regular number, e.g. 12.4789654
The Counterparty shows either the sender address (for a receive) or the destination address. It's resolved into the contact name (and address alias in parenthesis) if found.
The Fee is shown separately.
To help summarizing, 3 additional helper columns show the amount either as Credit (for incoming) or as Debit. The third column, Fee Token Debit, shows the fee amount paid with the network native coin on EVM networks (mostly ETH).
It also shows the Transaction ID.

Extended
Shows some additional columns compared with the Basic version
Timestamp is in UTC (Zulu time, GMT, ...)
Also shows From and To addresses for all transactions
And also contains an Explorer Link to an app showing this specific transaction

A word on rounding
Crypto tokens often use a precision of 18 or even up to 24 digits after the decimal separator, which can lead to numbers that need a larger amount of digits to represent. Spreadsheet tools usually only allow up to 15 significant digits per numeric value, which can lead to a loss of precision when importing them, or that a value is then imported as text instead of a numeric value.
Note that OISY exports the full precision into the CSV text files. Rounding can happen when importing them into spreadsheet tools.
Problems
Problem 1 - Precision
Tokens use up to 24 places after the decimal point to store a balance. For example you can have
1234.123456789012345678901234 NEAR, a number that needs 28 digits to represent.Spreadsheet tools can only store at max 15 significant digits (leading and trailing zeros don't count) per numeric value, for example:
1234567890123450000000000(stored as123456789012345e10)1234.123456789010.1234567890123450.00000123456789012345(stored as1.23456789012345e-6)
Problem 2 - Automatic conversion with precision loss
When you import a text file into a spreadsheet tool, a value that represents a numeric value can automatically be converted into a number and then cut to the maximum precision, so
The value in the CSV fils is
0.1234567890123456789The resulting value in the spreadsheet will be
0.123456789012345
Note that spreadsheet tool allow to import without automatically converting a cell into a numeric value. In this case the value would be imported as a text:
"0.1234567890123456789"
But this cell then can not be used in mathematical functions.
This means that it's not always possible to import all balances and amounts as numbers into a spreadsheet while keeping the full precision. But having 15 significant digits mean that if some digits are cut off, they contribute less than 0.0000000000001% of its value, so the rounding is not all too bad.
OISY exports all token amounts with full precision into the CSV export files.
The Basic exports export them as regular numbers, containing a decimal point.
5.1234USDC will be exported as5.1234
The Extended exports write the amounts as Integer value without decimal points, and also exports a column indicating the number of digits precision of the token.
5.1234USDC will be exported as5123400and a column indicating that USDC has6digits precision
The Basic exports allow to easily import the numbers anywhere without further processing, but you might lose those digits after 15. While the Extended exports allow safer imports, as large integer value are usually not automatically rounded by spreadsheet tools, and remain a text value.
Last updated