Well, here it is.
the StockTracker Spreadsheet version 1.0 has arrived! A screenshot of the spreadsheet can be seen below. This is the format that I will be using to post all of my future stock picks and recommendations. Help Files are also included and a link to their download is listed belolw. I have designed this spreadsheet to be 100% customizable to your own trading style and risk tolerance with an area to define your personal Maximum Risk Exposure per trade as well as a cell where you can adjust for the comission structure of your current broker.
Every day I will post the picks that I will personally be looking to trade that day as well as my Entry, Target, and Stop prices. Of the 3 prices, targeting is the area that is the most subjective and the area where I have the most room to grow. Nevertheless, all of the columns marked in white are editable so you can feel free to modify certaing picks here & there and the spreadsheet will automatically adjust for your appropriate position size based on your desired risk exposure.
In the mornings, I will post a copiable version of the White Areas of the spreadsheet so that anyone who has a copy can simply cut and past the cells directly from the website into the spreadsheet. However, in the afternoons when I post the daily results I will post this as a .jpg image which you will only be able to copy as an image, not the individual contents of each cell. I am doing this to save time and space as the .jpg image is much easier to throw on the website than formating the cells in HTML.
Areas in Green are formulas that should only be edited by people who are very familiar with Excel. I have added locked those cells that should not be edited, but there is no password on the sheet so to change these cells all you need to do is go to Tools–>Protection–>Unprotect Sheet
Please feel free to leave me your comments and impressions regarding the spreadsheet as well as any suggestions for improvements in future releases.
For the Stock Tracker Spreadsheet itself, DOWNLOAD HERE
I have included help files which I would highly recommend you review and understand thoroughly before making any trades based on the spreadsheet. A .pdf version of the HELP FILES can be DOWNLOADED HERE
