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 error if empty date #16

Closed ClimberMel closed 1 year ago

ClimberMel commented 1 year ago

Issue discovered that if empty date sent, you get an error due to 0/0/0 being invalid date. If the date fields are not sent, it works with the default dates. But if the field is sent but empty, then it provides zero (0) as the int for that item. See the RCHGetYahooHistory.xlsx for an example. It sends all the fields based on cell contents. If the cell is empty, it defaults to zero not NULL. I added error checking for date so that if any zeros are received it changes them to the defaults, except the end year will be the current year. I changed the default start date to 1950-01-01 and the end date to 2030-12-31