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.

Showing posts with label Excel status bar. Show all posts
Showing posts with label Excel status bar. Show all posts

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.