Login Page - Create Account

Support Board


Date/Time: Fri, 03 May 2024 02:39:41 +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