Alert -- Barchart JSON files now require an API key

Barchart has changed things so that any JSON requests require an API key. That means any add-in function that uses their JSON files will no longer work. A quick list of functions would be:

• smfGetBarchartPortfolioView()
• smfGetOptionQuotes(), when using Barchart as the data source.
• smfGetBarchartOptionQuote()

I'll be looking into this, but I'm not optimistic.

Alert -- Restored StockScouter Element Definitions

StockScouter data elements used to come from MSN before they removed the data from their web pages. So those elements had been obsoleted. A question on the Yahoo group today noted that they are now available from the FreeRealTime web site, so I restored the element definitions that I could.

New files on the web site: 

• Change-Log.html
• RCHGetElementNumber-Element-Definitions.xls
• smf-elements-1.txt

Best practice is to exit EXCEL when updating SMF add-in files.

Restored element definitions:

#	Usage	Source	Element	Template or Notes	Updated
541	S	Scouter	Quick Summary	None	2018-06-25
543	S	Scouter	StockScouter Rating -- Current	None	2018-06-25
544	S	Scouter	StockScouter Rating -- 1 Month Ago	None	2018-06-25
545	S	Scouter	StockScouter Rating -- 3 Months Ago	None	2018-06-25
546	S	Scouter	StockScouter Rating -- 6 Months Ago	None	2018-06-25
547	S	Scouter	Technical Grade	None	2018-06-25
548	S	Scouter	Valuation Grade	None	2018-06-25
549	S	Scouter	Ownership Grade	None	2018-06-25
550	S	Scouter	Fundamental Grade	None	2018-06-25
551	S	Scouter	Return Grade	None	2018-06-25
552	S	Scouter	Risk Grade	None	2018-06-25

 

Alert -- Updates to Zacks Element Definitions

Zacks recently made some changes to their quote web page, so some defined elements on smf-elements-6.txt needed to be updated.

New files on the web site: 

• Change-Log.html
• RCHGetElementNumber-Element-Definitions.xls
• smf-elements-6.txt

Best practice is to exit EXCEL when updating SMF add-in files.

Updated element definitions:

#	Usage	Source	Element	Template or Notes	Updated
844	S	Zacks	Stock Style, Value	SMF-Template-Zacks-Data.xls	2018-06-07
845	S	Zacks	Stock Style, Growth	SMF-Template-Zacks-Data.xls	2018-06-07
846	S	Zacks	Stock Style, Momentum	SMF-Template-Zacks-Data.xls	2018-06-07
847	S	Zacks	Stock Style, VGM	SMF-Template-Zacks-Data.xls	2018-06-07
848	S	Zacks	Zacks Rank	SMF-Template-Zacks-Data.xls	2018-06-07
850	S	Zacks	Industry Group	SMF-Template-Zacks-Data.xls	2018-06-07
13873	S	Zacks	Zacks Recommendation	SMF-Template-Zacks-Data.xls	2018-06-07

 

Alert -- Updates to Yahoo Analyst Element Definitions

Yahoo recently changed the layout of their analyst estimates web page, so some defined elements on smf-elements-2.txt needed to be updated, obsoleted, and added.

New files on the web site: 

• Change-Log.html
• RCHGetElementNumber-Element-Definitions.xls
• smf-elements-2.txt
• SMF-Template-Yahoo-Analyst-Estimates.xls

Best practice is to exit EXCEL when updating SMF add-in files.

New ZIP File -- Version 2018.01.24

I just uploaded a new version of the ZIP archive.

---

New files on the web site: 

• Change-Log.html
• RCH_Stock_Market_Functions-2.1.2018.01.24.zip
• smfGetAdvFNElement-Template-All-Line-Items.xls

Best practice is to exit EXCEL when updating SMF add-in files.

---

Changes since the 2017.11.30 ZIP archive: 

• smfGetAdvFNElement() -- Updated URLs to "https://" from "http://"
• smfGetOptionExpirations() -- Added ability to limit by type (weekly, monthly, ...)
• Previously announced element definition changes for ETFScreen

---