NexusFi: Find Your Edge


Home Menu

 





Excel Gurus: Is This Possible


Discussion in Traders Hideout

Updated
      Top Posters
    1. looks_one GFIs1 with 2 posts (0 thanks)
    2. looks_two Wikmar with 2 posts (0 thanks)
    3. looks_3 DavidHP with 1 posts (0 thanks)
    4. looks_4 learning0101 with 1 posts (0 thanks)
    1. trending_up 4,844 views
    2. thumb_up 0 thanks given
    3. group 4 followers
    1. forum 8 posts
    2. attach_file 0 attachments




 
Search this Thread

Excel Gurus: Is This Possible

  #1 (permalink)
JTurner77
Los Angeles, CA
 
Posts: 68 since Dec 2011
Thanks Given: 55
Thanks Received: 31

Hey Guys

I have downloaded a years worth of data in 5 minute bars for the ES through Interactive Brokers/Excel DDE. I would like to get a visual look at each day's worth of data. Excel has stock charts (bars and candlesticks) available. But is there a way to get excel to automatically create these charts for me without my having to do it one by one?

Reply With Quote

Can you help answer these questions
from other members on NexusFi?
New Micros: Ultra 10-Year & Ultra T-Bond -- Live Now
Treasury Notes and Bonds
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
NexusFi Journal Challenge - April 2024
Feedback and Announcements
The space time continuum and the dynamics of a financial …
Emini and Emicro Index
Deepmoney LLM
Elite Quantitative GenAI/LLM
 
  #3 (permalink)
 
Wikmar's Avatar
 Wikmar 
Madrid - Spain
 
Experience: Advanced
Platform: Own (more or less)
Trading: S&P500, FDAX, €/$, CL, etc.
Posts: 143 since May 2014
Thanks Given: 1,647
Thanks Received: 121



JTurner77 View Post
Hey Guys

I have downloaded a years worth of data in 5 minute bars for the ES through Interactive Brokers/Excel DDE. I would like to get a visual look at each day's worth of data. Excel has stock charts (bars and candlesticks) available. But is there a way to get excel to automatically create these charts for me without my having to do it one by one?


It is highly probably possible, programming the VBA capabilities of Excel. It's all I can say because it would require time for study the problem and route a solution.

Greetings

Home people force
https://wikmar.wordpress.com/
Reply With Quote
  #4 (permalink)
 
DavidHP's Avatar
 DavidHP 
Isla Mujeres, MX
Legendary Market Wizard
 
Experience: Advanced
Platform: NinjaTrader
Broker: Ninjatrader / Optimus Futures / AmpFutures
Trading: ES / 6E / 6B / CL
Frequency: Every few days
Duration: Minutes
Posts: 1,609 since Aug 2009
Thanks Given: 11,328
Thanks Received: 2,743

Just do it once manually and record the steps with the built-in recorder:

How to Record a Macro to Automate Tasks in Excel 2010 - For Dummies

Rejoice in the Thunderstorms of Life . . .
Knowing it's not about Clouds or Wind. . .
But Learning to Dance in the Rain ! ! !
Follow me on Twitter Reply With Quote
  #5 (permalink)
 
Wikmar's Avatar
 Wikmar 
Madrid - Spain
 
Experience: Advanced
Platform: Own (more or less)
Trading: S&P500, FDAX, €/$, CL, etc.
Posts: 143 since May 2014
Thanks Given: 1,647
Thanks Received: 121


DavidHP View Post
Just do it once manually and record the steps with the built-in recorder:

How to Record a Macro to Automate Tasks in Excel 2010 - For Dummies


Great idea if the process is enough easy.

I assumed it's not the case, hopefully wrongly.

Home people force
https://wikmar.wordpress.com/
Reply With Quote
  #6 (permalink)
 GFIs1 
who cares
Legendary Market Wizard
 
Experience: None
Platform: nobody interested
Broker: none
Trading: forget about it
Posts: 6,921 since Feb 2012
Thanks Given: 6,181
Thanks Received: 15,563

If you want to record your steps in the data sheet be aware of "relative" and "absolute cell references".
In your case with NEW data coming that means you need a Recording with "relative cell references".
Only with this setting the new data is taken and produces a new chart.

Hints here: Excel 2013: Relative and Absolute Cell References

But if you know Excel and recording then you might know it anyway...

GFIs1

Follow me on Twitter Visit my NexusFi Trade Journal Reply With Quote
  #7 (permalink)
 GFIs1 
who cares
Legendary Market Wizard
 
Experience: None
Platform: nobody interested
Broker: none
Trading: forget about it
Posts: 6,921 since Feb 2012
Thanks Given: 6,181
Thanks Received: 15,563

If you are using the data on one sheet where new data is incrementally getting in you
can use in your Macro the entry point to start with "goto last cell" and do the wanted
selection "backwards".
This helps to automate your selections and you do not have to select it manually every time.
With that function you are able to use only the "new data" or the new data with the old data
in total or in parts.

Just my 2 cents
GFIs1

Follow me on Twitter Visit my NexusFi Trade Journal Reply With Quote
  #8 (permalink)
NoiseTrader716
Buffalo, NY
 
Posts: 64 since Jul 2014
Thanks Given: 4
Thanks Received: 38

Certainly possible to chart based on a date range with some VBA but I would just install ninja, import the data and be done with it. It would be a good project if you want to learn VBA but if you don't, I don't see the point of turning things into a project.

Reply With Quote
  #9 (permalink)
 
learning0101's Avatar
 learning0101 
Houston, Texas
 
Experience: Intermediate
Platform: NinjaTrader,TOS,Etrade,St
Broker: NT:( tos,etrade,CS
Trading: stocks,options,futures,forex
Frequency: Never
Duration: Never
Posts: 287 since Aug 2011
Thanks Given: 3,613
Thanks Received: 222

Hi if there are any excel wizards out there?
Will someone have a look and see if they can modify this existing file to have the capability to handle multiple accounts?
Like for example: five different accounts.
As it is now it just has one.
If is too time/labor intense I understand, just taking a chance that maybe someone that uses excel a lot can do?
Any comments welcome
Thanks in advance

this is direct download for file from 1st post


also posted in that thread:

Thanks in advance

Reply With Quote




Last Updated on April 24, 2015


© 2024 NexusFi™, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
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.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Privacy Policy - Downloads - Top
no new posts