Website to parse BTC price into spreadsheet

[pereira4]

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.

[bitmover]

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.

[pereira4]

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.

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.

[pereira4]

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.