Universal News Aggregator

Job ID: 38617980

Budget: $30 – $250 USD

Project to get news for Firms

IMPORTANT: WHEN BITTING TO THE PROJECT WRITE "NOT BOT" AT THE FIRST LINE, without it will not even look at your offer

Background of the project. I have an Excel file with a table where have formal names of 300 firms, corresponding to ID of each company, Direct link to firms web page, and a verbal name for search

I need an Python script that will go through main media sources and collect news posts about each company, and send when news is found need it to past to consol in a format
[News ID; Firm ID; Firm name;News Agency; News name; Link to news; News text]

Also the data will possess direct links to emitents websites. With a news section. I would also need to get data from there. On this part no consistency news data is not needed.
One excel file there will also be some key words to provide for the search: “like Gas, Oil and so one”. Prosedure for them is the same as for the firms
I need script to send news with no more then 5 min lag after arrival on any media platform.
Note
• Script should work constantly and do not send same news several time
• Should also append News table in SQL
• All work is done on you machine, I will past it to my end myself
• Firms names are not ideal for news search as it contains formal names not a talk ones. Like “Общество с ограниченной ответственностью "Управляющая компания "Альфа-Капитал"” but not just “Альфа-Капитал”.
• News portal some time can in search give news that are irrelevant to any firm. Those one we still need to receive and past to consul, but just not add Firm ID and Firm Name.
So you would need also to make some key world search for the name, because «ВТБ» and «ВТБ Капитал» are different firms and I do not what to see any news about «ВТБ Капитал» in a «ВТБ» section.
• Also note that this script will make lots of reqests to the media portals. So I Would need some mechanism to prevent block

Links to data source:
• https://lenta.ru/
• https://www.interfax.ru/
• https://www.forbes.ru/
• https://www.rbc.ru/
• https://www.gazeta.ru/
• https://e-disclosure.ru/poisk-po-kompaniyam
• https://ria.ru/
• + Direct links to Emitents web-pages