2
1
I installed Bitcoin-Core Wallet and downloaded the whole 130gigs BlockChain. Now I'd like to read the BlockChain Data to know all bitcoin values since the beginning. Not sure how to start. I need that data for making my own graphs in Excel
How can I read data from the whole BlockChain? Thanks.
3
It sounds like you are asking how to build a block explorer. Basically you would activate the full transaction index by adding txindex=1 to your bitcoin.conf. Parse all the history data and dump it into a database. Then keep track of all the new transaction data on your own database as blocks come in with blocknotify or real-time with ZMQ notifications.
https://github.com/bitcoin/bitcoin/blob/master/doc/zmq.md#usage
There's also options like bitpay's bitcore that pretty much does the work for you. It does require a lot more HD space though.
1
My understanding of your question is that you want a tool that parses/queries the blockchain and saves the results into an Excel file. I'm not sure that something like that exists, but if you're willing to experiment with code then there are options.
Each of these libraries is capable of reading the blockchain, and the languages have other libraries for saving data to Excel, CSV, in a database, etc.
-1
Checkout this API: https://blockchain.info/api
Specifically look at "Transactions & Blocks Data" & "Market Data".
With PHP you can use that API and work with the data. PHP also allows you to create and export to Excel sheets: http://www.the-art-of-web.com/php/dataexport/
For me, because I know PHP, this would be the easiest route to go.
OP is asking how to read data from the blockchain that his Bitcoin Core instance downloaded, not how to use a 3rd party API. – Pieter Wuille – 2017-04-23T08:48:31.430
I was just telling him how I would do it as the last line of my answer says. Any bit of information helps that is relevant. Maybe if he knew PHP he would find it easier to do the route I recommended. But I do see your perspective. – Marc Alexander – 2017-06-09T22:43:42.980
4What do you mean by bitcoin values? – Pieter Wuille – 2017-04-15T22:57:43.693