1 reply to this topic

[Scottyf11]

I want to create a database that contains every stock ticker, and all types of financial information for each ticker. I need PHP to read an excel file for a ticker symbol, then query websites like reuters, yahoo finance, google finance to gather financial statement and other appropriate financial information. I then need PHP to write this information to the database, and continue until all tickers have been "researched". This project is going to be very intense, and I was hoping someone could help me get started. I don't need you to write the code (obviously), but maybe provide me with tutorials for this type of project.

Thanks!

Scott

[Orjan]

Well, first of all, is excel file necessary? wouldn't it be easier if you enter a stock ticker on the web page and puts it to search around for information?

maybe store requested tickers in a DB with relevant information from these places?

then to fetch this info, you need to find out how to get appropriate info from the pages, how to use curl or any other method. when you have fetch the the info page, you then need how to locate the attactive info on the page and store it to your database.

this is the very basic things to look in to in the first place.