Trying to get data for a LIBOR ticker that stopped in 2021 by providing just the start date and end date defaulting to today - doesn't return anything. But if I give a proper end date (where data was available)- it does return values. Normal BDH function in excel doesn't care about this and returns to the max(last date of available data, end date). Can we please solve this? Otherwise one needs to know the exact last data entry date for all the tickers over which BDH is called. Thanks for your help!
Trying to get data for a LIBOR ticker that stopped in 2021 by providing just the start date and end date defaulting to today - doesn't return anything. But if I give a proper end date (where data was available)- it does return values. Normal BDH function in excel doesn't care about this and returns to the max(last date of available data, end date). Can we please solve this? Otherwise one needs to know the exact last data entry date for all the tickers over which BDH is called. Thanks for your help!