Skip to content

This creates a ohlc timeseries from downloaded CSV files from NSE India website and makes a SQLite database for your research.

License

Notifications You must be signed in to change notification settings

pillai-amal/NSE-timeseries-form-CSV-file-creator-and-SQL-appender-

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

NSE-timeseries-form-CSV-file-creator-and-SQL-appender-

This creates a ohlc timeseries from downloaded CSV files from National Stock Exchange India (NSE) website and makes a SQLite database for your research. This has made my work flow 95% faster compared to creating time series for individual tickers. Which even increases the time with increase in timeframe, earlier loops were used to go through entire csvs. I'm working for hosting the DB so that this is can be very much used like yfinance but for daily candles. Only daily infomation is available. As NSE publishes only daily inforation after the market hours. For intraday ohlc data I would suggest AlphaVantage which gives for Bombay Stock Exchange intraday values. In case if you trying to bulid a bot, there are brokers who give free data for using their APIs to place order.

Feel free to contribute to this project..

Created table using the script

alt text

Database Structure:

alt text

About

This creates a ohlc timeseries from downloaded CSV files from NSE India website and makes a SQLite database for your research.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages