Hi I'm wondering if it is possible to use a macro to get information from a website using macros.
I did a thorough Google search and all the help i get was scripts to retrieve data from Yahoo stocks or something similar.
I tried the Import external data > New Web Query but I'm still unable to get the results i want as the layout of the website is really different from the ones shown at Yahoo.
The website I will be getting information from is
And would like to keep track of the daily pricings while still keeping track of the pricings for different days in a format like that of:
Column A would be the date, Column B to F would be name of the stocks.
A2 would show the date and B2 to F2 would show the bid prices for every stock on that day.
The next day, I would like the date to be at A3 and prices to be at B3 to F3 too.
I'm wondering if anyone could help me with it or give me a rough guide on how to do it as I'm really at my wits end. Sorry for demanding alot and am hoping for some help to be given.