How to Extract data from Webpage based on Fund ID given in Column A

[Akash kothari]

Hello Friends,

Looking for Help with VBA.

This is one of my daily office task.

Requirement:
In Column A ; Cell A1 Contains the date for which i want to pull the prices.
In Column A; From Cell A2 are the Security ID for which i want to pull the prices and Put Under B2. ( for some 200 funds May vary).

I have tried to built the code but its not correct. I have done till Login into website but don't know how to extract data from webpage table only for the date mentioned in Cell A1.

I have also attached the Excel file that contains the HTML Source code(In Module2), (Module1) the code that i tried and in Column A some Sample funds.

Steps that i follow:
Step 1: Login into website
step 2 : Click in Security info
Step 3: Enter the Security ID in the Security ID BOX and Click on retrive button.
Step 4: Click on Pricing / Evaluations.
Step 5: Click on Pricing / Evaluation History
Step 6: Copy the price for date mentioned in the Cell A1 and Paste in front of that ID in Sheet1.
Step 7: Save file and Logout.

Thank you
Ak

 

[Akash kothari]

Is this Possible ????

 

[Akash kothari]

Hi Friends i am attaching the screenshot of the Image with the required information.

 

[Akash kothari]

Attached Source code in Text file.