I am new to using openoffice . Have no coding skills of any sortI 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

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:

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