Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


Hi all,

I've searched this forum for "web query", "querytables", and "query tables",
as well as Googling, but most of the information I've found is pretty dated
(circa 2007).    I'm looking for some way to emulate the QueryTables "web
query" functionality that is present in Excel
(http://support.microsoft.com/kb/162080).  I've also found the OO developer
guide
(http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Spreadsheet_Documents),
but it's just not organized in a way I can easily use.

I am trying to collect multiple quarters of data from the ADVFN site (e.g.
http://www.advfn.com/p.php?pid=financials&btn=istart_date&mode=quarterly_reports&symbol=GLW&istart_date=0),
where the quarters change as the "istart_date" URL parameter changes, so it
doesn't seem like "Insert->Link to External Data" is going to work well for
me.

I was able to find a function that can pull in stock prices, but it uses
Yahoo! quote's CSV file output
(http://www.oooforum.org/forum/viewtopic.phtml?t=16741).  This would be
nice, but I need more than just stock prices, which is why I'm using the
ADVFN site.

If there's not a "baked-in" function that works like QueryTables, I could
probably write a scraper, but it seems like much of that is built-in
already; I just don't know what it's called.

Thanks for your time,

Chris

--
View this message in context: 
http://nabble.documentfoundation.org/QueryTables-equivalent-tp3013283p3013283.html
Sent from the Users mailing list archive at Nabble.com.

-- 
Unsubscribe instructions: E-mail to users+help@libreoffice.org
In case of problems unsubscribing, write to postmaster@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.