Pulling Historical Imoku Study Data

This Microsoft Excel® spreadsheet pulls in five Imoku studies along with open, high, low, and close bar values. You can change the symbol and the time frame. You can retrieve up to 300 daily bars and up to 3,000 intraday bar values. The spreadsheet also allows you to use either the primary session or a custom session.


Here are the individual RTD formulas for each of the five Imoku studies using the EP symbol and the daily time frame:

Imoku1: = RTD("cqg.rtd",,"StudyData", "EP", "Imoku", "Period1=9", "Imoku1","D","0","ALL",,,"FALSE","T")

Imoku2: = RTD("cqg.rtd",,"StudyData", "EP", "Imoku", "Period2=26", "Imoku2","D","0","ALL",,,"FALSE","T")

Imoku3: = RTD("cqg.rtd",,"StudyData", "EP", "Imoku", "Period3=52", "Imoku3","D","-26","ALL",,,"FALSE","T")

Imoku4: = RTD("cqg.rtd",,"StudyData", "EP", "Imoku", "Period1=9,Period2=26,Period4=1,MAType4=Sim", "Imoku4","D","-26","ALL",,,"FALSE","T")

Imoku5: = RTD("cqg.rtd",,"StudyData", "EP", "Imoku", "MAType5=Sim,Period5=1,InputChoice5=Close", "Imoku5","D","0","ALL",,,"FALSE","T")

Requires CQG Integrated Client or CQG QTrader and Excel 2010 or higher.




Trading and investment carry a high level of risk, and CQG, Inc. does not make any recommendations for buying or selling any financial instruments. We offer educational information on ways to use our sophisticated CQG trading tools, but it is up to our customers and other readers to make their own trading and investment decisions or to consult with a registered investment advisor. The opinions expressed here are solely those of the author and do not reflect the opinions of CQG, Inc. or its affiliates.