VBA: web scrapping with custom dates

[Mekrog]

I am trying to copy some historical figures from https://www.investing.com/equities/a...istorical-data

My problem is that the page only shows the last month's daily figures but I want to select the start and end date from the dropdown menu and click on the "apply" button hyperlink.

I have checked the similar questions/answers but could not find any solutions to selecting custom dates.

here is what I did so far:

Please Login or Register  to view this content.

Is there any method to solve the problem?