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.

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)

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.