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