LoadPrices.py

###########################################################################
# logging
# https://docs.python.org/3/howto/logging.html#logging-advanced-tutorial
###########################################################################
import sys
import logging
import platform

LOGNAME = 'LoadPrices'
LOGFILE = 'out.log'
LOGFORMAT = '%(asctime)s %(levelname)5s [%(filename)-15s %(lineno)4s %(funcName)-25s] %(message)s'
LOGLEVEL = logging.DEBUG
LOGENABLED = True  # set to False to disable logfile


def createLogger(logname, logfile, logformat, loglevel, enabled):
    Logger = logging.getLogger(logname)
    Logger.setLevel(loglevel)
    if enabled:
        tmp = logging.FileHandler(logfile)
        tmp.setFormatter(logging.Formatter(logformat))
        Logger.addHandler(tmp)
    return Logger


Logger = createLogger(LOGNAME, LOGFILE, LOGFORMAT, LOGLEVEL, LOGENABLED)

Logger.info("Start")
Logger.info("Platform: " + ' '.join(platform.uname()))
Logger.info("Python: " + str(sys.version))

###########################################################################
# embedded zip archive pythonpath
###########################################################################
PYTHONPATH = '/Scripts/python/pythonpath'


def prependPath(newpath):
    import uno
    doc = XSCRIPTCONTEXT.getDocument()
    pythonpath = uno.fileUrlToSystemPath(doc.URL) + newpath
    if pythonpath not in sys.path:
        sys.path.insert(0, pythonpath)


prependPath(PYTHONPATH)

Logger.info("Path: " + str(sys.path))

# import embedded
from sites import Yahoo
from spreadsheet.api.factory import spreadsheet_api

###########################################################################
# the macros
###########################################################################
API = spreadsheet_api('libreoffice', docroot=XSCRIPTCONTEXT)


def get_yahoo_stocks(*args):
    get = Yahoo(API)
    try:
        get.stock(sheet='Sheet1', keyrange='A1:A200', datacols=['B', 'C'])
        API.show_box("Processing finished", "Status")
    except Warning as e:
        API.show_box(str(e), "Web error")


def get_yahoo_fx(*args):
    get = Yahoo(API)
    try:
        get.fx(sheet='Sheet1', keyrange='E1:G200', datacols=['F'])
        API.show_box("Processing finished", "Status")
    except Warning as e:
        API.show_box(str(e), "Web error")


def get_yahoo_indices(*args):
    get = Yahoo(API)
    try:
        get.index(sheet='Sheet1', keyrange='H1:H200', datacols=['I', 'J'])
        API.show_box("Processing finished", "Status")
    except Warning as e:
        API.show_box(str(e), "Web error")


g_exportedScripts = (
    get_yahoo_stocks,
    get_yahoo_fx,
    get_yahoo_indices,
)

###########################################################################