search

ClimberMel / SMF_Add-in

Stock Market Functions for Excel using VBA
https://climbermel.github.io/SMF_Add-in/
14 stars 5 forks source link

Remove Obsolete elements and modules #35

Open ClimberMel opened 1 year ago

ClimberMel commented 1 year ago

All the elements for MorningStar data have been marked as obsolete for RCHGetElementNumber. Morningstar.com became a pay site. Check and test the following: Remove all of them from the Element Definitions. Keep an archived copy to show what those element numbers were if anyone is interested. Remove module modMStarReturns No calls to Function smfGetMorningstarHistReturns (only function in modMStarReturns) so it should be safe to remove.

ClimberMel commented 1 year ago

MSN and AdvFN are also all obsolete items now. MSN is long gone and I gather AdvFN is not working due to wanting a paid subscription.

Private Function RCHSpecialExtraction Has Google and MSN references so it should be considered for removal.

LoadElementsFromInternet in modGetElementNumber references the old ogres-crypt web site, so that won't work. s1 = RCHGetURLData("http://ogres-crypt.com/SMF/Elements/smf-elements-" & pSuffix & ".txt") Determine if it is needed and either fix it or remove it.

ClimberMel commented 4 months ago

Interesting, https://www.morningstar.com/stocks/xnas/aapl/quote, does display data. Is there any value in looking into Morningstar?