Tuesday, February 24, 2009

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)

1 comment:

Marcus Tarrant said...

Hi Friends,

This is the best way for watching stocks on a spreadsheet. It is an excel that was written to track stock purchases. Thanks for providing this...

Project Plan Templates