Friday, February 10, 2023

Tip! Sort order for returned data

For RCHGetYahooHistory()

The parameters are as follows:

=RCHGetYahooHistory( Ticker, [Start Year], [Start Month], [Start Day], [End Year], [End Month], [End Day], [Period], [Data Items], [Header Line], [Adjust], [Resort] )

If you have this on your spreadsheet

You could use this array entered formula to get that values from the table

=RCHGetYahooHistory(C2,C3,C4,C5,C6,C7,C8,C9,C10,C11,C12,C13)

If the start and end dates are left black, the program uses default values and those may not be what you want.  Currently the Start Date is 1970-1-1, but there is data for some companies older than that.  I believe 1962 is the earliest data Yahoo has.  2020-12-31 is the end date for the last version of the Add-In, but that will be updated in the next release to 2024.



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...