Automating Daily Scans (Schedulers, Cloud Tools)

Running prompts by hand every morning is fine when you’re starting out.

But if you want your screener to become part of your daily routine, automation is the next step.

Instead of typing the same prompt again and again, schedulers and cloud tools can run it for you — and deliver fresh results automatically.

Save Your Core Prompts

Pick 2–3 prompts you’ll reuse often.

Example:

• “Find Nifty 100 stocks with ROE above 12% and price above 200-DMA.”
• “List auto stocks under ₹1,000 with RSI below 30.”

These become your base rules.

Use Scheduling Tools

• Windows: Task Scheduler can run your script every morning.
• Mac/Linux: Cron jobs do the same.
• Cloud: Google Apps Script, Zapier, or n8n can trigger your prompts daily.

Automate the AI Call

A simple script can send your saved prompt to the AI, fetch results, and put them in a usable format.

Store in the Right Format

• Use Google Sheets if you want access from anywhere.
  
• Use Excel if you want to add further analysis.
  
• Or build a dashboard if you like visual charts.
  

Example

Suppose your screener is for auto stocks.

Your saved prompt:

“Show auto companies under ₹1,000 with profit growth for 3 years, low debt, and RSI below 30.”

If you run this manually, it’ll take 15–20 minutes every time. With automation, the list refreshes daily, waiting for you when you log in.

How to Set It Up (Sample Script)

Here’s a starter Google Apps Script that runs your prompts every morning at 9:05 IST and updates a Google Sheet:

const SHEET_NAME = 'Results';
const PROP_KEY = 'AI_API_KEY';
const AI_API_URL = 'https://YOUR_LLM_PROVIDER/v1/chat/completions'; // adjust per vendor
const MODEL = 'YOUR_MODEL'; // e.g., gpt-4o-mini

// Prompts you want on schedule
const PROMPTS = [
  'List Nifty 500 stocks with P/E < 20, ROE > 15%, RSI < 30. Return STRICT JSON: {"columns":["Stock","Price","PE","ROE","RSI"],"rows":[...]}',
  'Find auto stocks under ₹1,000 with profit growth > 10% (3y) and RSI < 30. Return STRICT JSON with same schema.'
];