Home › Browse Extensions

Get Stock Price

by Ted
3.9
Average: 3.9 (10 votes)

This OO Calc Extension has been replaced by "GetQuote".
Learn more...

License: Freeware
Report abuse here |
Downloads: Today: 0 | Week: 2 | Month: 15 | Year: 8,460

Comments

Sat, 05/22/2010 - 19:32 — lunaincognita

Error when reopening file

Why when I exit Calc and reopen the file with =getprice() functions do I get #name? and the cells repopulated with "=com.ejs.ooo.calcstockaddin.getstockprice(M10)" ? I have tried file -> reload but to no avail.

I'm running OO 3.2.0

Any help is greatly appreciated. Thanks for the extension!

Wed, 06/02/2010 - 12:56 — lunaincognita

Fixed?

Well it seems to have fixed itself :)

Mon, 04/26/2010 - 22:19 — bandana1948

Option quotes

This is a very nice extension. Until now, I was using a macro described in one of the OO bulletin boards to do this. This extension is lighter and easier.

One question/problem, however. This extension doesn't work with options symbols, even though the format to retrieve them from Yahoo Finance is the same as for stocks. For example:

=GETPRICE("HON") gives $48.27, the current stock price retrieved from http://finance.yahoo.com/q?s=HON

BUT

= GETPRICE("HON100619C00039000"), the HON June 19 Call option price, retrieved from http://finance.yahoo.com/q?s=HON100619C00039000 gives "0"

Only the length of the symbol is different, and it'll be great if there is a fix for this.

Thanks for a great extension!

Sun, 05/02/2010 - 18:54 — tedschloss

Option quotes (YAHOO! limitation)

This would appear to be a limitation of the YAHOO! service. As is demonstrated by visiting http://finance.yahoo.com/q?s=HON100619C00039000 and then clicking on the "Download Data" link on the right.

I reported the issue to YAHOO! and here is an excerpt from their reply:

Because of the recent changes in the way we display options symbols,
Yahoo! Finance does not currently offer the ability to download data on
options symbols. We do apologize for any inconvenience, and I would like
to let you know that I have shared your report with our development team
as they consider future Yahoo! Finance releases and enhancements.

Tue, 04/13/2010 - 00:19 — mplaut

Installation problem

When I try to install it says: Could not create Java implementation loader.

I have Win XP with all the updates, and Java version 6 update 19 (build 1.6.0_19-b04)

Wed, 04/14/2010 - 14:40 — tedschloss

Installation problem (Solution)

Please take the following steps to resolve the issue.

1) Select "Options" under the "Tools" menu
2) In the left side of the dialog, select "Java" under "OpenOffice.org"
3) Check the "Use a Java Runtime Environment" box
4) Pick a recent version of the JRE in the list. (Might have to wait a while for OO to populate the list).
5) Push the "OK" button
6) Re-install the plug-in.

Thu, 04/15/2010 - 18:53 — mplaut

Thank you

Now it works very nicely.

ATB.

Sun, 04/04/2010 - 00:07 — jmcahren

Nice function

Very useful for looking at current valuations, but I'd also like a date parameter so that historical prices could be obtained.

Wed, 04/28/2010 - 14:41 — tedschloss

Nice function (Future Enhancement)

Thanks for the feedback. I will consider this as a future enhancement.

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

Great add in

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

Fri, 02/12/2010 - 19:15 — jtkleeme

Gold and Silver

Yea, currencies would be nice but what about just simple gold and silver spot prices. It would be nice to have those too. Is there already a way to do this?

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

Fri, 09/17/2010 - 16:34 — gnappolo

refreshing stock quote by Copy&Paste!

It's possible to reload yahoo! quotes by copying and pasting the formula from/into the same cell.
Have fun and enjoy this great addon!
Gnap

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 — rwisleder

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.

Sun, 06/06/2010 - 17:29 — tedschloss

Ticker Symbol as a String

To call the GETPRICE function with a symbol directly (as opposed to referencing the contents of a cell), put double-quotes around the symbol. For example:

=GETPRICE("XOM")