Excel - Pivot chart filter - futures io
futures io



Excel - Pivot chart filter


Discussion in Tech Support

Updated
    1. trending_up 1,570 views
    2. thumb_up 1 thanks given
    3. group 2 followers
    1. forum 2 posts
    2. attach_file 0 attachments




Welcome to futures io: the largest futures trading community on the planet, with well over 125,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
 

Excel - Pivot chart filter

(login for full post details)
  #1 (permalink)
 DarkPoolTrading 
PTA, Gauteng
 
Experience: Advanced
Platform: Self built + Sierra + TWS
Trading: Stocks and Options
 
DarkPoolTrading's Avatar
 
Posts: 1,036 since May 2012
Thanks: 1,244 given, 1,321 received

Hi All,

Does anyone know if there is a reasonably easy way to filter a pivot chart by trading instrument? For example say you trade the 6E, ES and CL. You would have all your trades listed on the first sheet with all the relevant information including a dropdown on each row indicating which instrument was traded. On the 2nd sheet you would then have all your pivot charts which would be based on the information from the 1st sheet.

What im hoping is possible would be to have a drop down on the second sheet to select which instrument you want the pivot charts to display. That way you can for example have an equity curve just plotting the 6E, or you could select "ALL" if you wanted an equity curve for everything. It would be fine if you have to click 'refresh' after selecting the dropdown to refresh the data in the pivot chart.

I've done some googling but cant seem to figure it out. Perhaps some of the excel guru's such as @vvhg and others could advise.

Much appreciated!

cheers

Diversification is the only free lunch
Follow me on Twitter Started this thread Reply With Quote

Journal Challenge April 2021 results (now extended!):
Competing for $1800 in prizes from Jigsaw
looks_oneMaking a Living with the Microsby sstheo
(302 thanks from 30 posts)
looks_twoSalao's Journalby Salao
(81 thanks from 13 posts)
looks_3Deetee’s DAX Trading Journal (time based)by Deetee
(50 thanks from 20 posts)
looks_4Learning to Profit - A journey in algorithms and optionsby Syntax
(38 thanks from 16 posts)
looks_5Maybe a little bit different journalby Malykubo
(17 thanks from 18 posts)
 
Best Threads (Most Thanked)
in the last 7 days on futures io
The Crude Dude Oil Trading System
122 thanks
Big Mike in Ecuador
60 thanks
Help improve the FIO community
38 thanks
Next New Poll Ideas/Suggestions
20 thanks
futures io site changelog and issues/problem reporting
16 thanks
 
(login for full post details)
  #2 (permalink)
 vvhg 
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,816 received

Well, you could achieve that in a number of ways. You could use a table with filters or named ranges with filters or as you mentioned pivot charts. I never used a loT of pivot charts, so I couldn't tell you from the top of my head how it works. But it should in fact be really simple...maybe you need a pivot table to pull the data from instead of doing it directly.
Your best bet might just be to google "filtered chart excel". Always remember, when it comes to excel, google really is your best friend...


Vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following user says Thank You to vvhg for this post:
 
(login for full post details)
  #3 (permalink)
 DarkPoolTrading 
PTA, Gauteng
 
Experience: Advanced
Platform: Self built + Sierra + TWS
Trading: Stocks and Options
 
DarkPoolTrading's Avatar
 
Posts: 1,036 since May 2012
Thanks: 1,244 given, 1,321 received


Thanks for the reply. Named ranges I guess may be the route to go. Ill try a bit more googling again to figure something out.

Diversification is the only free lunch
Follow me on Twitter Started this thread Reply With Quote


futures io Trading Community Off-Topic Tech Support > Excel - Pivot chart filter


Last Updated on February 20, 2013


Upcoming Webinars and Events
 

NinjaTrader Indicator Challenge!

Ongoing
 

Journal Challenge w/$1,800 in prizes!

April

An Introduction to CME Group Micro Bitcoin Futures w/David Lerman

Elite only
     



Copyright © 2021 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada), 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