Ask Your Question

Ways to make a live spreadsheet [closed]

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

creativeflower gravatar image

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

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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-10-13 11:52:09.649378

1 Answer

Sort by » oldest newest most voted

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

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

Question Tools

1 follower


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

Seen: 1,142 times

Last updated: Aug 21 '17