Import coinmarktecap data into excel spreadsheet

karsyla

full member

Activity: 248

Merit: 112

Time is money so I went and bought a Rolex

Quote from: NuttyOrange on December 23, 2017, 06:32:50 PM

Quote from: karsyla on December 21, 2017, 01:23:53 AM

Quote from: NuttyOrange on December 21, 2017, 12:50:46 AM

Try octaparse or webscraper.io they both used in scraping. Or let somebody to the scraping for you. Hire some freelancer who can do a web scraping.

but do u think thats possible with excel? because I want to perform certain calculations and that would be easy with excel.

It is okay, the output format is either in xlsx or csv file. You can still perform calculations and formulas if needed. More like you will get a raw data that needs cleaning.

but I need raw data that can refresh as often as possible and excel is perfect for that, it allows refreshing data of queries every 1 min.

Still looking for a solution of importing exchanges' API into excel!!

NuttyOrange

newbie

Activity: 65

Merit: 0

Quote from: karsyla on December 21, 2017, 01:23:53 AM

Quote from: NuttyOrange on December 21, 2017, 12:50:46 AM

Try octaparse or webscraper.io they both used in scraping. Or let somebody to the scraping for you. Hire some freelancer who can do a web scraping.

but do u think thats possible with excel? because I want to perform certain calculations and that would be easy with excel.

It is okay, the output format is either in xlsx or csv file. You can still perform calculations and formulas if needed. More like you will get a raw data that needs cleaning.

slyfox

member

Activity: 350

Merit: 10

Quote from: LuanX3 on December 20, 2017, 02:29:34 PM

Better if you guys just used google sheets to do this, there is already an app that allows you to import the prices and you don't need to code anything else. It's an add-on called cryptofinance. You just need to input the pair (ETH/BTC, LTC/BTC, NLC2/BTC, BAT/ETH, etc.). Then the add-on just takes the prices from coinmarketcap instantly. I've used this for quite sometime and it's been reliable so far.

Thanks for the tip I did not even knew that existed I'm going to test it and report my results.

hastag_80

member

Activity: 392

Merit: 11

The New Pharma-Centric Marketplace

Quote from: karsyla on December 19, 2017, 06:19:08 PM

Hello,

I am looking for a solution to track coins' price and change in my excel spreadsheet.

I found this video and this would be a great solution to me, but it does not work because I am getting script errors, and no matter what I press (yes/no), they still keep popping up:
https://www.youtube.com/watch?v=tJ7-GyYxmEI

Maybe someone knows how to fix this or can share other solution to this?

What I am looking for is a comfortable way to track coins prices and their % change during 24hrs, 7 days etc.

I look forward to hearing from you, thank you!

Will,for me that a nice move on how you track the coin market cap,but tracking the price value of market data is like you cathing a sticky fish in the ocean ,that why you failed.bitcoin is unpredictable crypto currency, we cannot determine the exact day when the times its pump or dump only things we can do is follow the basic analysis,leave the things happen normally and find the right exact timing to when the times you do a trading process.

mamesso

hero member

Activity: 2114

Merit: 740

Leading Crypto Sports Betting & Casino Platform

Quote from: itsmeram on December 20, 2017, 12:48:01 PM

Quote from: karsyla on December 19, 2017, 06:19:08 PM

I am looking for a solution to track coins' price and change in my excel spreadsheet.

Are you sure that you can do it with excel? it might be a little bit difficult, i have been studying and learning about excel for more than two years and far as i know there isn't a real formula to import data from the internet that is constantly changing every two minutes (as coinmarketcap does)
Maybe you will need a script or just use any other software that allows you to do so.

I also wonder if it can be done, I am a teacher who teach microsoft office and I do not know this way.
maybe this is new knowledge, i feel stupid Cool

karsyla

full member

Activity: 248

Merit: 112

Time is money so I went and bought a Rolex

Quote from: NuttyOrange on December 21, 2017, 12:50:46 AM

Try octaparse or webscraper.io they both used in scraping. Or let somebody to the scraping for you. Hire some freelancer who can do a web scraping.

but do u think thats possible with excel? because I want to perform certain calculations and that would be easy with excel.

NuttyOrange

newbie

Activity: 65

Merit: 0

Try octaparse or webscraper.io they both used in scraping. Or let somebody to the scraping for you. Hire some freelancer who can do a web scraping.

karsyla

full member

Activity: 248

Merit: 112

Time is money so I went and bought a Rolex

Quote from: NuttyOrange on December 21, 2017, 12:12:06 AM

Quote from: karsyla on December 21, 2017, 12:10:28 AM

I have already made the spreadsheet for myself regarding coinmarketcap.

What I am trying to do now, is import data from exchange (bittrex), but I am getting this error

Does anybody know how to fix this? So I could import data from bittrex into excel?

Try to use a web scraper rather than direct to an excel sheet. Excel sometimes encounters error when scraping.

hey never heard of that before, could you recommend me one please?

NuttyOrange

newbie

Activity: 65

Merit: 0

Quote from: karsyla on December 21, 2017, 12:10:28 AM

I have already made the spreadsheet for myself regarding coinmarketcap.

What I am trying to do now, is import data from exchange (bittrex), but I am getting this errorhttp://oi67.tinypic.com/16axqn5.jpg

Does anybody know how to fix this? So I could import data from bittrex into excel?

Try to use a web scraper rather than direct to an excel sheet. Excel sometimes encounters error when scraping.

karsyla

full member

Activity: 248

Merit: 112

Time is money so I went and bought a Rolex

I have already made the spreadsheet for myself regarding coinmarketcap.

What I am trying to do now, is import data from exchange (bittrex), but I am getting this error

Does anybody know how to fix this? So I could import data from bittrex into excel?

lite

legendary

Activity: 1400

Merit: 1009

Google spreadsheet is better, you can open the sheets anywhere or on any device. i have been using this nice open source script(https://github.com/bradjasper/CryptocurrencySpreadsheetUtils) to keep track of coins prices/portfolio. give it a try?

LuanX3

hero member

Activity: 756

Merit: 505

Better if you guys just used google sheets to do this, there is already an app that allows you to import the prices and you don't need to code anything else. It's an add-on called cryptofinance. You just need to input the pair (ETH/BTC, LTC/BTC, NLC2/BTC, BAT/ETH, etc.). Then the add-on just takes the prices from coinmarketcap instantly. I've used this for quite sometime and it's been reliable so far.

itsmeram

full member

Activity: 212

Merit: 104

Quote from: karsyla on December 19, 2017, 06:19:08 PM

I am looking for a solution to track coins' price and change in my excel spreadsheet.

Are you sure that you can do it with excel? it might be a little bit difficult, i have been studying and learning about excel for more than two years and far as i know there isn't a real formula to import data from the internet that is constantly changing every two minutes (as coinmarketcap does)
Maybe you will need a script or just use any other software that allows you to do so.

karsyla

full member

Activity: 248

Merit: 112

Time is money so I went and bought a Rolex

Fixed this with power query!

karsyla

full member

Activity: 248

Merit: 112

Time is money so I went and bought a Rolex

Hello,

I am looking for a solution to track coins' price and change in my excel spreadsheet.

I found this video and this would be a great solution to me, but it does not work because I am getting script errors, and no matter what I press (yes/no), they still keep popping up:
https://www.youtube.com/watch?v=tJ7-GyYxmEI

Maybe someone knows how to fix this or can share other solution to this?

What I am looking for is a comfortable way to track coins prices and their % change during 24hrs, 7 days etc.

I look forward to hearing from you, thank you!

Topic: Import coinmarktecap data into excel spreadsheet (Read 198 times)