Building a self-learning msql database for 15,000 companies that regularly updates itself

- the input I provide is company name and stock symbol

- the exact url of the actual company needs to be found by the code (a publicly traded company has always news, press, and investor realtions sections and mentioning of the stock symbol. other sites which are not the company itself will not have these)

- within the website the investors section on the site exact url needs to be found (sometimes called invest / investor / investors / stock / investor relations / etc)

- within the investors relation section the latest 1 webcast needs to be download. it is always the earning call conference call. the code will need to automatically every time register with a fictive email address and names to be able to download the audio file.

columns for each company to be filled-in:

company symbol

company name

in which stock exchange is traded (I provide it already)

city of headoffice

country of headoffice

date of latest webcast recording

full title of the recording

the recording file full audio

how many mb is that file

the code needs to update the database (scrawl) regularly and have an easy to comprehend excel output for fields it could not find or points of attention humans needs to look at.

I estimate it at 1 to 2 hours coding. later on there will be follow ups on this.

file attached is one of 6 - just for reference of the input you get.

i need a recommendation for a free hosting of the mysql with such data size. the 20-80 mb per audio file are times 20 columns in the future for all 12,000-15,000 companies.

thanks

Codage Développement de bases de données MySQL PHP Programmation

Nº du projet : #18734490

À propos du projet