Spreadsheet show/hide chart? - futures io
futures io futures trading



Spreadsheet show/hide chart?


Discussion in Psychology and Money Management

Updated by Seahn
    1. trending_up 1,186 views
    2. thumb_up 2 thanks given
    3. group 0 followers
    1. forum 3 replies
    2. attach_file 0 attachments




Welcome to futures io: the largest futures trading community on the planet, with well over 100,000 members
  • Genuine reviews from real traders, not fake reviews from stealth vendors
  • Quality education from leading professional traders
  • We are a friendly, helpful, and positive community
  • We do not tolerate rude behavior, trolling, or vendors advertising in posts
  • We are here to help, just let us know what you need
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.

-- Big Mike, Site Administrator

(If you already have an account, login at the top of the page)

 
Search this Thread
 

Spreadsheet show/hide chart?

(login for full post details)
  #1 (permalink)
New York, New Jersey/USA
 
Experience: Intermediate
Platform: NinjaTrader
Trading: Futures
 
Seahn's Avatar
 
Posts: 161 since Jan 2013
Thanks: 63 given, 267 received

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.

Thanks

Reply With Quote

 
Best Threads (Most Thanked)
in the last 7 days on futures io
Is anyone actually making money?
190 thanks
Micro account vs Funded account (combine)
53 thanks
Are sharks watching on the other side?
32 thanks
Market profile entries/exits
25 thanks
Spoo-nalysis ES e-mini futures S&P 500
23 thanks
 
(login for full post details)
  #3 (permalink)
Melbourne
 
Experience: None
Platform: NinjaTrader
Broker: Amp/CQG
Trading: NQ
 
shuglu's Avatar
 
Posts: 70 since Jul 2012
Thanks: 311 given, 92 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:
 
(login for full post details)
  #4 (permalink)
New York, New Jersey/USA
 
Experience: Intermediate
Platform: NinjaTrader
Trading: Futures
 
Seahn's Avatar
 
Posts: 161 since Jan 2013
Thanks: 63 given, 267 received

I found this, unfortunately does not work with OpenOffice.


How to Conditionally Show or Hide Charts - Excel Chart Templates & Tutorials | Chandoo.org - Learn Microsoft Excel Online

Reply With Quote


futures io Trading Community Psychology and Money Management > Spreadsheet show/hide chart?


March 7, 2014


Upcoming Webinars and Events
 

Every journal equals ten meals for the hungry

Now
     



Copyright © 2020 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, +507 833-9432, info@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