UiPath use case please solve this fast plese

[prashant1603765]

Step 1: Open browser and launch - Major World Indices - Yahoo Finance Major World Indices Yahoo FinanceSee the complete list of world stock indexes with points and percentage change, volume, intraday highs and lows, 52 week range, and day,

Step 2: Extract the table from the webpage as an excel file

Step 3: If the downloaded file is in CSV format, convert it to XLSX format.

Step 4: Query the records using excel as database. Consider only the first four columns .

Step 5: Remove “^” from Symbol column

Step 6: Remove “.” from Name column

Step 7: If the value in Change column is negative, then append " (Negative)" to the corresponding Name column value

Step 8: Save the excel as “youremail_FinYahoo_Day_Mon th_Year.xlsx”

[Palaniyappan (Forum Leader)]

Hi

Hope the below steps would help you resolve this

Step 1: Use the ‘Open Browser’ activity to open the Yahoo Finance website.

Step 2: Use the ‘Click’ activity to click on the ‘Market Data’ tab on the website.

Step 3: Use the ‘Click’ activity to click on the ‘World Indices’ option.

Step 4: Use the ‘Data Scraping’ wizard to extract the table on the webpage as an Excel file. Save the file as a CSV file.

Step 5: Use the ‘Read CSV’ activity to read the CSV file.

Step 6: Use the ‘Write Range’ activity to write the data to a new Excel file with the XLSX format.

Step 7: Use the ‘Filter Data Table’ activity to select only the first four columns of the table.
Have a view on this how to use filter datatable activity

https://docs.uipath.com/activities/other/latest/user-guide/filter-data-table

Step 8: Use the ‘For Each Row’ activity to loop through each row of the table.

Step 9: Use the ‘Replace’ method to remove the “^” character from the Symbol column and the “.” character from the Name column.
Like this
CurrentRow.ToString.Replace(“^”,””)

Step 10: Use the ‘If’ activity to check if the value in the Change column is negative. If it is, append " (Negative)" to the corresponding Name column value.
To get the column name
Yourdatatable.Columns(“yourcolumnname”).ColumnName = “your new columnname”

Step 11: Use the ‘Save Workbook’ activity to save the Excel file with the name “youremail_FinYahoo_Day_Month_Year.xlsx”.

Step 12: Use the ‘Close Application’ activity to close the Yahoo Finance website.

Cheers @prashant1603765

[prashant1603765]

@Palaniyappan Thanks for the best response. Can you please share the .nuget file of this. please creat and share.

[Palaniyappan (Forum Leader)]

Will get back to u on this @prashant1603765

[prashant1603765]

@Palaniyappan Thanks, I’m waiting for your response.