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

getquote.oxt.tar.gz

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