𝙺𝚛𝚢𝚙𝚝𝚘𝚋ö𝚛𝚜𝚎𝚗 𝚅𝚎𝚛𝚐𝚕𝚎𝚒𝚌𝚑 - 𝚃𝚊𝚋𝚎𝚕𝚕𝚎 𝚗𝚊𝚌𝚑𝚋𝚊𝚞𝚎𝚗

Here is an explanation of how to build a table analogous to the one I showed at [0]. I use LibreOffice because everyone can download it for free and Linux users often have it installed already. You can do something similar in Excel or other spreadsheets. Originally I wanted to do this in a Google Sheet, but there is the problem that the IP of Google is constantly blocked by Binance.

LibreOffice Calc cannot evaluate JSON and perform GET requests by default. This can be changed with a plugin. Link to the Github with the docs at [1]. Since there is only the code, the download links for the plugin no longer work and probably no one wants to compile it themselves, there is a backup at [2].

The oxt then in Calc via Tools > Extension Manager > Add, add.

Then you can start to build API queries. If you want to have a look at the documentation of the API of different exchanges, you will find a collection of links below, as well as a compilation of the links to the fee tables.

If you just want to make price queries you can use my cell values. These can be found under [3]. You then only have to unify the queried values. Also the queries of the conversion rates are included.

To have everything as comfortable as possible, I recommend to multiply once with the Euro / USDT cell and to divide it out again. This changes nothing in the result, but you can now select the Euro / USDT and with the key F9 all values again query and calculate. Because the values of all cells with exchange rates now depend on the Euro / USDT cell.

You can use the conditional formatting functionality to automatically colorize cells. For example to show automatically where you get the biggest / smallest amount of coins. (Select cells > Format > Conditional formatting > Color bar)

[0] https://app.getquin.com/activity/AWIfMnuORw

[1] https://github.com/DmytroBazunov/LibreOfficeGetRestPlugin/wiki

[2] https://gist.github.com/ThomasG77/4ed97370af8355feabf50cb2909198a0

[3] https://paste.dismail.de/?a358130235a5d5a7#6gSuma1rXEKvtLsZA7VSZpuH8ajMx8ycwHoNc2u6mUVi

Fee Links: https://paste.dismail.de/?53ebbebde70ec610#Aq5DZ4i4Wqm7xztWUbGZgTDGf2vCvWcSvjBtzp6cwx44

API Docs: https://paste.dismail.de/?ac7d2e661b519dc4#A1iDVPf9ZuKTXSvxFu2MDKC83R1Uk4Gvf958tapwn4XD