How can I import cryptocurrency prices in excel sheet?

CounterEntropy

full member

Activity: 214

Merit: 278

Quote from: Little Mouse on June 18, 2020, 09:36:11 PM

I am looking for a way to import cryptocurrency prices into an excel sheet to monitor some currencies in my preference. I did not find a good article in the web or I have missed. Can someone share me a detailed way or link me an article which is easy to understand? Because I am not expert on this things.

Cryptocurrency prices are always dancing and to grab them every moment, the host of your excel sheet must always be online as well. This can be done through API with Google Sheet as many have already suggested, though I'd say updating a MySQL DB would be better and easier than updating an excel sheet. But, you have a far easier alternative that serves the same purpose.

Check: https://coinhodler.io

mikeywith

legendary

Activity: 2394

Merit: 6581

be constructive or S.T.F.U

Here is an excel sheet that imports the price of the top 100 coins on CMC > https://easyupload.io/tdvt0w

It has an auto-update every 60 seconds, and it updates once you open the file (outside of the 60 seconds range), there are other settings you can play with under Data tab > properties, it's pretty much the public API TryNinja mentioned above, with a little bit more settings.

The problem with this native excel import function is that you can't change much in the layout and content, so if you delete the volume column for an example, it will come back the moment it refreshes, it will even override any data you enter, so what I usually do is create a separate sheet for what I need to work on, something like this.

You can copy the columns/cells you need from Sheet1 using CRL+C and then on Sheet2 you right-click > Paste special > Paste link, this way you end up with 1 messy sheet that has all the data you need and don't need and one nice clean sheet which contains only the data you need and it will automatically update from sheet1.

AB de Royse777

legendary

Activity: 2464

Merit: 3878

Hire Bitcointalk Camp. Manager @ r7promotions.com

If you are using Google Spreadsheet then they already have extensions which can be found in their add-ons tab

Add-ons > Get add-ons > Search for "CRYPTO"

You will be seeing a list of extensions related to CRYPTO. In the past I have used CRYPTOFINANCE. Try that if you want to.

TryNinja

legendary

Activity: 2758

Merit: 6830

You can get any data from an public API to your excel file by using the option: Data -> Get Data -> From Other Sources -> From Web.

Take a look at this article: https://steemit.com/cryptocurrency/@tomshwom/excel-portfolio-how-to-get-live-prices-and-stats
It shows some examples with CoinMarketCap and Coincap, but it should work with pretty much every API.

Little Mouse

legendary

Activity: 2156

Merit: 2100

Marketing Campaign Manager |Telegram ID- @LT_Mouse

Quote from: jackg on June 18, 2020, 09:40:10 PM

What coins are you after?

I am trying to get price of Bitcoin and ETH for example, actually it is bigger because I am looking for monitoring couple of more currency. Is it possible to get data from web as I found an option in excel? I would like to get data from cmc if possible because I need more currencies to look at.

jackg

copper member

Activity: 2856

Merit: 3071

https://bit.ly/387FXHi lightning theory

What coins are you after? I use investing.com to get bitcoin daily data normally every so often (they have weekly and monthly options). You just download as a csv and import into a spreadsheet. You could also try getting data from exchanges like coinbase if they have the facilities for it (not sure if they do or not)...,

Little Mouse

legendary

Activity: 2156

Merit: 2100

Marketing Campaign Manager |Telegram ID- @LT_Mouse

I am looking for a way to import cryptocurrency prices into an excel sheet to monitor some currencies in my preference. I did not find a good article in the web or I have missed. Can someone share me a detailed way or link me an article which is easy to understand? Because I am not expert on this things.

Topic: How can I import cryptocurrency prices in excel sheet? (Read 286 times)