Watching stocks on a Spreadsheet

Here's a spreadsheet which follows selected stocks from a given point in time, up to the current, updated price - to give an "unrealized gain or loss" calculation based on some theoretical number of shares purchased. It's very simple. The way this spreadsheet was populated as you see it, was from using the Google Finance stock screener - a very useful tool which lets you identify stocks which meet certain criteria which you can easily set. Oh - I almost forgot to mention - the stock prices in this spreadsheet update automatically using the GoogleFinance function of Google spreadsheets... sweet.

Site:	JRsays (my blog)
Page/Post:	Stock Screening
Spreadsheet:	Stock Screen Spreadsheet (preview)
Spreadsheet:	get your own copy (on click, you'll get a copy put in your Docs list)

Covered Call Stock Investment Strategy

The Buy (Hold) & Write blog presents deep information and data on a "covered call investment strategy". There are spreadsheets with individual stock data (like the one we link to below), as well as Portfolilo Values and Transactions. The educational links on this site make it a very nice place to start when trying to learn about covered calls and investing in stocks overall.

Site:	Buy (Hold) & Write
Page/Post:	Pop Goes CYBS
Spreadsheet:	Break Even Analysis for CYBS

Stock Gumshoe Tracks Stock Tips

The Stock Gumshoe blog is for people who are "frustrated or intrigued by email teasers from investment newsletters and advisers". It includes a spreadsheet which tracks the investment advice of these investment newsletters which provide, for lack of a better name, "Stock Tips". Travis Johnson, the author of this blog and another investment blog (called OneGuysInvestments) says on that other blog that he's "not an investment advisor, registered or otherwise, so don't follow my moves unless you're happy to lose money without suing someone.". Notice in this spreadsheet, Travis' smart use of links in cells to point viewers to specific blog posts for each of the investments being tracked... Great way to offer value to readers but also to syndicate your pages to other sites.

Site:	Stock Gumshoe Blog
Page/Post:	Sock Gumshoe's Tracking Spreadsheet Page
Spreadsheet:	Stock Gumshoe Tracking Spreadsheet

Income Statements and Balance Sheets

Dayanand Menashi created the Annual Report Analysis blog to "analyze the annual reports of the businesses [in which he is] interested to invest". He Posted the Balance sheet and Income statement of Infosys in a recent post as part of this analysis... these are now good templates for people looking to use online spreadsheets to document their financial statements. (note: as with other posts here - we cannot confirm the validity of the information posted on these blogs or the related spreadsheets)

Site: Annual Report Analysis
Page/Post: Dissecting INFY's 2Q results
Spreadsheet: Infosys Financials

Boston Investors Share Stock Data

BostonIBD "is the online group for Boston, Massachusetts area IBD (Investors Business Daily) investors. Join this site to share knowledge about stock investing. We encourage free discussion about investing...". An interesting spreadsheet of the IBD100 stocks was posted to the Google Group where many people gather around this topic.

Site: Boston IBD Group
Page/Post: Public LInk to IBD100 Spreadsheet
Spreadsheet: Boston IBD Spreadsheet