Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Excel Spreadsheet: Stock Price, Watch List
#2
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-histori...nto-excel/

Here's more on Google Docs:

http://www.aubrett.com/InformationTechno...nance.aspx
=====

“While the dividend itself is merely a rearrangement of equity, over time it's more like owning an apple tree. The tree grows the apples back again and again and again, and the theoretical value of the tree doesn't change just because of when the apples are about to fall.” - earthtodan


Reply


Messages In This Thread
RE: Excel Spreadsheet: Stock Price, Watch List - by Dividend Watcher - 11-08-2015, 01:49 AM
RE: Excel Spreadsheet: Stock Price, Watch List - by Amos - 11-13-2015, 04:41 AM



Users browsing this thread: 2 Guest(s)