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.

New ZIP File -- Version 2017.11.30

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.2017.11.30.zip
• smfGetBarchartPortfolioView-Function.html
• smfGetYahooPortfolioView-Function.html

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

---

Changes since the 2017.11.11 ZIP archive: 

• smfGetBarchartPortfolioView() -- Added parameter to allow data for multiple occurrences of a ticker
• smfGetYahooPortfolioView() -- Added parameter to allow data for multiple occurrences of a ticker
• smfGetGoogleHistoryCSV() -- Changed URL of CSV file
• Previously announced element definition changes for Stockscores, Reuters, Yahoo, and Morningstar

---

New ZIP File -- Version 2017.11.08

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.2017.11.08.zip
• smfGetBarchartPortfolioView-Example.xls
• smfGetBarchartPortfolioView-Function.html
• smfGetYahooPortfolioView-Function.html

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

---

Changes since 2017.11.04: 

• smfGetYahooPortfolioView() -- Fix errors on percentage adjustments when value returned is non-numeric 
• smfGetYahooPortfolioView() -- Adjust GMT date/times by GMT offset
• smfGetYahooPortfolioView() -- Allow first ticker of "None" to turn off retrieval 
• smfGetBarchartPortfolioView() -- New function to get multiple stock quotes/data from Barchart with single Internet access
• smfMenuRecalculationSelection  -- Fix context menu processing of recalculating a selected range

---

The new smfGetBarchartPortfolioView() is basically just the smfGetYahooPortfolioView() function pointing at a Barchart JSON file instead of Yahoo JSON file. But the Barchart file has 246 fields available instead of Yahoo's 91 fields, including a number of technical indicator values.

The change to the smfMenuRecalculationSelection macro fixes the context menu option to calculate a selected range of the worksheet. It can do a selective version of the smfForceRecalculation macro. However, it ONLY updates that range. It will not update any part of the worksheet outside of that range, even references to items in that range that changed.