STOCKHISTORY - issue with range of dates available

[StuLux]

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,

=SORT(STOCKHISTORY("XLON:LLOY",A6,B6,2),1,-1)

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

=SORT(STOCKHISTORY("XLON:LLOY",A6,B6,0),1,-1)

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?

 

[DRSteele]

I put the daily formula STOCKHISTORY("XLON:LLOY",A6,B6,0) into Excel and it reported 8674 dates starting at 4/2/1987.

The monthly formula STOCKHISTORY("XLON:LLOY",A6,B6,2) reported 416 dates beginning 4/1/1987.

 

[StuLux]

I put the daily formula STOCKHISTORY("XLON:LLOY",A6,B6,0) into Excel and it reported 8674 dates starting at 4/2/1987.

The monthly formula STOCKHISTORY("XLON:LLOY",A6,B6,2) reported 416 dates beginning 4/1/1987.

Thank you, I tried re-entering the formulae on a new sheet and the problem cleared itself, put it down to one of those many Excel oddities.