Live data feed

[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

[robleyd]

This question also asked over in AskLibO; https://ask.libreoffice.org/en/question ... readsheet/

Edit:

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   Expand viewCollapse view

[
    {
        "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??

[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

[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

[Villeroy]

The Java add-on "getrest" works with LibreOffice and OpenOffice.