FAQ

Q.  Does the function work with options symbols?

No.  Unfortunately this is a limitation of the YAHOO! service.

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

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.

Q.  Would you please enhance the function to do ________?

Enhancements are being made to the soon to be released GetQuote extension that is intended to replace GetStockPrice.  Learn more...

Q. When I exit Calc and reopen the file, the cells display "#name?" and cell values are populated with "=com.ejs.ooo.calcstockaddin.getstockprice(M10)".

I haven't yet figured out why this happens.  Try exiting and restarting OpenOffice.  Try reinstalling the extension.

Q.  How how does one force an update other than closing the spreadsheet and reopening it?

Open the "File" menu and select "Reload".

Q.  How do I 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:

=GETQUOTE("XOM")