(11-08-2015, 01:49 AM)Dividend Watcher Wrote: Can you create a custom view for your portfolio or a watchlist on your brokers web site? Might also consider a custom view in Yahoo Finance if you use that for quotes.

Or you can create a spreadsheet and either link it or download and import. There's lots of ways to skin this cat. Google is your friend.

This one shows how to download a csv from Yahoo Finance and a little discussion on Google Docs:

http://www.marketindex.com.au/yahoo-finance-api

Another one:

http://investexcel.net/importing-historical-stock-prices-from-yahoo-into-excel/

Here's more on Google Docs:

http://www.aubrett.com/InformationTechnology/Productivity/GoogleFinance.aspx

(11-08-2015, 05:33 PM)Rasec Wrote: Try this out:

https://docs.google.com/spreadsheets/d/1J2uOic20RnAg3QUDBHC0N6Fso8I0sQimNNBIoAHD8HU/edit?usp=sharing

Let me know if you need help. It's a simplified version of the tracker I built and use almost daily. Just edit the light yellow cells and nothing else.

(11-07-2015, 03:28 PM)stewardinlife Wrote: Hi all,

Can anyone point me to, or advice on any resources or spreadsheet that would help me in looking at all of my DG stock watch lists with prices/dividends on a spreadsheet, or some other dashboards.

Currently, I am either going to M* or S & P reports from the brokerage account, and individually look at each one I am interested -- As you can tell it definitely is time consuming. Ideally I would like to see it in one view from a report or something that is providing real-time quotes.

Thanks.

(11-08-2015, 05:33 PM)Rasec Wrote: Try this out:

https://docs.google.com/spreadsheets/d/1J2uOic20RnAg3QUDBHC0N6Fso8I0sQimNNBIoAHD8HU/edit?usp=sharing

Let me know if you need help. It's a simplified version of the tracker I built and use almost daily. Just edit the light yellow cells and nothing else.