Go to https://www.screener.in/
Search company names
1.Bajaj Auto Ltd
2.NTPC Ltd
3.NTT DATA
4.Gail Ltd
5.Nu Tech Organic Chemicals Ltd
6.Vodafone Idea Ltd
7.Zee TV
Extract market Cap and current price for each company
Write the extracted value to excel.
Excel should contains 3 columns. Comapany name, market Cap and current pricestrong text
1.Bajaj Auto Ltd
2.NTPC Ltd
3.NTT DATA
4.Gail Ltd
5.Nu Tech Organic Chemicals Ltd
6.Vodafone Idea Ltd
7.Zee TV
From where you are getting this data either from excel or from what can you explain me
Hi @Anjana_R
=> initialize two variable of datatype int in below way:
int_MarketCap=1
int_CurrentPrice=1
=> Store the company name in excel and read the data using Read Range Workbook and store the output in a data table say dt_input.
=> Use Use Application/Browser activity and indicate the screen.
=> Use For Each Row in Data Table to iterate through each row in the excel.
=> Under that use Type Into and give CurrentRow("Company Name").Tostring.
=> Use Keyboard shortcuts and give enter.
=> Use Get Text activity to get the value of Market Cap and current price.
=> Use Write Cell workbook to enter back the extracted prices to the excel.
Check the below zip file for better understanding.
Forum.zip (82.5 KB)
Hope it helps!!
i got these questions from excel sheet sir
Check out the zip file @Anjana_R . It will meet the requirements.
Regards
I did my workflow as per your requirement ,go through this it will help you
thank you ma,am , i will do like this and will update u soon
oke sir, I will go through these,
ManipulationsForum.zip (873.4 KB)
I update the xaml while running it encounters NTT DATA it shows some login page for this to me
There is no NTT Data and Gail Ltd in your company list it will open an login page in my execution
Hi @Anjana_R
For NTT there is no data so it will open an login page. For that use Check App state activity indicate that page. In Targert appears section if that page appears Navigate Browser to go back to that page. Otherwise in Target does not appears section place the Type Into, Get Text and Write Cell Workbook activity.
Hope you understand!!
i haven’t got a clear idea. but i will try
I will share you the workflow file in a short while @Anjana_R
Regards,
oke ma,am ,actually that question also have a sub question in which they are saying like " if error occours use logic for retry instead of retry scope activity
okay sir, 
.
webextraction.zip (17.2 KB)
ma,am I am getting the xls file as like in the zip file while running the project. how can i correct it?
Ma’am,can u help me with the workflow