NSE Pulse – Upload & Import

Select Excel / CSV files from your laptop. They are saved into the server uploads/ folder and can be imported into the database automatically.

How it works

  1. Auto from NSE – enter a start date (or range). App downloads CSV from nsearchives.nseindia.com.
  2. Daily 9 PM IST – set a cron job that hits the cron URL; today’s file is fetched & imported automatically.
  3. Manual upload – still available: drag & drop CSV/Excel from your laptop.
  4. All files land in uploads/ and are imported into MySQL for the app.

0. Download from NSE Archives (auto)

Source: https://nsearchives.nseindia.com/products/content/sec_bhavdata_full_DDMMYYYY.csv

to

Weekends are skipped. Max ~400 days per request. Be patient – one request every 0.3s.

Daily auto at 9:00 PM IST

Set a cron job (or free service like cron-job.org) to call this URL every day at 21:00 Asia/Kolkata:

Loading…

Edit includes/config.php → change CRON_SECRET to a long random string, then use that value as ?key=….

Example crontab line:
30 21 * * * curl -s "https://YOUR-DOMAIN/api/cron_download.php?key=YOUR_SECRET"

1. Upload files from your laptop

📂

Drag & drop Excel / CSV files here
or click to browse your laptop folder

Allowed: .csv .xlsx .xls .txt · Max 50 MB each

2. Import files already on server

Use this if files were copied via FTP or are already in uploads/.

Open App

Server uploads/ folder

Loading…

Files currently on server

Loading…

Database status

Loading…

Log

Ready.