Wednesday, February 15, 2023

New update soon to arrive!

I have a new version just about ready to release.  It was delayed today as during testing I found an interesting quirk with the sort order of the data.
Since the data is now being retrieved from Yahoo oldest to newest, the original resort function has a problem.
For example if you request years worth of data, but only provide say 100 rows in your array entered formula... it was giving us the 100 rows of data from the start date, so even resorting it only resorted the 100 rows.
So I have added a function to sort the data into newest to oldest and then process it to return.  So now if you select resort, it will resort the newest data that fits in your array.
 
Hope that made sense...
 
So the good news here are some of the fixes in the new version:
 
Issue# 11: The order should now be like it was
 
Issue# 10: I have fixed other issues like Paul's item he reported about doing math such as average on the returned data.  (It was being returned as a string)
 
Issue# 16: Fixed error if blank date sent to RCHGetYahooHistory.  Excel was defaulting it to 0 not NULL.
I plan to have the add-in put together and posted tomorrow.

Thanks,
Mel Pryor

No comments:

Post a Comment

SMF new Add-In version 3.0.2024.04.29

  This new release has fixes for: module smfGetOptionQuotes A member (Bruce) found the issue was with the crumb processing and provided cod...