Manually create an excel file with one sheet and two columns (Stock name and Current Price). Add stock names ‘Tata Motors’, ‘Asian Paints’ as two rows in the sheet.
Build an automation in UiPath that does the below:
- Read the excel file and fetch current stock price for each of these stocks from Google (Search “Stock price of [stock_name]”).
- Write the stock price values in the corresponding column of same excel sheet.