Excel-Based Stock Screener with Built-in Technical Indicator Calculations

Hello,

I’m looking for an experienced Excel/VBA developer with solid financial markets knowledge to build a smart technical analysis tool in Excel.

✅ The Excel file must automatically calculate the following technical indicators, based on daily stock price data that I will enter manually:
• RSI (Relative Strength Index)
• MACD
• Volume comparison (vs weekly and monthly averages)
• Moving Averages (MA50, MA100, MA200)
• Pivot Points (Classic)
• OBV (On-Balance Volume)

✅ Project Details:
• I will provide sample historical stock data (Date, Open, High, Low, Close, Volume)
• You will use that data to implement and test all indicator calculations
• All logic must be implemented inside Excel using formulas or VBA (no external sources)

✅ Conditional formatting should highlight each signal:
• RSI between 25–35 → Orange
• MACD Bullish Crossover → Blue
• Volume Spike → Green
• Price above MA50 → Purple
• Price above MA100 → Brown
• Price above MA200 → Red
• Price near Pivot or S1 → White
• OBV trending up with price → Yellow
• If all conditions are met, highlight the stock row in Gold

⚠️ Important: The developer must have working knowledge of financial indicators.
These formulas are not copy-paste tasks — correct implementation requires proper understanding of financial analysis.

❌ No API or real-time data integration is needed — just logic and formatting.

Please include examples of similar Excel tools or dashboards you’ve created related to technical analysis or trading.

Thank you.