Spreadsheet show/hide chart? - Psychology and Money Management | futures.io
futures.io futures trading

Go Back   futures.io

> Futures Trading, News, Charts and Platforms > Psychology and Money Management

Spreadsheet show/hide chart?
Started:March 6th, 2014 (11:58 AM) by Seahn Views / Replies:487 / 3
Last Reply:March 7th, 2014 (02:45 PM) Attachments:0

Welcome to futures.io.

Welcome, Guest!

This forum was established to help traders (especially futures traders) by openly sharing indicators, strategies, methods, trading journals and discussing the psychology of trading.

We are fundamentally different than most other trading forums:
  • We work extremely hard to keep things positive on our forums.
  • We do not tolerate rude behavior, trolling, or vendor advertising in posts.
  • We firmly believe in openness and encourage sharing. The holy grail is within you, it is not something tangible you can download.
  • We expect our members to participate and become a part of the community. Help yourself by helping others.

You'll need to register in order to view the content of the threads and start contributing to our community. It's free and simple, and we will never resell your private information.

-- Big Mike

Thread Tools Search this Thread

Spreadsheet show/hide chart?

Old March 6th, 2014, 11:58 AM   #1 (permalink)
Elite Member
New York, New Jersey/USA
Futures Experience: Intermediate
Platform: NinjaTrader
Favorite Futures: Futures
Seahn's Avatar
Posts: 128 since Jan 2013
Thanks: 53 given, 181 received

Spreadsheet show/hide chart?

I am creating a spreadsheet to track my trading system performance. At this point it just reproduces the NT7 "Account Performance" summary, without the bugs and miscalculations but I will add more to it as I need it.

The spreadsheet is about done but I am not happy with the fact that I have a bunch of performance charts on one sheet making it look cluttered. I am looking for a way to either show or hide a chart in a sheet based on the value of a cell which is a dropdown list. Then I can overlay all the charts on top of each other and select the chart I want from the dropdown list.

I am pretty sure this can be done in excel (or openoffice which I am using) but I am not very good at spreadsheets and cannot find how even with a google search. Any tips are welcome and appreciated.


Last edited by Seahn; March 6th, 2014 at 12:04 PM.
Reply With Quote

Old March 6th, 2014, 11:58 AM   #2 (permalink)
Quick Summary
Quick Summary Post

Quick Summary is created and edited by users like you... Add FAQ's, Links and other Relevant Information by clicking the edit button in the lower right hand corner of this message.


Old March 6th, 2014, 07:25 PM   #3 (permalink)
Elite Member
Futures Experience: None
Platform: NinjaTrader
Broker/Data: Amp/CQG
Favorite Futures: /$
shuglu's Avatar
Posts: 48 since Jul 2012
Thanks: 219 given, 58 received

This is what I use. Hope it helps.

Interactive Dashboard in Excel using Hyperlinks | Chandoo.org - Learn Microsoft Excel Online

Reply With Quote
The following 2 users say Thank You to shuglu for this post:


futures.io > Futures Trading, News, Charts and Platforms > Psychology and Money Management > Spreadsheet show/hide chart?

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Upcoming Webinars and Events (4:30PM ET unless noted)

NinjaTrader 8: Programming Profitable Trading Edges w/Scott Hodson

Elite only

Anthony Drager: Executing on Intermarket Correlations & Order Flow, Part 2

Elite only

Adam Grimes: Five critically important keys to professional trading

Elite only

Machine Learning Concepts w/FIO member NJAMC

Elite only

MarketDelta Cloud Platform: Announcing new mobile features

Dec 1

NinjaTrader 8: Features and Enhancements

Dec 6

Similar Threads
Thread Thread Starter Forum Replies Last Post
"Hide/Show studies" Buttons Study slickiam Sierra Chart 9 January 7th, 2014 10:15 AM
show chart bubble with close actionashley ThinkOrSwim 0 April 29th, 2012 06:17 PM
Toogle Trades Indicator to just show chart markers? bluemele NinjaTrader 1 September 8th, 2011 01:31 AM
Intraday RealTime Chart: Indicators show late ManuAdam NinjaTrader 5 August 30th, 2011 12:15 PM
Show me the SEXIEST Ninjatrader Chart Template adaseb Traders Hideout 4 November 15th, 2010 09:47 PM

All times are GMT -4. The time now is 02:43 PM.

Copyright © 2016 by futures.io. All information is for educational use only and is not investment advice.
There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
no new posts

Page generated 2016-10-27 in 0.08 seconds with 19 queries on phoenix via your IP