Tuesday, July 17, 2018

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.

Monday, June 25, 2018

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: 

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

Restored element definitions:

# UsageSourceElementTemplate or NotesUpdated
541SScouterQuick SummaryNone2018-06-25
543SScouterStockScouter Rating -- CurrentNone2018-06-25
544SScouterStockScouter Rating -- 1 Month AgoNone2018-06-25
545SScouterStockScouter Rating -- 3 Months AgoNone2018-06-25
546SScouterStockScouter Rating -- 6 Months AgoNone2018-06-25
547SScouterTechnical GradeNone2018-06-25
548SScouterValuation GradeNone2018-06-25
549SScouterOwnership GradeNone2018-06-25
550SScouterFundamental GradeNone2018-06-25
551SScouterReturn GradeNone2018-06-25
552SScouterRisk GradeNone2018-06-25
 

Thursday, June 7, 2018

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: 

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

Updated element definitions:

# UsageSourceElementTemplate or NotesUpdated
844SZacksStock Style, ValueSMF-Template-Zacks-Data.xls2018-06-07
845SZacksStock Style, GrowthSMF-Template-Zacks-Data.xls2018-06-07
846SZacksStock Style, MomentumSMF-Template-Zacks-Data.xls2018-06-07
847SZacksStock Style, VGMSMF-Template-Zacks-Data.xls2018-06-07
848SZacksZacks RankSMF-Template-Zacks-Data.xls2018-06-07
850SZacksIndustry GroupSMF-Template-Zacks-Data.xls2018-06-07
13873SZacksZacks RecommendationSMF-Template-Zacks-Data.xls2018-06-07
 

Wednesday, April 18, 2018

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: 

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

Wednesday, January 24, 2018

New ZIP File -- Version 2018.01.24

I just uploaded a new version of the ZIP archive.

New files on the web site: 
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