This downloader loads an RSS feed from the Abu Dhabi securities exchange website (www.adx.ae) and then executes a pre-script to populate a custom database. The database, whose name is 'adx_news', has 3 columns:
Date: The date the news was published.
Title: The company news title.
Link: A PDF or DOC link to get more details about the news.
The pre-script was created because there is only one RSS feed (There is no RSS feed for each listed company such as the RSS feeds you find in Yahoo or Google), so there was no simple way to distinct which news belongs to which symbol or security. Pre-Script are .Net codes that are executed before populating a database to perform specific tasks, such as updating or cleaning fields, extracting data...
Example of a title data:
Companies Disclosures - [DRIVE] Rescheduling the date of Emirates Driving Company board meeting to August 20, 2009
The script task is simple; it has to extract the symbol within the above title. In this example the symbol is 'DRIVE' (Emirates Driving Company). It then removes 'Companies Disclosures - ' text and rebuild the title. The script is automatically executed on each RSS item to extract the company symbol name from the title field and to fill the custom database with the news data.
This item or object is not set to automatically add new symbol (symbols that doesn't exist), so before running the downloader, you have to download the list of company symbols that are listed in the Abu Dhabi securities exchange. Here is the ticker symbols list: Abu Dhabi Stock Exchange