Customised Excel Sheets for Companies

You might be have some of your own investment models. Screener allows you to upload your own Excel sheets and automate much of your analysis work.

So let us open NESTLE on Screener. Click on Export to Excel.

Click "Export to Excel" on any company page

Let us add Median PE (price to earning ratio) of last 10 years to the sheet.

Select Cell A21
Put the formula as: =MEDIAN(B14:L14)
Add row for median PE

Now Save the sheet and upload it on Screener: www.screener.in/excel/

Wow! You have automated this workflow. Now whenever you will click on Export to Excel for any company, it will remember to show your Median PE.

Lets open INFOSYS to check it out.