ClimberMel / SMF_Add-in

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

smfGetYahooHistory - Data getting truncated #17

Closed ClimberMel closed 1 year ago

ClimberMel commented 1 year ago

The data returned from Yahoo is now from oldest to newest. This didn't seem to be an issue with the ability to set the resort flag. It turned out that if you requested 2 years of historical data (example: 2021-02-01 to 2023-02-01), and then only array entered the formula over say 100 rows... The data returned would be from 2021-02-01 to 2021-09-09 (100 rows of data) If I selected resort, it would resort that data... so I would not get the most recent 100 rows!