thumbnail

How to track Cryptocurrency prices using LibreOffice Calc spreadsheet

📰2 years ago733 views

This was made possibe thanks to cryptorates.ai.

You can also track the prices using Google Sheets and Microsoft Excel (you will find more information on his website).

In this tutorial I would like to show you how to easily track top 4000+ cryptocurrency prices with an open source Libre Office.  So let's begin!


Step 1:

Open LibreOffice with blank Calc spreadsheet and create Sheet2 at the bottom. Open it.


Step 2:
  • Go to: Sheet tab at the top panel and select External Data option.
  • Set the time how often you want it to update prices while file is open at the bottom.
  • Paste link "https://cryptorates.ai/files/standard.csv" in top field and press enter.
  • Select only Separated by Comma option and click OK on both windows.
  • You should see all cryptos added to your spreadsheet, now go back to Sheet1.



Step 3:
  • Type any cryptocurrency ticker in A1 cell.
  • Paste following function to B1 cell "=VLOOKUP(A1,$Sheet2.A$2:$Sheet2.C$4001,2,FALSE())".
  • Paste following functi...