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

Question about new format for RCHGetYahooHistory #24

Closed ClimberMel closed 1 year ago

ClimberMel commented 1 year ago

From: Mike G [griff...@gmail.com](mailto:griff...@gmail.com) Date: 2023-03-16 12:05 p.m. (GMT-08:00) To: SMF Add-In [SMF-...@googlegroups.com](mailto:SMF-...@googlegroups.com) Subject: [SMF Add-In] Question about new format for RCHGetYahooHistory

Firstly, THANK YOU SO MUCH to those that have kept the SMF Add-in going since Randy's passing. I haven't been able to make the Add-in work since last year, but have finally found and fixed the bug that had me stymied.

So, my question: I have used the Add-in mainly to download price history for index constituents, so my spreadsheets were simplified to allow easy updating of the index lists and then download the data. Previously =RCHGetYahooHistory(A2) would return DOHLUVC, but now is leaving out Close and Volume. Is this intentional or do I have a glitch? I only ask because I trying to avoid updating a huge number of formulas!

Before:

image

Now: image

ClimberMel commented 1 year ago

Ok, after copious amounts of coffee, I have looked at this and yes the default is only returning DOHLC. No V (Volume) or U (Unadjusted close). I checked the Function RCHGetYahooHistory in module modGetYahooHistory and the default was changed. I will change it back to the previous values: Optional pItems As String = "DOHLCVU", _ This shouldn't affect anyone supplying the Items list, but any older spreadsheets using just the defaults should now work as they used to.