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