Prateekkp/N-AIRS — reverse-engineered prompt

Build me a Python market intelligence pipeline for NIFTY 50 style stock data. I want it to pull market prices, save the raw data in MySQL, check that the data looks valid, flag weird values, calculate technical indicators like RSI, MACD, and Bollinger Bands, then create simple BUY, SELL, or HOLD signals from editable rules.

Please make it modular so I can run the whole pipeline with one command, or run ingestion, quality checks, features, decisions, and feedback separately. Use a config file for database settings, symbols, dates, and rule settings, and make sure no real passwords are committed.

I also want the results stored in reporting tables or views that Power BI can use, including signal history, stock details, calendar data, and quality summaries. Add clear setup instructions, database setup scripts, and a basic sample dashboard output or spec if possible. Look up current docs online if you need to.