Page 1 of 1
Live data feed
Posted: Sun Nov 19, 2017 5:12 am
by ourfreedom
Hello Every one
I am new to using openoffice . Have no coding skills of any sort
I mention this first so that there is no assumptions Made
Now to What i am trying to Achieve
I would like to be able to Have a live data feed from a API to an excel spreadsheet.>> THIS IS THE LINK >>
https://api.coinmarketcap.com/v1/ticker/
I have Browsed the internet looking for a way to do this using openoffice.
and have not been able to figure out away to do this . without information in some methods going way over my head and end up becoming confused
So I ask here in the hope that some one could Maybe help out please
With a description or steps to follow
Thank you in Advance
Re: LIVE DATA FEED
Posted: Sun Nov 19, 2017 7:02 am
by robleyd
This question also asked over in AskLibO;
https://ask.libreoffice.org/en/question ... readsheet/
OP
@ourfreedom here says AOO is used, but in AskLibO says LibO is being used; answers may vary according to which flavour is actually used.The API referred to is in fact a simple text file of variable names and values on the same line, formatted thus, but with many more lines:
Code: Select all
[
{
"id": "bitcoin",
"name": "Bitcoin",
"symbol": "BTC",
"rank": "1",
"price_usd": "7775.4",
"price_btc": "1.0",
"24h_volume_usd": "2743870000.0",
"market_cap_usd": "129755875200",
"available_supply": "16688000.0",
"total_supply": "16688000.0",
"max_supply": "21000000.0",
"percent_change_1h": "-0.46",
"percent_change_24h": "1.32",
"percent_change_7d": "27.05",
"last_updated": "1511069953"
},
{
"id": "ethereum",
"name": "Ethereum",
"symbol": "ETH",
"rank": "2",
"price_usd": "348.747",
"price_btc": "0.0449722",
"24h_volume_usd": "623675000.0",
"market_cap_usd": "33415563150.0",
"available_supply": "95816059.0",
"total_supply": "95816059.0",
"max_supply": null,
"percent_change_1h": "0.06",
"percent_change_24h": "5.57",
"percent_change_7d": "13.75",
"last_updated": "1511069951"
}
]
OP
@ourfreedom hasn't stated what needs to be done with the data, but presumably wants it laid out with the variable names as column headers (once only) and relevant values filling the columns??
Re: LIVE DATA FEED
Posted: Sun Nov 19, 2017 9:43 am
by ourfreedom
OP @ourfreedom hasn't stated what needs to be done with the data, but presumably wants it laid out with the variable names as column headers (once only) and relevant values filling the columns??
To clarify the above . Yes i would like it to have the same format layout as the website it comes from So that i can use it to track the difference Between currency price i have bought at and current markets
So Is there a way to do this please
And as earlier I do not have coding skills and will need a guide how to implement this into openoffice on a excel spreadsheet
Thank you all
Re: LIVE DATA FEED
Posted: Sun Nov 19, 2017 2:33 pm
by Villeroy
https://extensions.libreoffice.org/exte ... t-plugin-1
follow the "External documentation" link to github.com and there "How to install" and the "Direct Link" to the oxt package which is currently
Direct Link
Re: LIVE DATA FEED
Posted: Sun Nov 19, 2017 4:28 pm
by Villeroy
The Java add-on "getrest" works with LibreOffice and OpenOffice.