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

lpsarathi 

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:

1)
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.

2)
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
GFIs1

Enjoy



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

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?

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