I am currently working on an assignment which extracts data from the yahoo finance page.
I have an csv file as an input which has the names of stocks and is typed into the search bar using read csv and using the for each activity.
After doing so I need to extract the historical data for the given stock on the page which is in the form of a table and for that I am using data scraping . Currently I am getting the same data table as an output for all the stock names that iterate through the for each activity.
example if the first stock name is NIFTY the data table for it is extracted and for the next iteration the data table and its contents remain the same after writing it in the excel.
Kindly help me with this.