Bitcoin Forum
December 16, 2017, 11:31:16 PM *
News: Latest stable version of Bitcoin Core: 0.15.1  [Torrent].
 
   Home   Help Search Donate Login Register  
Pages: [1]
  Print  
Author Topic: Where / How can I download historical prices of Alts into an Excel Spreadsheet  (Read 946 times)
jdlr
Full Member
***
Offline Offline

Activity: 152


View Profile
May 30, 2017, 09:56:49 AM
 #1


How can I get it the prices into an excel sheet with the date of each price.

Is there some kind of website where I can download ?

coimarketcap shows last 7 days only, and it is not detailed enough.

Some of you might have a ready made API or smth they use to do that, pls share, as Ive been looking for sometime and couldnt find.

Bounty available for whoever is helpful

thanks
1513467076
Hero Member
*
Offline Offline

Posts: 1513467076

View Profile Personal Message (Offline)

Ignore
1513467076
Reply with quote  #2

1513467076
Report to moderator
1513467076
Hero Member
*
Offline Offline

Posts: 1513467076

View Profile Personal Message (Offline)

Ignore
1513467076
Reply with quote  #2

1513467076
Report to moderator
1513467076
Hero Member
*
Offline Offline

Posts: 1513467076

View Profile Personal Message (Offline)

Ignore
1513467076
Reply with quote  #2

1513467076
Report to moderator
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
italianMiner72
Hero Member
*****
Offline Offline

Activity: 602



View Profile
May 30, 2017, 01:15:06 PM
 #2


How can I get it the prices into an excel sheet with the date of each price.

Is there some kind of website where I can download ?

coimarketcap shows last 7 days only, and it is not detailed enough.

Some of you might have a ready made API or smth they use to do that, pls share, as Ive been looking for sometime and couldnt find.

Bounty available for whoever is helpful

thanks

usually i use this service
https://www.quandl.com/collections/markets/bitcoin-data
really interesting for the wide of the hystorical data.
There are a lots of Exchange...
give it a try

██
█║█
║║║
║║║
█║█
██
'BTC MULTI-WALLET SOON'
▬▬▬▬ Download WHITEPAPER ▬▬▬▬

                    ▄██▄
                  ▄██████▄
                ▄██████████
              ▄██████████▀   ▄▄
            ▄██████████▀   ▄████▄
          ▄██████████▀    ████████▄
         ██████████▀      ▀████████
         ▀███████▀   ▄███▄  ▀████▀   ▄█▄
    ▄███▄  ▀███▀   ▄███████▄  ▀▀   ▄█████▄
  ▄███████▄      ▄██████████     ▄█████████
  █████████    ▄██████████▀    ▄██████████▀
   ▀█████▀   ▄██████████▀    ▄██████████▀
     ▀▀▀   ▄██████████▀    ▄██████████▀
          ██████████▀    ▄██████████▀
          ▀███████▀      █████████▀
            ▀███▀   ▄██▄  ▀█████▀
                  ▄██████▄  ▀▀▀
                  █████████
                   ▀█████▀
                     ▀▀▀
e i d o o
██

███▀▀
▐▐▌
▐▌
▐▌
▐▐▌
███▄▄
▀▀███
▐▌▌
▐▌
▐▌
▐▌▌
▄▄███
jdlr
Full Member
***
Offline Offline

Activity: 152


View Profile
May 30, 2017, 02:35:41 PM
 #3

That's very interesting , thank you.

Do you know if they have data for altcoins ?

I could only find bitcoin related on quandl
ulhaq
Sr. Member
****
Offline Offline

Activity: 276


View Profile
May 30, 2017, 06:19:45 PM
 #4

Use poloniex api.
gjhiggins
Legendary
*
Offline Offline

Activity: 1218



View Profile WWW
May 30, 2017, 09:38:09 PM
 #5

coimarketcap shows last 7 days only, and it is not detailed enough.

Detailed historical price data requires storage === costs money.

Otherwise:

Navigate to https://coinmarketcap.com, select “Tools” drop-down menu, click on “Historical Snapshots”, click on any date, import the HTML table to Excel.

https://coinmarketcap.com/historical/

Cheers

Graham
jdlr
Full Member
***
Offline Offline

Activity: 152


View Profile
June 03, 2017, 12:46:20 PM
 #6

would anyone have a working spreadsheet with APIs setup that I could use ?
Bounty available ! : )
ppc.pt
Member
**
Offline Offline

Activity: 84


View Profile
June 03, 2017, 01:17:21 PM
 #7

would anyone have a working spreadsheet with APIs setup that I could use ?
Bounty available ! : )

I would be interested in this too Smiley Guess no-one will provide a good one for free.. Sad
jdlr
Full Member
***
Offline Offline

Activity: 152


View Profile
June 03, 2017, 02:32:58 PM
 #8

not for free, we can agree a price !
italianMiner72
Hero Member
*****
Offline Offline

Activity: 602



View Profile
June 05, 2017, 08:16:49 AM
 #9

would anyone have a working spreadsheet with APIs setup that I could use ?
Bounty available ! : )

hi jdlr!!!
what's wrong with quandl???
you have tons of data there.
there are a lot's of exchange and cross there..
can you explain better what do you need???
thank you!!

██
█║█
║║║
║║║
█║█
██
'BTC MULTI-WALLET SOON'
▬▬▬▬ Download WHITEPAPER ▬▬▬▬

                    ▄██▄
                  ▄██████▄
                ▄██████████
              ▄██████████▀   ▄▄
            ▄██████████▀   ▄████▄
          ▄██████████▀    ████████▄
         ██████████▀      ▀████████
         ▀███████▀   ▄███▄  ▀████▀   ▄█▄
    ▄███▄  ▀███▀   ▄███████▄  ▀▀   ▄█████▄
  ▄███████▄      ▄██████████     ▄█████████
  █████████    ▄██████████▀    ▄██████████▀
   ▀█████▀   ▄██████████▀    ▄██████████▀
     ▀▀▀   ▄██████████▀    ▄██████████▀
          ██████████▀    ▄██████████▀
          ▀███████▀      █████████▀
            ▀███▀   ▄██▄  ▀█████▀
                  ▄██████▄  ▀▀▀
                  █████████
                   ▀█████▀
                     ▀▀▀
e i d o o
██

███▀▀
▐▐▌
▐▌
▐▌
▐▐▌
███▄▄
▀▀███
▐▌▌
▐▌
▐▌
▐▌▌
▄▄███
jdlr
Full Member
***
Offline Offline

Activity: 152


View Profile
June 08, 2017, 04:41:18 AM
 #10

@ ItalianMiner :
I could only find bitcoin data on Quandl, there was no altcoins data, im interested in altcoin data,
unless I have missed smthg ??
rijnsent
Newbie
*
Offline Offline

Activity: 5


View Profile
June 14, 2017, 01:51:29 PM
 #11

Hi all,
you could indeed connect Excel via VBA to any of the online available APIs. It's work-in-process for me:
I am working on an Excel/VBA tool for e.g. Kraken, BTC-e and Poloniex in this project: https://github.com/krijnsent/crypto_vba
Getting data from e.g. min-api.cryptocompare.com is on my ToDo list. What data are you looking for? Historical rates? Daily/hourly/monthly? High-Low-Open-Close-Volume? Per exchange or just one exchange?
Cheers,
Koen
Pages: [1]
  Print  
 
Jump to:  

Sponsored by , a Bitcoin-accepting VPN.
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!