Enhance the WhyDRS Database by adding a new column that stores the last closing price of each stock. This column should automatically update once a day to ensure that the data remains current and reliable for investors.
Tasks:
Modify the database schema to include a new column for the last closing price.
Set up a scheduled job (e.g., a cron job) to fetch the latest closing prices daily from a reliable financial data source.
Implement error handling to manage data fetching issues or discrepancies.
Update the data entry and update procedures to accommodate the new column.
Ensure that the front-end displays the last closing price appropriately.
Write unit and integration tests to verify the functionality of the new feature.
Document the changes in the database schema and update any relevant documentation.
Expected Outcome:
The database includes a new column that accurately reflects the last closing price for each stock.
The last closing price is updated automatically every day without manual intervention.
Users can view the most recent closing prices, enhancing the usefulness of the database for investment decisions.
Enhance the WhyDRS Database by adding a new column that stores the last closing price of each stock. This column should automatically update once a day to ensure that the data remains current and reliable for investors.
Tasks:
Expected Outcome: