Excel - Pivot chart filter - Tech Support | futures io social day trading
futures io futures trading


Excel - Pivot chart filter
Updated: Views / Replies:707 / 2
Created: by DarkPoolTrading Attachments:0

Welcome to futures io.

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

futures io is the largest futures trading community on the planet, with over 90,000 members. At futures io, our goal has always been and always will be to create a friendly, positive, forward-thinking community where members can openly share and discuss everything the world of trading has to offer. The community is one of the friendliest you will find on any subject, with members going out of their way to help others. Some of the primary differences between futures io and other trading sites revolve around the standards of our community. Those standards include a code of conduct for our members, as well as extremely high standards that govern which partners we do business with, and which products or services we recommend to our members.

At futures io, our focus is on quality education. No hype, gimmicks, or secret sauce. The truth is: trading is hard. To succeed, you need to surround yourself with the right support system, educational content, and trading mentors Ė all of which you can find on futures io, utilizing our social trading environment.

With futures io, you can find honest trading reviews on brokers, trading rooms, indicator packages, trading strategies, and much more. Our trading review process is highly moderated to ensure that only genuine users are allowed, so you donít need to worry about fake reviews.

We are fundamentally different than most other trading sites:
  • We are here to help. Just let us know what you need.
  • We work extremely hard to keep things positive in our community.
  • We do not tolerate rude behavior, trolling, or vendors advertising in posts.
  • We firmly believe in and encourage sharing. The holy grail is within you, we can help you find it.
  • 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.

-- Big Mike, Site Administrator

Reply
 
Thread Tools Search this Thread
 

Excel - Pivot chart filter

  #1 (permalink)
 Vendor: diversifyportfolio.com 
PTA, Gauteng
 
Futures Experience: Advanced
Platform: Self built + Sierra + TWS
Favorite Futures: Stocks and Options
 
DarkPoolTrading's Avatar
 
Posts: 1,036 since May 2012
Thanks: 1,244 given, 1,304 received

Excel - Pivot chart filter

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
Reply With Quote
 
  #2 (permalink)
Elite Member
Northern Germany
 
Futures Experience: Intermediate
Platform: NT
Favorite Futures: FDAX, CL
 
vvhg's Avatar
 
Posts: 1,583 since Mar 2011
Thanks: 1,016 given, 2,807 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:
 
  #3 (permalink)
 Vendor: diversifyportfolio.com 
PTA, Gauteng
 
Futures Experience: Advanced
Platform: Self built + Sierra + TWS
Favorite Futures: Stocks and Options
 
DarkPoolTrading's Avatar
 
Posts: 1,036 since May 2012
Thanks: 1,244 given, 1,304 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
Reply With Quote

Reply



futures io > > > > Excel - Pivot chart filter

Thread Tools Search this Thread
Search this Thread:

Advanced Search



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

Jigsaw Trading: TBA

Elite only

FuturesTrader71: TBA

Elite only

NinjaTrader: TBA

Jan 18

RandBots: TBA

Jan 23

GFF Brokers & CME Group: Futures & Bitcoin

Elite only

Adam Grimes: TBA

Elite only

Ran Aroussi: TBA

Elite only
     

Similar Threads
Thread Thread Starter Forum Replies Last Post
Sierra Chart Excel Journal drw112 Sierra Chart 6 January 22nd, 2017 12:10 PM
How do I chart the CFTC COT Excel data in NinjaTrader? JohnPS NinjaTrader 8 September 2nd, 2014 11:06 AM
Sierra Chart filter bad ticks Big Mike Sierra Chart 7 August 1st, 2012 10:34 PM
Point Filter peonia trader NinjaTrader 1 July 17th, 2012 04:35 PM
help with excel writing in sierra chart ALFASSY Sierra Chart 5 May 3rd, 2011 07:35 AM


All times are GMT -4. The time now is 01:49 PM.

Copyright © 2017 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
Page generated 2017-12-17 in 0.07 seconds with 19 queries on phoenix via your IP 54.226.113.250