Tuesday, August 9, 2011

Yahoo! Service Unreliable

Many have commented that GETQUOTE is intermittently returning incorrect prices.  For a time it was returning grossly wrong values like 505218528.  That seems to have stopped and now it is returning values that are just a little off.  Unfortunately the root of the problem lies with the Yahoo! Finance service upon which GETQUOTE depends.  Moreover, since the incorrect values are only slightly off, there is no way for GETQUOTE to recover from the error.  According to a recent posting to the Yahoo! developers forum, the problem has been reported to Yahoo!.  Hopefully they will fix it soon.

Meanwhile I will be focusing my efforts on making GETQUOTE work with another data provider.

Friday, April 29, 2011

Understanding Arrays

You can use the GETQUOTE function without arrays in OOo Calc, but for GETHISTORY, understanding arrays is a must.  The OOo wiki has a nice article about using arrays that explains the topic.  Using arrays with GETQUOTE is the best way to speed up that slow-loading spreadsheet that contains lots of symbols.

Monday, April 18, 2011

GetQuote v1.1 Released

Many new quote types have been added to the GETQUOTE function in this latest release. They are listed in Section 4.1.2 of the User Guide.

A new function for getting historical quotes has been added. It is described in Section 5 of the User Guide.

Installing the new add-in should replace the old one, but if it does not, (1) uninstall all previous versions of the add-in using the Extension Manager, (2) shut down all instances of OpenOffice (logging off and/or rebooting can't hurt), and then reinstall the add-in. Section 3 of the User Guide gives instructions for using the Extension Manager.

Download the latest version.

Read the users guide

Thursday, March 17, 2011

Windows 7: Call for Help

There are several reports of GetQuote not working on 64-bit machines running Windows 7. I do not have a copy of Windows 7 or a 64-bit machine and therefore cannot debug this case. I must instead rely on the kindness of strangers.

If you have successfully used GetQuote on Windows 7 or on a 64-bit machine, please leave a comment. And if you did anything special to get it to work, please tell us what you did.

^DJI Bad, INDU Good

Thank TJCacher for this bit of advice:

From further research, I learned I could used the symbol "INDU" (without the normal ^ which generally is used to designate an index). This appears to return an accurate value for the Dow Jones Industrial Average, which is what ^DJI used to do.

Saturday, October 2, 2010

The ^DJI Symbol is Broken

About a month ago, the symbol for the Dow Jones Industrial Average, "^DJI", stopped working. The root cause of the issue is the Yahoo! web service, so unfortunately there is nothing GETQUOTE can do to fix it.

As a work-around, consider using the symbol "^DJX", which is 1/100 of the Dow Jones Industrial Average.

Another substitute symbol is "DIA", the SPDR exchange traded fund (ETF) that seeks to mimic the price and yield of the DJIA.

Saturday, August 28, 2010

Planned Release Content

Thank you all who participated in the polling. An overwhelming number of people want to be able to get historical price data so this will be the next major enhancement to the OOo Calc Extension.

One person requested bid/ask price of stock. I will include this in the next release, along with many other new quote types, but remember that GETQUOTE relies on a Yahoo! service that is not always real-time:
Many quotes are delayed!
Click here for a list of exchanges and their delays.