Home › Browse Extensions

Get Stock Price

by tedschloss
(8 votes)

This OO Calc Extension adds the GETPRICE function to the "Financial" category. This function returns the price of a stock using a service provided by YAHOO! Finance.

Example 1: Cell A1 contains =GETPRICE("HON"), and displays 35.6
Example 2: Cell A1 contains HON, cell A2 contains =GETPRICE(A1), and cell A2 displays 35.6

If you can find your issue on YAHOO! Finance, GETPRICE will likely work for that symbol. Price quotes are available for issues on many different exchanges and are delayed as described at http://finance.yahoo.com/exchanges.

Example Symbol (Description) Exchange:

  • ^DJI (Index, Dow Jones) NYSE
  • ^BSESN (Index) Bombay
  • HEB (Hemispherx Biopharma, Inc) AMEX
  • FAZ (Direxion Daily Financial Bear 3x Shares) ETF – PCX
  • BUMI.JK (Bumi Resources Tbk) Jakarta
  • BARC.L (BARCLAYS) London
Download extension
Operating System: System Independent
Official release: 0.0.2
Date: 2009-Jun-20
Size: 10.82 KB
View all releases
License: freeware
Further product information: Product details
Report abuse here | Contact extension owner
  • 5921 downloads initiated
  • 88 downloads this week

Comments

Tue, 11/03/2009 - 22:28 — chinamac

Great add in

Is it possible to develop a similar lookup for foreign exchange rates?
Cheers

Thu, 09/24/2009 - 04:37 — UpAbove

Thanks

Thanks for a very useful extension.

There is a problem though: Retrieving the stock prices takes significant time when a sheet contains several stocks. This becomes a bother if it happens often and/or automatically (say when switching from one sheet to another).

Suggestion: After the initial invokation at the file-open, maintain a cache of the prices corresponding to symbols - and use these for cell recalculations. These can be explicitly "updated" by the user - perhaps by clicking a button somewhere.

Adv: The user experience would be much better: once he has opened the file - there is no undue delay due to GetPrice() till the file is closed - unless he explicitly asks for updated prices.

Thanks again.

Fri, 08/28/2009 - 18:05 — garbanzo

Refreshing stock quote date

Is there a parameter one can set in this extension that will periodically cause the quotes to update? If there isn't, how does one force an update other than closing the spreadsheet that uses GETPRICE and reopening it? Thanks.

Thu, 09/17/2009 - 16:53 — santer

refreshing stock quote

garbanzo,

yes, you can reload any time you want: file=>reload

Thu, 07/02/2009 - 22:37 — mayjune2004

open high low close

Hi, I'd love to see it retrieve open, high, low, close and possibly even volume.

If you'd like help with that, I can help (I know java).

Tue, 06/23/2009 - 09:28 — hylli

Behind a proxy?

Hi,

is it possible to make this extension work behind a proxy server with authentification?

Hylli

Tue, 06/16/2009 - 19:32 — MichaelCMills

Using the extension

The function can be used two ways:
GETPRICE(a1) -- accesses cell a1 and expects to find a valid alphabetic ticker symbol to look up

GETPRICE("TICK") -- uses the characters enclosed in quotes as a ticker symbol to look up

If you forget the quotes, it will not give a valid result. Hope this helps...

Sun, 07/12/2009 - 21:12 — bylo

Multiple symbols

GETPRICE is great for single symbol lookups, but if you want several quotes you have to do a separate GETPRICE for each and, in turn, contact Yahoo once per symbol. With a large number of symbols, say a dozen or more, this can take several seconds. This delay manifests itself every time you open or refresh the spreadsheet. Yahoo, however, allows for multiple symbols per lookup, e.g. http://finance.yahoo.com/q/cq?s=VTI+VEA+VWO+...

It would be a great performance enhancement to GETPRICE if it could do a single request to Yahoo for multiple symbols, then place the results in a row or column of cells.

Tue, 06/09/2009 - 16:28 — RobertS

How exactly?

The idea of this extension is good and usefull. But I fail to understand exactly how we have to proceed. The preceding comment gives a hint but it doesn't seem to work for me. Could a demonstration be posted here by the author?
Thanks

Tue, 06/09/2009 - 06:16 — Enrol1202

Great little Extension

I agree with Bob W. A very useful add-on. I too would love to see additional look-ups such as "change" if that is possible.

Highly recommend

Tue, 06/09/2009 - 02:05 — rwwisleder

GETPRICE

I've been hoping for an extension like this for Firefox, and thank you for providing it. It works fine but I have one thing to point out: The ticker symbols must be contained in a separate cell, with that cell referenced by the GETPRICE function. My first try was to just put the ticker symbol within the () of the function, but that doesn't work. In other words, GETPRICE(xom) will not work, but GETPRICE(C12) works fine if "xom" is the content of C12.

Would love to see more parameters available, such as change, volume, date, etc., but this is great as is.

Bob W.