Table of Contents
GetQuote addon for Libreoffice
Have been using the GetQuote addon for LibreOffice for some time to download and update Excel sheets from Yahoo finance.
In Jan 2015, I see that the original website for the addon has disappeared and user guide also seems to be gone. As I found the software useful and wish to continue using it - gathering the infmration I have for it here.
09 Jan 2016 - dob
New addon - Stock Market Functions - SMF that is supposed to be faster than Getquote and seems to be actively developed.
Last traded price given by:
GETYAHOO("bir.de",21)
More examples: yahooexample.ods
Addon
Information on how to use it
User guide: getquote-user-guide.pdf
GetHistory
highlighting a 5-column range and then typing
=GETHISTORY("PETR4.SA",1,TODAY()-1)
(you might need to use semicolons instead of commas) and then pressing
Ctrl+Shift+Return.
That should provide you with date, open, high, low and close quotes for PETR4, the preferred stock of Brazilian oil giant Petrobras S.A.
Outputting only part of the array can be done with the INDEX function. You don't need to use ctrl+shift+enter for it to work as it does't return an array.
=INDEX(GETHISTORY(“PETR4.SA”,1,TODAY()-1),1,5)
GetQuote
Yesterday's closing price can be retrieved using a second argument, for example: =GETQUOTE(“TD.TO”,21)
0 = Last traded price 1 = Change in price for the day 2 = Opening price of the day 3 = High price of the day 4 = Low price of the day 5 = Volume 6 = Average Daily Volume 7 = Ask Price 8 = Bid Price 9 = Book Value 10 = Dividend/Share 11 = Earnings/Share 12 = Earnings/Share Estimate Current Year 13 = Earnings/Share Estimate Next Year 14 = Earnings/Share Estimate Next Quarter 15 = 52-week low 16 = Change from 52-week low 17 = 52-week high 18 = Change from 52-week high 19 = 50-day Moving Average 20 = 200-day Moving Average 21 = Previous Close 22 = Price/Earning Ratio 23 = Dividend Yield 24 = Price/Sales 25 = Price/Book 26 = PEG Ratio 27 = Price/EPS Estimate Current Year 28 = Price/EPS Estimate Next Year 29 = Short Ratio 30 = 1-year Target Price