StuLux
Well-known Member
- Joined
- Sep 14, 2005
- Messages
- 679
- Office Version
- 365
- Platform
- Windows
I'm using the STOCKHISTORY function to gather monthly/daily stock prices but can't always seem to get a date range going back as far as I would like.
As an example,
with a start date of 01/01/1980 in cell A6 and "=TODAY()" in cell B6 will give me monthly stock prices for Lloyds Banking Group going back to September 1987 but when I try to get the same range for daily prices using
it only goes back as far as April 2020.
What I do notice is that there are 411 values returned for both so am I to presume that there is a limit of 411 returned values regardless of date range. If so I wonder why 411, it seems a random starange number?
EDIT - Strangely if I do the same with another stock - say Barclays Bank, I can get 462 values so there seems to be soem dependency on the individual stock - weird?
As an example,
Excel Formula:
=SORT(STOCKHISTORY("XLON:LLOY",A6,B6,2),1,-1)
Excel Formula:
=SORT(STOCKHISTORY("XLON:LLOY",A6,B6,0),1,-1)
What I do notice is that there are 411 values returned for both so am I to presume that there is a limit of 411 returned values regardless of date range. If so I wonder why 411, it seems a random starange number?
EDIT - Strangely if I do the same with another stock - say Barclays Bank, I can get 462 values so there seems to be soem dependency on the individual stock - weird?
Last edited: