Query to fetch data

i want to fetch Nifty-500 stocks data from wikipedia or from other sites . i am not able to fetch the data as you have done in below code. 



it is giving me error the dataframe doesn't contain Symbol. i tried to change the Symbol from other name  but not workin. and also i am not able to get results about filtering of data in Hierechical Risk parity course.  v



not able to apply RSI,ROI etc on indian market data

 

Hi Keerti,



You can go to this link to find symbols of all the stocks under Nifty-500: https://www.nseindia.com/products-services/indices-nifty500-index



On this page, you will find a link to download the list of NIFTY 500 stocks.



I hope this helps.

Thanks

Sir I tried this before  . But what I want is ohlcv data of all 500 stocks at a time as you got about s&p 500. And also m not able to filter stocks using technical indicators and financial indicator plz help

Hi Keerti,



You can follow the following instructions to get OHLC data of 500 stocks in NIFTY 500. 

  1. Read the CSV file downloaded from this link. And put it in a pandas dataframe.
  2. Take the Symbols series from the above dataframe.
  3. Convert the above series into a list. Can check this link for this step.
  4. Add ".NS" after every symbol in the list. Check this link for this step.
  5. To get market data of the list of stocks you can check the code in this jupyter notebook.
  6. To screen the stock based on some technical indicators and financial indicators you can check this Jupyter notebook. 

I hope this helps.
Thanks