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

RCHGetYahooHistory missing funtionality #13

Closed ClimberMel closed 1 year ago

ClimberMel commented 1 year ago

Rodrigo Fernandez Ridano unread, Feb 5, 2023, 9:34:04 AM (5 days ago) to SMF Add-In Hi Mel,

I appreciate all the work that it's being done to get the Add-in back. I am trying the new version and I think we may have lost some fonctionalities, so I would like to check with you. I used to see historical stock prices like this below. The formula in each column would get the stock name from the fist row, and only the first and second columns would be different by getting the dates plus the adjusted closing values. image However, now it looks like this below. Using the same code, it always includes the date and adds an unecessary new row at the top "Date". image This is the formula for the first two columns: =RCHGetYahooHistory(B1,2002,1,1,YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()),"m","DA",0,1,0) this is the formula for the other columns: =RCHGetYahooHistory(C1,2002,1,1,YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()),"m","A",0,1,0)

Hopefuly we can get this great tool back! Rodrigo

ClimberMel commented 1 year ago

I believe this should be resolved with the recent fix of smfGetYahooHistory but I will check with Rodrigo before closing this.

ClimberMel commented 1 year ago

Tested and closed