Welcome, Guest

Beginner and formula for filter
(1 viewing) (1) Guest

TOPIC: Beginner and formula for filter

Re: Beginner and formula for filter 9 months, 3 weeks ago #2708

  • gandolfi
  • OFFLINE
  • Fresh Boarder
  • Posts: 7
  • Karma: 0
hello,

is it possible to add or verify this filter please ?

- Positive eanings revision by analyst.

- Positive earnings surprises: announced corporate earnings that are higher than analysts expected

- Increasing sales growth >5% : continued rapid growth in sales of a company's products sales growth in the current quarter at the rate of increase over the same quarter of the previous year

- Expanding operating margins >5%

- Strong cash flow, increase of 5%. company's free cash flow on a quarterly basis.
"Total Operating Cash Flow(A) - Capital Expenditures(A) >= ( Total Operating Cash Flow(A-1) - Capital Expenditures(A-1) ) * 1.05"

- Earnings growth >5%: sustained earnings growth quarter to quarter

- Positive earnings momentum: earnings that are accelerating year over year (3 years minimum)
"Diluted EPS(A) >= Diluted EPS(A-1) * 1.05" or "EPS(A) >= EPS(A-1) * 1.05

- High return on equity compare to sector: high overall corporate profitability

- Do i use "(periodtypeq = "Quarterly" AND (periodtypeq) IS NOT NULL)"

thanks
adolfin

Re: Beginner and formula for filter 9 months, 3 weeks ago #2709

  • gandolfi
  • OFFLINE
  • Fresh Boarder
  • Posts: 7
  • Karma: 0
gandolfi wrote:

- Expanding operating margins >5% --> operating income divided by net sales

adolfin

Re: Beginner and formula for filter 9 months, 3 weeks ago #2710

  • admin
  • OFFLINE
  • Administrator
  • Posts: 282
  • Karma: 17
Below are some formulas you can use (all assume quarterly reporting companies):

- Positive earnings revision by analyst.

We have the current consensus analyst recommendation, but do not have a variable for earnings revision.

- Positive earnings surprises: announced corporate earnings that are higher than analysts expected

We do no have a variable for earnings surprises.

- Increasing sales growth >5% : continued rapid growth in sales of a company's products sales growth in the current quarter at the rate of increase over the same quarter of the previous year

Total Revenue(I) > Total Revenue(I-4) * 1.05

- Expanding operating margins >5%

Operating Income(I) / Total Revenue(I) > ( Operating Income(I-4) / Total Revenue(I-4) ) * 1.05

- Strong cash flow, increase of 5%. company's free cash flow on a quarterly basis.
"Total Operating Cash Flow(A) + Capital Expenditures(A) >= ( Total Operating Cash Flow(A-1) + Capital Expenditures(A-1) ) * 1.05"

For most recent quarter compared to the same period a year ago, it would be:

Total Operating Cash Flow(I) + Capital Expenditures(I) >= ( Total Operating Cash Flow(I-4) + Capital Expenditures(I-4) ) * 1.05

- Earnings growth >5%: sustained earnings growth quarter to quarter

I'm not quite sure what you are looking for here. For two consecutive quarters of 5% earnings growth compared to the prior year quarters, you can use:

Net Income(I) >= Net Income(I-4) * 1.05

and

Net Income(I-1) >= Net Income(I-5) * 1.05

- Positive earnings momentum: earnings that are accelerating year over year (3 years minimum)
"Diluted EPS(A) >= Diluted EPS(A-1) * 1.05" or "EPS(A) >= EPS(A-1) * 1.05

This works. You can also compare A-1 to A-2 and A-2 to A-3 to look for a minimum of three years of growth.

- High return on equity compare to sector: high overall corporate profitability

We do not have sector averages built-in. You could use the Analytics functionality to manually calculate an average for your screener universe, and then plug that in to a formula.

- Do i use "(periodtypeq = "Quarterly" AND (periodtypeq) IS NOT NULL)"

That would ensure that you are only screening companies that report quarterly.
Last Edit: 9 months, 3 weeks ago by admin.
The following user(s) said Thank You: gandolfi

Re: Beginner and formula for filter 9 months, 3 weeks ago #2711

  • gandolfi
  • OFFLINE
  • Fresh Boarder
  • Posts: 7
  • Karma: 0
thanks for your answer

"Total Operating Cash Flow(I) - Capital Expenditures(I) >= ( Total Operating Cash Flow(I-4) - Capital Expenditures(I-4) ) * 1.05"

is it the same formula for "free cash flow" ?
adolfin

Re: Beginner and formula for filter 9 months, 3 weeks ago #2712

  • admin
  • OFFLINE
  • Administrator
  • Posts: 282
  • Karma: 17
Yes, free cash flow is operating cash flow less capital expenditures.

Re: Beginner and formula for filter 9 months, 3 weeks ago #2713

  • admin
  • OFFLINE
  • Administrator
  • Posts: 282
  • Karma: 17
I just realized that I made a mistake in the free cash flow formulas. Capital expenditures is coded as a negative number from the cash flow statement. As a result, you need to add it to operating cash flow (as a negative), rather than subtract it, in order to calculate free cash flow.

I edited the responses in this thread to correct the affected formulas.
The following user(s) said Thank You: gandolfi
Time to create page: 0.16 seconds