Please help me with this task(1)

Help Studio
, ,
1

Hi,

I want to scrap the data from https://www.screener.in/ website. i need to get 5 companies data include peer comparsion data, balance sheet and profit and loss statements.

and i also need this data from website.

  • Market Cap
    *** Current Price**
    *** High / Low**
    *** Stock P/E**
    *** Book Value**
    *** Dividend Yield**
    *** ROCE**
    *** ROE**
    *** Face Value**

write all data in excel sheets.

Please go through it Input company names attached below
CompanyData.xlsx (9.0 KB)

Thanks & Regards
R.Sai Srinivas

2

Hi @Sai.Srinivas

Please have a look at below workflow
IndiaStockExchangeInformation.zip (179.3 KB)

1 Like
3

Hi @sangeethaneelavannan1

Thanks for your reply. I also need balance sheet, peer comparsion, profit and loss sheets for each company with proper headings.
OutputCompanyData.xlsx (19.4 KB)

Looking for reply

Best Regards
R.Sai Srinivas

4

@Sai.Srinivas We could not add it in same excel sheet but we could add it in different sheet like peer compatison,balance sheet

5

Can you get me the code for me.

please look into below code but i need proper naming for each element.

Main.xaml (33.0 KB)

Best Regards
R.Sai Srinivas

6

We can add different sheet in same file… When you use write range for writing extracted data just create sheet name as you want…

7

help me with code

please look into output format
OutputCompanyData.xlsx (20.0 KB)
Is there any possible where we can do formatting using macros