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