I don't know why my post got quoted
Is it possible for one of these programs to allow the address entered to be at the end?
Like mysite.info/balance/(insertaddress)
It would make it a lot easier for future plans as well.
Topic: run my own blockchain explore (Read 561 times)
~~
OP specifically mentioned not wanting to rely on a third party. He is already using a service like you are describing.
yes, i can read.
but also he said this:
~
Everything in in google sheets and automatically updates every time I load it up. Due to api limits/server~~chainz.cryptoid.info/btc/api~~~
Everything in in google sheets and automatically updates every time I load it up. Due to api limits/server~~chainz.cryptoid.info/btc/api~~~
which means the problem is in the API service provider he is using. in other words chainz.cryptoid API is limiting him to 1 call per every 10 seconds and this limit does not exist in blockchain.info query so it is not really the same service you see.
besides not relying on a third party means he has to run his own full node and connect to that which i doubt that he wants to do that just for updating his balance based on his comments.
One of the problems I ran into was the address needs to be at the end and not in the middle. mysite.info/(insert) works but I never did get mysite.info/(insert)/balance. I have it so when say sell a6 gets an address cell b6 automatically populates the link it at updates it.
I was also thinking last night about the full node. While I am not to worried I do have unlimited bandwidth and a decent speed. If this works I will use some older hardware I have to run this and just have it do its thing. If it were ever compromised all the would get is a empty address.
~~
OP specifically mentioned not wanting to rely on a third party. He is already using a service like you are describing.
yes, i can read.
but also he said this:
~
Everything in in google sheets and automatically updates every time I load it up. Due to api limits/server~~chainz.cryptoid.info/btc/api~~~
Everything in in google sheets and automatically updates every time I load it up. Due to api limits/server~~chainz.cryptoid.info/btc/api~~~
which means the problem is in the API service provider he is using. in other words chainz.cryptoid API is limiting him to 1 call per every 10 seconds and this limit does not exist in blockchain.info query so it is not really the same service you see.
besides not relying on a third party means he has to run his own full node and connect to that which i doubt that he wants to do that just for updating his balance based on his comments.
almost all the Blockchain Explorer APIs that i have seen had some type of Query API which will return Plaintext in their repose that you can use in your google spread sheet
here is blockchain.info https://blockchain.info/q
example:
https://blockchain.info/q/addressbalance/{bitcoinAddress}?confirmations=1
for multiple at once:
https://blockchain.info/q/addressbalance/{add1}|{add2}?confirmations=1
you can change the confirmation to a different number between 0 and 120 to only get the confirmed transactions.
here is blockchain.info https://blockchain.info/q
example:
https://blockchain.info/q/addressbalance/{bitcoinAddress}?confirmations=1
for multiple at once:
https://blockchain.info/q/addressbalance/{add1}|{add2}?confirmations=1
you can change the confirmation to a different number between 0 and 120 to only get the confirmed transactions.
OP specifically mentioned not wanting to rely on a third party. He is already using a service like you are describing.
almost all the Blockchain Explorer APIs that i have seen had some type of Query API which will return Plaintext in their repose that you can use in your google spread sheet
here is blockchain.info https://blockchain.info/q
example:
https://blockchain.info/q/addressbalance/{bitcoinAddress}?confirmations=1
for multiple at once:
https://blockchain.info/q/addressbalance/{add1}|{add2}?confirmations=1
you can change the confirmation to a different number between 0 and 120 to only get the confirmed transactions.
here is blockchain.info https://blockchain.info/q
example:
https://blockchain.info/q/addressbalance/{bitcoinAddress}?confirmations=1
for multiple at once:
https://blockchain.info/q/addressbalance/{add1}|{add2}?confirmations=1
you can change the confirmation to a different number between 0 and 120 to only get the confirmed transactions.
Blockexplorer.com also provides insight api you can check here https://github.com/bitcoin-blockexplorer/insight-api
and also seems this guide will be quite helpful in running own explorer using insight-api here https://bitcore.io/guides/full-node/
I haven't used them or developed anything yet as i am also quite noob on linux.
and also seems this guide will be quite helpful in running own explorer using insight-api here https://bitcore.io/guides/full-node/
I haven't used them or developed anything yet as i am also quite noob on linux.
For Bitcoin, BitPay's Insight API should meet your requirements. Its API methods should work nicely with Google Sheets, e.g. to check an address's balance:
https://insight.bitpay.com/api/addr/38ccq12hPFoiSksxUdr6SQ5VosyjY7s9AU/balance
The rate limiter can be disabled if you host it yourself.
Keep in mind that IMPORTDATA is executed remotely, so your API server will need to be publicly available, whereas 192.168.1.101 from your example is part of a private address range.
sounds exactly what I need. Now to get the install issue figured out. https://insight.bitpay.com/api/addr/38ccq12hPFoiSksxUdr6SQ5VosyjY7s9AU/balance
The rate limiter can be disabled if you host it yourself.
Keep in mind that IMPORTDATA is executed remotely, so your API server will need to be publicly available, whereas 192.168.1.101 from your example is part of a private address range.
For Bitcoin, BitPay's Insight API should meet your requirements. Its API methods should work nicely with Google Sheets, e.g. to check an address's balance:
https://insight.bitpay.com/api/addr/38ccq12hPFoiSksxUdr6SQ5VosyjY7s9AU/balance
The rate limiter can be disabled if you host it yourself.
Keep in mind that IMPORTDATA is executed remotely, so your API server will need to be publicly available, whereas 192.168.1.101 from your example is part of a private address range.
https://insight.bitpay.com/api/addr/38ccq12hPFoiSksxUdr6SQ5VosyjY7s9AU/balance
The rate limiter can be disabled if you host it yourself.
Keep in mind that IMPORTDATA is executed remotely, so your API server will need to be publicly available, whereas 192.168.1.101 from your example is part of a private address range.
why not use blockchain.info? keep your address in a note and copy and paste on blockchain, voila.
Everything in in google sheets and automatically updates every time I load it up. Due to api limits/server usage it sometimes takes time to update my 10 or so addresses.plus I am lazy and don't what to enter every address like you said
Current code
=importdata(IF(ISBLANK(A),"",CONCAT("https://chainz.cryptoid.info/btc/api.dws?key=@@@@@@@@@@@@&q=getbalance&a=",A1)))
New code or something like this
=importdata(IF(ISBLANK(A),"",CONCAT("http://192.168.1.101/q/addressbalance/",A1)))
why not use blockchain.info? keep your address in a note and copy and paste on blockchain, voila.
Right now I am using 3rd party api to update and keep track of my wallets ballance. I would like to run my own so I don't need to rely on 3rd party and possibly not wait for things to load.
Thoughts or point me in the right direction?
I prefer windows but can use linux with some guides.
Thoughts or point me in the right direction?
I prefer windows but can use linux with some guides.
Jump to: