Closed ClimberMel closed 1 year ago
ClimberMel
commented
1 year ago From Ian: A direct way to get the Zacks forward PE is to get it from that page: RCHGetTableCell("https://www.zacks.com/stock/quote/AAPL/detailed-earning-estimates",1,"P/E (F1)",1)
Ian
ClimberMel
commented
1 year ago So since it works the way Ian posted, it should be a fixable in RCHGetElement
kitiany
commented
1 year ago Tested editing smf-elements-6.txt line to: 13892;Zacks;Forward P/E;=RCHGetTableCell("https://www.zacks.com/stock/quote/~~~~~/detailed-earning-estimates",1,">P/E (F1)") Restarted Excel and it works.
ClimberMel
commented
1 year ago Although the suggested change above did work, I decided make a fix that allowed getting the data from the quote page as it did originally instead of the detailed-earning-estimates page. Updated smf-elements-6.txt.
kitiany
commented
1 year ago Mel, I see an error in your update. 13892;Zacks;Forward P/E;=smfGetTagContent("https://www.zacks.com/stock/quote/AAPL","dd",1,">Forward PE")
IanWhat is the error?
kitiany
commented
1 year ago It is hard coded to AAPL and not 5 squiggly marks used as the variable.
On Fri, May 26, 2023, 7:54 PM ClimberMel @.***> wrote:
What is the error?
— Reply to this email directly, view it on GitHub https://github.com/ClimberMel/SMF_Add-in/issues/31#issuecomment-1565120959, or unsubscribe https://github.com/notifications/unsubscribe-auth/A7XIS4TUBJEPDGKUDMLTWVDXIFGDRANCNFSM6AAAAAAX4BES3I . You are receiving this because you commented.Message ID: @.***>
ClimberMel
commented
1 year ago Oh silly me, I do that during testing... I'll send a new one out, Thanks!
Element# 13892 should be Forward P/E from Zacks (smf-elements-6.txt)
Here is where the Forward P/E comes from: https://www.zacks.com/stock/quote/AAPL?q=AAPL Here is the page section and if you search for Forward PE, then the following
tag contains the amount (28.76)Key Earnings Data
Zacks Earnings ESP (Expected Surprise Prediction) looks to find companies that have recently seen positive earnings estimate revision activity. The idea is that more recent information is, generally speaking, more accurate and can be a better predictor of the future, which can give investors an advantage in earnings season.
The technique has proven to be very useful for finding positive surprises. In fact, when combining a Zacks Rank #3 or better and a positive Earnings ESP, stocks produced a positive surprise 70% of the time, while they also saw 28.3% annual returns on average, according to our 10 year backtest.
Visit the Earnings ESP Center
See the Full List of Stocks To Beat Earnings
This is an estimated date of earnings release. Neither Zacks Investment Research, Inc. nor its Information Providers can guarantee the accuracy, completeness, timeliness, or correct sequencing of any of the Information on the Web site, including, but not limited to Information originated by Zacks Investment Research, Inc, licensed by Zacks Investment Research, Inc. from Information Providers, or gathered by Zacks Investment Research, Inc. from publicly available sources. There may be delays, omissions, or inaccuracies in the Information.
12.50%