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”
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
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.
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.
@Palaniyappan Thanks for the best response. Can you please share the .nuget file of this. please creat and share.
Will get back to u on this @prashant1603765
@Palaniyappan Thanks, I’m waiting for your response.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.