NE Excel Wizards in here? - Platforms and Indicators | futures io social day trading
futures io futures trading


NE Excel Wizards in here?
Updated: Views / Replies:3,689 / 22
Created: by forrestang Attachments:5

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
 5  
 
Thread Tools Search this Thread
 

NE Excel Wizards in here?

  #11 (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


forrestang View Post
Anyone know of any good tutorials on how to manage data you create that you want to sort? Just basics would be helpful.

I.e. using tables, or PowerPivot?

Actually YouTube holds a bunch of good vids on any aspect of excel, normally a simple search like 'excel table' would do...
If you have any specific questions, just shout and I'll try to help.

vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following user says Thank You to vvhg for this post:
 
  #12 (permalink)
Market Wizard
Switzerland
 
Futures Experience: Intermediate
Platform: Investor/RT
Broker/Data: IB / DTN
Favorite Futures: Futures
 
Posts: 4,080 since Feb 2012
Thanks: 3,767 given, 7,537 received
Forum Reputation: Legendary

Two links that might help

Excel Pivot Tables Tutorial : What is a Pivot Table and How to Make one | Chandoo.org - Learn Microsoft Excel Online

Excel Blog - Using PowerPivot with Excel 2010

my 2 cents :-)

GFIs1

Reply With Quote
The following user says Thank You to GFIs1 for this post:
 
  #13 (permalink)
Urban Samurai
Chicago IL
 
Futures Experience: Intermediate
Platform: Ninja, MT4,TOS, SC, Matlab
Broker/Data: CQG, AMP, MB, DTN
Favorite Futures: E/U, G/U
 
forrestang's Avatar
 
Posts: 1,039 since Jun 2010
Thanks: 226 given, 687 received


Got some basic sorting accomplished.

But here is a general question..... say you have data in the format of:
 
Code
Date    Size1    Size2   Size3.......
21Feb   22.00    30.50   60.50
        Lvl1     Lvl5    Lvl3
Where in the above example, the column headers are blue, and Have 'Date and SizeX.' But then on a row under that in color green, for each 'Size' value, there is a corresponding code associated with it in green.

So for each DATE/DAY, I essentially have various 'Sizes' associated with it, along with a code.

I am primarily wanting to filter on 'Size', which is just a number I want to apply a sort to. So if I sort a cell in THAT column, it will sort the size along with the date fine.

The problem, is, that it also throws the 'Code' Row out of whack, in that the Codes don't stay with the original size value it was associated with.

So basically, is it possible to sort on a value in a given column, while keeping the actual value of the data of the cell beneath it with it?

Reply With Quote
 
  #14 (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


forrestang View Post
Got some basic sorting accomplished.

But here is a general question..... say you have data in the format of:
 
Code
Date    Size1    Size2   Size3.......
21Feb   22.00    30.50   60.50
        Lvl1     Lvl5    Lvl3
Where in the above example, the column headers are blue, and Have 'Date and SizeX.' But then on a row under that in color green, for each 'Size' value, there is a corresponding code associated with it in green.

So for each DATE/DAY, I essentially have various 'Sizes' associated with it, along with a code.

I am primarily wanting to filter on 'Size', which is just a number I want to apply a sort to. So if I sort a cell in THAT column, it will sort the size along with the date fine.

The problem, is, that it also throws the 'Code' Row out of whack, in that the Codes don't stay with the original date column.

So basically, is it possible to sort on a value in a given column, while keeping the actual value of the data of the cell beneath it with it?

Is the 'Code' entered manually or is it calculated by a formula? If its a formula, then there might be a slim chance it could be done without too much fuss, but i would say probably not.

So basically you would need some helper columns and code the sort function, which is not that easy....

The easiest way would be to have the 'Code' in the same row as the other stuff....if that's an option, I would be happy to help any time if you provide some more details of what exactly you want to accomplish.



vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following user says Thank You to vvhg for this post:
 
  #15 (permalink)
Urban Samurai
Chicago IL
 
Futures Experience: Intermediate
Platform: Ninja, MT4,TOS, SC, Matlab
Broker/Data: CQG, AMP, MB, DTN
Favorite Futures: E/U, G/U
 
forrestang's Avatar
 
Posts: 1,039 since Jun 2010
Thanks: 226 given, 687 received


vvhg View Post
Is the 'Code' entered manually or is it calculated by a formula? If its a formula, then there might be a slim chance it could be done without too much fuss, but i would say probably not.

So basically you would need some helper columns and code the sort function, which is not that easy....

The easiest way would be to have the 'Code' in the same row as the other stuff....


vvhg

All those values are actually placed in there by NT. So there aren't any formulas associated with the sheet, just the values.

I was afraid that I would have to put everything on the same row, which I can do, just makes the data a bit harder to read.

Reply With Quote
 
  #16 (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


forrestang View Post
All those values are actually placed in there by NT. So there aren't any formulas associated with the sheet, just the values.

I was afraid that I would have to put everything on the same row, which I can do, just makes the data a bit harder to read.

If it is only readability, I'd swallow that pill. The other option would likely end in a major coding project.
If the data is put in there by NT, have you had a look at @petrmacs importer for the journal in this thread? Perhaps the things he uses would be useful to you too?

vvhg

Hic Rhodos, hic salta.
Reply With Quote
 
  #17 (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

Btw, once you got that issue sorted, if you want to use the table feature in excel for your data, I could easily provide a code snippet that re-sizes the table based on the existing data.


vvhg

Hic Rhodos, hic salta.
Reply With Quote
The following user says Thank You to vvhg for this post:
 
  #18 (permalink)
Urban Samurai
Chicago IL
 
Futures Experience: Intermediate
Platform: Ninja, MT4,TOS, SC, Matlab
Broker/Data: CQG, AMP, MB, DTN
Favorite Futures: E/U, G/U
 
forrestang's Avatar
 
Posts: 1,039 since Jun 2010
Thanks: 226 given, 687 received

Nebody know how to plot frequency distributions?

I used THIS tutorial, but it seems like it just doesn't work?

Actually, just to plot the number of occurrences, then plot a distribution of frequency/occurrences.

Reply With Quote
 
  #19 (permalink)
Elite Member
las vegas
 
Futures Experience: Intermediate
Platform: Sierra Chart
Broker/Data: Velocity/IB
Favorite Futures: 6E
 
Posts: 1,147 since Feb 2010
Thanks: 304 given, 836 received


forrestang View Post
Nebody know how to plot frequency distributions?

I used THIS tutorial, but it seems like it just doesn't work?

Actually, just to plot the number of occurrences, then plot a distribution of frequency/occurrences.

It's working for me, are you highlighting the whole range where you want the formulas to be entered first and after entering the formula, are you hitting ctrl shift enter?

Reply With Quote
The following user says Thank You to vegasfoster for this post:
 
  #20 (permalink)
Urban Samurai
Chicago IL
 
Futures Experience: Intermediate
Platform: Ninja, MT4,TOS, SC, Matlab
Broker/Data: CQG, AMP, MB, DTN
Favorite Futures: E/U, G/U
 
forrestang's Avatar
 
Posts: 1,039 since Jun 2010
Thanks: 226 given, 687 received



vegasfoster View Post
It's working for me, are you highlighting the whole range where you want the formulas to be entered first and after entering the formula, are you hitting ctrl shift enter?

Here's the video for what I am doing. Not sure what I'm doing wrong? You can see I select multiples cells, then type in the formula, and select the dataSeries, followed by the range. But it just does what it wants it seems?


Reply With Quote

Reply



futures io > > > NE Excel Wizards in here?

Thread Tools Search this Thread
Search this Thread:

Advanced Search



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

RandBots: AutoTrading Bots to diversify your trading

Oct 24
 

TopstepTrader: Profiting Without Risking Your Own Money

Oct 26

Building Open Source Indicators for NT8 w/Fat Tails @ Lizard Indicators

Elite only
     

Similar Threads
Thread Thread Starter Forum Replies Last Post
Wizards Den (Holy Grail II) TheWizard The Elite Circle 1489 October 10th, 2017 04:17 AM
Renaming the Market Wizards user title Big Mike Feedback and Announcements 35 January 20th, 2013 02:41 PM
Portugal Is Next: Improverished PIIG Demands US Assistance, Debt "Haircut" To Come Ne Quick Summary News and Current Events 0 October 29th, 2011 06:30 PM
Market Wizards of BMT Big Mike Feedback and Announcements 0 December 12th, 2009 07:28 AM


All times are GMT -4. The time now is 05:47 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-10-20 in 0.13 seconds with 20 queries on phoenix via your IP 23.20.86.177