I am not sure if I understood well, but it seems that you are trying
to recover stocks end of the day quotes.
Is that it?
If you live in North America, why don't you simply use a WebQuery
(the MSM webquery works great), that will bring the requested tickers
directly into your workbook.
If you do not live in North America, you could probably create
another Webquery of your own.
If I understood you right, tell me and I could tell you more about
how to do that.