Support Board
Date/Time: Tue, 26 Nov 2024 06:53:56 +0000
Post From: Re: DRAWING RECTANGLE BY SPREADSHEET?
| [2014-03-25 20:25:16] |
| mario mario - Posts: 22 |
|
1) In am using this zones.scbf input file, How can I make the colors little transparent so that info behind it, is visible. 2) If I have number at cell KF3 in zz rev line spreadsheet, how can I make the chart draw a line automatically at the number 3) I am also using zig zag study, I see that we can select yes/no on display length of zigzag, volume etc, if I want to put % change with ref to previous close at the reversal point, what should I do? thanks mario >>>>>>>>>>>>>>>>>>>>>> tomgilb tomgilb is online now User Account Join Date: Nov 2008 Posts: 1,680 Default Re: DRAWING RECTANGLE BY SPREADSHEET? Quote: Originally Posted by User63345 View Post Thank you for trying to help ... The elements of each line are: Bottom of zone Top of zone S for Support, R for Resistance, L for level (change by color) Normal or Strong * but for me it ok if i can only copy the columns: botton of the zone and the top of the zone to spreadsheet in SC if that is can be done please tell me where to copy this columns in SC SPREADSHEET .. to see the zone on my chart . (this file is made for ninjatrader so i will only can COPY the columns to SC) best regards. Here is a semi-automatic example of what can be done: Put the attached files in your Sierra Chart \Data folder Click on File >> Open Spreadsheet >> Zones input Click on Analysis >> Zones- Zones output-.StdyCollct is a study collection that will load the correct spreadsheet study with the correct settings. Zones output.scwbf is a Spreadsheet Study study that will draw zones under the price graph. It references cells in Zones input.scwbf. Zones input.scwbf is a standalone SC spreadsheet (not a study) where you paste data from your ninja file. Since you are limited to 8 zones on the spreadsheet study, copy only 8 lines of data from the file, and choose prices that surround the current price. As price moves, you'll have to copy another 8 lines surrounding the new current price. Full automation would probably be possible using complex formulas. Attached Files File Type: scwbf Zones input.scwbf (4.7 KB, 59 views) File Type: stdycollct Zones output-.StdyCollct (7.7 KB, 55 views) File Type: scwbf Zones output.scwbf (32.2 KB, 49 views) Date Time Of Last Edit: 2014-03-25 21:00:24
|