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”
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.