New ZIP file -- Version 3.0.2023.02.15

 This update has fixes to a number of issues.

From GitHub

 

Release RCH_Stock_Market_Functions-3.0.2023.02.15

Change Log

Module    |    Function

modGetElementNumber    Function RCHGetElementNumber

Update version number (kVersion) and update comments for changes.

RCH_Stock_Market_Functions-3.0.2023.02.15

smfGetYahooHistory_    smfGetYahooHistory_

Issue#10 Fix data being returned as string instead of decimal

Issue#11 Data order

Issue#17 Data getting truncated

Changed default start date from 1970 to 1950 if no date provided

modGetYahooHistory    Function RCHGetYahooHistory

Issue #16 If empty date elements sent, you get an error due to 0/0/0 being invalid date.

Fix data order to return as it did in the past to avoid confusion.

Milestone fix is:

RCH_Stock_Market_Functions-3.0.2023.02.15

New update soon to arrive!

I have a new version just about ready to release.  It was delayed today as during testing I found an interesting quirk with the sort order of the data.

Since the data is now being retrieved from Yahoo oldest to newest, the original resort function has a problem.

For example if you request years worth of data, but only provide say 100 rows in your array entered formula... it was giving us the 100 rows of data from the start date, so even resorting it only resorted the 100 rows.

So I have added a function to sort the data into newest to oldest and then process it to return.  So now if you select resort, it will resort the newest data that fits in your array.

 

Hope that made sense...

 

So the good news here are some of the fixes in the new version:

 

Issue# 11: The order should now be like it was

 

Issue# 10: I have fixed other issues like Paul's item he reported about doing math such as average on the returned data.  (It was being returned as a string)

 

Issue# 16: Fixed error if blank date sent to RCHGetYahooHistory.  Excel was defaulting it to 0 not NULL.

I plan to have the add-in put together and posted tomorrow.

Thanks,

Mel Pryor

Tip! For Excel 365 you need to change trust settings

For the SMF Add-In to work in newer versions of Excel such as Office 365 you will need to change the default Trust Settings to allow macros to run.

Change macro settings in the Trust Center

Macro settings are located in the Trust Center. However, if your device is managed by your work or school the system administrator might prevent anyone from changing settings.

Important: When you change your macro settings in the Trust Center, they are changed only for the Microsoft 365 program that you are currently using. The macro settings are not changed for all your Microsoft 365 programs.

1. Click the File tab.

2. Click Options.

3. Click Trust Center, and then click Trust Center Settings.

4. In the Trust Center, click Macro Settings.
   
    

   Make the selections that you want (Enable all macros), then click OK.

   Here is the full article:

   https://support.microsoft.com/en-us/office/enable-or-disable-macros-in-microsoft-365-files-12b036fd-d140-4e74-b45e-16fed1a7e5c6

    
   

Note! Samples and Templates are being updated

 I have created an updated version of spreadsheet for the RCHGetElementNumber() function elements.

It is RCHGetElementNumber-Element-Definitions.xlsx 

I will add it to the website.

I have also created new versions of the Template files as samples of which parts are working.

For now they are on my GitHub site and can be downloaded from: https://github.com/ClimberMel/SMF_Add-in/tree/main/samples

I will try to get the Templates page updated with link to the files there.

Tip! Sort order for returned data

For RCHGetYahooHistory()

The parameters are as follows:

=RCHGetYahooHistory( Ticker, [Start Year], [Start Month], [Start Day], [End Year], [End Month], [End Day], [Period], [Data Items], [Header Line], [Adjust], [Resort] )

If you have this on your spreadsheet

You could use this array entered formula to get that values from the table

=RCHGetYahooHistory(C2,C3,C4,C5,C6,C7,C8,C9,C10,C11,C12,C13)

If the start and end dates are left black, the program uses default values and those may not be what you want.  Currently the Start Date is 1970-1-1, but there is data for some companies older than that.  I believe 1962 is the earliest data Yahoo has.  2020-12-31 is the end date for the last version of the Add-In, but that will be updated in the next release to 2024.

Alert! Yahoo Finance change has caused multiple issues to multiple platforms.

 On Dec. 16, 2022 yahoo finance made changes to its web pages.  This has caused a number of issues to the SMF Add-in, but it has also caused errors with yFinance python module.

The web site for the SMF Add-In

    https://climbermel.github.io/SMF_Add-in/

The GitHub for code changes for SMF Add-In

    https://github.com/ClimberMel/SMF_Add-in

The GitHub for yFinance

    https://github.com/ranaroussi/yfinance     

 The PyPi install for yFinance

    https://pypi.org/project/yfinance/

Alert -- Updates to Zacks Element Definitions

 

Zacks recently changed the web page name where the earnings estimates were located, so elements on smf-elements-8.txt needed to be updated.

New files on the website: 

• smf-elements-8.txt

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