J
jgalt650-excel
Over the years, this board has been a huge help to me, so I thought I'd
post this link in which I show how to bring stock quotes into a
spreadsheet in an easy and robust way.
http://gallery.yahoo.com/apps/2260/locale/en
(click on the blue W3 circle below the words that say "visit
application")
This is a link to a a simple spreadsheet that allows you to pull stock
quotes in from Yahoo Finance, for a range named 'tickers'. If you
change the tickers, the company names and stock prices will change as
well. This spreadsheet just makes it easier to track a portfolio using
Excel. Virtually all financial quotes tell you the amount that a stock
has changed since the prior close. One benefit of this spreadsheet
approach is that by recording your observation, you can review the
change since the last time you looked at your portfolio, whether that
was an hour or a week ago. This is written in visual basic for excel,
and I've left the source code open. email: jgalt650-excel@[email protected]
post this link in which I show how to bring stock quotes into a
spreadsheet in an easy and robust way.
http://gallery.yahoo.com/apps/2260/locale/en
(click on the blue W3 circle below the words that say "visit
application")
This is a link to a a simple spreadsheet that allows you to pull stock
quotes in from Yahoo Finance, for a range named 'tickers'. If you
change the tickers, the company names and stock prices will change as
well. This spreadsheet just makes it easier to track a portfolio using
Excel. Virtually all financial quotes tell you the amount that a stock
has changed since the prior close. One benefit of this spreadsheet
approach is that by recording your observation, you can review the
change since the last time you looked at your portfolio, whether that
was an hour or a week ago. This is written in visual basic for excel,
and I've left the source code open. email: jgalt650-excel@[email protected]