2Yr·

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

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

17 Comments

Nostradonkey💩@DonkeyInvestor

2Yr

You're an IT specialist ... 🧐🤔

•

Lorena@Lorena

2Yr

@DonkeyInvestor I think so, too. The picture is becoming clearer and clearer. 😈

••

Nostradonkey💩@DonkeyInvestor

2Yr

@Lorena Would also explain the face color. Normally always cheese white but once accidentally come when getting mail in the sun and bang - sunburn of death 🆘🆘🆘

•

Europoor@Europoor

2Yr

@DonkeyInvestor Crap I got caught.

•

Lucrash@KapriolenCapital

2Yr

@DonkeyInvestor Very good, another one with which we can build getquin 2 🦍

•

Nicolas Professioneller Rolls Royce Großaktionär Coole Leute: @leveragegrinding, @SharkAce und @Lorena(aber die ist nen bisschen schüchtern)@getquinfuermerchverkauft

2Yr

@meta back spreadsheet out🌚

•

Deleted User

2Yr

Comment was deleted

Nicolas Professioneller Rolls Royce Großaktionär Coole Leute: @leveragegrinding, @SharkAce und @Lorena(aber die ist nen bisschen schüchtern)@getquinfuermerchverkauft

2Yr

@meta yes yes exactly

••

Moritz@leveragegrinding

2Yr

@getquin digga you spam under every crap post I read ccf BOY DOES NOT MAKE SENSE

••

Nicolas Professioneller Rolls Royce Großaktionär Coole Leute: @leveragegrinding, @SharkAce und @Lorena(aber die ist nen bisschen schüchtern)@getquinfuermerchverkauft

2Yr

@leveragegrinding Hihi

••

View one more answer

Lorena@Lorena

2Yr

@ccf huiiii 🚀

•

CryptoPfand@CryptoPfand

2Yr

Can you please add a Visual Basic script to the post so that it also works with Excel? Thank you!

•

Europoor@Europoor

2Yr

@CryptoPfand It should be very easy to import the API URL via "Import data from the web" and Excel will recognize that it is JSON. Here it is shown quite well: https://www.howtoexcel.org/how-to-access-a-json-api-with-power-query/

••

Lucrash@KapriolenCapital

2Yr

Nice contribution! You could btw. also make with Google Sheets API queries in which you build custom macros or functions. I made the Bison price query with it and could use it easily.

•

Europoor@Europoor

2Yr

@KapriolenSonne As written this does not work with Binance, otherwise I would have done it in the googlesheet. Or can you set it so that the queries are executed locally?

••

Lucrash@KapriolenCapital

2Yr

@Europoor You could interpose a dumb proxy but is annoying. If not coinmarketcaps api should be able to help.

•

Europoor@Europoor

2Yr

@KapriolenSonne CMC would be an option, but I don't know how current the prices are. Too large offset between the queries also distorts the results, so I wanted at least to pre-calculate really directly query the stock exchange. With Bison you already have the problem that the data is not updated every second via the URL. As with other marketplaces have not tried it but think the make only per minute or so. At BSDEX I have found nothing where current data is given to the outside. In the widget, for example, the rates are updated very slowly: https://widgets.bsdex.de/de/markets/?hide_cta=1&range= otherwise https://api.bsdex.de/btc-eur/quote would work, but you have to send an authtoken that you have to pull from the web version. Since the API is not officially offered. kA what the token gives access to everything (guess everything) so I was not so keen on it to deposit somewhere.

•