NexusFi: Find Your Edge


Home Menu

 





Ichimoku signals in Excel VBA


Discussion in Emini and Emicro Index

Updated
      Top Posters
    1. looks_one abudabu with 2 posts (0 thanks)
    2. looks_two kronie with 1 posts (0 thanks)
    3. looks_3 redratsal with 1 posts (5 thanks)
    4. looks_4 lpsarathi with 1 posts (1 thanks)
    1. trending_up 13,397 views
    2. thumb_up 6 thanks given
    3. group 4 followers
    1. forum 5 posts
    2. attach_file 1 attachments




 
Search this Thread

Ichimoku signals in Excel VBA

  #1 (permalink)
lpsarathi
New delhi, India
 
Posts: 1 since Jan 2013
Thanks Given: 1
Thanks Received: 1

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

Reply With Quote
Thanked by:

Can you help answer these questions
from other members on NexusFi?
Ninja Mobile Trader VPS (ninjamobiletrader.com)
Trading Reviews and Vendors
Better Renko Gaps
The Elite Circle
New Micros: Ultra 10-Year & Ultra T-Bond -- Live Now
Treasury Notes and Bonds
NexusFi Journal Challenge - April 2024
Feedback and Announcements
Deepmoney LLM
Elite Quantitative GenAI/LLM
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Get funded firms 2023/2024 - Any recommendations or word …
59 thanks
Funded Trader platforms
37 thanks
NexusFi site changelog and issues/problem reporting
22 thanks
GFIs1 1 DAX trade per day journal
22 thanks
The Program
20 thanks
  #3 (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,564



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:

1)
Signals for many indizes already calculated and charted (free) here:
Ichimoku Trader - [AUTOLINK]Ichimoku[/AUTOLINK] 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

Follow me on Twitter Visit my NexusFi Trade Journal Reply With Quote
  #4 (permalink)
 
redratsal's Avatar
 redratsal 
Milan (I)
 
Experience: Advanced
Platform: Ninjatrader
Broker: Kinetick
Trading: FDAX,6E,CL,YM,NQ,ES
Posts: 1,648 since Oct 2010
Thanks Given: 1,215
Thanks Received: 2,090

Enjoy



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

Attached Files
Elite Membership required to download: ichimoku.xls
Visit my NexusFi Trade Journal Reply With Quote
  #5 (permalink)
 
kronie's Avatar
 kronie 
NYC + NY / USA
 
Experience: Advanced
Platform: "I trade, therefore, I AM!"; Theme Song: "Atomic Dog!"
Trading: EMD, 6J, ZB
Posts: 796 since Oct 2009

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)
abudabu
San Francisco
 
Posts: 1 since Jul 2016
Thanks Given: 0
Thanks Received: 0

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




Last Updated on July 23, 2016


© 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