Consider a txt or XLS file containing a list of stock names.
Is there a way to populate data in this sheet. I need columns like Market cap, 1 and 3 year returns, PE ratio etc.
One method is to get external data for each of the stock and extract the columns. But this is too time consuming considering there could be 350 scrips in the list. Is there a ready made list like this available somewhere?
Is there a way to populate data in this sheet. I need columns like Market cap, 1 and 3 year returns, PE ratio etc.
One method is to get external data for each of the stock and extract the columns. But this is too time consuming considering there could be 350 scrips in the list. Is there a ready made list like this available somewhere?