Title: Website to parse BTC price into spreadsheet Post by: pereira4 on August 03, 2019, 05:20:06 PM 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. Title: Re: Website to parse BTC price into spreadsheet Post by: bitmover on August 03, 2019, 05:25:18 PM 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. Title: Re: Website to parse BTC price into spreadsheet Post by: pereira4 on August 03, 2019, 05:31:18 PM 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: https://wiki.openoffice.org/w/images/thumb/d/d9/CG3Ch9F20.png/500px-CG3Ch9F20.png But the list is empty, so Opencalc doesnt seem to be finding anything to work with there. Title: Re: Website to parse BTC price into spreadsheet Post by: pereira4 on August 10, 2019, 11:27:58 PM 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. |