How to make Excel monitor your cryptocurrencies

Today we will show you how you can create a portfolio of crypto assets using an excel sheet, where you will tell us what is the value of bitcoin, ethereum, dogecoin and all those currencies that investors love so much.

Although the market is in a doldrums right now and coins are worth less every day, there are many people interested in upgrading their portfolio to be prepared for what they have to buy or sell.

Just today, a well-known Bloomberg economist said that Bitcoin should hit $100,000 in 2025, and with this Excel, you can find out from your desktop without going to any web page or mobile app.

The first thing we need to do is open an excel sheet and copy the Binance API: https://api.binance.com/api/v3/ticker/price. We will use this now.

With the Excel sheet open, we go to the data and click on From Web. We then paste the binance API into the box that appears below.

After that, a pop-up window will appear. What you need to do is hit: On the table.

And then they give to accept the box that comes out. Simple and easy.

Now it’s time to click on the column itself, don’t worry because everything is marked with red arrows.

After that, click OK when the three columns are checked.

We click on the “Price” column and then on “Replace Values”.

Let’s replace the dots “.” separated by comma”,”. Here below you have instructions, it seems complicated but it is very easy.

Then where it says “ABC” we click on it and change it to 1.2 which is a decimal number.

And then we click “Filter by Text” to place USDT. USDT stands for Tether (USDT), a stablecoin.

Done, close, download and accept. If we did everything right, this is what we should get on our Excel page.

Finally, go to properties, click on this icon and set “Update every 1 minute”. Accept later.

With all this, we will already have our portfolio updated, and for now from the desktop itself, no web pages or apps, just our Excel sheet and a bit more.