Ultimate Trade Tracking tools for traders! - - Official TJS... News & Update blog.
Trading Journal Spreadsheet
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.
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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment