Support Board
Date/Time: Sat, 01 Mar 2025 13:27:33 +0000
[User Discussion] - SPREADSHEET ISSUE
View Count: 792
| [2021-09-29 11:29:29] |
| User278398 - Posts: 291 |
|
hello, there is an option to Switch Data in Columns to Rows ? i want to see the time (which is in the column) moving horizontal (and not vertical as default), if it is not possible, maybe there is an option to rotate this spreadsheet window? many thanks. |
| [2021-09-29 15:52:41] |
| User278398 - Posts: 291 |
|
i hope it is fine, but i have another question about spredsheet formula and i hope u can help me about this question to : as in the attach pic, u can see cell p1 which have number which allways change. i'm trying to see the "last number" (that in cell p1) of each min time, record in the right row. the formula "=$P$1" in cell p3 doesnt show me what i want. what is the correct formula for what i ask ? many thanks. |
 111qqqq.jpg / V - Attached On 2021-09-29 15:49:39 UTC - Size: 223.73 KB - 208 views |
| [2021-09-29 18:34:09] |
| Sawtooth - Posts: 4177 |
|
is there an option to Switch Data in Columns to Rows ?
No, this is not supported.The spreadsheet study's sheet is directly related to the chart bars, where the current bar is in row 3 and earlier bars are in rows below. i'm trying to see the "last number" (that in cell p1) of each min time, record in the right row.
It's not possible to record (make persistent) a certain dynamic value of one cell.You can only create a persistent value from one row to another, because each row is a chart bar, and it would necessarily need to be the closing value of that bar. |
| [2021-09-29 20:04:32] |
| User278398 - Posts: 291 |
|
so how can i take this cumulative bid size (which is dynamic value) and make it as a stamp for each closing value of each bar (row) ? (maybe there is a way to make it as static value in some way for every row?) what is the alternative SC have ? many thanks Date Time Of Last Edit: 2021-09-29 20:06:43
|
| [2021-09-29 22:39:23] |
| Sawtooth - Posts: 4177 |
|
What is your formula in cell P1 ? Or, how are you calculating 'cumulative bid size' in cell P1? |
| [2021-09-30 10:30:08] |
| User278398 - Posts: 291 |
|
as in column F there is "volume" value which is get a dynamic value from the exchange (or what ever), which accumulate for period of time and then stays as "stamp" value. so y i can't take this dynamic value (cell p1) and then make it like a stamp.... there most be a way! (in excel vba i can do that) maybe there is a way to export the data/the spreadsheet to excel? (real time data) maybe u have a new solution ? many thanks Date Time Of Last Edit: 2021-09-30 10:39:10
|
| [2021-09-30 12:20:54] |
| User278398 - Posts: 291 |
|
leave it all!!! i found solution!!! add "bid & ask depth bars", choose in calculation mode "sum bid size" and u get for each row in the spread sheet the cumulative of the bid size (as well for some ask size) :) |
| [2021-09-30 12:27:52] |
| Sawtooth - Posts: 4177 |
|
so i can't take this dynamic value (cell p1) and then make it like a stamp....?
Not unless it is associated with a chart bar, like volume in column F.F3 is cumulative until the bar closes. The cumulative value can only be 'recorded' at bar close. It is possible to accumulate values across multiple bars using a modification of one of these examples: Spreadsheet Example Formulas and Usage: Persistent and Incrementing Variables there must be a way! (in excel vba i can do that)
Sierra Chart spreadsheet studies do not support VBA, nor real-time export to Excel.maybe there is a way to export the data/the spreadsheet to excel? (real time data) However, it is possible to periodically write spreadsheet data to a CSV file, but only with the Spreadsheet Study study. https://www.sierrachart.com/index.php?page=doc/SpreadsheetStudyInputs.html#PeriodicallySaveSheetAsTextInMinutes To sum the market depth bid size and ask size, refer to post# 2 in this thread: find cumulative bid and ask size But this isn't cumulative for each bar. It only returns the non-cumulative current value in the current bar, and the non-cumulative value at bar close in previous bars. Date Time Of Last Edit: 2021-09-30 19:38:06
|
To post a message in this thread, you need to log in with your Sierra Chart account: