ValuePickr Forum The destination for Intelligent Screening & Reporting in India

(Matt1985) #619

Hi there - can we have ebit / ev ratio? Thanks


(Changu Mangu) #620

Dear @Matt1985, That is already existing in screener.

Please search for: Enterprise Value to EBIT
And it’s complementary ratio: Earnings yield

(Parthgarg) #621

Hi, can you please post some examples as well.

(Parthgarg) #622

Hi, If you want then you can check your ratios or create new ratios by following these steps:

First click on the tab “View Your Profile” given on top right.
Then click on “Your ratios” tab given on top center.
and there you are, now you can edit or make new custom ratios.

I hope this helps.

(Changu Mangu) #623

Dear @Parthgarg

Is this what you mean? Hope so :slight_smile:

(Parthgarg) #624

Yes, screener does provide that Ratio already but if one wants then he can always create his own ratio as well.

(Saurabh G) #625

10 Year Financial Ratios are also provided on stockadda quotes page. e.g. : Avanti Feeds - Stock Page
But screener is more customisable and has an unparalleled screening parameters.

1 Like
(yourraj) #626

Hi there
How one can download expanded form of data of any company

Cash from Operating Activity
Profit from operations
Working Capital Changes
Taxes paid

Cash from Investing Activity
Fixed Assets Purchased
Fixed Assets Sold
Capital WIP
Investments purchased
Investments sold

(VijayShetty) #627

The Balance sheet data in the page for any company doesn’t fit into the standard data shown in balance sheets.

Shouldn’t there be a row for Current Assets, Current Liabilities, Long Term Debt etc?

(VijayShetty) #628

One suggestion for’s export to excel feature.

The export feature exports either Consolidated or Standalone depending on what option you have currently active on the page. This is great - it allows us to get both kinds of data in the export. However, it would be very useful if the resulting exported excel sheet has it mentioned somewhere where it’s Consolidated or Standalone - that would be very helpful.

1 Like
(Satya Prakash) #629

When Mcap divided by Book value is Price to Book value then why in this case it is not matching.
I am talking about Oceanaa Biotek.

Mcap = 28.35
Book Value = 33.36

p/B = 0.63.

But Mcap/Book value is 0.84.

(Akbar Khan) #630

Book Value is book value per share, hence you can take
P/B=Current Price / Book Value

(Satya Prakash) #631

Ah! Got it.

Book value is given as Book value per share.


(rajanprabu) #632

@Parthgarg Thanks for the good work. Any idea when do we get the Accounts Payables to the exported excel sheet ?

(Satya Prakash) #633

How to calculate BOOK VALUE even roughly on


What do you mean calculate? Do you want to calculate on your own and not consider the readily available value in Screener? Although the available value is not accurate and could be different from other sites. For example, for Bajaj Finance Screener gives 338.49, and Moneycontrol gives 355.40, Morningstar gives P/B as 10.96 which comes to 301.18, as Book Value.

(Satya Prakash) #635

I don’t want book value on dashboard. I thought, by looking at balance sheet area, I can get some rough idea.
If I include BV on dashboard then I get one year value. And not the idea that BV increasing or not.

(ashish) #636

In the balance sheet section just add share capital and reserves, u get the book value of a company. To get book value per share divide by outstanding number of shares.