Custom query in slider

Hello, I am wondering whether it is possible to have dynamic content in slider.

I have MySQL table, where I store menu/dish offer for each day in restaurant.

My idea is to have page that is part of slider, which perform query based on current date, and then show menu / dish offer for current day. Ideally, I need page that is part of slider to be refreshed everytime when this page is displayed in slider.

I tried to append query using WordPress shortcode – that did not work.

I tried to perform AJAX query in mentioned page, but it did not execute when page appeared in slider.

Can you please help me with it?

Thank you