Provider:
Ted
Maintainer:
tedschloss
Rating:
4.75
Average: 4.8 (4 votes)
Application:
Calc
Tags:
history, , symbol, , open, , stock, , ticker, , price, , equity, , currency, , exchange, , volume, , high, , low, , quote, , etf, , historic,
Post date:
Sunday, 6 June, 2010 - 18:16
Statistics
Week: 41 - Month: 194 - Year: 2,057 - Timeline
Download extension
System Independent version - All releases
Compatible with OpenOffice 4: Unknown
User feedback:
Compatible with OpenOffice 4.x?

GetQuote is an extension to the OpenOffice.org spreadsheet application, Calc. It adds the GETQUOTE function which returns a price or volume quote (and many other types of quotes) for a stock. It also adds the GETHISTORY function which returns similar information for a range of dates.

More information and download...

GetQuote

Version Operating system Compatibility Release date
1.0 System Independent 3.2, 3.3, 3.4 06/06/2010 - 18:20 More information Download

Comments

I am interested in using your GETQUOTE function, but am getting the error described here:
http://www.oooforum.org/forum/viewtopic.phtml?t=104142

I am using Ubuntu 10.10 and Calc 3.2 (see below for full version info), and also had the error before upgrading from 10.4. I see the same error in spreadsheets I create and the portfolio balancing sample you posted on your blog. I will continue to investigate the error on my own, but don't want to bang my head against the wall if you already have a fix or possible ideas for a solution.

Thanks for your time developing the function.

Full Version info:
OpenOffice.org 3.2.1
OOO320m19 (Build:9505)
ooo-build 3.2.1.4, Ubuntu package 1:3.2.1-7ubuntu1

I invest in a number of preferred stocks. A lot of them have symbols that contain dashes. Yahoo Finance mangles these names in its own proprietary way. My source list of preferred stocks comes from QuantumOnline.com. These symbols match the Google Finance quotes (and my TD Ameritrade account).

At the moment, I solve this problem by using Google Docs, which offers a GoogleFinance() function that lets me query current stock prices much like GetQuote(). However, GetQuote() returns $0 for about half of the symbols in my list, making it nearly worthless as it stands.

So, any chance of doing a version that using Google Finance?

- Joel

old machine has failed need new copy. How do I get it?

old machine has failed need new copy. How do I get it?

Please visit the main GetQuote website for news and downloads by clicking on the "More information and download..." link above.

Ted,

Is there a way to fetch more quote types from Yahoo finance? I need current ratio, debt/equity, quarterly revenue growth, quarterly earnings growth, institution ownership and insider ownership. They are all on the key statistics webpage.

Great extension for Calc by the way!

Thanks!

one of my extensions is causing calc to fail with jre/java 7. is it getquote?

first i try to delete the old version but i get "Rejecting types due to incompatibility" error. i tried rebooting, but that doesn't help. perhaps it's because i have to versions of java (v6 and v7) on my system? i can't remove the old getquote, nor can i install the new getquote w/o getting the error "Rejecting types due to incompatibility." i'm running win xp

Go to http://www.pirform.com and download CCleaner.exe and install it (assuming you're using a WinTel device). You can also buy a fuller featured copy but the freebie will get you where you need to go. (I made them a donation as I figured they certainly earned it!) After you install it, click on the Tools menu and then on Uninstall. Find the outdated Java and blow it away.

BTW, if you're using a Mac you're probably not asking the question. But CleanMYMac has many similar features PLUS and is well worth the price.
______________
Van D. Olmstead, Jr.

my system is win xp

Please forward this email to GetQuote extension developer Ted
Thank you for developing GetQuote, GeQuote was successfully loaded to my two computers. However, my third computer, it does not. I have tried all options shown below in the Troubleshooting section , nothing works. It gives a message, indicated red below, about Java Loader. I am trying to figure out why. You probably heard that before from other users. If you have a friend /associate who is a Java/Open Source developer to bring a real answer to the satisfaction of all that have this problem. That will be really appreciated.
Best
Leonard

Reference :

FAQ
Q. When I try to install it says: "Could not create Java implementation loader."
Please refer to the Troubleshooting section in the users guide .
6.1 Issue 1

When attempting to install the add-in, OpenOffice reports an error: “Could not create Java implementation loader”.
Try enabling Java in OpenOffice. First, select the Tools | Options... menu. Second, select “Java” on the left hand side of the dialog. Third, look on the right and make sure the “Use a Java run time environment” box is checked. Fourth, select a 1.5 or later version of Java. Fifth, push “OK”. Close OpenOffice, restart it, and try installing the add-in again.

Leo Tezduyar
6349 Cliff Side Drive, Florence, KY 41042

Running OO 3.4.1; installed GetQuote & it is able to look up a quote just fine for me. Thanks.

However, with this: =GETQUOTE(A4) in a cell, if I save the spreadsheet and reload it, what comes up in the cell is =com.ejs.ooo.getquote.getquote(A4) which the spreadsheet program displays as #NAME? instead of looking up the quote. Note that if I manually re-enter =GETQUOTE(A4) in the cell it works fine.

Maybe I have something set incorrectly? Appreciate any help. Thanks

I have a range of stock quotes created by the GetQuote() add-in. I assume I cannot copy a range, because this would copy the range formula instead of the value - but copying the values from the cells individually seems to be very slow - it's as if each time a cell value is copied, the data is retrieved from Yahoo Finance.

I am copying cell values like this:

fitCell.value = dataCell.getValue

...where datacell is a stock price in the GetQuote() formula range.

I have also tried the following:

oDoc = ThisComponent
oDoc.addActionLock()
' --- code to get cell values ---
oDoc.removeActionLock()

...but it doesn't seem to help.

Has anyone seen this behaviour before, and does anyone know a remedy, please?

Hi: I am a complete newby to openoffice.org and calc and GetQuote . . . However, I have had great success with setting up a sheet with about 60 or so stock quotes, Indices and a few currencies - They all seem to be feeding in from Yahoo! ok . . . except one!! I have tried various configurations but I can't get anything to download for ^DJI except #VALUE! I have also tried referencing it from another cell:

=GETQUOTE("^DJI") result: #VALUE!

=GETQUOTE(E14) result: #VALUE!

=GETQUOTE(""^DJI"") result: Err:509

Any ideas? Thanks in advance

Amen to that, but I've found an approximation that is something of a work around.
Use DIA (An ETF based on the Dow Jones Industrials) and multiply the cell result by 100. Today (5/16/13) the difference between the two (^DJI= 15,233.22, DIA *100=15,235) is 1.78

______________
Van D. Olmstead, Jr.

Hi, it seems that there are some interaction problems between LibreOffice and GetQuote 1.1

@Ted:
It would be great if you could visit
"Bug 62472 - Cells referring to values by "Extension GetQuote 1.1" with wrong value after FILEOPEN"
https://bugs.freedesktop.org/show_bug.cgi?id=62472
"Bug 63823 - GetQuote 1.1: Installation fails with Java error message"
https://bugs.freedesktop.org/show_bug.cgi?id=63823
"Bug 63824 - GetQuote 1.1: breaks cell formatting "
https://bugs.freedesktop.org/show_bug.cgi?id=63824
and help us a little with debugging.

Thank you and best regards

Rainer Bielefeld
(LibO QA Volunteer)