Stock Moving Averages

[tmerritt]

I am trying to build an excel formula for doing some basic stock analysis. I found a way for excel to automatically link with MSN money and import LIVE basic stock quotes.

What I am now looking for is a way to calculate the current 200 and 50 day moving averages of the stock price without having to manually input new information every day (since i am setting this up for many individual stocks).

Is there anyway to automatically import the 200 & 50 day averages directly from a web site or something of that nature? If not is there a way to have a up to date list of the last 200 day closing prices of a stock automatically updated in excel? Any guidance someone can give me would be much appreciated!

 

[dannac]

You could chart the prices .... excel can add many types of MA's to the data.
Once the chart is made, right click on price data and choose "add trendline"

similar to this

 

[tmerritt]

That does not help with what I am trying to accomplish.

A simple way to put what I am looking would be...

Is there any link I can establish between excel and an internet site or existing data feed of some kind so that each day the current average is calculated. Or is there a link where the most recent stock closing price is automatically added to an existing list of previous closing values?

 

[dannac]

You may be able to download the data ... ususally as CSV file.

I currently do this with commodity prices.

A macro opens the CSV file, makes a few adjustments then and I save.

I then open a workbook and import the CSV data with another macro.

 

[tmerritt]

any suggestions on places/sites to download the file from?

 

[dannac]

I download from the company I have an account with.

I know of a web site such as tfccharts.com that allows downloads, but I think it's mainly commodity prices, have not looked at them in awhile.

Not familiar with stock download sites .....
do a google search on "download daily stock prices"