Live data feed

Java, C++, C#, Delphi... - Using the UNO bridges
Post Reply
ourfreedom
Posts: 2
Joined: Sun Nov 19, 2017 4:55 am

Live data feed

Post 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
Windows 10 Apache OpenOffice 4.1.4
User avatar
robleyd
Moderator
Posts: 5055
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: LIVE DATA FEED

Post by 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

[
    {
        "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
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.1.2; SlackBuild for 24.2.1 by Eric Hameleers
ourfreedom
Posts: 2
Joined: Sun Nov 19, 2017 4:55 am

Re: LIVE DATA FEED

Post 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
Windows 10 Apache OpenOffice 4.1.4
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: LIVE DATA FEED

Post 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
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 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: LIVE DATA FEED

Post by Villeroy »

The Java add-on "getrest" works with LibreOffice and OpenOffice.
Attachments
json.ods
testing the getrest plugin
(18.72 KiB) Downloaded 1232 times
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Post Reply