Ask Your Question

Ways to make a live spreadsheet

asked 2017-07-15 22:26:01 +0200

creativeflower gravatar image

updated 2017-07-16 10:11:55 +0200

what are the options to get live data into the spreadsheet to update market tickers regularly. I wrote some Basic Timer but to get this API working I dunno what options I have, could some pro's enlighten me?

I like opensource, people made it already in google docs: which i oppose.

I am here, but lost: If possible i would stick with libreoffic basic, otherwise we need glue code. So far I found:

Function GetValue( oDocument As Object,_
                   sName As String,_
                   fDate As Double, fValue As Double )

    Dim sUrl As String, sFilter As String
    Dim sOptions As String
    Dim oSheets As Object, oSheet As Object

    oSheets = oDocument.Sheets
    If oSheets.hasByName("Link") Then 
        oSheet = oSheets.getByName("Link")
        oSheet = _

        oSheets.insertByName("Link", oSheet)
        oSheet.IsVisible = False
    End If

    sUrl = "" +_
     sName + "&f=sl1d1t1c1ohgv&e=.csv"

    sFilter = "Text - txt - csv (StarCalc)"

    sOptions = _

    oSheet.LinkMode =, "", sFilter, sOptions, 1 )

    fDate = oSheet.getCellByPosition(2,0).Value
    fValue = oSheet.getCellByPosition(1,0).Value
    GetValue = (fDate <> 0)
End Function
edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-08-21 16:41:06 +0200

librebel gravatar image

Hello @creativeflowers,

Please have a look at these two LibreOffice extensions:

LibreWeb - allows to fill the spreadsheet cells with data from different web pages.

SMF Extension for LibreOffice Calc - allows you to create customized spreadsheets with stock market data directly from the web.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-07-15 22:26:01 +0200

Seen: 409 times

Last updated: Aug 21 '17