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


Le 03/06/11 06:43, nwchrisb a écrit :

Hi Chris,

Just to clarify: I'm not trying to use a relational database.  I really just
want to parse a web page which has a lot of data.  I need to do it
programmatically because the number of quarters of historical data will vary
by company.  That is, I need to call

http://www.advfn.com/p.php?pid=financials&btn=istart_date&mode=quarterly_reports&symbol=GLW&istart_date=0
http://www.advfn.com/p.php?pid=financials&btn=istart_date&mode=quarterly_reports&symbol=GLW&istart_date=1
http://www.advfn.com/p.php?pid=financials&btn=istart_date&mode=quarterly_reports&symbol=GLW&istart_date=2

etc. until I get no more data.  In addition, I need to easily get the data
onto one sheet.  I was hoping to do it without writing the scraper myself,
since opening a calc sheet as a "web query" works quite nicely.  I was
unable to figure out if this GUI functionality would allow me to collate
multiple queries, however.

Well the GUI allows you to "Insert Data from an External Link" and using
the internet link you posted I was able to change the istart_date
variable manually to insert the data onto a sheet. I didn't try copying
onto the same sheet in different cells though, rather I copied the data
into separate sheets. The dialog for inserting the link is a bit quirky
though, you have to activate the update checkbox, and then deactivate it
for the import wizard to start (and it is a bit slow on my system). Then
you get a list of the the HTML data to select that you want to import.

Alex


-- 
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.