Support Board
Date/Time: Sat, 01 Mar 2025 12:54:08 +0000
Post From: SPREADSHEET ISSUE
| [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
|