Home >> Support Board

Support Board

Date/Time: Tue, 26 Nov 2024 20:37:58 +0000

How to Post a Message for Support

[Programming Help] - Day/Date display on TPO bars

View Count: 723

[2021-11-18 15:41:58] #1 [Go To First Post]
amazayn - Posts: 48
Is there a way to show the day on top of a TPO chart. See screenshot. I know we have the dates on the bottom of the scrollbar but I wanted the actual day of the week on top of each bar. Date Time Of Last Edit: 2021-11-18 15:42:56


Date on top of VbP.PNG / V - Attached On 2021-11-18 15:41:41 UTC - Size: 66 KB - 168 views

[2021-11-18 21:06:45] #2 [Go To First Post]
Sawtooth - Posts: 4120
It can be done with the Spreadsheet Study study. Put both files in the Sierra Chart \Data folder. To add the study, go to Analysis >> Day of Week display+ Choose No when asked if you want to clear existing studies. If you want the long day name, edit the Text To Draw for SG1-SG7. Use cell R3 on Sheet1 to set the display offset from the High. You must use the Study Collection to add the study because it has the saved settings. Note: This is intended to only be used on Daily charts.


Day Of Week display+.StdyCollct - Attached On 2021-11-18 20:44:06 UTC - Size: 18.43 KB - 282 views Day Of Week display.scss - Attached On 2021-11-18 20:56:53 UTC - Size: 44.37 KB - 177 views

[2021-11-22 15:47:50] #3 [Go To First Post]
amazayn - Posts: 48
Thank you for your help. The days are coming back with multiple letters like MMMMMMMMMMon, TTTTTTTTTue, etc. Please see screenshot. Can you help me fix this. Date Time Of Last Edit: 2021-11-22 15:48:03


Bad Day Name displayed.PNG / V - Attached On 2021-11-22 15:48:00 UTC - Size: 39.56 KB - 173 views

[2021-11-22 16:25:09] #4 [Go To First Post]
Sawtooth - Posts: 4120
The days are coming back with multiple letters like MMMMMMMMMMon, TTTTTTTTTue, etc. Can you help me fix this. In the spreadsheet study settings' 'Text To Draw' field, try adding some spaces before and/or after the day name.

[2021-11-23 00:44:52] #5 [Go To First Post]
amazayn - Posts: 48
Thank you - this did the trick. On a side note, is it possible to get the Letters from the 30m periods of the TPO chart (A,B,C, etc) to display on the top of the bars of a Footprint chart. For example, the 9:30am est bar would show an 'A' on top of that bar in the footprint chart.

[2021-11-23 02:23:50] #6 [Go To First Post]
Sawtooth - Posts: 4120
I don't understand what you want. Does the 9:30 bar get an 'A', and the 10:00 bar gets a 'B', etc.?

[2021-11-23 14:47:57] #7 [Go To First Post]
amazayn - Posts: 48
Yes, that's exactly what I want. If you look at the attached screenshot, you will see the TPO chart on the right all the way to the right (today's chart) only has the letter A b/c we are still in the 9:30am est bar. I want that A to be displayed on the top of my Footprint chart (on the left)


TPO_FP chart.PNG / V - Attached On 2021-11-23 14:47:54 UTC - Size: 151.27 KB - 173 views

[2021-11-23 15:18:50] #8 [Go To First Post]
Sawtooth - Posts: 4120
If each subsequent 30min footprint bar gets sequential alpha, why the reference to the TPO chart?

[2021-11-23 15:22:35] #9 [Go To First Post]
amazayn - Posts: 48
Different monitors and trying to add as much to my footprint chart as possible since I look at that one more than any other chart.

[2021-11-23 16:22:18] #10 [Go To First Post]
Sawtooth - Posts: 4120
You would use the example in post#2: - You would set the Number of Formula Columns to 60. - You would find the 9:30 bars with a formula like this in a Formula Column: =IF(MROUND(FRACTIME(A3),1/86400000)=TIME(09,30,00,000),C3*(1+$BR$3),0) where BR3 is the Display Offset This formula rounds the bar timestamp to the millisecond (to remove any floating point imprecision), and compares it to the TIME to the millisecond. When TRUE, it returns the price location for the alpha display of the Text To Draw. - You would replicate this formula in other Formula Columns, one column for each 30 min bar, editing the TIME for each. - You would use the Text To Draw fields of each SG# to label the alpha. - You would want to edit the Formula Column name in row 2 to match the alpha.

[2023-10-31 14:30:01] #11 [Go To First Post]
jorisvallier - Posts: 5
Would it be possible to make it work with like a 30mn chart by any chance pls ? Thanks

[2023-10-31 15:24:52] #12 [Go To First Post]
Sawtooth - Posts: 4120
Would it be possible to make it work with like a 30mn chart by any chance pls ? Make what work on a 30 min chart?

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