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

Go Back   futures.io

> Futures Trading, News, Charts and Platforms > Traders Hideout > Index Futures Trading

Ichimoku signals in Excel VBA
Started:January 1st, 2013 (03:34 AM) by lpsarathi Views / Replies:4,664 / 5
Last Reply:July 23rd, 2016 (09:50 AM) 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

Old January 1st, 2013, 03:34 AM   #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:

Old January 1st, 2013, 03:34 AM   #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.


Old January 1st, 2013, 06:01 AM   #3 (permalink)
Market Wizard
Futures Experience: Intermediate
Platform: Investor/RT
Broker/Data: IB / DTN
Favorite Futures: Futures
Posts: 3,518 since Feb 2012
Thanks: 3,045 given, 6,077 received

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

Old January 1st, 2013, 10:12 AM   #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,052 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, 149 views)
Reply With Quote
The following 5 users say Thank You to redratsal for this post:

Old January 3rd, 2013, 03:31 PM   #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, 494 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

Old July 23rd, 2016, 09:50 AM   #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 > Futures Trading, News, Charts and Platforms > Traders Hideout > Index Futures Trading > Ichimoku signals in Excel VBA

Thread Tools Search this Thread
Search this Thread:

Advanced Search

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

NinjaTrader 8: Programming Profitable Trading Edges w/Scott Hodson

Elite only

Anthony Drager: Executing on Intermarket Correlations & Order Flow, Part 2

Elite only

Adam Grimes: Five critically important keys to professional trading

Elite only

Machine Learning Concepts w/FIO member NJAMC

Elite only

MarketDelta Cloud Platform: Announcing new mobile features

Dec 1

NinjaTrader 8: Features and Enhancements

Dec 6

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 03:08 AM.

Copyright © 2016 by 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 2016-10-27 in 0.10 seconds with 30 queries on phoenix via your IP