Topic: Website to parse BTC price into spreadsheet (Read 165 times)
There are a lof of sites with prices and good API but you will need some programming knowledge to use it. I dont sure that CMC and others will work with excel directly
In case anyone was having problems with this: I contacted the guy from https://www.bitcoinexchangerate.org/ and told him that the website wasn't properly configured, the certificate was updated and my spreadsheet is once again updating properly.
I would still be interested in alternative ways to hear how people are parsing data into excel/Opencalc because this is the only site that Opencalc is able to read tables from.
I would still be interested in alternative ways to hear how people are parsing data into excel/Opencalc because this is the only site that Opencalc is able to read tables from.
I use Coinmarketcap API to update my excel spreadsheet.
Maybe this a solution for you also.
The API can be found here
https://api.coinmarketcap.com/v1/ticker/bitcoin/
https://api.coinmarketcap.com/v1/ticker/ethereum/
and so on.
There is an easy way to import it to excel.
Just click the Data tab
Look for Get Data > Other Sources > From Web
And paste the API address.
Then everytime I want to update it, I just click Data > Refresh All
I think it will work for your OpenCalc software, but the names might be slightly different.
Maybe this a solution for you also.
The API can be found here
https://api.coinmarketcap.com/v1/ticker/bitcoin/
https://api.coinmarketcap.com/v1/ticker/ethereum/
and so on.
There is an easy way to import it to excel.
Just click the Data tab
Look for Get Data > Other Sources > From Web
And paste the API address.
Then everytime I want to update it, I just click Data > Refresh All
I think it will work for your OpenCalc software, but the names might be slightly different.
It doesn't seem to be working. On "Tables/Range" it doesn't detect anything. This is how it should look like:
But the list is empty, so Opencalc doesnt seem to be finding anything to work with there.
I use Coinmarketcap API to update my excel spreadsheet.
Maybe this a solution for you also.
The API can be found here
https://api.coinmarketcap.com/v1/ticker/bitcoin/
https://api.coinmarketcap.com/v1/ticker/ethereum/
and so on.
There is an easy way to import it to excel.
Just click the Data tab
Look for Get Data > Other Sources > From Web
And paste the API address.
Then everytime I want to update it, I just click Data > Refresh All
I think it will work for your OpenCalc software, but the names might be slightly different.
Maybe this a solution for you also.
The API can be found here
https://api.coinmarketcap.com/v1/ticker/bitcoin/
https://api.coinmarketcap.com/v1/ticker/ethereum/
and so on.
There is an easy way to import it to excel.
Just click the Data tab
Look for Get Data > Other Sources > From Web
And paste the API address.
Then everytime I want to update it, I just click Data > Refresh All
I think it will work for your OpenCalc software, but the names might be slightly different.
I was using https://www.bitcoinexchangerate.org/price thus far for a .csv project which would update BTC price equivalences in fiat every X seconds, it was working but for some reason it's no longer loading (Error 502 in OpenCalc)
Does anyone know a website like this that simply shows the price so you can easily use the tables on OpenCalc and load the price there? I believe it's not working because the certificate of the website is not set up properly anymore.
Does anyone know a website like this that simply shows the price so you can easily use the tables on OpenCalc and load the price there? I believe it's not working because the certificate of the website is not set up properly anymore.
Jump to: