Home >> Support Board

Support Board

Date/Time: Mon, 25 Nov 2024 01:43:31 +0000

How to Post a Message for Support

[User Discussion] - ACSIL help needed, Wyckoff Activity

View Count: 2647

[2013-12-09 19:51:18] #1 [Go To First Post]
George - Posts: 60
Using the ZigZag study and a spreadsheet I can calculate and plot the Activity lines, as shown in the Wyckoff Division 1 course, chart attached. I would like to calculate the Activity in ACSIL, by using the ZigZag study and adding code to it to make a custom study, but only for the purpose of displaying the text string of the Activity reading. The formula I use to get the Activity in the spreadsheet takes 8 columns and basically is: "ZigZagNumberOfTrades/ZigZagDuration(only using minutes)/Divisor", all based on the reversal points of each ZigZag. I have added, calculate and display ZigZagNumberOfTrades, also a Divisor to a custom study, but I cannot figure out how to divide the ZigZagNumberOfTrades by the ZigZagDuration in ACSIL. If anyone can help with this, kindly respond. It would be very much appreciated. http://www.sierrachart.com/image.php?l=1386618850965.png Date Time Of Last Edit: 2013-12-09 19:55:00

[2013-12-10 02:15:22] #2 [Go To First Post]
StevieD - Posts: 39
Problem 1) As is, Zig-Zag study does not make the data of it's text labels accessible through ACSIL. Problem 2) Through ACSIL, there is no way I know of to access an internal spreadsheet. The good news is the Zig-Zag study is located in the Studies7.cpp file! A cursory look at the code and I noticed the data associated with the "Additional Output For Spreadsheets" setting can be made available in ACSIL through existing subgraphs. The "Name" parameter of those subgraphs need to be set in the sc.defaults section and the code re-compiled. Then use the newly compiled ZZ study instead. By itself, that SHOULD get you on your way, allowing you to use "GetStudyArray**" functions through your custom WyCkoffActivity ACSIL study. You'll need to use sc.secondsperbar zigzagnumberofbars or something similar to make a minutes calculation. HTH

[2013-12-10 03:32:05] #3 [Go To First Post]
George - Posts: 60
Thanks, HTH. I will check it out. Much Appreciated, George

[2013-12-16 05:16:06] #4 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
Problem 1) As is, Zig-Zag study does not make the data of it's text labels accessible through ACSIL. Yes it does if you set Additional Output for Spreadsheets to Yes in the study input settings. Update: As we continued to read through your posting, we can see that you know how to do this. Problem 2) Through ACSIL, there is no way I know of to access an internal spreadsheet. You can by accessing the Subgraphs of the Spreadsheet study on the chart. This will allow you to get any of the formula columns data (K-Z and more depending upon the setting of the Number of Formula Columns input). Additionally, by using the appropriate formulas in the formula columns, you are able to reference other data on the spreadsheet by having those formula column formulas reference the particular cells that you need. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, change to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2013-12-16 05:24:21

To post a message in this thread, you need to log in with your Sierra Chart account: