Help needed (creating VBA macro to retrieve stock info)

tentatively I have written a macro for you. I am sending the file 'L80N.xlsm"
see the column H in sheet ("E mail data"
the open prices are filled by the macro
if you want to retest you can run the macro "test"

there is only one big problem. You have 334 stocks and mostly for each stock the date (co. G) is different ( may be one to three stocks may have same date). the macro downloads the rices for the next day to corresponding col. G dates and copy it to col H of the email data sheet. Temporarily the data is downloaded in sheet 3.

IT TAKES NEARLY 9 MINUTES TO FILL THE DATA BY THE MACRO
once you experiment with this with patience. meanwhile let me check whether some speedier solution can be made.
see the macro in the vb editor to understand the logic of the macro