Trading Journal Spreadsheet

Trading Journal Spreadsheet
TJS Trading Log
Record It, Track It, Analyze It!
Expertly crafted, simple to use trading spreadsheets for traders.
Products for all: Stock, Options, Futures, Forex, SpreadBetting, CFD markets.

Tuesday, May 17, 2011

Quick 'Summary' Using Excel's Status Bar


For those that don't know... Excel displays a very helpful summary in the (lower status bar) window.

Just scroll & highlight any numeric data column and you'll see some interesting calculations come to life:

* Sum
* Average
* Minimum
* Maximum
* Count (# of items)

Unlike a formula entered into a cell, you cannot permanently keep these results in your trading spreadsheet, but when you want a quick answer to a question on your input area, it can't be beat for its quick and instant display.

To change your choice of what the status bar displays, just right-click in the status bar to see your choices (towards the bottom-half), then check or uncheck the ones you want displayed.

Click the image to see an example using the new TJS Elite.

No comments:

Post a Comment