I've updated the following files to the "Works in Progress" folder:
- @Change-log.html -- Shows a log of changes to the add-in since the last official release
- RCHGetElementNumber-Element-Definitions.xls -- The current documentation of element definitions, including the many recent changes. I've added a "Usage" column to indicate if an element is for Stocks ("S"), ETFs ("E"), and/or Mutual Funds ("F").
- smf-elements-8.txt -- Contains the updates of the earnings.com earnings announcement element definitions, #1286 thru #1400, with element definitions from Zacks. I replaced the old "Prev Year Actual" elements from earnings.com with the new "Reported Time" from Zacks. Otherwise, the elements mapped one-to-one. You could even open up the old earnings.com template to see the data for the new element definitions.
- SMF-Template-Zacks-Earnings-Annoucements.xls -- A new template, to display elements #1286 thru #1400 in context.
To install the updates to the element definitions, replace the smf-elements-8.txt in your SMF add-in folder with this new file. Then, you'll either need to exit and restart EXCEL, or run the smfForceRecalculation macro, in order for the add-in to load the new definitions.
One thing that does concern me about the Zacks earnings announcement table is that the older quarters have an "Estimated EPS", but not a "Reported EPS". That seem a little strange to me.
These are not trivial extractions, since the data was extracted from JavaScript code. For example, the extraction formula for element #1287 looks something like:
=smfConvertData(smfstrExtr(smfstrExtr(smfWord(smfWord(","&smfstrExtr(smfGetTagContent("http://www.zacks.com/stock/research/IBM/earnings-announcements","script",-1,"Period Ending"),"""data"" : [ ","]"),1,"}"),4,","),": ","~"),"""",""""))
But once I got the pattern down, it went fairly quickly. :)
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar