Ichimoku signals in Excel VBA - Emini Index Futures Trading | futures.io
futures io futures trading

Ichimoku signals in Excel VBA
Started: by lpsarathi Views / Replies:5,188 / 5
Last Reply: Attachments:1

Welcome to futures io.

Welcome, Guest!

This forum was established to help traders (especially futures traders) by openly sharing indicators, strategies, methods, trading journals and discussing the psychology of trading.

We are fundamentally different than most other trading forums:
  • We work extremely hard to keep things positive on our forums.
  • We do not tolerate rude behavior, trolling, or vendor advertising in posts.
  • We firmly believe in openness and encourage sharing. The holy grail is within you, it is not something tangible you can download.
  • 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, and we will never resell your private information.

-- Big Mike

Thread Tools Search this Thread

Ichimoku signals in Excel VBA

  #1 (permalink)
Trading Apprentice
New delhi, India
Futures Experience: Intermediate
Platform: metatrader
Favorite Futures: stocks
Posts: 1 since Jan 2013
Thanks: 1 given, 1 received

Ichimoku signals in Excel VBA

Can any body have developed ichimoku signal code in Excel VBA? , if so can you please provide that code?

Reply With Quote
The following user says Thank You to lpsarathi for this post:
  #2 (permalink)
Quick Summary
Quick Summary Post

Quick Summary is created and edited by users like you... Add FAQ's, Links and other Relevant Information by clicking the edit button in the lower right hand corner of this message.

  #3 (permalink)
Market Wizard
Futures Experience: Intermediate
Platform: Investor/RT
Broker/Data: IB / DTN
Favorite Futures: Futures
Posts: 3,693 since Feb 2012
Thanks: 3,312 given, 6,649 received
Forum Reputation: Legendary

lpsarathi View Post
Can any body have developed ichimoku signal code in Excel VBA? , if so can you please provide that code?

Hi @Ipsarathi

Even if I do not see the goal to do this - you do NEED data from somewhere and signals created from that data.
Have two ways to help:

Signals for many indizes already calculated and charted (free) here:
Ichimoku Trader - Ichimoku charts of shares & stock market indices
From here you can manually put the shown signals into Excel.

I am using RT/Investor as charting tool - with DTN to import historical data.
With that I can set up a chart with the instrument wanted, put up a Ichimoku-Signal-Generator
and export this data to Excel.
From there the signals may further be used.

Hope this helps

Reply With Quote
  #4 (permalink)
Elite Member
Milan (I)
Futures Experience: Advanced
Platform: Ninjatrader
Broker/Data: Kinetick
Favorite Futures: FDAX,6E,CL,YM,NQ,ES
redratsal's Avatar
Posts: 1,653 since Oct 2010
Thanks: 1,217 given, 2,059 received

This post has been selected as an answer to the original posters question Answer


Please register on futures.io to view futures trading content such as post attachment(s), image(s), and screenshot(s).

Courtesy Gummy Stuff http://www.financialwebring.org/gummy-stuff/gummy_stuff.htm

Attached Files
Register to download File Type: xls ichimoku.xls (389.0 KB, 158 views)
Reply With Quote
The following 5 users say Thank You to redratsal for this post:
  #5 (permalink)
Banned: trolling
Futures Experience: Advanced
Platform: "I trade, therefore, I AM!"; Theme Song: "Atomic Dog!"
Favorite Futures: EMD, 6J, ZB
kronie's Avatar
Posts: 798 since Oct 2009
Thanks: 216 given, 497 received

Futures Edge on FIO
this seems interesting,

I would imagine that if one were to change the interval of the Ichi base chart, then one would derive a different timestamp set of signals in contrast to say, a longer frame chart, and the inverse too

generally, most responses come from applications oriented towards NinjaTrader

has this concept or approach been adapted towards NT?

Reply With Quote
  #6 (permalink)
Trading Apprentice
San Francisco
Futures Experience: None
Platform: MetaTrader
Favorite Futures: Equities
Posts: 1 since Jul 2016
Thanks: 0 given, 0 received

ichimoku.xls from Gummy Stuff is filled with errors

The excel chart posted above has so many incorrect calculations.

1. For conversion line, base line and leading a line, the high/low calculations actually take the start and end dates and return the high or low from those two dates, not the high/low of the range.
2. For conversion line, base line and leading a line, the lows lows are calculated using the values from the high column

Reply With Quote


futures io > > > > Ichimoku signals in Excel VBA

Thread Tools Search this Thread
Search this Thread:

Advanced Search

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

Mastering Trading Pysychology w/Brett Steenbarger & Trading Technologies

Elite only

PTMC Protrader Platform First Look w/Sergey Sokolov

Elite only

Spring Grains Outlook w/Sean Lusk @ Walsh Trading

Elite only

FIO Video Journal Challenge featuring NinjaTrader ($2,000+ of prizes)


Process above all else w/Anthony Crudele @ Futures Radio Show

Elite only

Machine Learning - Quantitative Trading w/Martin Froehler @ Quantiacs

Elite only

Market Dynamics w/Peter Davies @ Jigsaw Trading

Elite only

Ask Me Anything w/Patrick Rooney @ Trading Technologies

Apr 18

Ask Me Anything w/FuturesTrader71

Apr 19

Machine Learning w/Kris Longmore

Elite only

Market Analysis w/Dave Forss

Apr 25

Introducing iSystems with Stage 5 Trading

Apr 27

Similar Threads
Thread Thread Starter Forum Replies Last Post
Ichimoku for Multicharts rani MultiCharts 16 April 28th, 2016 03:44 AM
Ichimoku Reconstructed...! linkon7 Traders Hideout 58 August 13th, 2013 03:07 PM
Signals in Excel Mehul MultiCharts 5 September 13th, 2012 04:43 AM
Signals in Excel Mehul NinjaTrader 6 February 14th, 2012 10:05 AM
Patrick's Ichimoku Trades itzme Elite Trading Journals 4 February 3rd, 2012 09:06 AM

All times are GMT -4. The time now is 02:23 AM.

no new posts
Page generated 2017-03-24 in 0.09 seconds with 30 queries on phoenix via your IP