~TA FAnaTick$~

[~6979~]

My Excel Spreadsheet (Risk Management){shared}

My new spreadsheet = now I can keep track of Stocks,Options, and Futures trades (Long & Short) all in one worksheet...

(with options , you have to move the decimal point over 2 #'s to make it work...& 4 #'s for Futures)
{example:if an option is .45, you have to input the trade as 45.00...It will also differentiate between long and Short trades simply by putting a L or an S in the (Long or Short)column...

Its not perfect,but it really helps me keep track of my trade history...(remember, Im not an Excel expert)...the only problem is inputting data on an open trade skews the #'s in the blue box...its probably best to enter the entire position once closed...Other than that, it works really well...the # in the blue box are not correct because I have open trades on my sheet...until you close the trade it counts the position as a loss...

these trades are real...as you see..I never risk more than 3% of my portfolio...Never...the most important column for me is the Portfolio Risk column...and of course the % of winners & Losers... ...It really brings your game up when you make a spread sheet like this...Trading is a competition against yourself...You have to constantly keep an eye on yourself so you dont lose control...this is a good way to do that...

...here it is...trade well my friends...

...in the second image, Im sharing the formulas that you will have to input into Excel if you would like to use it...