how download yahoo finance data into spreadsheet and databas

[fr0zenmon]

I want to download data using web queries from yahoo finance into openoffice. Does anyone have experience with this?

I want to create a spreadsheet and database to analyze stocks.

what i need help with:
1. how to get updated stock data into worksheet automatically at regular internvels
2. Also managing historical data
3. download and search financial statements

[jdhurst]

I used to use ODBC within Excel to pluck data from an AS400, so that method might work. It has been years since I did it, and I don't recall the details. ... JDH

[MeaninglessNick]

As I recall, there are several scripting interfaces. You would probably have more luck asking such questions on the openoffice forums (www.openoffice.org). You could also consider writing a separate perl or python script to do the downloading. I would look on CPAN (www.cpan.org) to see if someone has already written
a perl module to interface with Yahoo! finance.