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.
Libreoffice Quotes
- Shakespeare
- Veteran Contributor
- Posts: 23396
- Joined: 15 Feb 2005 23:25
- Location: Calgary, AB
Libreoffice Quotes
Sic transit gloria mundi. Tuesday is usually worse. - Robert A. Heinlein, Starman Jones
- Bylo Selhi
- Veteran Contributor
- Posts: 29494
- Joined: 16 Feb 2005 10:36
- Location: Waterloo, ON
- Contact:
Re: Libreoffice Quotes
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
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
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
The main advantage of this is simplicity, e.g. =GETREALTIME("VBAL.TO",21,"YAHOO")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
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.