Help
Earnings Excel Image Definition
Jul 22nd
Field Definition
Ticker: Bef-Mkt = Green Cell, Aft-Mkt = Orange Cell, Red Font = EPS Growth% >=50 or “LtoP”
AftHrV: After Hour Volume/Average Volume (%)
Last: Last Price
Chg: After Hours Change%
VaV: Volume/Average Volume
Ch1: IntraDay Change%
Volume: Volume
Open%: Open/Last Close %
Est.Turn(M): Average Turnover * 5
MktCap: Market Cap
Country: Country
ATR: Average True Range
Bloomberg Sub-Industry: Industry
Avg.Vol/Float: Average Volume/ Float
Short: Short Interest%
Cover.D: No. of Days for short interest to cover
Float: Float
Debt%: Total Debt/MktCap (%)
Est.p: Ignore this field
EPSG: EPS Growth compare to same quarter last year “LtoP” = “from Loss to Profit”, “LtoL” = “from Loss to Loss”
RevG : Revenue Growth compare to same quarter last year
Guid: Guidance; In=Inline, Up=Guidance Up, Dn=Guidance Down
EPS Beat%: EPS beat% compare to estimate “NtoP” = “Estimate is Negative, Actual EPS is Postive”, “PtoN” = “Estimate is Positive, Actual EPS is Negative”
EPS: Current Quarter EPS
EPS1: Estimate EPS
PE4: Price/ (Current Quarter EPS * 4)
EV: EV/EBITDA estimate or Trailing 12M EBITDA if no estimate
Time: ErnAft=Aft-Mkt Earnings, ErnBef=Bef-Mkt Earnings
RevBeat%: Revenue beat% compare to estimate
Rev: Current Quarter Revenue
RevEst: Current Quarter Revenue estimate
Color Code
EPSG: EPS >= 50 or EPS = “LtoP” in Red Cell, EPS>0 or EPS<50 in Yellow Cell
RevG: RevG >=50 in Red Cell, Rev>0 or Rev<50 in Yellow Cell
Guid : Guid = “Up” in Red Cell
EPSBeat%: EPSBeat% >= 50 in Red Cell, EPSBeat%>20 or EPSBeat%<50 in Yellow Cell
RevBeat%: RevBeat% >=5 in Red Cell
Earnings Aft+Bef Table Field Definition
Jun 15th
Field Definition
Type: ErnAft=Aft-Mkt Earnings, ErnBef=Bef-Mkt Earnings
Sym: Ticker
Last: Last Price
Chg: After Hours Change%
Chg1: IntraDay Change%
AftHrV: After Hour Volume/Average Volume (%)
VaV: Volume/Average Volume
EPSG: EPS Growth compare to same quarter last year “LtoP” = “from Loss to Profit”, “LtoL” = “from Loss to Loss”
RevG : Revenue Growth compare to same quarter last year
Guid: Guidance; In=Inline, Up=Guidance Up, Dn=Guidance Down
Beat%: EPS beat% compare to estimate “NtoP” = “Estimate is Negative, Actual EPS is Postive”, “PtoN” = “Estimate is Positive, Actual EPS is Negative”
EPS: Current Quarter EPS
PE4: Price/ (Current Quarter EPS * 4)
Beat%: Revenue beat% compare to estimate
Rev: Current Quarter Revenue
RevEst: Current Quarter Revenue estimate
MktCap: Market Cap
Debt%: Total Debt/MktCap (%)
EV: EV/EBITDA estimate or Trailing 12M EBITDA if no estimate
Indsutry: Industry
Country: Country
ATR: Average True Range
Avg.Vol: Average Volume
52WkH: Last Close from 52 week High%
Short: Short Interest%
Cover.D: No. of Days for short interest to cover
Float: Float
Color Code
Type: Entire Row in Grey if “ErnAft”, Entire Row in Light Blue if “ErnBef”
Chg: Chg>=4 in Green Cell, Chg<=-4 in Red Cell
AftV: AftV>=10 in Yellow Cell
VaV: Pre-Mkt Vav>=5 will be in Red,the value goes up depending on update time.
EPSG: EPS >= 50 or EPS = “LtoP” in Yellow Cell
RevG: RevG >=20 in Yellow Cell
Guid : Guid = “Up” in Yellow Cell
Beat%: EPS Beat% >=20 or EPS Beat%=”NtoP” in Yellow Cell
Beat%: Rev Beat% >=10 in Yellow Cell
MktCap: Market Cap >=1000M in Green Cell
Debt%: Debt%<0 in Yellow Cell, Debt%>=50 in Red Cell
ATR: ATR<=3 in Green Cell, ATR>=5 in Red Cell
Short and Cover.D: Short/Cover.D >=5 in Yellow Cell
