I want to download historical stock prices from 1 Jan 1990 until 30 Jun 2022 for a certain number of companies. I use the TR function and especially "=@TR(B1;"TR.Closeprice";"Sdate=1990-12-31 EDate=2021-12-31 Frq=D CH=Fd";B3)", where on B1, I place the stock RIC and on B3, the data are placed. Although the data are retrieved, the starting date (and the first observation) changes according to the data availability or the initiation of the stock public trading. How I can create fixed columns where in case of data unavailability in the first days or any other period a "null" to be appeared? So every column (stock) includes the same number of observations. I have a large number of stocks and to adjust every column by hand is an overkill.
Thank you in advance.