Implement Moving Average Cross-Over Stock Trading Strategy in Streamlit App

[espin086]

Create a Python script to implement a simple moving average cross-over stock trading strategy using data from a SQLite database. The script should calculate the moving averages, generate buy/sell signals based on the cross-over.

Here is video showing how to do this: https://www.youtube.com/watch?v=PUk5E8G1r44

I would like to create a simple moving average cross-over stock trading strategy that will be integrated into a Streamlit application. The data for this strategy is stored in a SQLite database.

Requirements:

1. Implement a moving average cross-over strategy using the data from the SQLite database.
2. Integrate this strategy into a Streamlit application for easy visualization and interaction.
3. Include data visualization to show the stock prices, moving averages, and buy/sell signals.
4. Ensure the application is user-friendly and provides clear insights into the trading strategy.
5. The code needs to be modular and all parameters (aka window) in the SMA function should be selected by the user before running analysis.

Additional Information:

• The SQLite database contains historical stock price data that will be used for the moving average calculations, you will need to pick a ticker to analyze in the streamlit UI.
• The moving average cross-over strategy should generate buy signals when the short-term moving average crosses above the long-term moving average, and sell signals when the short-term moving average crosses below the long-term moving average.

[ZaibyS]

@espin086
I've started working on this and will provide an update by tomorrow.

[ZaibyS]

@espin086
I've integrated a moving average cross-over strategy on the closing price of the stock and included data visualization to display stock prices, moving averages, and buy/sell signals.