Stock Trend Signal Updater for Google Sheets
Budget: ₹1,500 – ₹12,500 INR
Developer Brief: Google Sheet Automation for Stock Trend Signals
Objective:
To build an automation system that fetches technical trend data (daily, weekly, monthly) for Nifty 500 universe stocks only from Moneycontrol.com (logged-in access) and updates it in a pre-structured Google Sheet. This system will help the user track stock trend changes efficiently without disclosing any trading or investment logic to the developer.
Data Source:
Website: https://www.moneycontrol.com
Data to be fetched is under each stock's "Technical" section (visible post login).
Authentication:
System should support login with the user’s Moneycontrol credentials (manual or token-based).
Input:
A list of Nifty 500 stock names (NSE-listed).
Provided in a Google Sheet (sample sheet structure will be shared).
Data Points to Fetch per Stock:
Daily Trend (e.g., Bearish / Bullish / Neutral / Very Bullish etc.)
Weekly Trend
Monthly Trend
Price at Time of Trend Fetch
Actions Required in Google Sheet:
Match stock names in sheet.
Compare current fetched trend with previously stored trend.
If trend has changed:
Update corresponding trend column (daily/weekly/monthly)
Update corresponding date column with today’s date
Update the price column with the current market price of that stock
If no change: do nothing.
Google Sheet Integration:
Automation should update an existing Google Sheet (shared by user).
Must have ability to write data to specific columns without disturbing existing formatting or formulas.
Technology Suggestions (developer may choose):
Python with Selenium or Playwright for scraping
Google Sheets API for writing
Scheduled script (e.g., cronjob or cloud function)
Security & Constraints:
Developer must not store any trading logic, position sizing, or buy/sell strategy.
This automation is for data update only.
Developer will receive only the sample Excel/Sheet structure, not strategy logic.
Deliverables:
Code to run locally or on cloud
Clean UI or trigger system (optional)
Documentation for future edits or scaling
One-time setup support
Optional (Bonus):
Highlight rows with fresh trend changes (color or flag column)
Export today's changed stocks to a separate tab or report
Timeline:
Phase 1: Trend Signal Updater Only (2 weeks max)
Objective:
To build an automation system that fetches technical trend data (daily, weekly, monthly) for Nifty 500 universe stocks only from Moneycontrol.com (logged-in access) and updates it in a pre-structured Google Sheet. This system will help the user track stock trend changes efficiently without disclosing any trading or investment logic to the developer.
Data Source:
Website: https://www.moneycontrol.com
Data to be fetched is under each stock's "Technical" section (visible post login).
Authentication:
System should support login with the user’s Moneycontrol credentials (manual or token-based).
Input:
A list of Nifty 500 stock names (NSE-listed).
Provided in a Google Sheet (sample sheet structure will be shared).
Data Points to Fetch per Stock:
Daily Trend (e.g., Bearish / Bullish / Neutral / Very Bullish etc.)
Weekly Trend
Monthly Trend
Price at Time of Trend Fetch
Actions Required in Google Sheet:
Match stock names in sheet.
Compare current fetched trend with previously stored trend.
If trend has changed:
Update corresponding trend column (daily/weekly/monthly)
Update corresponding date column with today’s date
Update the price column with the current market price of that stock
If no change: do nothing.
Google Sheet Integration:
Automation should update an existing Google Sheet (shared by user).
Must have ability to write data to specific columns without disturbing existing formatting or formulas.
Technology Suggestions (developer may choose):
Python with Selenium or Playwright for scraping
Google Sheets API for writing
Scheduled script (e.g., cronjob or cloud function)
Security & Constraints:
Developer must not store any trading logic, position sizing, or buy/sell strategy.
This automation is for data update only.
Developer will receive only the sample Excel/Sheet structure, not strategy logic.
Deliverables:
Code to run locally or on cloud
Clean UI or trigger system (optional)
Documentation for future edits or scaling
One-time setup support
Optional (Bonus):
Highlight rows with fresh trend changes (color or flag column)
Export today's changed stocks to a separate tab or report
Timeline:
Phase 1: Trend Signal Updater Only (2 weeks max)