a. Set up automated daily report download process from CapitalIQ:

 

      – Broker Research:

 

https://www.capitaliq.com/CIQDotNet/Research/InvestmentResearch.aspx

 

      – Annual Reports: https://www.capitaliq.com/CIQDotNet/Filings/FilingsAnnualReports.aspx?CompanyId=9263360

 

   b. Design folder structure on Amazon S3 for storing reports:

 

      – Categorize by report type (Broker Research, Annual Reports)

 

      – Subcategorize by company, country (Malaysia), and industry

 

   c. Implement historical report download process for the past 5 years

 

   d. Aggregate additional Malaysia-specific data sources:

 

      – Government reports from Malaysian agencies

 

      – Economic analyses from local research institutions

 

      – News articles from Malaysian business publications

 

   e. Develop a data pipeline to continuously fetch and update information