Live data feed

Java, C++, C#, Delphi, ??? - Using the UNO bridges

Live data feed

Postby ourfreedom » Sun Nov 19, 2017 5:12 am

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
Windows 10 Apache OpenOffice 4.1.4
ourfreedom
 
Posts: 2
Joined: Sun Nov 19, 2017 4:55 am

Re: LIVE DATA FEED

Postby robleyd » Sun Nov 19, 2017 7:02 am

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??
Cheers
David
Apache OpenOffice 4.1.4 - Windows 7
Apache OpenOffice 4.1.4 - Slackware 14.2 - 64 bit
User avatar
robleyd
Moderator
 
Posts: 1080
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: LIVE DATA FEED

Postby ourfreedom » Sun Nov 19, 2017 9:43 am

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
Windows 10 Apache OpenOffice 4.1.4
ourfreedom
 
Posts: 2
Joined: Sun Nov 19, 2017 4:55 am

Re: LIVE DATA FEED

Postby Villeroy » Sun Nov 19, 2017 2:33 pm

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
Last edited by Villeroy on Sun Nov 19, 2017 4:56 pm, edited 1 time in total.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 24650
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: LIVE DATA FEED

Postby Villeroy » Sun Nov 19, 2017 4:28 pm

The Java add-on "getrest" works with LibreOffice and OpenOffice.
Attachments
json.ods
testing the getrest plugin
(18.72 KiB) Downloaded 42 times
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 24650
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to External Programs

Who is online

Users browsing this forum: No registered users and 3 guests