stock prices; EOD data from internet

[impala096]

Created a macro to update end of day (EOD) info for stock prices. I'm able to manually change the stock symbol within the URL line found in the macro to retrieve another stocks data but i want to be able to reference a cell in my spreadsheet instead of having to manually enter within the macro.

This is a line from the macro that actually retrieves the info from the web:

Please Login or Register  to view this content.

To get data for another stock, i would manually change the "GM" (General Motors Corp) in this line to another stock symbol of interest. How do i automate the process so that it will reference a cell instead?

Thanks for any help,
Impala

[Tom Schreiner]

Hi Impala. I'm not going to spend time modifying your example file when I already have my own. Maybe you can adapt to your needs using the attached example...

[impala096]

Awesome Tom,

That spreadsheet looks great. I am also interested in being able to grab intraday data for stocks. Have you been able to find a way to be able to do this within excel? I have freeware software that downloads up to 30 days of historical intraday data but i have no idea what feeds the data gets the data from.

Let me know if you have run across this yourself.

Thanks,
Impala

[Tom Schreiner]

Are you speaking of realtime data? Please explain to me what intra-day means exactly and tell me of some potential sources.

[yawnzzzz]

Have either of you found a stock site that you could grab the information for the net worth of a company along with what percentage of a company a stock currently represents (or enough information where I could calculate both)?

[Tom Schreiner]

Hi Yawn. If it is a publicly traded company, I think that the information you are looking, by law, must be made public.

See the U.S. Securities and Exchange Commission (Home Page)

[impala096]

Hi Tom,

Ultimately I would need both intraday and real-time data.

Intraday data would be the exact same data as you would find for an end of day (EOD) quote but would be available on a minute by minute basis. It would include the date, time, volume, open, high, low, and close.

It might look something like this: 8/11/08; 9:35; 8,000; 10.55; 1062; 10.52; 10.53.

Interpreting the data, at 9:35 a total of 8000 shares were traded with an opening price for that minute of 10.55, a high for that minute of 10.62, a low for that minute of 10.52, and a close for that minute of 10.53.

Also, I would need it to be available in real-time where excel would constantly (every minute) be refreshing and re-importing the intraday data.

There are websites that provide real-time data (http://finance.yahoo.com/q/ecn?s=GM). Sites like this do me little good though as it only provides a snap-shot of what the current price is (you are unable to download the intraday data from 5 minutes ago, an hour ago, or 2 weeks ago which I would definitely need to be able to do).

Hope this clarifies things and I apologize for the delayed response back.

Thanks,
Impala

[yawnzzzz]

Hi Yawn. If it is a publicly traded company, I think that the information you are looking, by law, must be made public.

See the U.S. Securities and Exchange Commission (Home Page)

I understand that they're legally required to provide that information, but it's normally hidden within some part of their own web page. I was curious whether a website gathered up all of that information for all or most publicly traded stocks, so that I could for instance go to one website and download that data for a hundred stocks.

[Tom Schreiner]

Impala.

You can get data for less than a handul of stocks using any number of sources by way of an autorefreshing web query though I have yet to find a site that makes it easy to do so. My experience has been that it is not worth it. Buy the feeds...

What are you wanting exactly? Data for how many/which symbols? An index, perhaps?

Yawn. You might consider posting your question in a relative forum.