I need to fetch the historical daily ohlc data of 1900 tickers from nse equity but I also need ATH(all time high) data along with ohlc. I also need suggestions how should I go ahead about storing the data. At the end of the day I need the data to be pulled into excel for further analysis.
You can save all the live market data from Websocket API and use that for your analysis or convert it to candle data use that for analysis. For older data, you need to pull historical candle data and dump it in your database and use that as source.
For older data, you need to pull historical candle data and dump it in your database and use that as source.