I'm working on a personal project to help me manage my "Stocks Target List". Basically I have about 300 stocks in an excel spreadsheet that have the stock quote/ current price, Book Value, 52 Week High/Low, Dividend and Ex Dividend Date, Next Earnings Release Date, Earnings Per Share (EPS), Cash, Debt, Revenue, Forward P/E, and a Notes column. In addition there are two more columns. One I have a Buy Under Price which is the price I would like to buy the stock at or cheaper, and the other column is a preferably Price column which is a price that I think is an absolutely good deal for the stock (both values are made up by me). I've been trying to link the quote column to a msn.com or yahoo.com spreadsheet that gives me the quote info for each stock. 99% of the time it breaks the whole excel document or just doesn't update the proper fields.
I want to try and make this a web application instead but not sure if its possible. Is there a way I can make a spreadsheet or table, and have it update certain columns like the quote column from an external source such as google finance or yahoo finance? For example, is there a way to update it through google.com/finance with the particular stock symbol for each row.
Here's a small example of the format: I need the quote column updated automatically or with the click of a button to start with.
Stock Buy under Preferably Quote BOOK 52 WEEK LOW/HIGH
MXIM $19.00 $15.25 $19.44 $8.43 11.01 - 21.00
XLNX $25.00 $23.30 $26.04 $7.36 18.16 - 27.50
CY $11.00 $8.50 $11.47 $3.93 4.29 - 11.76
TSRA $18.55 $15.00 $20.32 $11.44 10.13 - 32.17
RFMD $3.85 $3.76 $5.02 $1.74 0.73 - 5.85