Problem:

Manual collection of stock quote data and calculation of the TSMI index consumed a significant amount of time in the analytics department, which slowed down the preparation of daily reports.

Solution:

Developed a Python script that fully automates the process:

• Automated Data Collection: The script automatically collects stock quotes from public sources.
• Automatic Calculation: Performs calculations of percentage changes and the TSMI index without human intervention.
• Automatic Report Generation: Creates CSV files and visual materials for social networks, ready for publication.

Implementation Results:

• Time Savings: Significantly reduced the time required to prepare reports.
• Increased Efficiency: Allows employees to focus on analytics rather than data collection.
• Improved Quality: Automation provides more accurate results.
• Quick Publication: Reports and visual materials are published automatically, ensuring the information is up-to-date.