PalmTree on Nostr: ...
If your using LibreOffice Calc and you want to get the live ⚡ BTC price to run some calculations, for example ROI or whatever, don't try using the WEBSERVICE function as it expects an XML reply which most API's don't give. API's usually respond with JSON format which is not supported in LibreOffice. Fear not, get this extension
https://github.com/DmytroBazunov/LibreOfficeGetRestPlugin/wiki/How-to-install-plugin and in the cell where you want the BTC price, add the following (using Coinbase for this example, if you use some other API, adjustments will have to be made)
=PARSEJSON(GET("
https://api.coinbase.com/v2/prices/btc-usd/buy";),"data.amount")
When you recalc sheet, it will automatically fetch the latest price.
#libreoffice #calc #diy #price
Published at
2025-02-17 01:56:54Event JSON
{
"id": "08b7ff164af00a7ee687a2ef9e2f52b9545f006972a32782d277b522fb69602f",
"pubkey": "cc448f8b3442b60396a14baaab38fc76c8d3f31ad9f7c0e1724d921fa1ad47db",
"created_at": 1739757414,
"kind": 1,
"tags": [
[
"t",
"libreoffice"
],
[
"t",
"calc"
],
[
"t",
"diy"
],
[
"t",
"price"
]
],
"content": "https://image.nostr.build/b818d98a109a5b38c2d6d42e8e2899652f2677ae0d2ea8df0c9e22d638daaa52.png If your using LibreOffice Calc and you want to get the live ⚡ BTC price to run some calculations, for example ROI or whatever, don't try using the WEBSERVICE function as it expects an XML reply which most API's don't give. API's usually respond with JSON format which is not supported in LibreOffice. Fear not, get this extension https://github.com/DmytroBazunov/LibreOfficeGetRestPlugin/wiki/How-to-install-plugin and in the cell where you want the BTC price, add the following (using Coinbase for this example, if you use some other API, adjustments will have to be made)\n\n=PARSEJSON(GET(\"https://api.coinbase.com/v2/prices/btc-usd/buy\"),\"data.amount\")\n\nWhen you recalc sheet, it will automatically fetch the latest price.\n\n#libreoffice #calc #diy #price",
"sig": "05818a44c329106c7c5e50e0b43299d62d96fc43b8a7f17a84367b3baf31ad4ae4485f6d0fec7e053a0992cad7088dc194694031c8b424d514b1fd629460f8b8"
}
