Finally a web based trade journal with full stats and automatic trade import. Head over to StockTradingToGo. An average of column K R Multiple.

This formula must be modified each day to include the latest rows. Commission for both sides of the trade.

I have it set to calculate based on the number of shares entered in column E. I use this to list errors made on the trade or anything else worth noting.

Using Excel To Track Your Stock Portfolio

This gives me an idea of how much money was in the position. The percentage return for the trade.

Again, not exact for shorts. Just tells me how far my stop was from my entry in percentage terms.

Tells whether the trade was a winner 1 or a loser 0. Thanks for the look at.

Trading Software. Stand-Alone Trading Software. Excel Trading Software

I use one of my own. Pretty crude, but…gets the just done. Thanks for the fancy link. Have a good one.

Download historical EOD stock quotes for MetaStock, Excel/CSV or ASCII format

Home About Trade Tools Contact. Posted by Michael Tweet 17 January RSS Feed Subscribe to get Free Updates. Posted by Mousefinger on January 18, at 1: Posted by Glenn on January 18, at 1: Posted by Doug on January 18, at 2: Posted by Michael on January 18, at 2: Posted by Doug on January 18, at 8: Posted by Tapeworm on January 19, at Enter your email address Most Popular Inverse ETFs Day Trading Trading Journals Trade Expectancy About TraderMike Market Recap Archives.

Terms of Use Disclaimers Privacy Policy.