I'm trying to get price data in excel for a stock without much history. If there are 30 years of data I would like to see 30 years of price close. If there are 30 days of data I would like to see only 30 days. The method I use below would include 29 years of null for a stock that had 1 year of data. How would I simply ask for "all" available data for a time series?
=TR("UBER.K","TR.PriceClose","SDate=0 EDate=-7499 CH=Fd RH=IN",AS2)