Monday, May 27, 2024
Home Tech How to make Excel monitor your cryptocurrencies

How to make Excel monitor your cryptocurrencies

355
0

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.


Step 2

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.


Excel and cryptocurrencies

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.


Step 4

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.


step 5

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.


Step 6

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.


Step 7

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.

Source: Computer Hoy

Previous articleHow many moons does the planet Jupiter have and what are they like?
Next articleApple Watch not working well for you? This is the best way to fix it
I am Bret Jackson, a professional journalist and author for Gadget Onus, where I specialize in writing about the gaming industry. With over 6 years of experience in my field, I have built up an extensive portfolio that ranges from reviews to interviews with top figures within the industry. My work has been featured on various news sites, providing readers with insightful analysis regarding the current state of gaming culture.

LEAVE A REPLY

Please enter your comment!
Please enter your name here