Libreoffice Quotes

Banking and Saving strategies, maximizing interest rates, budgeting, GICs, HISAs.
Post Reply
User avatar
Shakespeare
Diamond Ring
Diamond Ring
Posts: 20779
Joined: 15 Feb 2005 23:25
Location: Lethbridge, AB
Contact:

Libreoffice Quotes

Post by Shakespeare » 02 Feb 2017 23:09

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.
“A wise man should be prepared to abandon his baggage at any time.” -- R.A. Heinlein, The Door Into Summer.

Post Reply