Libreoffice Quotes

Banking and Saving strategies, maximizing interest rates, budgeting, GICs, HISAs.
Post Reply
User avatar
Shakespeare
Veteran Contributor
Veteran Contributor
Posts: 23396
Joined: 15 Feb 2005 23:25
Location: Calgary, AB

Libreoffice Quotes

Post by Shakespeare »

Using the Release Golf · madsailor/SMF-Extension · GitHub, it is possible to get TSX quotes from Yahoo in the form

=GETYAHOO($A1,21)

Where A1 contains the stock ticker e.g. BCE.TO .

The dividend is code 2, e.g. =GETYAHOO($A1,2).

For those who want an alternative to Quicken.
Sic transit gloria mundi. Tuesday is usually worse. - Robert A. Heinlein, Starman Jones
User avatar
Bylo Selhi
Veteran Contributor
Veteran Contributor
Posts: 29494
Joined: 16 Feb 2005 10:36
Location: Waterloo, ON
Contact:

Re: Libreoffice Quotes

Post by Bylo Selhi »

There seem to be several threads on downloading securities quotes into spreadsheets but only this one seems dedicated to LibreOffice.

Here's a current LibreOffice extension that gets data from Yahoo and the Financial Times. It can get data on TSX-listed stocks . Dunno about Canadian MFs since I don't have any(*)

Financials-Extension
This is a Python based extension for LibreOffice Calc to make market data available in Calc spreadsheets - currently supporting Yahoo's (FX, crypto, equities, indices, futures, options) and Financial Times' (FX, equities, indices, futures) websites using old-fashioned web scraping.

Starting with version 3.1.0, we received a contribution to get crypto data directly from Coinbase
The main advantage of this is simplicity, e.g. =GETREALTIME("VBAL.TO",21,"YAHOO")

Another advantage is the wide range of data points or attributes that this function can return for each security.

The main disadvantage is that you have to do a refresh manually to get updated data. A secondary disadvantage is that this uses screen scraping rather than an official API.

(*) A random test of =GETREALTIME("0P00016N6E.TO",21,"YAHOO") seems to work for TD Dividend Growth-D
Sedulously eschew obfuscatory hyperverbosity and prolixity.
Post Reply