Using WebService with Yahoo API

[Jeremy35]

Linking data from Yahoo Finance API into my Excel worksheet via the function WebService(). I would like to link in historical data from specific past dates. For instance, I would like to receive the Open/Close prices for MSFT on 03/24/2013. The example below is a call that works well for receiving the current "open/last" prices.

=NUMBERVALUE(WEBSERVICE("http://finance.yahoo.com/d/quotes.csv?s="&a2&"&f=l1"))

Would anyone be willing to help me out with this or at least point me in the right direction for finding instruction on how to do so?

Here is a basic example sheet of what I am trying to accomplish: Ex 1.xlsx

Thanks, J.