Login Page - Create Account

Support Board


Date/Time: Sun, 07 Aug 2022 15:41:08 +0000



[User Discussion] - text display net change from open/high/ low and previous close in the middle of chart window

View Count: 1582

[2014-01-19 01:54:19]
mario mario - Posts: 22
is there any way to display net change from today's open/high/low and previous close; in the middle of chart window. I am using text study from chart to display today's Open, high, low, last price in the middle of chart(about 1 inch big fonts), and I would like to display net change with reference to open/high/low/previous close; underneath it.
i see dailychange and percentsinceopen in the header which is too small fonts

thans
[2014-01-21 22:50:22]
mario mario - Posts: 22
I would appreciate your help with the net change calculations.
bumping...


thanks
[2014-01-23 17:39:27]
mario mario - Posts: 22
I used the ZIG-SPREAD SHEET TO CALCULATE THE net change from OHLC in column h3,i3,j3; now i see it is changing in the spreadsheet, HOW DO I make it display in the chart ?

thanks
[2014-01-25 00:16:04]
tomgilb - Posts: 3358
You must use a row3 cell in columns K-Z...BR for the Text Display study to see it.


[2014-01-25 18:09:14]
mario mario - Posts: 22
thanks tomgilb.
i noticed k3-z3 upto fm3 is already used by zig-zag program in the spreadsheet.

how do I program it ?, I could not figure out how to make it display in the chart, do I need to change anything in the cpp file to make it display the netchange from the today's open, high, low and previous close in the middle of the chart.

Appreciate all the help you have done in the sc community

>>>>>>>>>>
You must use a row3 cell in columns K-Z...BR for the Text Display study to see it.
[2014-01-27 04:02:48]
tomgilb - Posts: 3358
What is the exact name of the Zigzag spreadsheet study you are using?

User formula columns are from K-Z by default, when the Number Of Formula Columns is set to the default 16.
This setting can be as high as 60, and then the user formula columns would go from K-BR.
However, changing the Number of Formula Columns would cause existing formulas to no longer reference the correct columns. All formulas that reference study output columns would need to be edited.



[2014-01-27 09:37:12]
mario mario - Posts: 22
I am using zz rev lines.scwbf spreadsheet
I added "text display from study" to display todays open, high, and low in the chart

I was just playing with different studies and the spreadsheet and saved it, it created whole bunch of sheets in the spreadsheet. I got lost there
I am planning to delete the scwbf file, download the new one from your website.

Then what should I change in the program to display the net changes from open, from the high etc..

thanks





Date Time Of Last Edit: 2014-01-27 23:48:02
[2014-01-28 01:16:02]
tomgilb - Posts: 3358
The ZZ Rev Lines spreadsheet study uses all 16 user formula columns, so you will need to change the Number Of Formula Columns setting to something large enough to accommodate your formulas.

It so happens that this study has the ability to easily accommodate a change in the Number Of Formula Columns by simply editing the formula in cell Q3 to reference the Zigzag study's output column.


[2014-01-30 16:58:37]
mario mario - Posts: 22
Thanks tomgilb, it is working now. It took a while for me to understands the basics of the cell reference in the chart.
how do i reference a cell from another sheet in a spreadsheet.
Also if I add or delete any indicator it will change the sheet columns and the formula wont change automatically, how can I avoid to change the formula everytime
is there any way to assign chart #1 to sheet1 so that changes made in chart #2 wont effect sheet1. I have put data output # 1 and 2 in the respective chart.

I get tired of zooming the charts every time, for some reason es chart has 0 value in the indicator and chart needs to be zoomed up.
Date Time Of Last Edit: 2014-01-30 17:39:45
[2014-01-31 00:49:35]
tomgilb - Posts: 3358
how do i reference a cell from another sheet in a spreadsheet.
Enter an = in the destination cell (e.g Sheet1 cell K3), navigate to the source sheet and cell (e.g. Sheet2 cell Z3), press Enter. This will give you a something like this in K3:
=Sheet2!Z3
http://www.sierrachart.com/index.php?l=doc/doc_Worksheets.html#ReferencesOtherSheets
However, here is the recommended way to reference another chart's studies:
http://www.sierrachart.com/index.php?l=doc/doc_ReferencingChartsFormulas.html#OverlayStudies

Also if I add or delete any indicator it will change the sheet columns and the formula wont change automatically, how can I avoid to change the formula everytime
As you have discovered, study outputs appear on the spreadsheet (beginning in column AA-BR respective to the Number Of Formula Columns setting 16-60) in the same order they appear in the Studies to Graph list. If you add, remove, or rearrange studies, or if you change the Number Of Formula Columns setting, studies will appear in different columns which will require editing all affected column references.
There is no goof-proof way to always avoid the need to edit formulas when adding or removing studies, but here are some ideas to mitigate the need:
-Use the example in column Q of the ZZ Rev Lines study, where the study's column is referenced in one of the user formula columns. If many formulas reference the same column, you only need to change one reference.
-Be careful of the order of the studies in the Studies to Graph list.
-Use a larger Number of Formula Columns setting than the default 16 before you write any formulas.

I get tired of zooming the charts every time, for some reason es chart has 0 value in the indicator and chart needs to be zoomed up.
In columns O and above, the formula needs to return a value commensurate with the price. A zero or one, or TRUE/FALSE, will cause the chart to squish with most Draw Styles. For example, if you are placing an up arrow at the bottom of the bar, you can use a formula like this:
=IF(YourConditions,D3,0)
[2014-02-17 14:37:17]
User83762 - Posts: 61
Tom, on the old support board, in the post entitled "DRAWING RECTANGLE BY SPREADSHEET? ", you posted a spreadsheet file, spreadsheet study and collection file. The input spreadsheet file no longer has any data in it. Can you post a screenshot of it, so I can see where you placed the data? Also, can you post a copy of the study file in Notepad so I can learn how you coded it? Thanks.
[2014-02-17 15:33:35]
tomgilb - Posts: 3358
Tom, on the old support board, in the post entitled "DRAWING RECTANGLE BY SPREADSHEET? ", you posted a spreadsheet file, spreadsheet study and collection file. The input spreadsheet file no longer has any data in it. Can you post a screenshot of it, so I can see where you placed the data? Also, can you post a copy of the study file in Notepad so I can learn how you coded it? Thanks.
This topic is unrelated to this thread. Please start a new thread and I can respond there.

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

Login

Login Page - Create Account