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

SMFPricesByDates is not working #1

Closed ClimberMel closed 1 year ago

ClimberMel commented 1 year ago

From Jer01: I have 2 files where I use smfPricesByDates. Neither of them are updating now. In addition, it takes much longer than it normally does to try to update. I will explain what I do in one of these files. I want to calculate the Weekly change and % change for multiple TIKRS. So I dl the Friday close for these TIKRS using the latest Friday date and the previous Friday date. And i use excel to calc the change and % change.

In cell O7 I enter the latest Friday date. In cell N7 I calculate the previous Friday date : =O7-7 I start a list of TIKRS in cell M10 .... down to M121 I use the SMF formula in cols N and O to dl the close for the TIKRS in col M and the dates in cells O7 and M7. Here is the formula in cols N & O, Row 10: ={smfPricesByDates($M10,$N$7:$O$7)} The 10 in $M10 changes to the current row number as you scroll down. Al I get in cols N & O is : #N/A

My second file uses the same formula to calc Friday closes for multiple TIKS over a wide range of weeikly closes. It too is having the same problem..If we can solve the problem described here, I expect that solution will solve the problem in my second file. So I won't try to describe the setup in my 2nd file.

Honminhui commented 1 year ago

RCHGetYahooHistory also does not seem to be working. One of my other add-ins stated that there was a major change to Yahoo as of Dec 20, 2022. Thank you again Mel for hosting this!

ClimberMel commented 1 year ago

Both this issue and the RCHGetYahooHistory error in the called module smfGetYahooHistory. See note in the other issue for details.

ClimberMel commented 1 year ago

This is fixed in the smfGetYahooHistory and RCHGetYahooHistory changes.