Stock Prices import

**roger00782006** · 12-07-2010, 06:14 PM

Hi y`all,
I am trying to have the current stock prices from yahoo finance imported to Excel and
i m also looking to have prices of the last 30 days along with the current day price on excel.
Therefore, for eg: if today`s date is Dec 7, 2010 the excel should show prices of Dec 7, 2010- Nov 8, 2010 and tomorrow (i.e. Dec 8, 2010) the prices shown should be Dec 8, 2010 to nov 7, 2010.

I would really appreciate all the help for the above.

Thanks

**6StringJazzer** · 12-08-2010, 09:09 AM

Is there a URL you can grab from Yahoo that will always show the data you describe for the current day in a table? If so you should be able to set it up as a web data import (Data, Import External Data, New Web Query).

If you aren't familiar with a web table import then I can give more detail, if you give more detail about what data you're getting and how you're getting it from Yahoo.

(Your 30-day interval is clear but I think the dates in your example are a little hosed up. If today's date is Dec 7 then you want prices from Nov 8-Dec 7. The next day you want prices from Nov 9-Dec 8.)

**roger00782006** · 12-08-2010, 09:21 AM

Originally Posted by 6StringJazzer

Is there a URL you can grab from Yahoo that will always show the data you describe for the current day in a table? If so you should be able to set it up as a web data import (Data, Import External Data, New Web Query).

If you aren't familiar with a web table import then I can give more detail, if you give more detail about what data you're getting and how you're getting it from Yahoo.

(Your 30-day interval is clear but I think the dates in your example are a little hosed up. If today's date is Dec 7 then you want prices from Nov 8-Dec 7. The next day you want prices from Nov 9-Dec 8.)

thanks for your reply . Yes, the date you quoted are correct. Concerning the URL, here is the URL: http://finance.yahoo.com/q/hp?s=IP&a...e=8&f=2010&g=d

so what I am looking to do is, At the end of every day excel should update the prices by itsef by linking it up to that URL automatically. Is it possible??

Thanks once again.

**6StringJazzer** · 12-08-2010, 09:33 AM

First I suggest you look at how to import web data using the menu sequence I provided above, possibly checking Excel Help for Web Data.

It looks like the URL has the desired date hard-coded as parameters, so I'll have to look into the possibility of generating the URL dynamically, or possibly finding another way to get there.

**roger00782006** · 12-08-2010, 06:17 PM

Hey, yeah..I m able to import the data as indicated, however, I am not able to have it update it accordingly...in terms of generating URL dynamically ..that is where i need you ehlp big time on...appreciate..

**6StringJazzer** · 12-08-2010, 07:04 PM

This was an interesting little project, I learned a lot.

Attached is a workbook that is seeded with a range of dates from earlier in the year, just to demonstrate how this works. When you open the workbook, you must allow macros to run. Then it automatically updates the URL to reflect the current date, and updates the web query with the new URL.

One note: In the Yahoo page, if you enter Dec 9 as the end date, the latest date in the table is Dec 8 (at this moment). I don't know if there is a lag from the closing bell to when they make the data available in this form.

**Jaack** · 12-08-2010, 07:32 PM

I'm only chiming in with my useless $0.00000002

Ha I asked a very similar question about a month ago. here's the link if any of it may help you, and looks like this will help me.

http://www.excelforum.com/excel-gene...ne-column.html