Basic query for the experienced hands out there: Which are the most reliable and complete sources of historical fundamental and price information for Indian listed companies for quantitative (not technical) analysis?
I’m referring to data that is available in easy-to-collate and use formats, be it as downloadable spreadsheets or in flat files through python queries for quantitative analysis of the universe of stocks.
Looking to improve on:
screener.in for historical financials, but has it’s limitations on completeness.
python scripts to Yahoo Finance for price data, but some errors in price data compared to NSE
Apart from the ones mentioned, Trendlyne is pretty good in terms of the fundamental data, be it historical P&L, balance sheet, promoter share holding and research reports etc. Not to mention their own valuation and durability scores which are also pretty decent in gauging the relative valuation.
You will have to write some code in order to access their APIs.
You may ask Alok Jain (https://twitter.com/WeekendInvestng). I guess he has a Microsoft Excel utility that fetches quotes from Google Finance API. That should involve very little coding.
You can check this source with relatively cheap prices https://eodhistoricaldata.com. This service provides both historical price and fundamental data for more than 60 exchanges all around the world. The data is provided both in JSON and CSV format and with Python examples as you wish (see documentation pages).
For end-of-day data are covered all US stocks, ETFs and Mutual Funds (more than 45 000 in total) from the beginning, for example, the Ford Motors data is from Jun 1972 and so on. Other stock exchanges are covered mostly from Jan 3, 2000.
For fundamentals supported symbols from major US exchanges (around 7000 symbols in total from NYSE, NASDAQ, and ARCA) 10 years both for yearly and quarterly. For other symbols the data for last 5 years and last 10 quarters.
At the moment it does not provide shareholding patterns for companies. Basically, it’s not a fundamental data, but more ‘usage data’, but I guess it’s a good idea and definitely could be provided at least for US tickers.
From the other point of view, the service provides Top holdings for almost all ETFs, and it also could be useful for company analyze from the ownership point of view.
I have built price data all the way back from 1990s adjusted for Splits/Bonuses/Dividends and can extend to Rights/Reduction of Capital. I can expose an API if there is sufficient interest, for a small fee. I noticed that most of the EOD adjusted price data was expensive for no reason which is why I decided to build it myself. I have the shareholding data as well accessible for free at https://phreakonomics.in/shareholding/index which I can expose through an API as well, again for a fee if there is interest. I have built these for personal use in my toolsets as a hobby so monetising them is currently not a priority for me.
After some SQL queries and coding on python. I made this dataset. In this dataset, all stocks of the Indian Stock Market are present a total of 2435 stocks. The data is of 1-year rows represent stock name and column represent date and I have filled the table with closing price.
