Create an error message when retrieving information for invalid dates

In retrieving stock info from the internet there is a problem if a user selects a date that was prior to the existence of the stock. Currently, if that happens, the user just gets blank cells.

The attached image shows 2 printscreens.

The top image shows a table that isn't a problem.
The bottom image shows an attempt to retrieve info 2 years prior to the existence of data and Yahoo says data is unavailable.

What code can I insert that will alert a user that they need to pick a different date? The alert can be something as simple as inserting XXXX instead of a stock price. Definitely not looking for a fancy solution.

Thanks all!!


StkErr.jpg

Here is my code:

Please Login or Register  to view this content.

can you retrieve data of listing of each of the stocks. in that case you can put a condition that beginning date should be >=that listing date.