The NSE website hosts a CSV file that comprises the current list of F&O (Futures and Options) stocks along with their corresponding lot sizes.
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, You can find a YouTube video demonstrating the step-by-step procedure in just one minute.