search

ClimberMel / SMF_Add-in

Stock Market Functions for Excel using VBA
https://climbermel.github.io/SMF_Add-in/
14 stars 5 forks source link

More Elements not returning correct data #33

Closed ClimberMel closed 1 year ago

ClimberMel commented 1 year ago

See Sheet for details, there are too many to list all details here... 13869 - Market Capitalization - returns: Computer and Technology» Computer - Mini computers 13871 - Current Year Estimate - same 13872 - EPS Last Year - same 13891 - Beta - same 13892 - Forward P/E - same 13873 - Zacks Recommendation - returns: Error 13893 Error 13894 Error

ClimberMel commented 1 year ago

Currently working on these Zacks elements: 844, 845, 846, 847, 852, 13869, 13871, 13872, 13873, 13891, 13893, 13894

ClimberMel commented 1 year ago

Fixed 852 that was marked obsolete 852;Zacks;Rank Within Industry;=smfGetTagContent("https://www.zacks.com/stock/quote/~~~~~","a",-1,"rank_view","rank_view","rank_view","stocks/industry-rank")

ClimberMel commented 1 year ago

Element 13873: I can find no trace of Zacks Recommendation. There is the Zacks Ranks and Zacks provides the average brokerage recommendation (ABR) for thousands of stocks for most of the leading investment web sties. The ABR is the calculated average of the actual recommendations (strong buy, hold, sell etc) made by the brokerage firms for a given stock. But there are elements for the ABR. Elements 13885 - 13889.

Element 13890 Average Broker Recommendation -- Rank Within Industry was marked obsolete 2013. To me it appears to be the same as 852.

13873 will be updated as Obsolete

ClimberMel commented 1 year ago

Elements 844 - 847 Style Scores should be able to be fixed together. Find rank_view (2x) then composite_val These 4 have now been fixed 844;Zacks;Style Scores, Value;=smfGetTagContent("https://www.zacks.com/stock/quote/~~~~~","span",-1,"rank_view","rank_view","composite_val") 845;Zacks;Style Scores, Growth;=smfGetTagContent("https://www.zacks.com/stock/quote/~~~~~","span",2,"rank_view","rank_view","composite_val") 846;Zacks;Style Scores, Momentum;=smfGetTagContent("https://www.zacks.com/stock/quote/~~~~~","span",4,"rank_view","rank_view","composite_val") 847;Zacks;Style Scores, VGM;=smfGetTagContent("https://www.zacks.com/stock/quote/~~~~~","span",6,"rank_view","rank_view","composite_val")

ClimberMel commented 1 year ago

Fix 13869;Zacks;Market Capitalization;=smfGetTagContent("https://www.zacks.com/stock/quote/~~~~~","span",1,">Market Cap") 13871;Zacks;Current Year Estimate;=smfGetTagContent("https://www.zacks.com/stock/quote/~~~~~","dd",1,">Current Yr Est") 13872;Zacks;EPS Last Year;=smfGetTagContent("https://www.zacks.com/stock/quote/~~~~~","dd",1,">Prior Year EPS<")

ClimberMel commented 1 year ago

Fixed 13891 - Beta 13891;Zacks;Beta;=smfGetTagContent("https://www.zacks.com/stock/quote/~~~~~","span",1,">Beta")

ClimberMel commented 1 year ago

Fixed 13893 Next Earnings Report Date 13893;Zacks;Next Earnings Date;=smfstrExtr(smfGetTagContent("https://www.zacks.com/stock/quote/~~~~~","dd",-1,"spl_sup_text"),"","~")

ClimberMel commented 1 year ago

Here are the fixes added to smf-elements-20.txt for now:

844;Zacks;Style Scores, Value;=smfGetTagContent("https://www.zacks.com/stock/quote/~~~~~","span",-1,"rank_view","rank_view","composite_val") 845;Zacks;Style Scores, Growth;=smfGetTagContent("https://www.zacks.com/stock/quote/~~~~~","span",2,"rank_view","rank_view","composite_val") 846;Zacks;Style Scores, Momentum;=smfGetTagContent("https://www.zacks.com/stock/quote/~~~~~","span",4,"rank_view","rank_view","composite_val") 847;Zacks;Style Scores, VGM;=smfGetTagContent("https://www.zacks.com/stock/quote/~~~~~","span",6,"rank_view","rank_view","composite_val") 848;Zacks;Zacks Rank;=smfGetTagContent("https://www.zacks.com/stock/quote/~~~~~","p",-1,"rank_view",,,,,,,,"<span") 852;Zacks;Rank Within Industry;=smfGetTagContent("https://www.zacks.com/stock/quote/~~~~~","a",-1,"rank_view","rank_view","rank_view","stocks/industry-rank") 13869;Zacks;Market Capitalization;=smfGetTagContent("https://www.zacks.com/stock/quote/~~~~~","span",1,">Market Cap") 13871;Zacks;Current Year Estimate;=smfGetTagContent("https://www.zacks.com/stock/quote/~~~~~","dd",1,">Current Yr Est") 13872;Zacks;EPS Last Year;=smfGetTagContent("https://www.zacks.com/stock/quote/~~~~~","dd",1,">Prior Year EPS<") 13873;Zacks;Zacks Recommendation;="Obsolete -- No data found" 13891;Zacks;Beta;=smfGetTagContent("https://www.zacks.com/stock/quote/~~~~~","span",1,">Beta") 13893;Zacks;Next Earnings Date;=smfstrExtr(smfGetTagContent("https://www.zacks.com/stock/quote/~~~~~","dd",-1,"spl_sup_text"),"","~") 13894;Zacks;Earnings Expected Surprise Prediction current;=smfGetTagContent("https://www.zacks.com/stock/quote/~~~~~/detailed-estimates","span",1,">Earnings ESP Stocks") 13897;Zacks;Earnings Expected Surprise Prediction prev Qtr;=smfGetTagContent("https://www.zacks.com/stock/quote/~~~~~/detailed-estimates","span",2,">Earnings ESP Stocks") 13898;Zacks;Earnings Expected Surprise Prediction 2Q prev;=smfGetTagContent("https://www.zacks.com/stock/quote/~~~~~/detailed-estimates","span",3,">Earnings ESP Stocks") 13899;Zacks;Earnings Expected Surprise Prediction3Q prev;=smfGetTagContent("https://www.zacks.com/stock/quote/~~~~~/detailed-estimates","span",4,">Earnings ESP Stocks")

ClimberMel commented 1 year ago

Fixed these Barchart elements in smf-elements-9.txt 1141 - 1144, 1195 - 1214