@ShubhS9 @siva-reddy @nithin
Where can I find a complete and updated list of F&0 stocks with lot size as a web page. I have checked the NSE excel sheet and it is not updated with the latest stocks. Can ZERODHA provide an updated and latest version from time to time in Z- CONNECT or somewhere else. It would be a great help.
Thanks
1 Like
This CSV file available on the NSE website contains the updated list of F&O stocks with their respective lot sizes.
In case you want to view this list on a web-page itself, then you could use the Zoho Sheet Online Excel Viewer’s Import from URL option and directly paste the CSV file link (https://archives.nseindia.com/content/fo/fo_mktlots.csv) in it. There is an open-source tool for viewing CSV files in the browser available as well but that requires uploading the CSV file -
Hi, take a printout of every FnO series and enjoy trading. Click on [Download the file for permitted lot size ] in NSE link site attached NSE - National Stock Exchange of India Ltd. (nseindia.com)
1 Like
Too much work…
You can view the CSV directly in a Google Sheet using a built-in function called IMPORTDATA. Here’s how you can do it:
- Open a Google Sheet where you want to import the CSV data.
- In the cell where you want to display the imported data, enter the following formula:
=IMPORTDATA("https://archives.nseindia.com/content/fo/fo_mktlots.csv")
- Press Enter.
Here is a video of that 1-minute procedure →
The Google sheet which I made is downloadable. So You can just copy it to your drive.