I want to write a macro to download historical financial data from Yahoo’s free financial site into Excel. My primary requirement is to do it in batch, i.e. a whole bunch of symbols (in a loop?) at the click of a button. I have used the QueryTable.Add method but the data loaded does not get treated as a CSV. Each line (date, open, high, low, close, volume, adj. close) is stored in a SINGLE cell instead of a row of cells. For some reason Excel does not recognize the comma delimiters. How do I fix this problem?
Thanks in advance.
(P.S. I’m a newbie to Excel VBA programming, please elaborate if you can)
also tell me frm where can i download books by arihant publications for enng entrance xams-2010.
Which search engine can let me download the fastest, safest torrent movies. And what is the average time it takes to download torrent.
And also where can you download torrent video games also faster and safer. I need user experience so please do not hesitate to post you answer in detail.