Bitcoin Forum
September 26, 2017, 08:24:36 PM *
News: Latest stable version of Bitcoin Core: 0.15.0.1  [Torrent]. (New!)
 
   Home   Help Search Donate Login Register  
Pages: [1]
  Print  
Author Topic: historical data of AltCoin prices  (Read 839 times)
altsheets
Hero Member
*****
Offline Offline

Activity: 756

Free trial of #AltFolio = save time, react faster


View Profile WWW
March 27, 2016, 04:50:31 PM
 #1

Could anyone please provide me with historical data of

* HZ / BTC
* NXT / BTC

Plus (even thought I can probably find that elsewhere)
* USD / BTC
* EUR / USD or EUR / BTC

... back to early 2015.  Daily precision is fine.


I need to calculate 2015 income positions, to pay dividends.

And to look up tons of old prices manually ... sounds really boring.

Thanks a lot!

:-)

EDIT: Of course, to avoid the manual ordeal,  I want a table of data or an API access. Anything that I can feed a dozens of DATEs into, and get PRICEs out of.  Wink


Newbium great new platform || AltFolio = Altcoin Portfolio solution || AAsset = crowdfunding, dividends paying = profit sharing Assets (on NXT & HZ) - big 2nd dividends were paid, xmas 2016 || AssetGraphs = novel GUI to assets & shareholders (won nxthacks2015!) || ABEE = Block Explorer Extension for ETH clones, live on SOIL || Advice = Consulting || assetparser.py and shareholders.py - tools for NXT/HZ asset buyers & issuers || bamm.py || PeerCrawler || PGP || Texts || Github e.g. ChainCountDown, ethjsre |||| /give/ GiveBackLicense /give/ |||| Looking for an affordable crypto advertisement service with adspaces on crypto-attractive websites, contact me, thx.
          ▄█████▄
        ▄█████████▄
      ▄████▀   ▀████▄
    ▄████▀   ▄ ▄█▀████▄
  ▄████▀   ▄███▀   ▀████▄
▄████▀   ▄███▀   ▄   ▀████▄
█████   ███▀   ▄███   █████
▀████▄   ▀██▄▄███▀   ▄████▀
  ▀████▄   ▀███▀   ▄████▀
    ▀████▄       ▄████▀
      ▀████▄   ▄████▀
        ▀███  ████▀
          ▀█▄███▀
.
|
.
|
          ▄█████▄
        ▄█████████▄
      ▄████▀   ▀████▄
    ▄████▀   ▄ ▄█▀████▄
  ▄████▀   ▄███▀   ▀████▄
▄████▀   ▄███▀   ▄   ▀████▄
█████   ███▀   ▄███   █████
▀████▄   ▀██▄▄███▀   ▄████▀
  ▀████▄   ▀███▀   ▄████▀
    ▀████▄       ▄████▀
      ▀████▄   ▄████▀
        ▀███  ████▀
          ▀█▄███▀
unthy
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
1506457476
Hero Member
*
Offline Offline

Posts: 1506457476

View Profile Personal Message (Offline)

Ignore
1506457476
Reply with quote  #2

1506457476
Report to moderator
alyssa85
Legendary
*
Offline Offline

Activity: 952


View Profile
March 27, 2016, 04:55:14 PM
 #2

Try the following site:

http://www.cryptocoincharts.info/

I think their charts go back to at least 2013

altsheets
Hero Member
*****
Offline Offline

Activity: 756

Free trial of #AltFolio = save time, react faster


View Profile WWW
March 27, 2016, 05:12:01 PM
 #3

Try the following site:

http://www.cryptocoincharts.info/

I think their charts go back to at least 2013

Yes, I can get current data there, but

I do not see historical data access anywhere .

Thanks anyways.


Newbium great new platform || AltFolio = Altcoin Portfolio solution || AAsset = crowdfunding, dividends paying = profit sharing Assets (on NXT & HZ) - big 2nd dividends were paid, xmas 2016 || AssetGraphs = novel GUI to assets & shareholders (won nxthacks2015!) || ABEE = Block Explorer Extension for ETH clones, live on SOIL || Advice = Consulting || assetparser.py and shareholders.py - tools for NXT/HZ asset buyers & issuers || bamm.py || PeerCrawler || PGP || Texts || Github e.g. ChainCountDown, ethjsre |||| /give/ GiveBackLicense /give/ |||| Looking for an affordable crypto advertisement service with adspaces on crypto-attractive websites, contact me, thx.
Nxtblg
Legendary
*
Offline Offline

Activity: 924



View Profile WWW
March 27, 2016, 05:37:46 PM
 #4

Try the following site:

http://www.cryptocoincharts.info/

I think their charts go back to at least 2013

Yes, I can get current data there, but

I do not see historical data access anywhere .

Thanks anyways.

I'd like to see some historical data too: preferably, raw trade records. Those records do exist for bitcoin trades.






██████████████████████████████████████████████████████████████████████████████████████████████
██████████████████████████████████████████████████████████████████████████████████████
███████████████████████████████████████████████████████████████████████▄▄▄███████████████████████
███████████████████████████████████████████████████████████████████████▀▀▀████████████████████████
██████████████████████████████████████████████████████████████████████████████████████████████████
█████████████████████████████████████████████████████████████████████████████████████████████████





...INTRODUCING WAVES........
...ULTIMATE ASSET/CUSTOM TOKEN BLOCKCHAIN PLATFORM...






gjhiggins
Legendary
*
Offline Offline

Activity: 1134



View Profile WWW
March 28, 2016, 01:54:06 PM
 #5

Could anyone please provide me with historical data of

* HZ / BTC
* NXT / BTC

... back to early 2015.  Daily precision is fine.

https://coinmarketcap.com/historical/

Weekly precision.

It's pages of HTML tables, so you'll need to roll your own processing which is trivially easy to do with pandas. The defaults returns prices in USD, from which BTC price can be derived by using df.iloc[0, 4] (assuming Bitcoin occupies the first row).

Code:
$ python
Python 3.4.3 (default, Jul 28 2015, 18:20:59)
[GCC 4.8.4] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> from pandas.io.html import read_html
>>> df = read_html('https://coinmarketcap.com/historical/20151101/')[0]
>>> btcusd = float(df.iloc[0, 4].split(' ')[1])
>>> for il in range(0, len(df)):
...     if df.iloc[il, 2] in ['NXT', 'HZ']:
...         print("{name} {symbol} {btcprice:02.8f}".format(
...             name=df.iloc[il, 1],
...             symbol=df.iloc[il, 2],
...             btcprice=(float(df.iloc[il, 4].split(' ')[1]) / btcusd)))
...
Nxt NXT 0.00002371
Horizon HZ 0.00000041

Close enough for government work, I'd say.

Cheers

Graham

Edit: added pandas url
alyssa85
Legendary
*
Offline Offline

Activity: 952


View Profile
March 28, 2016, 01:57:49 PM
 #6

Try the following site:

http://www.cryptocoincharts.info/

I think their charts go back to at least 2013

Yes, I can get current data there, but

I do not see historical data access anywhere .

Thanks anyways.

Some exchanges have graphs - you could try logging into one and seeing if they go back to 2013. Bitstamp definitely existed in 2013 so they should have the info on BTC/USD as should BTC-E. 

altsheets
Hero Member
*****
Offline Offline

Activity: 756

Free trial of #AltFolio = save time, react faster


View Profile WWW
March 28, 2016, 03:02:26 PM
 #7

Try the following site:

http://www.cryptocoincharts.info/

I think their charts go back to at least 2013

Yes, I can get current data there, but

I do not see historical data access anywhere .

Thanks anyways.

Some exchanges have graphs - you could try logging into one and seeing if they go back to 2013. Bitstamp definitely existed in 2013 so they should have the info on BTC/USD as should BTC-E.  

Thanks a lot, alyssa85. But what I meant is not manually extracting 2 times 49 datapoints for all the dates I have, but automatic extraction. So if an exchange offers a graph of past data (they all do), that is not what I am looking for.

Thanks anyways.



Newbium great new platform || AltFolio = Altcoin Portfolio solution || AAsset = crowdfunding, dividends paying = profit sharing Assets (on NXT & HZ) - big 2nd dividends were paid, xmas 2016 || AssetGraphs = novel GUI to assets & shareholders (won nxthacks2015!) || ABEE = Block Explorer Extension for ETH clones, live on SOIL || Advice = Consulting || assetparser.py and shareholders.py - tools for NXT/HZ asset buyers & issuers || bamm.py || PeerCrawler || PGP || Texts || Github e.g. ChainCountDown, ethjsre |||| /give/ GiveBackLicense /give/ |||| Looking for an affordable crypto advertisement service with adspaces on crypto-attractive websites, contact me, thx.
altsheets
Hero Member
*****
Offline Offline

Activity: 756

Free trial of #AltFolio = save time, react faster


View Profile WWW
March 28, 2016, 03:12:03 PM
 #8

WOW!

Grrrrreat Graham Gjhiggins

Brute force approach, just downloading all 49 pages - but hey, as long as it gets there ... very cool!

Weekly precision - fine, then just needs a preparational and a final step, to quantize the wanted dates to that grid.


Even though I had now already solved it myself (actually paying a 3rd party for the HZ data - which is fine he is providing a great website), and actually also using panda ...

... your new solution is much much appreciated. Might help a lot, in the future. Thanks!

I have just tried out your script ...

Code:
pip install html5lib pandas

then it works like a charm.

Could anyone please provide me with historical data of
* HZ / BTC
* NXT / BTC
... back to early 2015.  Daily precision is fine.

https://coinmarketcap.com/historical/

Weekly precision.

It's pages of HTML tables, so you'll need to roll your own processing which is trivially easy to do with pandas. The defaults returns prices in USD, from which BTC price can be derived by using df.iloc[0, 4] (assuming Bitcoin occupies the first row).

Code:
$ python
Python 3.4.3 (default, Jul 28 2015, 18:20:59)
[GCC 4.8.4] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> from pandas.io.html import read_html
>>> df = read_html('https://coinmarketcap.com/historical/20151101/')[0]
>>> btcusd = float(df.iloc[0, 4].split(' ')[1])
>>> for il in range(0, len(df)):
...     if df.iloc[il, 2] in ['NXT', 'HZ']:
...         print("{name} {symbol} {btcprice:02.8f}".format(
...             name=df.iloc[il, 1],
...             symbol=df.iloc[il, 2],
...             btcprice=(float(df.iloc[il, 4].split(' ')[1]) / btcusd)))
...
Nxt NXT 0.00002371
Horizon HZ 0.00000041

Close enough for government work, I'd say.

Cheers

Graham

Edit: added pandas url


Great solution.

Thank you gjhiggins - happy Easter!



Newbium great new platform || AltFolio = Altcoin Portfolio solution || AAsset = crowdfunding, dividends paying = profit sharing Assets (on NXT & HZ) - big 2nd dividends were paid, xmas 2016 || AssetGraphs = novel GUI to assets & shareholders (won nxthacks2015!) || ABEE = Block Explorer Extension for ETH clones, live on SOIL || Advice = Consulting || assetparser.py and shareholders.py - tools for NXT/HZ asset buyers & issuers || bamm.py || PeerCrawler || PGP || Texts || Github e.g. ChainCountDown, ethjsre |||| /give/ GiveBackLicense /give/ |||| Looking for an affordable crypto advertisement service with adspaces on crypto-attractive websites, contact me, thx.
alyssa85
Legendary
*
Offline Offline

Activity: 952


View Profile
March 28, 2016, 03:12:31 PM
 #9

OK try the following chart:

http://bitcoincharts.com/charts/bitstampUSD#tgSzm1g10zm2g25zv

altsheets
Hero Member
*****
Offline Offline

Activity: 756

Free trial of #AltFolio = save time, react faster


View Profile WWW
March 28, 2016, 03:15:19 PM
 #10


YES. That's it, the "Load raw data" below the chart would have helped.


The BTC/fiat is the easy part, there is an abundance of sources.
I had actually used http://www.investing.com/currencies/btc-eur-historical-data now.


Thanks a lot for your help!



Newbium great new platform || AltFolio = Altcoin Portfolio solution || AAsset = crowdfunding, dividends paying = profit sharing Assets (on NXT & HZ) - big 2nd dividends were paid, xmas 2016 || AssetGraphs = novel GUI to assets & shareholders (won nxthacks2015!) || ABEE = Block Explorer Extension for ETH clones, live on SOIL || Advice = Consulting || assetparser.py and shareholders.py - tools for NXT/HZ asset buyers & issuers || bamm.py || PeerCrawler || PGP || Texts || Github e.g. ChainCountDown, ethjsre |||| /give/ GiveBackLicense /give/ |||| Looking for an affordable crypto advertisement service with adspaces on crypto-attractive websites, contact me, thx.
altsheets
Hero Member
*****
Offline Offline

Activity: 756

Free trial of #AltFolio = save time, react faster


View Profile WWW
March 28, 2016, 03:35:46 PM
 #11

Ready.

49 times 3 prices



Now I can calculate the dividends, finally

 Wink


Newbium great new platform || AltFolio = Altcoin Portfolio solution || AAsset = crowdfunding, dividends paying = profit sharing Assets (on NXT & HZ) - big 2nd dividends were paid, xmas 2016 || AssetGraphs = novel GUI to assets & shareholders (won nxthacks2015!) || ABEE = Block Explorer Extension for ETH clones, live on SOIL || Advice = Consulting || assetparser.py and shareholders.py - tools for NXT/HZ asset buyers & issuers || bamm.py || PeerCrawler || PGP || Texts || Github e.g. ChainCountDown, ethjsre |||| /give/ GiveBackLicense /give/ |||| Looking for an affordable crypto advertisement service with adspaces on crypto-attractive websites, contact me, thx.
altsheets
Hero Member
*****
Offline Offline

Activity: 756

Free trial of #AltFolio = save time, react faster


View Profile WWW
March 28, 2016, 03:51:15 PM
 #12

P.S.: PM me your HZ addresses, both of you - then I can say 'thank you' in the form of my asset.  Wink


Newbium great new platform || AltFolio = Altcoin Portfolio solution || AAsset = crowdfunding, dividends paying = profit sharing Assets (on NXT & HZ) - big 2nd dividends were paid, xmas 2016 || AssetGraphs = novel GUI to assets & shareholders (won nxthacks2015!) || ABEE = Block Explorer Extension for ETH clones, live on SOIL || Advice = Consulting || assetparser.py and shareholders.py - tools for NXT/HZ asset buyers & issuers || bamm.py || PeerCrawler || PGP || Texts || Github e.g. ChainCountDown, ethjsre |||| /give/ GiveBackLicense /give/ |||| Looking for an affordable crypto advertisement service with adspaces on crypto-attractive websites, contact me, thx.
altsheets
Hero Member
*****
Offline Offline

Activity: 756

Free trial of #AltFolio = save time, react faster


View Profile WWW
March 30, 2016, 08:50:24 AM
 #13

On the basis of all those insights ...

--> Paying dividends - done.

Thanks a bunch for your help.


Newbium great new platform || AltFolio = Altcoin Portfolio solution || AAsset = crowdfunding, dividends paying = profit sharing Assets (on NXT & HZ) - big 2nd dividends were paid, xmas 2016 || AssetGraphs = novel GUI to assets & shareholders (won nxthacks2015!) || ABEE = Block Explorer Extension for ETH clones, live on SOIL || Advice = Consulting || assetparser.py and shareholders.py - tools for NXT/HZ asset buyers & issuers || bamm.py || PeerCrawler || PGP || Texts || Github e.g. ChainCountDown, ethjsre |||| /give/ GiveBackLicense /give/ |||| Looking for an affordable crypto advertisement service with adspaces on crypto-attractive websites, contact me, thx.
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!