I was building myself a excel sheet to keep track of my investments. I have this link of the stock exchange website that has a single zip file containing a CSV file of the trading data of the last trading day. The name of the zipfile is dynamic in the form "eq_csv.zip where the ddmmyy is the date of the trading day for which the data pertains to. Therefore, the available file may be of the current day or 2-4 days old if the markets were closed. I was building myself a excel sheet to keep tra