Well, its only been out a day and already I’m coming out with bug fixes. This is a minor, but important one though. You can either download the latest version of the spreadsheet HERE< or you can make the adjustement within your current spreadsheet. The problem lies within the M-Column (AKA: Risk Unit)

To make the correction yourself you will have to unprotect the sheet. Then go to cell M9 and in the formula you will find two instances where it says:

(B9*2*$A$5)/200

The 200 needs to be replaced with $B$5 in each of these cases so that the the total formula will read:

=IF(J9=0,”",IF(K9>0,ABS(J9-H9)/ABS(H9-D9)-(B9*2*$A$5)/$B$5,IF(K9<0,-ABS(J9-H9)/ABS(H9-D9)-(B9*2*$A$5)/$B$5,”")))

Once you have this cell fixed, simply go to the lower right-hand corner of the cell until a + appears and drag the formula down to all the other cells and save the spreadsheet.

It might be a good idea to protect the sheet again if you are doing this manually so that no mistaken cell changes are made.

Sorry for any confusion,

Jason

This is what I have so far this morning. Each day I am getting more and more back into the swing of things after my break and after designing the new system. I wasn’t able to do any post market screening yesterday so the list is limited to only what I have been able to find in the last hour.

These cells should be editable for those of you who have downloaded the StockTracker Spreadsheet and wish to simply cut & paste the picks into it so that you can adjust it via your own risk preferences.

Happy Trading

-7

The signals are finally starting to converge a little clearer now after the past few days. I expect there to be a downward movement in the markets early with a possible bounce off support later in the day if the indices go down far enough.

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