Extracting Stock Data from Yahoo Finance

**Alex Fernandes** · 11-22-2013, 07:16 AM

Hi,

I'm attaching the Spreadsheet which is not giving me the desired output and getting only N/A as the result. Unable to understand as to where I'm going wrong.
Would be glad if I get the assistance in understanding the problem in the attachment.

Thanks
Alex

**6StringJazzer** · 11-24-2013, 11:29 AM

I don't understand the API you are using for the query but when I enter your query manually I get a CSV file that has only one line that says:

Missing Format Variable.

So you probably have an error in your URL string, rather than an Excel or VBA error.

**Alex Fernandes** · 11-27-2013, 05:20 AM

Hi 6StringJazzer,

Thanks a lot for your time.

So if I'm not able to extract data from Yahoo Finance, is there any other way that it can be worked out. I had even tried working with the option of "Get External Data" from Web without any success.

Alternatively, if Yahoo Finance is not working, can it be done from Google Finance.

Once again, thanks for your time and support.

Regards
Alex